Free Oracle 1z0-071 Exam Dumps Questions & Answers

Page: 1 / 88
Total 437 questions

Which two statements are true regarding constraints?

A.A column with the unique constraint can contain null values.
B.A constraint is enforced only for the insert operation on a table.
C.A constraint can be disabled even if the constraint column contains data.
D.A foreign key cannot contain null values.
E.All constraints can be defined at the column level as well as the table level.

Which two statements are true about INTERVAL data types? (Choose two.)

A.The value in an INTERVAL DAY TO SECOND column can be copied into an INTERVAL YEAR TO MONTH column.
B.INTERVAL DAY TO SECOND columns support fractions of seconds.
C.INTERVAL YEAR TO MONTH columns only support monthly intervals within a single year.
D.INTERVAL YEAR TO MONTH columns only support monthly intervals within a range of years.
E.INTERVAL YEAR TO MONTH columns support yearly intervals.
F.The YEAR field in an INTERVAL YEAR TO MONTH column must be a positive value.

Examine the structure of the DEPARTMENTS table.

You execute the following command:

Which two statements are true? (Choose two.)

A.Views created in the DEPARTMENTS table that include the COUNTRY column are automatically modified and remain valid.
B.A new column, COUNTRY, can be added to the DEPARTMENTS table after executing the command.
C.Unique key constraints defined on the COUNTRY column are removed.
D.Indexes created on the COUNTRY column exist until the DROP UNUSED COLUMNS command is executed.
E.Synonyms existing of the DEPARTMENTS table would have to be re-created.

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

A.A subquery can be used to access data from one or more tables or views.
B.Only two subqueries can be placed at one level.
C.A subquery in the WHERE clause of a SELECT statement can be nested up to three levels only.
D.If the subquery returns 0 rows, then the value returned by the subquery expression is NULL.
E.The columns in a subquery must always be qualified with the name or alias of the table used.

Which statement is true about the INTERSECT operator used in compound queries?

Add Comments