Your database is configured for ARCH

多选题 Your database is configured for ARCHIVELOG mode, and a daily full database backup is taken.
RMAN is configured to perform control file autobackup. In which three scenarios do you need media
Recovery?

A、 abnormal termination of the database instance

B、 loss of all the inactive online redo log group members

C、 loss of all the copies of the control file

D、 loss of a data file that belongs to the active undo tablespace

E、 loss of data files that belong to the SYSTEM tablespace

F、 logical corruption of data that is caused by a wrong transaction

查看答案

下载APP答题

由4l***6s提供分享举报纠错

相关试题

单选题 What is a requirement for creating a remote database scheduler job?

A、 The remote database job must run as a user that is valid on target remote database

B、 A private database link must be created from the originating database to the target remote
Database

C、 The target remote database on which the job is scheduled must be Oracle Database 11g
Release 2 or later

D、 The target remote database must be on a different host from the originating scheduler
Database host

查看答案

多选题 Which four are true about creating and running a remote database scheduler jobs?

A、 A database destination must exist or be created for the remote database.

B、 A database destination group must exist or be created for a job to run on multiple remote
Databases.

C、 A credential is optional for a remote database job.

D、 It must run as a user that is defined on the remote database.

E、 A destination is optional for a remote database job because DB links can be used instead.

F、 A credential must be created to define the remote user.

G、 Remote database jobs always run as the same user who submits the job on the local
Database.

查看答案

多选题 Which two statements are true about SQL*Loader Express Mode in an Oracle 12c database?

A、 It loads data faster than conventional SQL*Loader.

B、 It requires Enterprise Manager Express to be configured.

C、 It loads data more efficiently than conventional SQL*Loader.

D、 It can load data in parallel.

E、 No data file needs to be specified.

查看答案

多选题 Which two statement are true about using SQL*Loader?

A、 It can load data into only one table at a time.

B、 It can load data from external files by using direct path only.

C、 It can generate unique sequential key values in specified columns.

D、 It can load data from external files by using conventional path only.

E、 It can load data into multiple tables using the same level statement.

查看答案

多选题 You plan to upgrade your Oracle Database 9i to Oracle Database 12c. Which two methods can
You use?

A、 Perform a direct upgrade by manually running the catctl.pl and catupgrd.sql scripts before
Issuing the STARTUPUPGRADE command.

B、 Perform a rolling upgrade.

C、 Install the Oracle Database 12c software, create a new Oracle 12c database, and then use
The Oracle Data Rump to import data from the source Oracle 9i database to the target
Oracle 12c database.

D、 Upgrade your current database to Oracle Database release 10.2.0.5, and then upgrade
To Oracle Database 12c.

E、 Perform a direct upgrade by running the Database Upgrade Assistant (DBUA).

查看答案

多选题 Which three statements are true PFILEs, SPFILEs or both?

A、 SPFILEs and PFILES may both be edited with an O/S editing utility.

B、 All SPFILE parameters can be modified successfully with the SCOPE=MEMORY clause.

C、 Some SPFILE parameters can be modified successfully with the SCOPE=MEMORY clause.

D、 A PFILE can be created by an idle instance.

E、 A SPFILE can be created by an idle instance.

F、 All SPFILE parameters can be modified successfully with the SCOPE=BOTH clause.

查看答案

单选题 Your production database uses file system storage. You want to move storage to Oracle
Automatic Storage
Management (ASM). How would you achieve this?

A、 by using RMAN

B、 by using Data Pump

C、 by using the Database Upgrade Assistant (DBUA)

D、 by using a transportable database

查看答案

单选题 Examine the parameters for a database

Your database has three undo tablespaces and the default undo tablespace is not
Autoextensible. Resumable space allocation is not enabled for any sessions in the database
Instance. What is the effect on new transactions when all undo space in the default undo
Tablespace is in use by active transaction?

A、 Transactions write their undo in a temporary tablespace.

B、 Transactions fail.

C、 Transactions write their undo in the SYSTEM undo segment.

D、 Transactions wait until space becomes available in UNDOTBS1.

查看答案