Free 1z0-082 Exam Dumps

Question 16

Your database instance was shut down normally and then started in NOMOUNT state. You then execute this command:
ALTER DATABASE MOUNT;
Which two actions are performed? (Choose two.)

A. The online redo logs are opened
B. The online data files are opened
C. The alert log records the execution details
D. The Oracle background processes are started
E. The initialization parameter file is read
F. The control file is read

Correct Answer:DF

Question 17

Examine the description of the SALES1 table:
1Z0-082 dumps exhibit
SALES2 is a table with the same description as SALES1. Some sales data is duplicated in both tables.
You want to display the rows from the SALES1 table which are not present in the SALES2 table. Which set operator generates the required output?

A. INTERSECT
B. UNION ALL
C. UNION
D. SUBTRACT
E. MINUS

Correct Answer:E

Question 18

Which four statements are true regarding primary and foreign key constraints and the effect they can have on table data? (Choose four.)

A. A table can have only one primary key but multiple foreign keys
B. A table can have only one primary key and foreign key
C. The foreign key columns and parent table primary key columns must have the same names
D. 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
E. 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
F. Only the primary key can be defined at the column and table level
G. Primary key and foreign key constraints can be defined at both the column and table level

Correct Answer:ACEG