单项选择题

There is a problem with one of the disks used for your database and your system administrator informs you that the disk needs to be replaced. The replacement disk will not be available until tomorrow.
There was only one data file on this disk； it belongs to the USERS tablespace in your PROD database. Your PROD database runs in ARCHIVELOG mode and nightly online backups are taken. The users need to be able to access the data in the USERS tablespace before the replacement disk arrives. You have already taken the USERS tablespace offline and have restored the data file from last night’s backup to a new disk. Which additional steps are required in order to make the USERS tablespace available？（）

A.Only bring the tablespace back online.
B.Only recover the tablespace and then bring the tablespace back online.
C.Shut down the database， recover the data file and then start up the database.
D.Issue the ALTER DATABASE RENAME FILE command， recover the tablespace， and then bring the tablespace online.
E.Recover the tablespace， issue the ALTER DATABASE RENAME FILE command， and then bring the tablespace online.

<上一题目录下一题>

热门试题

多项选择题Whichtwoarecharacteristicsofuser-managedbackupandrecoveryoperations？（）

A.Recovery is initiated using SQL*Plus.
B.Database files are backed up using SQL commands.
C.Database files are backed up with Recovery Manager.
D.Database files are restored using Recovery Manager.
E.Database files are backed up using operating system commands.

单项选择题WhichcomponentoftheOraclenetworkingarchitectureprovidescharactersetanddatatypeconversionbetweendifferentcharactersetsontheclientandserver？（）

A.SQL*Plus
B.Oracle Net
C.Two-Task Common （TTC）
D.Oracle Protocol Support （OPS）

多项选择题SQL*Loaderisautilitythatcanperformwhichtwotasks？（）

A.Load data from a disk， tape， or named pipes.
B.Load data into an Oracle database using DML statements.
C.Extract， reorganize， and insert data within an Oracle database.
D.Load data from external files into tables in an Oracle database.
E.Load data into an Oracle database using operating system commands.
F.Load data directly from a non-Oracle database to an Oracle database.

多项选择题Inwhichthreesituationsisincompleterecoveryrequired？（）

A.After a shutdown abort.
B.When recovering to an SCN.
C.When recovering until a specific time.
D.When a required archived log is missing.

单项选择题AfterrunningtheCONFIGURERETENTIONPOLICYTORECOVERYWINDOWOF7DAYScommand，whathasbeenaccomplished？（）

A.Retain the data file backup for 7 days.
B.Run the recover process every 7 days.
C.Destroy the physical backup files every 7 days.
D.Destroy the physical backup files older than 7 days.
E.Retain one backup of each data file for at least 7 days.
F.Keep the catalog information in the control file for 7 days.