移动端

  • 题王微信公众号

    题王微信公众号

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

计算机考试 | Oracle认证考试

模式切换

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

章节目录

多选题 Which three elements can a job chain process involve?()

A

an event

B

a schedule

C

a program

D

another chain

E

a lightweight job

单选题 The Oracle Database 11g database is running in the ARCHIVELOG mode. The archived redo log files are stored on three locations. The Flash Recovery Area is one of the locations. The details are given below: Which statement is true regarding what this command accomplishes?()

A

All archived redo log files backed up at least twice to tape are deleted.

B

All archived redo log files backed up at least once to tape are eligible for deletion.

C

All archived redo log files backed up at least twice to tape are deleted from the flash recovery area.

D

All archived redo log files in local archiving destinations and the flash recovery area backed up at least twice to tape are eligible for deletion.

多选题 Which three are the valid statements in relation to SQL plan baselines?()

A

The plans can be manually loaded to the SQL plan baseline.

B

The plans in the SQL plan baseline are verified and accepted plans.

C

The plans generated for every SQL statement are stored in the SQL plan baseline by default.

D

The plan baselines are stored temporarily in the memory as long as the database instance is running.

E

  For the SQL plan baselines to be accessible to the optimizer, the SYSAUX tablespace must be online.

多选题 Evaluate the following command and its output: Which two statements correctly interpret the output?()

A

FREE_SPACE indicates only the space that is currently unallocated.

B

ALLOCATED_SPACE indicates only the space currently allocated and in use.

C

FREE_SPACE indicates only the space that is currently allocated and available for reuse.

D

ALLOCATED_SPACE indicates both the space currently allocated and used, and the space that is available for reuse.

E

FREE_SPACE indicates both the space that is currently allocated and available for reuse, and the space that is currently unallocated.

多选题 Which two statements are true regarding the USING and ON clauses in table joins?()

A

Both USING and ON clauses can be used for equijoins and nonequijoins 

B

Amaximum of one pair of columns can be joined between two tables using the ON clause 

C

The ON clause can be used to join tables on columns that have different names but compatible data types 

D

The WHERE clause can be used to apply additional conditions in SELECT statements containing the ON or the USING clause 

多选题 USER_DATA is a nonencrypted tablespace that contains a set of tables with data. You want to convert all existing data in the USER_DATA tablespace and the new data into the encrypted format. Which methodswould you use to achieve this?()

A

Use Data Pump to transfer the existing data to a new encrypted tablespace

B

Use ALTER TABLE MOVE to transfer the existing data to a new encrypted tablespace

C

Use CREATE TABLE AS SELECT to transfer the existing data to a new encrypted tablespace

D

Enable row movement for each table to be encrypted and then use ALTER TABLESPACE to encrypt the tablespace

E

Encrypt the USER_DATA tablespace using the ALTER TABLESPACE statement so that all the data in the tablespace is automatically encrypted

单选题 Which command will restore all datafiles to the date 9/30/2008 at 18:00 hours? ()

A

restore datafiles until time '09/28/2008:21:03:11'

B

restore database files until time '09/28/2008:18:00:00'

C

restore database until time '09/28/2008:18:00:00'

D

recover database until time '09/28/2008:18:00:00'

E

recover database until timestamp '09/28/2008:18:00:00'

多选题 When does a transaction complete?()

A

when a DELETE statement is executed 

B

when a ROLLBACK command is executed 

C

when a PL/SQL anonymous block is executed 

D

when a data definition language (DDL) statement is executed 

E

when a TRUNCATE statement is executed after the pending transact ion

单选题 How is block-change tracking enabled?()

A

With alter database enable block change tracking

B

With alter system enable block change tracking 

C

With an init.ora parameter change 

D

With an spfile parameter change 

最新资讯

首页 上一页 1 2 3 4 5 下一页 尾页 /

到第