单项选择题Management has decided that the database must be available 24 hours a day, 7 days a week. Given this requirement, which type of backup is required?()

A.user-managed backups.
B.partial database backups.
C.consistent database backups.
D.inconsistent database backups.


您可能感兴趣的试卷

你可能感兴趣的试题

1.多项选择题Oracle Net Configuration Assistant is a post-installation tool that configures basic network components after installation. Which four components are included in the configuration?()

A.Directory server
B.Hostname adaptor
C.TCP/IP host file
D.Connection Manager
E.connecting pooling
F.external procedures
G.listener names and protocol addresses
H.Net Service names in a tnsnames.ora file
I.naming methods the client uses to resolve connect identifiers

2.多项选择题Which two file types must be included in a closed database backup taken with operating system commands?()

A.data files
B.control file
C.password file
D.online redo log files
E.initialization parameter file

3.多项选择题Which four occur during the processing of a request using Oracle Shared Server?()

A.The dispatcher returns the response to the user.
B.The dispatcher places the request into the request queue.
C.The shared server places the response in the response queue.
D.The response is handed off to the next available dispatcher.
E.A shared server picks up the request from the request queue and processes the request.

5.单项选择题

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.

6.多项选择题Which two are characteristics of user-managed backup and recovery operations?()

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.

8.多项选择题SQ L*Loader is a utility that can perform which two tasks?()

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.

9.多项选择题In which three situations is incomplete recovery required?()

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.

10.单项选择题After running the CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS command, what has been accomplished?()

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.

最新试题

Which one of the following statements about the TNSPING utility is correct?()

题型:单项选择题

Where can you obtain information about full database backup set created using RMAN, if the control file was used as the repository?()

题型:单项选择题

Which of the following packages maintains information in the recovery catalog? ()

题型:单项选择题

Which of the following options enables a user to get authenticated though a single password instead of using multiple passwords?()

题型:单项选择题

Which one of the following RMAN commands is used to register the database files with repository that were backed up using O/S commands?()

题型:单项选择题

Which Oracle background process frees SGA resources that were allocated to a user process that failed?()

题型:单项选择题

Which of the following roles must be granted to a user to perform a full database import?()

题型:单项选择题

After a number of days set by the parameter CONTROL_FILE_RECORD_KEEP_TIME, the information in the control file is overwritten by RMAN. What is this parameter’s default value?()

题型:单项选择题

Which one of the following files contains records that do not meet the specified load criteria in the SQL*Loader control file?()

题型:单项选择题

Which of the following views must you query to identify any corrupt data file blocks that have been detected during backup set creation?()

题型:单项选择题