Free 1Z0-071 Exam Dumps

Question 21

Which two statements are true regarding constraints? (Choose two.)

A. All constraints can be defined at the column level and at the table level.
B. A constraint can be disabled even if the constraint column contains data.
C. A column with the UNIQUE constraint can contain NULLS.
D. A foreign key column cannot contain NULLS.
E. A constraint is enforced only for INSERT operations.

Correct Answer:BC

Question 22

You issue this command which succeeds: SQL> DROP TABLE products;
Which three statements are true?

A. All existing views and synonyms that refer to the table are invalidated but retained.
B. Any uncommitted transaction in the session is committed.
C. Table data and the table structure are deleted.
D. All the table’s indexes if any exist, are invalidated but retained.
E. Table data is deleted but the table structure is retained.

Correct Answer:BCD

Question 23

Evaluate the following SELECT statement and view the exhibit to examine its output:
SELECT constraint_name, constraint_type, search_condition, r_constraint_name, delete_rule, status, FROM user_constraints
WHERE table_name = 'ORDERS'; CONSTRAINT_NAME
CON SEARCH_CONDITION R_CONSTRAINT_NAME DELETE_RULE
STATUS ORDER_DATE_NN C
"ORDER_DATE" IS NOT NULL ENABLED ORDER_CUSTOMER_ID_NN C
"CUSTOMER_ID" IS NOT NULL ENABLED ORDER_MODE_LOV C
order _mode in ('direct', 'online') ENABLED
ORDER TOTAL MIN C
order total >= 0 ENABLED ORDER PK
P ENABLED
ORDERS CUSTOMER ID R
CUSTOMERS ID SET NULL ENABLED
ORDERS SALES REP R
EMP EMP ID SET NULL ENABLED
Which two statements are true about the output? (Choose two.)

A. The R_CONSTRAINT_NAME column gives the alternative name for the constraint.
B. In the second column, 'c' indicates a check constraint.
C. The STATUS column indicates whether the table is currently in use.
D. The column DELETE_RULE decides the state of the related rows in the child table when the corresponding row is deleted from the parent table.

Correct Answer:BD

Question 24

Which task can be performed by using a single Data Manipulation Language (DML) statement?

A. Removing all data only from a single column on which a primary key constraint is defined.
B. Removing all data from a single column on which a unique constraint is defined.
C. Adding a column with a default value while inserting a row into a table.
D. Adding a column constraint while inserting a row into a table.

Correct Answer:A

Question 25

Examine the data in the CUST_NAME column of the CUSTOMERS table.
CUST_NAME
-------------------
Renske Ladwig Jason Mallin Samuel McCain Allan MCEwen Irene Mikilineni Julia Nayer
You need to display customers' second names where the second name starts with "Mc" or "MC". Which query gives the required output?

A. SELECT SUBSTR (cust_name, INSTR (cust_name, ' ')+1)FROM customersWHERE SUBSTR (cust_name, INSTR (cust_name, ' ')+1)LIKE INITCAP ('MC%');
B. SELECT SUBSTR (cust_name, INSTR (cust_name, ' ')+1)FROM customersWHERE INITCAP (SUBSTR(cust_name, INSTR (cust_name, ' ')+1)) ='Mc';
C. SELECT SUBSTR (cust_name, INSTR (cust_name, ' ')+1)FROM customersWHERE INITCAP (SUBSTR(cust_name, INSTR (cust_name, ' ')+1))LIKE 'Mc%';
D. SELECT SUBSTR (cust_name, INSTR (cust_name, ' ')+1)FROM customersWHERE INITCAP (SUBSTR(cust_name, INSTR (cust_name, ' ')+1)) =INITCAP 'MC%';

Correct Answer:C