移动端

  • 题王微信公众号

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

计算机考试 | Oracle认证考试

模式切换

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

章节目录

多选题 In your database, the Log Writer (LGWR) process is unable to write to a member of a current redo log group due to read/write failure. Which two effects would you see in your database?()

A

The database instance aborts.

B

The database operation temporarily halts till the member becomes available.

C

Writing proceeds as normal. LGWR writes to the available members of a group and ignores the unavailable members.

D

The member would be marked as STALE and an error message would be written to the alert log file and LGWR trace file.

E

The status of the group changes to INACTIVE and an error message would be written to the alert log file and LGWR trace file.

单选题 You manually create an additional listener process,L1,for databases PROD,  PAYDB and FINDB. While starting up the listener process,you get the following error message: LSNRCTL> start l1  Starting /u01/app/oracle/product/10.1.0/db_1/bin/tnslsnr: please wait...  TNSLSNR for Linux: Version 10.1.0.2.0 - Production  System parameter file is /u01/app/oracle/product/10.1.0/db_1/network/admin/listener.ora Log messages written to /u01/app/oracle/product/10.1.0/db_1/network/log/l1.log Error listening on: (ADDRESS=(PROTOCOL=TCP)(HOST=144.23.230.185)(port=8899))  TNS-12542: TNS:address already in use TNS-12560:  TNS:protocol adapter error TNS-00512: Address already in use  Linux Error: 98: Address already in use  Listener failed to start. See the error message(s) above...  What action would you take to overcome this error without disrupting any existing database communications?()

A

stop and restart the listener process

B

set the TNS_ADMIN environmental variable

C

stop all running listener processes and restart the listener process

D

change the port number to an unused port number and restart the listener process

E

change the IP address to host machine name in the LISTENER.ORA file and restart the listener process

多选题 Which three statements are correct about temporary tables?()

A

Indexes and views can be created on temporary tables.

B

Both the data and the structure of temporary tables can be exported.

C

Temporary tables are always created in a user’s temporary tablespace.

D

The data inserted into a temporary table in a session is available to other sessions.

E

Data manipulation language (DML) locks are never acquired on the data of temporary tables.

单选题 You work as a database administrator for Certkiller .com. While granting a role,SELECT_CATALOG_ROLE, to a user, Certkiller, using Oracle Enterprise Manager 10g Database Control, you have cleared the DEFAULT check box. What will be the result?()

A

The user cannot use the role at all.

B

The role would not be granted to the user.

C

The user needs to enable the role explicitly.

D

The user can start using the role immediately.

E

The user would have the admin option for the role.

单选题 You work as a database administrator for Supportcenter.cn. On a Monday morning, you find the database instance aborted. After inspecting the alert log file, you execute the STARTUP command in SQL*Plus to bring the instance up. What statement is true?()

A

PMON coordinates media recovery.

B

SMON coordinates instance recovery.

C

PMON coordinates instance recovery.

D

Undo Advisor would roll back all uncommitted transactions.

E

SQL*PLUS reports an error with the message asking you to perform instance recovery.

多选题 In which two cases would you perform only consistent backup?()

A

You are working on a database where downtime is not tolerated.

B

You are working on a database where downtime can be tolerated.

C

You are working on a database that operates in ARCHIVELOG mode.

D

You are working on a database that operates in NOARCHIVELOG mode.

E

You are working on a database where all the tablespaces are locally managed.

F

You are working on a database where control files and redo log files are multiplexed.

G

You are working on a database where control files and redo log files are not multiplexed.

单选题 In your Certkiller .com production database, you find that the database users are able to create and read files with unstructured data, available in any location on the host machine from an application.  You want to restrict the database users to access files in a specific location on the host machine.  What could do to achieve this?()

A

Modify the value for the UTL_FILE_DIR parameter in the parameter file

B

Grant read and write privilege on the operating system path to the database users

C

Modify the value for the LDAP_DIRECTORY_ACCESS parameter in the parameter file

D

Modify the value for the PLSQL_NATIVE_LIBRARY_DIR parameter in the parameter file

E

Create a directory object referring to the operating system path, and grant read and write privilege on the directory object to the database users

单选题 You work as a database administrator for Supportcenter.cn. Users complain that their query is taking a long time to complete. You suspect the database buffer cache size to be the reason, and you define an alert to be generated when the buffer cache hit metric goes below 85%. When you observe the dynamic performance views, you find that the buffer cache hit ratio is 81% but no alerts are being generated.  What could be the reason for this problem?()

A

The advisory memory has been turned off.

B

The DB_CACHE_ADVICE parameter has been set to OFF in the parameter file.

C

The STATISTICS_LEVEL parameter has been set to BASIC in the parameter file.

D

The TIMED_STATISTICS parameter has been set to FALSE in the parameter file.

E

The STATISTICS_LEVEL parameter has been set to TYPICAL in the parameter file.

最新资讯

1 2 3 4 5 下一页 尾页 /

到第