移动端

  • 题王微信公众号

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

计算机考试 | Oracle认证考试

模式切换

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

章节目录

单选题 Which statement is true regarding the Archiver (ARCn) process,archived log files,and recovery? ()

A

A database backup, combined with archived redo log files, guarantees that all committed data can be recovered to the point of failure. 

B

During recovery the ARCn background process copies its redo entries identified for recovery by the control file to the data files. 

C

After each write to an archived log, the mandatory background process ARCn writes its log sequence number and the first and last SCN number within the log sequence to the control file. 

D

At database recover time, and archived redo log is uniquely identified for recovery use by its redo thread number and destination ID number retrieved from the control file.

单选题 Consider the following statement:   SQL> EXECUTE DBMS_STATS.GATHER_SHEMA_STATS (-  2> ownname => ‘OE’, -  3> estimate_percent => DBMS_STATS.AUTO_SAMPLE_SIZE, -  4> method opt => ‘for all columns size AUTO’);   What is the effect of ‘for all columns size AUTO’ of the METHOD_OPT option?()

A

The Oracle server creates a new histogram based on existing histogram definitions for all table, column, and index statistics for the OE schema. 

B

The Oracle server creates a histogram based on data distribution regardless of how the application uses the column/s for all table, column, and index statistics for the OE schema.

C

The Oracle server creates a histogram based on data and application usage of the column/s for all table, column, and index statistics for the OE schema. 

D

The Oracle server creates a histogram based on application usage, regardless of data distribution, for all table, column, and index statistics for the OE schema.

单选题 A client/server application has been configured to use local naming. The client and server run on separate machines. When the client tries to connect, it receives a TNS error. By carefully examining the environment, a tnsnames.ora is found only on the Oracle server machine, among other things. After copying this tnsnames.ora onto the client machine, the client is able to connect to the server.  Which statement is true?()

A

tnsnames.ora must be on the client machine for local naming. 

B

tnsnames.ora must be removed from the server for the connection to work. 

C

tnsnames.ora must be on both the client and server machines for local naming. 

D

tnsnames.ora is not required for local naming; the problem was not fixed by copying the file to the client.

单选题 In user-managed backup and recover procedures, how are data files backed up? ()

A

Using SQL commands.

B

Using SQL*Plus commands.

C

Using operating system commands.

D

Using Recover Manager commands.

多选题 The RMAN BACKUP command using the DELETE INPUT option can be used with which three types of files? ()

A

data files

B

backup sets

C

control files

D

archived redo log files

最新资讯

1 2 3 4 5 下一页 尾页 /

到第