Which three statements are true regardingpersistent lightweight jobs? (Choose three.)
Answer : A,B,D
See the Exhibit:
Exhibit 1:
Exhibit 2:
The time taken by the jobs are recorded in the TEST_LOG table. While comparing the time taken to create the jobs, the process in exhibit 1 less time than the process in exhibit2.
What is the reason for this?
Answer : A
While performing the backup of theflash recovery area, you notice that one of the archived redo log files is missing. You have multiple destinations for archived redo log files. What implications does it have on the backup of the flash recovery area?
Answer : C
Which three actions are requiredto configure the Flashback Database? (Choose three.)
Answer : A,B,D
The Oracle Database 11g database is running in the ARCHIVELOG mode. The archived redo log files are stored on three locations. The Flash Recovery Area is one of the locations. The details are given below:
LOG_ARCHIVE_DEST_1 = LOCATION = /disk1/archive
LOG_ARCHIVE_DEST_2 = SERVICE = stdb1
DB-RECOVERY_FILE_DEST = /u01/oradata
Examine the following RMAN command is used to set the deletion policy for archived log files:
RMAN> CONFIGURE ARCHIVELOG DELETION POLICY TO BACKED up 2 TIMES TO sbt;
Which statement is true regarding what this command accomplishes?
Answer : D
Which three statements are true regarding the function of the AutotaskBackground Process
(ABP)? (Choose three.)
Answer : A,C,D
Which two statements regarding the Flashback Table feature are correct? (Choose two.)
Answer : B,D
Sales details are being stored on a daily basis in the SALES_2007 table. A large amount of data is added to the table daily. To save disk space, you issued the following command:
ALTER TABLE sales_2007 COMPRESS FOR ALL OPERATIONS;
What would be the outcome of this command?
Answer : C
See the Exhibit:
Which statement is true regarding the status of the incident?
Answer : D
See the series of commands to be executed:
An index is then created on the ADMIN_WORK_AREA temporary table.
Which two statements are true regarding the TBS_T1 tablespace in the above command?
(Choose two.)
Answer : B,D
USER_DATA is anonencrypted tablespace that contains a set of tables with data. You want to convert all existing data in the USER_DATA tablespace and the new data into the encrypted format. Which methods would you use to achieve this? (Choose all that apply.)
Answer : A,B,C
Identify the activities performedas part of the Automatic SQL Tuning process in the maintenance window? (Choose all that apply.)
Answer : A,B,C,E
See the Exhibit:
Which statement is true regarding the status of the incident?
Answer : D
The SQL Tuning Advisor has beenconfigured with default configurationsinyourdatabase instance. Which recommendation is automatically implemented without the DBAs intervention after the SQL Tuning Advisor is run as part of the AUTOTASK framework?
Answer : B
Evaluate the following SQL statement used to create the PRODUCTS table:
Which statement is true regarding this command?
Answer : D