[多项选择] You Execute the Following command to create a password file in the database server: $ orapwd file = ‘+DATA/PROD/orapwprod entries = 5 ignorecase = N format = 12’ Which two statements are true about the password file?（）
A. It records the usernames and passwords of users when granted the DBA role.
B. It contains the usernames and passwords of users for whom auditing is enabled.
C. Is used by Oracle to authenticate users for remote database administration.
D. It records the usernames and passwords of all users when they are added to the OSDBA or OSOPER operating system groups.
E. It supports the SYSBACKUP, SYSDG, and SYSKM system privileges.

[多项选择] You plan to execute the following command to perform a Flashback Database operation in your database: SQL> FLASHBACK DATABASE TO TIMESTAMP (SYSDATE -5/24); Which two statements are true about this?（）
A. The database must have multiplexed redo log files
B. The database must be in the MOUNT state to execute the command
C. The database must be in the NOMOUNT state to execute the command
D. The database must be opened in RESTRICTED mode before this operation
E. The database must be opened with the RESETLOGS option after the flashback operation

[多项选择] You executed this command to create a password file: $ orapwd file = orapworcl entries = 10 ignorecase = N Which two statements are true about the password file?（）
A. It will permit the use of uppercase passwords for database users who have been granted the SYSOPER role.
B. It contains username and passwords of database users who are members of the OSOPER operating system group.
C. It contains usernames and passwords of database users who are members of the OSDBA operating system group.
D. It will permit the use of lowercase passwords for database users who have granted the SYSDBA role.
E. It will not permit the use of mixed case passwords for the database users who have been granted the SYSDBA role.

[单项选择] You execute the following commands to audit database activities: SQL > ALTER SYSTEM SET AUDIT_TRIAL=DB, EXTENDED SCOPE=SPFILE; SQL > AUDIT SELECT TABLE, INSERT TABLE, DELETE TABLE BY JOHN By SESSION WHENEVER SUCCESSFUL; Which statement is true about the audit record that generated when auditing after instance restarts?（）
A. One audit record is created for every successful execution of a SELECT, INSERT OR DELETE command on a table, and contains the SQL text for the SQL Statements.
B. One audit record is created for every successful execution of a SELECT, INSERT OR DELETE command, and contains the execution plan for the SQL statements.
C. One audit record is created for the whole session if john successfully executes a SELECT, INSERT, or DELETE command, and contains the execution plan for the SQL statements.
D. One audit record is created for the whole session if JOHN successfully executes a select command, and contains the SQL text and bind variables used.
E. One audit record is created for the whole session if john successfully executes a SELECT, INSERT,or DELETE command on a table, and contains the execution plan, SQL text, and bind variables used.

[单项选择] You execute the following statement in a Microsoft Windows environment. There are no conflicts in the path name definitions. C: /＞ mysqld – install Mysql56 – defaults – file = C :/my –opts.cnf What is the expected outcome?（）
A. Mysql is installed as the Windows service name Mysql56, and uses c: /my-opts.cnf as the configuration file
B. An error message is issued because – install is not a valid option for mysqld
C. A running Mysql 5.6 installation has its runtime configuration updated with the server variables set in c: /my-opts.cnf
D. Mysqld acts as an MSI installer and installs the Mysql 5.6 version, with the c: /my-opts.cnf configuration file

[多项选择]You execute the following piece of code with appropriate privileges: User SCOTT has been granted theCREATE SESSION privilege and the MGR role.Which two statements are true when a session logged in as SCOTT queries the SAL column in the viewand the table?（）
A. Data is redacted for the EMP.SAL column only if the SCOTT session does not have the MGR role set.
B. Data is redacted for EMP.SAL column only if the SCOTT session has the MGR role set.
C. Data is never redacted for the EMP_V.SAL column.
D. Data is redacted for the EMP_V.SAL column only if the SCOTT session has the MGR role set.
E. Data is redacted for the EMP_V.SAL column only if the SCOTT session does not have the MGR role set.

