[单项选择]You enabled Flashback Data Archive on the INVENTORY table.Which DDL operation is supported on the table after enabling Flashback Data Archive?（）
A. Drop the table.
B. Partition the table
C. Truncate the table.
D. Add a column to the table.
E. Rename a column in the table.

[多项选择]You have enabled resumable space allocation in your database by setting the RESUMABLE_TIMEOUT parameter set to a nonzero value.Which three statements about resumable space allocation are true? （）
A. Even with resumable space allocation enabled for your database, you can disable resumable space allocation for a single session.
B. A resumable statement is suspended only if an out of space error occurs. （Out of space condition Maximum extents reached condition，Space quota exceeded condition）
C. When a resumable statement is suspended, the transaction that contains the statement is also suspended.
D. A resumable statement can only be suspended and resumed once during the execution of the statement.
E. You can query the V$SESSION_WAIT dynamic performance view to identify the statements that are suspended for a session.

[单项选择]You enabled Flashback Data Archive on the INVENTORY table. Which DDL operation is supported on the table after enabling Flashback Data Archive？（）  
A.  Drop the table.
B.  Partition the table.
C.  Truncate the table.
D.  Add a column to the table.
E.  Rename a column in the table.

[单项选择] You have enabled backup optimization in RMAN. You issue the following RMAN command to configure a redundancy-based retention policy: CONFIGURE RETENTION POLICY TO REDUNDANCY 3; Which statement is true?（）
A. The command fails because you cannot configure a redundancy-based retention policy when backup optimization is enabled
B. Backup optimization is performed, but RMAN considers the redundancy-based retention policy when it determines which datafiles should be backed up
C. Backup optimization is permanently disabled
D. Backup optimization is temporarily disabled because a redundancy-based retention policy is specified

[多项选择]To enable faster incremental backups, you enabled block change tracking for the database.Which two statements are true about the block change tracking file?（）
A. Multiple change tracking files can be created for a database.
B. The change tracking file must be created after the first level 0 backup.
C. RMAN does not support backup and recovery of the change tracking file.
D. The database clears the change tracking file and starts tracking changes again, after whole database restore and recovery operations.

[多项选择]You have enabled backup optimization for the RMAN environment. Identify two criteria on which RMAN will skip the file, if it has already been backed up.（） (Choose two.)
A. The data file backup is done with multiple channels
B. The data files is in the read-write mode after being backed up in the read only mode
C. The backup was taken after the data files was taken offline-normal or is in the read only mode
D. The data file backup complies with the back retention policy and the backup duplexing feature

[单项选择] OSPF is enabled on router A. You execute the following command on router A and receive theaccompanying output:RouterA#ping 224.0.0.5 repeat1Type escape sequence to abort.Sending 1, 1 00 - byte ICMP Echos to 224.0.0.5, timeout is 2 seconds:Reply to request 0 from 10.100.100.1, 4 ms10.100.100.1 is the IP address of a loopback interface on router A. What can you conclude about router A?（）
A. Only the router A loopback interface is parti cipating in the OSPF routing process
B. None of the router A interfaces are participating in the OSPF routing process
C. Router A is using the loopback interface IP address as its OSPF router ID
D. Router A does not have any reachable OSPF neighbors

[单项选择] After implementing full Oracle Data Redaction, you change the default value for the NUMBER data type as follows: After changing the value, you notice that FULL redaction continues to redact numeric data with zero. What must you do to activate the new default value for numeric full redaction?（）
A. Re-enable redaction policies that use FULL data redaction.
B. Re-create redaction policies that use FULL data redaction.
C. Re-connect the sessions that access objects with redaction policies defined on them.
D. Flush the shared pool.
E. Restart the database instance

[多项选择] You enabled an audit policy by issuing the following statements: SQL> AUDIT POLICY ORA_DATABASE_PARAMETER BY SCOTT; SQL> AUDIT POLICY ORA_DATABASE_PARAMETER BY SYS, SYSTEM; For which database users and for which executions is the audit policy now active? （）
A. SYS, SYSTEM
B. SCOTT
C. Only for successful executions
D. Only for failed executions
E. Both successful and failed executions

[单项选择]If you find such a flower, you are ______ enabled to have several days of good luck.
A. likely
B. assuredly
C. inevitably
D. supposedly

[单项选择] You create a Data Collector Set (DCS).You need prevent the DCS from logging data if the server has less than 1 GB of available disk space. What should you do？（）
A. Create a passive file screen.
B. Create an active file screen.
C. Modify the Data Manager settings of the DCS.
D. Modify the Stop Conditions settings of the DCS.

