Which three statements are true abou

多选题 Which three statements are true about Oracle checkpoint processing?

A、 Thread checkpoints ensure that all dirty buffers are written to data files during a normal shutdown.

B、 It reduces the recovery time from instance failures.

C、 Frequent thread checkpoints can degrade database performance.

D、 Database Writer (DBWn. processes write checkpoint information to datafile headers and the control file.

E、 Incremental checkpoints write some dirty buffers to the datafiles and unwritten redo to the online redo logs.

查看答案

下载APP答题

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

相关试题

单选题 Examine these commands and output:SELECT open_mode from v4database;------------------------------------READ WRITEARCHIVE LOG LIST;Database log mode No archive ModeAutomatic archive DsiabledArchive destination USE_DB_RECOVERY_FILE_DESTNow examine these steps1 STARTUP NOMOUNT2 STARTUP MOUNT3 STARTUP FORCE4 ALTER DATABASE ARCHIVELOG5 ALTER DATABASE MOUNT;6 ALTER DATABASE OPWEN RESETLOGS7 SHUTDOWN IMMEDIATE8 ALTER DATABASE OPEN;Identify the required steps in the correct order to change the database to run in ARCHIBELOG mode.

A、7,1,4,5,6

B、7,2,4,8

C、3,4,8

D、7,2,4,6

E、3,4,6

查看答案

单选题 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 datbase link must be created from the originating database to the target remote database

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

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

查看答案

单选题 Examine the parameters for a database instance：NAME TYPE VALUETemp_undo_enabled boolean TRUEUndo_management string AUTOUndo_retention integer 900Undo_tablespace string UNDOTBS1Your 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.

查看答案

单选题 You must upgrade your Oracle 11g Database to Oracle 12c R2. Which method can you use?

A、Use Enterprise Manager Express.

B、Use SQL*Developer

C、Use the Database Creation Assistant(DBCA.to upgrade

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

E、Perform a rolling upgrade.

查看答案

单选题 One of your databases has archive logging enabled and RMAN backups are taken at regular intervals. The data file for the USERS tablespace is corrupt. Which command must you execute before starting the recovery of this tablespace?

A、 SWITCH DATAFILE ALL;

B、 STARTUP FORCE

C、 ALTER TABLESPACE users OFFLINE TEMPORARY;

D、 ALTER TABLESPACE users OFELINE NORMAL;

E、 ALTER TABLESPACE users OFFLINE IMMEDIATE;

查看答案

单选题 Examine the details of he uncompressed,non-partitioned heap table CITIES.Name null typeCITYID NOT NULL NUMBER(4.CITY_NAME VARCHAR2(50.Examine the command:SQL>ALTER TABLE cities SHRINK SPACE COMPACT;What must you do before executing it?

A、Make sure that row movement is disabled

B、Disable any constraints on the table.

C、Make sure that row movement is enabled.

D、Make any invisible indexes on the table visible.

E、Make all indexes on the table invisible.

查看答案

单选题 You must create a table, DAILY_ORDERS, for a DSS application. Data should be compressed when using direct-path INSERT the table will also be used for occasional Dss queries.Load performance is criticalWhich compression option satisfies these requirements?

A、COLUMN STORE COMPRESS FOR QUERY HIGH

B、ROW STORE COMPRESS ADVANCED

C、COLUNN STORE COMPRESS FOR QUERY LOW

D、COLUNN STORE COMPRESS FOR ARCHIVE HIGH

E、COLUNN STORE COMPRESS FOR ARCHIVE LOW

查看答案

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

查看答案