A complete database backup to media

多选题 A complete database backup to media is taken for your database every day.
Which three actions would you take to improve backup performance?

A、 Set the backup_tape_io_slaves parameter totrue.

B、 Set the dbwr_io_slaves parameter to a nonzero value if synchronous I/O is in use.

C、 Configure large pool if not already done.

D、 Remove the rate parameter, if specified, in the allocate channel command.

E、 Always use RMAN compression for tape backups rather than the compression provided by media manager.

F、 Always use synchronous I/O for the database.

查看答案

下载APP答题

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

相关试题

多选题 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 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.

查看答案

单选题 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.

查看答案

单选题 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

查看答案

多选题 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.

查看答案

单选题 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

查看答案

多选题 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.

查看答案