内容发布更新时间 : 2024/11/19 2:20:48星期一 下面是文章的全部内容请认真阅读。

补充题目

72.Examine the following output: SQL> SELECT index_name,status FROM dba_indexes

WHERE status='UNUSABLE'; INDEX_NAME STATUS EIND UNUSABLE

Which two statements about the above index are true? (Choose two.) A. It is ignored by the query optimizer.

B. It is not used while the index is being rebuilt.

C. The index cannot be rebuilt, and has to be re-created.

D. The index is automatically rebuilt when used the next time. Answer: AB

115.Which of these is true about undo tablespace? A. Undo tablespace is a temporary tablespace. B. Undo tablespace has only one datafile.

C. Undo tablespace has a datafile which is reused in cyclic manner. Answer: A

116.Your database is in shutdown state.

What will happend if you issue next command: SQL> startup

A. instance will started.

B. instance started and DB is mounted.

C. instance started, DB opened and finally mounted. D. instance started, DB mounted and finally opened. Answer: D

177.Which two statements are true regarding the SGA_TARGET initialization parameter? (Choose two.) A. It can be increased up to the value of the SGA_MAX_SIZE parameter.

B. Increasing the value of the SGA_TARGET parameter distributes the increased memory among all the autotuned components.

C. Reducing the value of the SGA_TARGET parameter deallocates memory from both autotuned and manually sized components.

D. Increasing the value of SGA_TARGET up to the value of SGA_MAX_SIZE disables the automatic shared memory management feature. Answer: AB

201.Why does performance degrade when many UPDATE, INSERT or DELETE statements are issued on a table that has an associated bitmap index?

A. The DML operations re-create the bitmap index blocks.

B. The bitmap index is rebuilt automatically after a DML operation.

C. The smallest amount of a bitmap that can be locked is a bitmap segment.

D. Additional time is taken to remove NULL values from the bitmap index after a DML operation. Answer: C

16) You executed the STARTUP MOUNT command to start your database. For which database operation do you need to start the database in the MOUNT state? A. Dropping a tablespace in your database.

B. re-creating the control files, after you lost all the control files in your database. C. dropping a user in your database. D. renaming the control files.

E. enabling or disabling redo log archiving. Answer: E

75) Note the following points describing various utilities in Oracle Database 11g: Which point describes the Oracle Data Pump utility?

1. It enables the transfer of data from one database to another

2. It provides a complete solution for the backup, restoration and recovery needs of the entire database 3. It enables the loading of data from an external file into tables of an Oracle Database 4. It provides a tape backup management for the Oracle ecosystem A. 1 B. 2 C. 3 D. 4

E. 1 and 3

F. 1, 2, 3 and 4 Answer: A

162) View the Exhibit.

Which statement causes more undo generation? A. DELETE FROM emp WHERE empno=7934;

B. UPDATE emp SET comm=400 WHERE empno=7844;

C. INSERT INTO emp VALUES(7999,?JHON?,?CLERK?,7782,?10-MAY-83′,1500,NULL,10); D. SELECT * FROM emp;

Answer: A

163) Where do you find information about a missing redo log file? A. audit trail B. event viewer C. alert log file D. trace file E. control file Answer: C

164) You want to administer your PROD database from a remote host machine using a Web-enabled interface. Which Oracle tool would you use to accomplish this task efficiently without using command-line interfaces? A. SQL*Plus B. iSQL*Plus

C. Management Server D. Management Repository

E. Oracle Enterprise Manager 11g Database Control Answer: E

165) The database users are connecting to the PROD database from different applications, thereby degrading the database performance. The senior database administrator suspects the large number of concurrent connections to be the reason for low performance and asks you to restrict the number concurrent connections per database user to one. Which action would you take to achieve this objective? A. set the SESSIONS to 1 in the parameter file

B. create a role with SINGLE SESSION privilege and assign the role to the users C. grant RESTRICTED SESSION privilege to all of the database users D. grant SINGLE SESSION privilege to all of the users

E. set the SESSIONS_PER_USER to 1 in the users? profile Answer: E

166) What advantage would you get if you increase the length of time during which the undo information would be stored in the database?

A. read consistency for long-running transactions B. roll back of large transactions C. roll forward to redo a transaction D. data concurrency for large updates Answer: A

167) One of the users in the PROD database, Adams, complains that his update on the table, TRANS, is taking an unusually long time to complete. You find that the table gets locked by another database user before Adams starts his transactions, and you are unable to contact the user holding the table lock. As Adams is updating some crucial rows in the table, he should get the highest priority. Which method would you use to overcome this problem? A. execute the command, ALTER SYSTEM UNLOCK SESSION .., to release the lock for the blocking session B. execute the command, ALTER SESSION UNLOCK .., to release the lock for the blocking session C. execute the command, ALTER SYSTEM KILL SESSION .., to kill the blocking session D. execute the command, ALTER SESSION KILL .., to kill the blocking session

E. execute the DBMS_SESSION.KILL_SESSION procedure to kill the blocking session Answer: C

168) Exhibit: Which two options are used to enable the connect-time failover feature? (Choose