移动端

  • 题王微信公众号

    题王微信公众号

    微信搜“题王网”真题密题、最新资讯、考试攻略、轻松拿下考试

计算机考试 | Oracle认证考试

模式切换

0 0 0
我的错题 我的收藏 学习笔记

章节目录

单选题 You are peer reviewing a fellow DBAs backup plan for his NOARCHIVELOG mode database, as shown here:   Put the tablespaces in backup mode.  Back up the datafiles for all tablespaces. Take the tablespaces out of backup mode. Back up all archived redo logs.   Your colleague asks for you to comment on his plan.  Which response would be correct?()

A

 The plan will work as is.

B

 The plan needs to be modified to allow for an archive-log switch after step 3.

C

 The plan needs to be modified so that a backup of the archived redo logs occurs before step 1.

D

 The plan needs to be adjusted to shut down the database after step 1 and to restart the database after step 2.

E

 The plan cannot work as presented.

多选题 Which options would you consider while configuring a flash recovery area fast recovery area in 11g Release 2 for your production database that is running in ARCHIVELOG mode?() 

A

 Setting the FAST_START_MTTR_TARGET to set the mean time to recover

B

 Setting the RECOVERY_PARALLELISM parameter to twice the number of CPUs

C

 Using the DB_RECOVERY_FILE_DEST parameter to set the location for flash recovery area

D

 Using the DB_RECOVERY_FILE_DEST_SIZE parameter to define the disk space limit for the recovery files created in the flash recovery area

多选题 Which of the following restrictions are not true with respect to tablespace point-in-time recovery?()

A

 The target database must be in NOARCHIVELOG mode.

B

 No backup is required of the database before you perform a TSPITR.

C

 You must have all archived redo logs generated since the last backup up to the point to which you want to restore the transport set.

D

 If you rename a tablespace, you can not perform a TSPITR to any point in time before that rename operation occurred.

E

 If you have tables in tablespace_1 that have associated constraints in tablespace_2,then you must transport both tablespaces.

多选题 You want to analyze a SQL Tuning Set (STS) using SQL Performance Analyzer in a test database. Which two statements are true regarding the activities performed during the test execution of SQLs in a SQL Tuning Set?()

A

 Every SQL statement in the STS is considered only once for execution.

B

 The SQL statements in the STS are executed concurrently to produce the execution plan and execution statistics.

C

 The execution plan and execution statistics are computed for each SQL statement in the STS. 

D

 The effects of DDL and DML are considered to produce the execution plan and execution statistics.

单选题 Which of the following is a potential performance tuning recommendation from the SQL Access Advisor?()  

A

 Create new indexes.

B

 Modify existing indexes.

C

 Implement partitioning on a nonpartitioned table.

D

 Create materialized views.

E

 All of the above

单选题 You are managing an Oracle Database 11g database. You want to take a backup on tape drives of the USERS tablespace that has a single data file of 900 MB. You have tape drives of 300 MB each. To accomplish the backup, you issued the following RMAN command: RMAN> BACKUP SECTION SIZE 300M TABLESPACE users; Identify the appropriate configuration to accomplish faster and optimized backups using the above command.()

A

The SBT channel must be configured, with the MAXPIECESIZE set to 300 mb.

B

The SBT channel must be configured, with the parallelism setting for the SBT devices set to 3.

C

The COMPATIBLE initialization parameter for the database instance must be set to at least 10.0.

D

The SBT channel must be configured, with the default parallelism setting for the SBT devices set to 1

多选题 Which commands are used for RMAN database recovery?()

A

 restore

B

 repair

C

 copy

D

 recover

E

 replace

多选题 What is the purpose of the RMAN recovery catalog?()

A

 Make backups faster

B

 Store RMAN metadata

C

 Store RMAN scripts

D

 Provide the ability to do centralized backup reporting

E

 Make recovery faster

多选题 Which two client requests are captured during database replay Capture?() (Choose two)

A

Flashback queries

B

Shared server requests

C

Login and logoff activities of sessions

D

Direct path load of data from external files by using utilities such as SQL *loader

E

Data definition language (DDL) and data manipulation language (DML) operations

最新资讯

1 2 3 4 5 下一页 尾页 /

到第