多项选择题
Which two statements regarding the LOGGING clause of the CREATE TABLESPACE... statement are correct？（）
A.This clause is not valid for a temporary or undo tablespace.
B.If the tablespace is in the NOLOGGING mode，no operation on the tablespace will generate redo.
C.The tablespace will be in the NOLOGGING mode by default，if not specified while creating a tablespace.
D.The tablespace-level logging attribute can be overridden by logging specifications at the table，index， materialized view，materialized view log，and partition levels.
相关考题
-
单项选择题
WhichtwooperationscanbeflashedbackusingtheFlashbacktechnology？（）
A.DROP USER SMITH；
B.DROP TABLE EMPLOYEES；
C.DROP TABLESPACE USERS；
D.ALTER TABLE SALES_REP DROP PARTITION P1；
E.ALTER TABLE EMPLOYEES DROP COLUMN DESIG_ID； -
单项选择题
Yourdatabaseishavingtwocontrolfiles，threeredologfilegroupswithtwomembersineachgroup.Failureofwhichfilewouldcauseaninstancetoshutdown？（）
A.any control file
B.any archive log file
C.one of the redo log members
D.loss of the initialization parameter file
E.any data file belonging to the default permanent tablespac -
单项选择题
Youhavebeenrecentlyhiredasadatabaseadministrator.YourseniormanagerasksyoutostudytheproductiondatabaseserverandsubmitareportonthesettingsdonebythepreviousDBA.Whileobservingtheserversettings，youfindthatthefollowingparameterhasbeensetintheparameterfileofthedatabase：REMOTE_OS_AUTHENT=TRUEWhatcouldhavebeenthereasontosetthisparameterasTRUE？（）
A.to enable operating system authentication for a remote client
B.to restrict the scope of administration to identical operating systems
C.to allow the start up and shut down of the database from a remote client
D.to enable the administration of the operating system from a remote client
E.to disable the administration of the operating system from a remote client