[单项选择] A senior DBA asked you to execute the following command to improve performance: SQL> ALTER TABLE subscribe log STORAGE (BUFFER_POOL recycle); You checked the data in the SUBSCRIBE_LOG table and found that it is a large table containing one million rows. What could be a reason for this recommendation?（）
A. The keep pool is not configured.
B. Automatic Workarea Management is not configured.
C. Automatic Shared Memory Management is not enabled.
D. The data blocks in the SUBSCRIBE_LOG table are rarely accessed.
E. All the queries on the SUBSCRIBE_LOG table are rewritten to a materialized view

[多项选择]You execute the following PL/SQL:Which two statements are true?（）
A. Fine-Grained Auditing (FGA) is enabled for the PRICE column in the PRODUCTS table for SELECT statements only when a row with PRICE > 10000 is accessed.
B. FGA is enabled for the PRODUCTS.PRICE column and an audit record is written whenever a row with PRICE > 10000 is accessed.
C. FGA is enabled for all DML operations by JIM on the PRODUCTS.PRICE column.
D. FGA is enabled for the PRICE column of the PRODUCTS table and the SQL statements is captured in the FGA audit trial.

[单项选择]Which command will allow you to quickly determine the administrative status of all interfaces on a Junos device?（）
A. show interfaces status
B. show interfaces summary
C. show interfaces terse
D. show interfaces admin

[单项选择]Which command would allow you to compare two files stored on your router?（）
A. user@host>file show filename1 compare filename2
B. user@host>file compare files filename1 filename2
C. user@host>compare files filename1 filename2
D. user@host>compare filename1 filename2

[单项选择]At which command prompt would you issue the set date command?（）
A. [edit chassis]   user@router#
B. [edit]   user@router#
C. [edit system]   user@router#
D. user@router>

[单项选择]Which command would allow you to login to FPC 1 to collect FPC specific logs?（）
A. start shell fpc1
B. start shell tnp1
C. start shell tnp address 1
D. start shell pfe network fpc1

[单项选择] Given the command line java Pass2 and： public class Pass2{ public void main（String[]args）{ int x=6； Pass2 p=new Pass2（）； p.doStuff（x）； System.out.print（"mainx="+x）； } void doStuff（intx）{ System.out.print（"doStuffx="+x++）； } } What is the result？（）
A. Compilation fails.
B. An exception is thrown at runtime.
C. doStuffx=6 main x=6
D. doStuffx=6 mainx =7
E. doStuffx=7 mainx =6
F. doStuffx=7 mainx =7

[单项选择]Which command will create a group called ‘delivery’and set the administrators to john’ and ‘mary’?（）
A. mkgroup -A=john,mary delivery
B. groupadd -A=john,mary delivery
C. mkgroup adms=john,mary delivery
D. groupadd adms=john,mary delivery

[多项选择] You execute the following Recovery Manager （RMAN） commands in he following order：   BACKUP VALIDATE DATABAE RECOVER CORRUPTION LIST；   Which two tasks are performed by these commands？（）  
A.  Repair the corrupted blocks. If any. In the backup created
B.  Populate VSCOPV_CORRUPTION with names of files that have corrupted blocks
C.  Back up the database after checking whether array of the files have corrupted blocks
D.  Discover any corrupt blocks that are viewable with the VSDATABASE_BI-OCK_CORBUPTION view
E.  Repair all corrupted blocks that have been logged in the VSDATABASE_BLOCK_ CORRUPTION

[单项选择] You execute the following command to perform a backup by using Recovery Manager （RMAN）： RMAN> run  {allocate channel c1 type sbt;  backup datafile 1;  }  The command errors out. A part of the error message is as follows：  RMAN/x7f03009： failure of allocate command on c1 channel  ORA/x7f19554： error allocating device， device type： SBT_TAPE， device name：  What could explain why the statement failed？（）
A. sbt is not a valid device type.
B. Media Management Library was not loaded.
C. The sbt device cannot be used for data file backups.
D. No path was defined in the ALLOCATE CHANNEL command.
E. The channel is currently being used by another RMAN session.