单项选择题
The DB_BLOCK_CHECKING initialization parameter is set to OFF. Which block checking would be performed？（）
A. The Oracle database will perform block checking for the index blocks only
B. The Oracle database will not perform block checking for any of the data blocks
C. The Oracle database will perform block checking for the default permanent tablespace only
D. The Oracle database will perform block checking for the data blocks in all user tablespaces
E. The Oracle database will perform block checking for the data blocks in the SYSTEM tablespace only
相关考题
-
单项选择题
A database is running in ARCHIVELOG mode and regular backups are performed. A user receives the following error message： Which is the recommended sequence of operations you need to perform for the query successfully？（）
A. Drop the affected tablespace，re-create the tablespace，restore the datafiles，and the tablespace.
B. Take the affected datafile offline（if not already offline），restore the damaged image of the datafile，and then bring it online.
C. Restart the database in MOUNT mode，restore the damaged datafile，recover the datafile and then open the database with resetlogs.
D. Put the database in RESTRICTED mode，restore all the datafiles in the affected datafile and recover the tablespace，and then put the database in normal operational mode. -
单项选择题
You are managing an ASM instance. You previously issued the following statements： ALTER DISKGROUP dg1 DROP DISK disk2； ALTER DISKGROUP dg1 DROP DISK disk3； ALTER DISKGROUP dg1 DROP DISK disk5； You want to cancel the disk drops that are pending for the DG1 disk group. Which statement should you issue？（）
A. ALTER DISKGROUP dg1 UNDROP disk2，disk3，disk5
B. ALTER DISKGROUP dg1 UNDROP
C. ALTER DISKGROUP dg1 UNDROP DISKS
D. You cannot cancel the pending disk drops -
多项选择题
WhichstatementsabouttheMEMORY_TARGETinitializationparameteraretrue？（）
A. MEMORY_TARGET can be increased up to the value of MEMORY_MAX_TARGET， if MEMORY_MAX_TARGET is set to a value greater than zero
B. MEMORY_MAX_TARGET defaults to a value of zero if MEMORY_TARGET is not set
C. MEMORY_TARGET represents the total amount of memory that can be allocated to SGA and PGA memory structures.
D. MEMORY_TARGET is static and cannot be modified without shutting down the instance
