Free 1Z0-071 Exam Braindumps

Which three statements are true regarding single-row functions? (Choose three.)

1. A. The data type returned, can be different from the data type of the argument that is referenced.
2. B. They can return multiple values of more than one data type.
3. C. They can accept only one argument.
4. D. They can be nested up to only two levels.
5. E. They can be used in SELECT, WHERE, and ORDER BY clauses.
6. F. They can accept column names, expressions, variable names, or a user-supplied constants as arguments.

Correct Answer: AEF

View the Exhibit and examine the description of the ORDERS table. (Choose two.)

Which two WHERE clause conditions demonstrate the correct usage of conversion functions?

1. A. WHERE Order_date_IN ( TO_DATE('OCT 21 2003', 'MON DD YYYY'), TO_CHAR('NOV 21 2003', 'MON DD YYYY') )
2. B. WHERE Order_date > TO_CHAR(ADD_MONTHS(SYSDATE, 6), 'MON DD YYYY')
3. C. WHERE TO_CHAR(Order_date, 'MON DD YYYY') = 'JAN 20 2003'
4. D. WHERE Order_date > ( TO_DATE('JUL 10 2006', 'MON DD YYYY')

Correct Answer: CD

Evaluate the following CRTEATE TABLE commands:
CREATE_TABLE orders
(ord_no NUMBER (2) CONSTRAINT ord_pk PRIMARY KEY,
ord_date DATE, cust_id NUMBER (4) );
CREATE TABLE ord_items (ord _no NUMBER (2),
item_no NUMBER(3),
qty NUMBER (3) CHECK (qty BETWEEEN 100 AND 200),
expiry_date date CHECK (expiry_date> SYSDATE), CONSTRAINT it_pk PRIMARY KEY (ord_no, item_no),
CONSTARAINT ord_fk FOREIGN KEY (ord_no) REFERENCES orders (ord_no) ); Why would the ORD_ITEMS table not get created?

1. A. SYSDATE cannot be used with the CHECK constraint.
2. B. The BETWEEN clause cannot be used for the CHECK constraint.
3. C. The CHECK constraint cannot be placed on columns having the DATE data type.
4. D. ORD_NO and ITEM_NO cannot be used as a composite primary key because ORD_NO is also the FOREIGN KEY.

Correct Answer: A

You are designing the structure of a table in which two columns have the specifications:
COMPONENT_ID – must be able to contain a maximum of 12 alphanumeric characters and uniquely identify the row
EXECUTION_DATETIME – contains Century, Year, Month, Day, Hour, Minute, Second to the maximum precision and is used for calculations and comparisons between components.
Which two options define the data types that satisfy these requirements most efficiently?

1. A. The EXECUTION_DATETIME must be of INTERVAL DAY TO SECOND data type.
2. B. The EXECUTION_DATETIME must be of TIMESTAMP data type.
3. C. The EXECUTION_DATETIME must be of DATE data type.
4. D. The COMPONENT_ID must be of ROWID data type.
5. E. The COMPONENT_ID must be of VARCHAR2 data type.
6. F. The COMPONENT_ID column must be of CHAR data type.

Correct Answer: CF

Which two statements are true regarding the COUNT function?

1. A. A SELECT statement using the COUNT function with a DISTINCT keyword cannot have a WHERE clause.
2. B. COUNT (DISTINCT inv_amt) returns the number of rows excluding rows containing duplicates and NULL values in the INV_AMT column.
3. C. COUNT (cust_id) returns the number of rows including rows with duplicate customer IDs and NULL value in the CUST_ID column.
4. D. COUNT (*) returns the number of rows including duplicate rows and rows containing NULL value in any of the columns.
5. E. The COUNT function can be used only for CHAR, VARCHAR2, and NUMBER data types.

Correct Answer: BD