多项选择题
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()
单项选择题 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()
单项选择题 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()