Oracle 1Z1-052 Actual Free Exam Questions & Community Discussion

Which two are true about data dictionary views? (Choose two.)

Examine the commands executed in the following sequence:

Which statement is true about the above commands?

You are working on a database that must be functioning 24 hours a day, 7 days a week.
The database is configured in ARCHIVELOG mode.
Which two options do you have for performing user-managed backups? (Choose two.)

Examine these SQL statements and their output:

Which two are true? (Choose two.)

You execute the following command to change the status of the SALES tablespace:
SQL> ALTER TABLESPACE sales OFFLINE;
Which statements describe the effect of the command? (Choose all that apply.)

Which two types of information can be found in the alert log? (Choose two.)

You suspect unauthorized data manipulation language (DML) operations on a particular table. You want to track users who are performing the transactions and the values used in the transactions. You also plan to transfer these values to another table for analysis. How would you achieve this?

Your DB_RECOVERY_FILE_DEST_SIZE is 8G.
Currently, 5G of the space is used of which 4G consists of obsolete backups.
You execute this command:
SQL> ALTER SYSTEM SET db_recovery_fle_dest_size=2G;
What is the outcome?

Examine the values for the following initialization parameters:
FAST_START_MTTR_TARGET=0
LOG_CHECKPOINT_INTERVAL=0
Which two will be the implications of these values in your database? (Choose two.)

In which situations does the Oracle Data Pump use external tables and not the direct path load while exporting a table? (Choose all that apply.)

Which two are true about FAST_START_MTTR_TARGET? (Choose two.)

Examine the following statement that is used to modify the primary key constraint on the SALES table:
SQL> ALTER TABLE SALES MODIFY CONSTRAINT pk DISABLE VALIDATE;
Which three statements are true regarding the above command? (Choose three.)

Which three statements are correct about temporary tables? (Choose three.)

You have two tables with referential integrity enforced between them. You need to insert data to the child table first because it is going to be a long transaction and data for the parent table will be available in a later stage, which can be inserted as part of the same transaction.
View the Exhibit to examine the commands used to create tables.
Which action would you take to delay the referential integrity checking until the end of the transaction?
Exhibit: