移动端

  • 题王微信公众号

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

计算机考试 | Oracle认证考试

模式切换

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

章节目录

单选题 You work as a database administrator for Supportcenter.cn. You are using Recovery Manager (RMAN) for backup and recovery of your database. You executed the delete command in RMAN to delete a backup of a tablespace. Which statement is true in this scenario?()

A

The backup status will be marked expired in RMAN recovery catalog.

B

The backup status will be marked deleted in RMAN recovery catalog after you execute the crosscheck command.

C

The backup will be deleted physically from the OS (Operating system)and the backup information is removed from the recovery catalogl

D

The backup status will be marked deleted and you must delete the backup file manually from the OS (Operating system).

E

The backup status will be marked deleted and you must delete the backup file manually from the OS (Operating system), if you are not using Oracle Managed Files (OMF).

单选题 Your test database is running in NOARCHIVELOG mode. What are the implications of this? ()

A

You can perform open database backups.

B

You can perform closed database backups.

C

You cannot perform schema-level logical backups.

D

You can perform the backup of only the SYSTEM tablespace when the database is open.

单选题 You work as a database administrator for Certkiller .com. In your Oracle database10g installation you have set ORACLE_BASE to /u01/app/oracle.  Which objective will be achieved by this setting?()

A

The Oracle kernel will be placed in this location.

B

The Oracle software will be placed in this location.

C

The server parameter file (SPFILE) will be placed in this location.

D

The database files will be placed in this location, if not specified explicitly.

E

The location will be considered for the base of Oracle Managed Files (OMF).

F

The location will be considered for the base of Optimal Flexible Architecture (OFA).

多选题 You work as a database administrator for Supportcenter.cn. While setting up the database for your production environment, you want to create a user according to the requirements in the exhibit. Which three options of the CREATE USER command would you use to achieve this objective?()

A

Profile

B

Account lock

C

Account unlock

D

Password expire

E

Quota 10MB on SupportCenter TBS1

F

Password never expire

G

Defaulttablespace SupportCenter TBS1

H

Quota unlimited on SupportCenter TBS1

I

TemporarytablespaceTEMP

J

TemporarytablespaceSYSTEM

单选题 Your database is running under automatic undo management and the UNDO_RETENTION parameter is set to 900 sec. You executed the following command to enable retention guarantee:  SQL> ALTER TABLESPACE undotbs1 RETENTION GUARANTEE;  What effect would this statement have on the database?()

A

The extents in undo tablespace retain data until the next full database backup.

B

The extents containing committed data in the undo tablespace are never overwritten.

C

The extents which no longer contain uncommitted data in the undo tablespace are not overwritten for at least15 minutes.

D

The extents containing committed data in the undo tablespace are not overwritten until the instance  is shut down.

单选题 You work as a database administrator for Certkiller .com. When you tried to connect to the database, you received the following error: ERROR:  ORA-12541:TNS:no_listener  You found that the listener is not running on the server, so you issued the following command in the Listener Control utility to start the listener.  lsnrctl>START  What statement is true?()

A

It would attempt to start the default listener

B

It would start the most recently created listener.

C

It would display an error with a message asking for the listener name to be specified.

D

It would show you a list of listeners and prompts for the listener name that you want to start.

多选题 You work as a database administrator for Certkiller .com. Your database is opened in NOARCHIVEKLOG mode. You decide to place the database in ARCHIVELOG mode.  How would you do this?()

A

Execute the ALTER DATABASE ARCHIVELOG statement 

B

Select ARCHIVELOG option in the database control and restart the database to apply the changes. 

C

Shut down and start the instance, and in the NOMOUNT state execute the ALTER DATABASE ARCHIVELOG statement. 

D

Shut down and start the instance, mount the database, then execute the ALTER DATABASE ARCHIVELOG statement. 

最新资讯

1 2 3 4 5 下一页 尾页 /

到第