单项选择题

Due to media failure you lost one of the data files belonging to the USERS tablespace， and the tablespace is not available to use. Which statement regarding the status of the database is true？（）

A.The database remains open.
B.The database gets dismounted.
C.The database becomes read only.
D.The database instance gets aborted.
E.The database gets shut down automatically.
F.The status of the database depends on the status of the USERS tablespace.

<上一题目录下一题>

热门试题

多项选择题OnwhichthreecanyouuseRecoveryManager（RMAN）toperformincrementalbackup？（）

A.data files
B.control files
C.tablespaces
D.password file
E.parameter file
F.whole database
G.flashback log file
H.archived log files
I.change tracking file

单项选择题Asadatabaseadministratoryouspendalotoftimeobservingandsettingvariousstorageparametervaluesforyourapplicationtablesinordertogainperformancebenefits.Whichtaskwouldyouperformtoreducethisoverhead？（）

A.Coalesce the application tables at a regular interval.
B.Export and Import the application tables a regular interval.
C.Drop and recreate the application tables at a regular interval.
D.Move the application tables to a tablespace with less space usage.
E.Distribute the application tables across multiple tablespaces depending on usage.
F.Move the application tables to automatic segment space management tablespace.

多项选择题Exhibit： View the Exhibit to see the structure of the EMPLOYEES and DEPARTMENTS tables. Your organization plans to dissolve the department with department ID 30. You execute the following command to delete rows from the DEPARTMENTS table： SQL>delete from DEPARTMENTS where DEPT_ID = 30； The command fails and displays the following error： ERROR at line 1： ORA-02292： integrity constraint （HR.SYS_C005374） violated - child record found Which two actions would you take to overcome this error？（）

A.A
B.B
C.C
D.D
E.E
F.F

单项选择题Yourdatabaseperformancehasdegradedduetofrequentcheckpointing.Whatwouldyoudointhisscenario？（）

A.make redo log files smaller
B.increase the size of the checkpoint file
C.make the changes as per the advice given by MTTR Advisor
D.make the changes as per the advice given by Checkpoint Advisor

单项选择题Youwantthesizeofthetablespacetoincreasewhenitisfull.Whichoptionwouldyouuse？（）

A.use automatic extent allocation
B.disable threshold for the tablespace
C.use freelists to manage the free space
D.use automatic segment space management
E.create the tablespace as a bigfile tablespace
F.use the RESIZE clause while creating the tablespace
G.enable AUTOEXTEND for at least one of the data files in the tablespace