[多项选择]You want to analyze a SQL Tuning Set (STS) using SQL Performance Analyzer in a test database. Which two statements are true regarding the activities performed during the test execution of SQLs in a SQL Tuning Set?（）
A. Every SQL statement in the STS is considered only once for execution
B. The SQL statements in the STS are executed concurrently to produce the execution plan and execution statistics
C. The execution plan and execution statistics are computed for each SQL statement in the STS
D. The effects of DDL and DML are considered to produce the execution plan and execution statistics

[单项选择] You want to set the following initialization parameters for your database instance: LOG_ARCHIVE_DEST_1 = 'LOCATION=/disk1/arch' LOG_ARCHIVE_DEST_2 = 'LOCATION=/disk2/arch' LOG_ARCHIVE_DEST_3 = 'LOACTION=/disk3/arch' LOG_ARCHIVE_DEST_4 = 'LOCATION=/disk4/arch MANDATORY' Identify the statement that correctly describes this setting.（）
A. The MANDATORY location must be a flash recovery area.
B. The optional destinations may not use the flash recovery area.
C. This setting is not allowed because the first destination is not set as MANDATORY.
D. The online redo log file is not allowed to be overwritten if the archived log cannot be created in the fourth destination.

[单项选择]If you want to set up a company, you must ________ with the regulations laid down by the authori- ties.
A. comply
B. adhere
C. confirm
D. accord

[单项选择] You conned using SQL Plus to the root container of a multitenant container database (CDB) with SYSDBA privilege. The CDB has several pluggable databases (PDBs) open in the read/write mode. There are ongoing transactions in both the CDB and PDBs. What happens alter issuing the SHUTDOWN TRANSACTIONAL statement?（）
A. The shutdown proceeds immediately. The shutdown proceeds as soon as all transactions in the PDBs are either committed or rolledhack.
B. The shutdown proceeds as soon as all transactions in the CDB are either committed or rolled back.
C. The shutdown proceeds as soon as all transactions in both the CDB and PDBs are either committed or rolled back.
D. The statement results in an error because there are open PDBs.

[单项选择]You are connected using SQL* Plus to a multitenant container database (CDB) with SYSDBA privilegesand execute the following sequence statements:What is the result of the last SET CONTAINER statement and why is it so?（）
A. It succeeds because the PDB_ADMIN user has the required privileges.
B. It fails because common users are unable to use the SET CONTAINER statement.
C. It fails because local users are unable to use the SET CONTAINER statement.
D. If fails because the SET CONTAINER statement cannot be used with PDB$SEED as the target pluggable database (PDB).

[多项选择]You want to take a complete database backup using RMAN. The backup should consist only the used blocks from your database.Which two statements are true about this backup operation?（）
A. Backup compression should be enabled
B. Parallelism for the channel should be set to 2
C. All the files must be backed up as backup sets
D. The backup may be stored either on disk or on media with media manager

[单项选择]You can do what you like, but I do not want you to be_________.
A. on the way
B. along the way
C. by the way
D. in the way

[名词解释]STS

[单项选择]We want you to describe all the events of that morning in sequence without any delay.
A. plans
B. memory
C. cycle
D. order

[单项选择]Haven't I told you I don't want you keeping ______ with those awful riding-about bicycle boys
A. company
B. acquaintance
C. friends
D. place

[单项选择]You have set up an Internet based FTP server, where people can upload and download files. In terms of the OSI model, what is the highest layer used during the FTP sessions.（）
A. Application
B. Presentation
C. Session
D. Transport
E. Internet
F. DataLink
G. Physical

[单项选择]You may move out any time you want to because you are old enough to live ______ you want.
A. why
B. when
C. where
D. what

[单项选择]I don't want you（）your brains about such problems.
A. being always bothered
B. always to be bothered 
C. to be always bothering
D. to be always bothered

[多项选择] You want to use the SQL Tuning Advisor to generate recommendations for badly written SQL statements in your development environment.   Which three sources can you select for the advisor to analyze？ （）
A. Top SQL
B. snapshots
C. SQL Tuning sets
D. index access path
E. optimizer statistics
F. materialized view logs

[单项选择]There isn’t enough space, I want you to clean _____ all the old files.
A. on
B. up
C. for
D. out

[单项选择] You want to set the following initialization parameters for your database instance：   LOG_ARCHIVE_DEST_1 = ’LOCATION=/disk1/arch’ LOG_ARCHIVE_DEST_2 = ’LOCATION=/disk2/arch’ LOG_ARCHIVE_DEST_3 = ’LOACTION=/disk3/arch’ LOG_ARCHIVE_DEST_4 = ’LOCATION=/disk4/arch MANDATORY’   Identify the statement that correctly describes this setting.（）  
A.  The MANDATORY location must be a flash recovery area.
B.  The optional destinations may not use the flash recovery area.
C.  This setting is not allowed because the first destination is not set as MANDATORY.
D.  The online redo log file is not allowed to be overwritten if the archived log cannot be created in the fourth destination.