[单项选择]Which of the following data network would you implement if you wanted a wireless network that had a relatively high data rate, but was limited to very short distances?（）
A. Broadband personal comm. Service (PCS)
B. Broadband circuit
C. Infrared
D. Spread spectrum
E. Cable

[单项选择] You have enabled the Slow Query Log for a short period. When you process the Slow Query Log, you receive the following snip of output: Count: 100 Time=0 .22a (22s) Lock=0.00s (0s) Rows=0.0 (0), root[root] @localhost CREATE TABLE 't1' (id serial,id0 varchar(N) unique key,intcaoll INT (N) ,intco12 INT(N) ,intco13 INT(N) ,intco14 INT(N) ,intco15 INT(N) ,charcol1 VARVHAR(N) ,charcol2 VARCHAR(N) charcol3 VARCHAR (N) ,charcol4 VARVHAR(N) ,charcol5 VARCHAR(N) charcol6 VARCHAR (N) ,charcol7 VARVHAR(N) ,charcol8 VARCHAR(N) charcol9 VARCHAR (N) .charcol 10 VACHAR (N) ) Count: 64000 Time-0.02s (1213s) Lock=0.00s (6s) Rows=1.0 (64000), root [root]@ localhost SELECT intocl1, intco12, intco13, intco14, intco15, intco16,intco17, intco18 ,intcol9, intcol10, charcol1, charcol2, charcol3, charcol4, charcol5, charcol6 ,charcol7, charcol8, charcol9, charcol10 FROM t1 WHERE id = 's' Count: 1 Time=0.02s (0s) Lock=0.00s (0s) Rows=1.0 (1) agent [agent] @localhost SELECT Select_priv, Repl_client_priv, Show_db_priv, Super_priv, Process_priv FROM mysql.user WHERE CONCAT (user, 's', host) = CURRENT_USER （　） Count: 48000 Time=0.02s (778s) Lock=0.00 (3s) Rows=1.0 (48000), root[root]@localhost SELECT intocl1,intcol2,intcol3, intcol4, intcol5, charcol1, charcol2, charcol3 ,charcol4, charcol5, charcol6, charcol7, charcol8, charcol9, charcol10 FROM t1 WHERE id = 's' You want to tune the query such that it provides the greatest overall time savings. Which query will accomplish this?（）
A. CHEATE TABLE 't1' (id serial, id0 varchar (N) unique key, intcol1 INT (N) ,intcol2 INT (N), intcol3 INT(N) ,intcol4 INT(N), intcol5 INT(N), charool1 VARCHAR (N) ,charcol2 VARCHAR (N), charcol3 VARCHAR(N), charcol4 VARCHAR(N), charcol5 VARCHAR (N) ,charcol6 VARCHAR (N), charcol7 VARCHAR(N), charcol8 VARCHAR(N), charcol9 VARCHAR (N) ,charcol10 VARCHAR (N)
B. SELECT intcol1, intcol2, intcol3, intcol4, intcol5, intcol6, intcol7, intcol8, intcol9, Intcol10, intcol11, intcol12, intcol13, intcol14, intcol15, intcol16, intcol17, intcol18, intcol19, charcol10 FROM t1 WHERE id = 's'
C. SELECT Select_priv, Repl_client_priv, Show_db_priv, Super_priv, Process_priv FROM mysql.user WHERE CONCAT (user,'s', host) = CURRENT_USER()
D. SELECT intcol1, intcol2, intcol3, intcol4, intcol5, charcol1, charcol2, charcol3, charcol4, charcol5, charcol6, charcol7, charcol8, charcol9, charcol10 FROM t1 WHERE id = 's'

[单项选择]Which data dictionary table should you query to view the object privileges granted to the user on specific columns?（）
A. USER_TAB_PRIVS_MADE
B. USER_TAB_PRIVS
C. USER_COL_PRIVS_MADE
D. USER_COL_PRIVS

[单项选择]You need to perform certain data manipulation operations through a view called EMP_DEPT_VU, which you previously created. You want to look at the definition of the view (the SELECT statement on which the view was created.) How do you obtain the definition of the view?（）
A. Use the DESCRIBE command on the EMP_DEPT_VU view.
B. Use the DEFINE VIEW command on the EMP_DEPT_VU view.
C. Use the DESCRIBE VIEW command on the EMP_DEPT_VU view.
D. Query the USER_VIEWS data dictionary view to search for the EMP_DEPT_VU view.
E. Query the USER_SOURCE data dictionary view to search for the EMP_DEPT_VU view.
F. Query the USER_OBJECTS data dictionary view to search for the EMP_DEPT_VU view.