移动端

  • 题王微信公众号

    题王微信公众号

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

计算机考试 | Oracle认证考试

模式切换

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

章节目录

单选题 User A executes the following command to drop a large table in your database: SQL> DROP TABLE trans;  While the drop table operation is in progress, user B executes the following command on the same table: SQL> DELETE FROM trans WHERE tr_type=’SL’;  Which statement is true regarding the DELETE command()

A

It fails with a Resource Busy error.

B

It deletes the rows successfully because the table is locked in SHARE mode.

C

It fails to delete the records because the table is locked in EXCLUSIVE mode.

D

It deletes the rows successfully because the table is locked in SHARE ROW EXCLUSIVE mode.

多选题 You set the following parameters in the parameter file and restarted the database:MEMORY_MAX_TARGET=0MEMORY_TARGET=500M PGA_AGGREGATE_TARGET=90MSGA_TARGET=270M Which two statements are true about these parameters after the database instance is restarted()

A

The MEMORY_MAX_TARGET parameter is automatically set to 500 mb.

B

The pga_AGGREGATE_TARGET and sga_TARGET parameters are automatically set to zero.

C

The value of the MEMORY_MAX_TARGET parameter remains zero until it is changed manually.

D

The lower bounds of pga_AGGREGATE_TARGET and sga_TARGET parameters are set to 90 nb and270 mb, respectively

多选题 Which two statements describe good practices for an application developer to reduce lockingconflicts in Oracle database()

A

Avoid coding unnecessary long-running transactions.

B

Allow the database to handle locks in default locking mode.

C

Always explicitly code the locks as per the requirement of the application.

D

Allow escalation of row locks to block locks if too many row locks cause problem.

单选题 ou are in the middle of a transaction updating a very important table. The machine on which adatabase was running reboots because of power outage. This caused a database instance failure.  Which statement is true in this situation()

A

The online redo log files and archived redo log files are required to accomplish the recovery.

B

The uncommitted transaction will be committed at the next startup of the database instance.

C

The uncommitted transaction is rolled back automatically at the next opening of the database.

D

The DBA has to perform the recovery on the database to recover the uncommitted transaction.

单选题 Examine the commands executed in the following sequence:  1:SQL> CREATE ROLE mgrrole;  2:SQL> GRANT create user,select any table,connect,resource TO mgrrole;  3:SQL> GRANT select,update ON sh.sales TO mgrrole;  4:SQL> CREATE ROLE ceo IDENTIFIED BY boss;  5:SQL> GRANT mgrrole,drop any table,create any directory TO ceo;  6:SQL> GRANT ceo TO mgrrole;  Which statement is true about the above commands()

A

The commands execute successfully.

B

Command 6 produces an error because of circular role grant.

C

Command 5 produces an error because a role cannot be granted to another role.

D

Command 3 produces an error because the MGRROLE role already contains system privileges.

E

The table created by HR remains and HR still has the CREATE TABLE system privilege.

F

The table created by HR remains and HR can grant the CREATE TABLE system privilege to other users.

多选题 You are managing an Oracle Database 11g database. The database is open, and you plan to perform Recovery Manager (RMAN) backups.  Which three statements are true about these backups()

A

The backups would be consistent.

B

The backups would be inconsistent.

C

The backups would be possible only if the database is running in ARCHIVELOG mode.

D

The backups would be possible only if the database is running in NOARCHIVELOG mode.

E

The backups need to be restored and the database has to be recovered in case of a media failure

单选题 Which statement is true about the PCTFREE setting for the table()

A

It sets the minimum percentage of a data block to be reserved to contain chained rows from other blocks.

B

It sets the minimum percentage of a data block to be reserved as free space before the server prevents inserts into the block.

C

It sets the minimum percentage of a data block to be reserved to contain the bitmap used to maintain the free block information.

D

It sets the minimum percentage of a block that can be used for row data plus overhead before new rows are added to the block.

最新资讯

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

到第