You executed the following command to perform a backup of the USERS tablespace：SQL> ALTER TABLESPACE users BEGIN BACKUP；ALTER TABLESPACE users BEGIN BACKUP*
ERROR at line 1：
ORA-01123： cannot start online backup； media recovery not enabled What could be the reason for this error（）

单项选择题The TRANS_SUMMARY table contains product-wise transaction details that get updated with every transactionin the system. Each row has cumulative transaction details of a single product and every product is identified bya product code， which is the primary key.As part of the archival process， the company wants to transfer therows in the TRANS_SUMMARY table to the TRANS_SUMMARY_DUP table at the end of every quarter of theyear. Along with existing products， the company deals with many new products during every quarter. Whichmethod is best suited for this quarterly data transfer（）

A.Using the MERGE command
B.Using the SQL*Loader utility
C.Using the correlated UPDATE command
D.Using the INSERT command to perform bulk operation

多项选择题Whichtwostatementsaboutthebackgroundprocessofthedatabasewriteraretrue（）

A.It is possible to have multiple database writers in an Oracle instance.
B.It writes dirty buffers， if any， to data files whenever a checkpoint occurs.
C.It writes dirty buffers， if any， to data files whenever a transaction commits.
D.It writes dirty buffers， if any， to data files before the log writer （LGWR） writes

单项选择题To make audit information more productive， the DBA executes the following command before starting an auditoperation： SQL> ALTER SYSTEM SET AUDIT_TRAIL=DB，EXTENDED SCOPE=SPFILE； Which statement is true regarding the audit record generated when auditing starts after restarting Thedatabase（）

A.It contains only the plan for the SQL statement executed by the user.
B.It contains the SQL text executed by the user and the bind variables used with it.
C.It contains the plan and statistics associated with the SQL statement executed by the user.
D.It contains the plan for the SQL statement executed by the user and the bind variables used with it

单项选择题View the Exhibit. You want to create a tablespace to contain objects with block size 16 KB. But while configuring the storage you find that the block size that you can provide is only 8 KB.  Which configuration couldhave enabled the block selection of 16 KB（）

A.Choosing the extent allocation type to uniform
B.Choosing the Segment Space Management option to manual
C.Setting autoextension on for the data file mentioned for the tablespace
D.Setting the DB_16K_CACHE_SIZE parameter for the database instance to a nonzero value

单项选择题You have issued a SHUTDOWN ABORT command to bring down your database instance. Consider the stepsthat will be performed later when you open the database： 1. SGA is allocated. 2. Control file is read. 3. Redo log files are read. 4. Instance recovery is started. 5. Background processes are started. 6. Data files are checked for consistency. 7. Server parameter file or the initialization parameter file is read.  Which option has the correct order in which these steps occur（）

A.7， 1， 5， 2， 3， 6， 4
B.1， 2， 3，7， 5， 6， 4
C.7， 1， 4， 5， 2， 3， 6
D.1， 7， 5， 4， 2， 3， 6