1z0-071 Dumps with Practice Exam Questions Answers

A table can have only one primary key but multiple foreign keys.

It is possible for child rows that have a foreign key to remain in the child table at the time the parent row is deleted.

Primary key and foreign key constraints can be defined at both the column and table level.

Only the primary key can be defined the column and table level.

It is possible for child rows that have a foreign key to be deleted automatically from the child table at the time the parent row is deleted.

The foreign key columns and parent table primary key columns must have the same names.

A table can have only one primary key and one foreign key.

A full outer join returns matched and unmatched rows.

A full outer join must use Oracle syntax.

Outer joins can be used when there are multiple join conditions on two tables.

Outer joins can only be used between two tables per query.

An inner join returns matched rows.

A left or right outer join returns only unmatched rows.

For large tables TRUNCATE is faster than DELETE.

For tables with multiple indexes and triggers is faster than TRUNCATE.

You can never TRUNCATE a table if foreign key constraints will be violated.

You can never tows from a table if foreign key constraints will be violated.

SELECT currency_ code FROM currencies

MINUS

SELECT currency_ code FROM invoices;

SELECT * FROM currencies

WHERE NOT EXISTS (

SELECT NULL FROM invoices WHERE currency_ code = currency_ code);

SELECT currency_ code FROM currencies

INTERSECT

SELECT currency_ code FROM invoices;

SELECT * FROM currencies

MINUS

SELECT * FROM invoices;

Numeric values are displayed in descending order if they have decimal positions.

Only columns that are specified in the SELECT list can be used in the ORDER BY clause.

In a character sort, the values are case-sensitive.

Column aliases can be used in the ORDER BY clause.

NULLS are not included in the sort operation.