单项选择题

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.


您可能感兴趣的试卷

你可能感兴趣的试题

1.多项选择题

A user receives the following error while executing a query:
ORA­01555:snapshot too old
Which two options can be the solutions to avoid such errors in future?()

A.increase the size of redo log files
B.increase the size of the undo tablespace
C.increase the size of the Database Buffer Cache
D.increase the size of the default temporary tablespace
E.enable the retention guarantee for the undo tablespace

2.多项选择题

User SCOTT executes the following command on the EMP table but has not issued COMMIT, ROLLBACK,or any data definition language (DDL) command: 
SQL> SELECT job FROM emp 
2  WHERE job=’CLERK’ FOR UPDATE OF empno; 
SCOTT has opened another session to work with the database. Which three operations would wait when issued in SCOTT’s second session?()

A.LOCK TABLE emp IN SHARE MODE;
B.LOCK TABLE emp IN EXCLUSIVE MODE;
C.DELETE FROM emp WHERE job=’MANAGER’;
D.INSERT INTO emp(empno,ename) VALUES (1289,’Dick’);
E.SELECT job FROM emp WHERE job=’CLERK’ FOR UPDATE OF empno;

3.多项选择题Which two are valid locking levels that are used by transactions in an Oracle database?()

A.row level
B.block level
C.object level
D.schema level
E.database level

5.多项选择题A constraint in a table is defined with the INITIALLY IMMEDIATE clause. You executed the ALTER TABLE command with the ENABLE VALIDATE option to enable the constraint that was disabled. What are the two effects of this command?()

A.It fails if any existing row violates the constraint.
B.It does not validate the existing data in the table.
C.It enables the constraint to be enforced at the end of each transaction.
D.It prevents insert, update, and delete operations on the table while the constraint is in the process of being enabled.

6.单项选择题

Your database is started by using the server parameter file (SPFILE). You issued this command to change the value of the LOG_BUFFER initialization parameter: 
ALTER SYSTEM SET LOG_BUFFER=24M SCOPE=BOTH; 
What would be the outcome of this command?()

A.The command would return an error because LOG_BUFFER is a static parameter.
B.The parameter value would be changed and it would come into effect immediately.
C.You need to restart the database so that parameter changes can come into effect.
D.The command would succeed only if initialization parameter LOG_ARCHIVE_MAX_PROCESS is set to value 2.

8.单项选择题Your database is in NOARCHIVELOG mode and a logswitch happens every 20 minutes. On Thursday morning, media failure resulted in corruption of a data file belonging to the TOOLS tablespace. Backups are taken on every Sunday.What would you do in this situation?()

A.recover using Oracle Flashback Database technology
B.restore the data files from backup and perform a complete recovery
C.restore only the corrupted data file and perform tablespace recovery
D.restore the data files from backup and perform cancel­based recovery
E.restore the entire database from the most recent backup and start the instance and open the database

9.单项选择题Which statement is true about the loss of system­critical data files in ARCHIVELOG mode?()

A.The data files can be recovered till the last committed transaction.
B.The data files can be recovered without shutting down the database.
C.The data file is taken offline automatically; the database remains open.
D.The data files can be recovered to the time of the most recent backup.

10.多项选择题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.

最新试题

While setting up the database for your production environment, you want to create a user with following requirements.  1.The objects created by the user must be stored in a tablespace, TBS1, if the  TABLESPACE option is not defined during the object creation.  2.The user should be able to use 10MB of space in the tablespace TBS1.  3.The user must change the password immediately after logging in for the first time.  Which three options of the CREATE USER command would you use to achieve this objective?()

题型:多项选择题

Which three statements are true regarding the logical structure of the Oracle database?()

题型:多项选择题

In your database, the STATISTICS_LEVEL initialization parameter is set to BASIC.  What is the impact of this setting?()

题型:单项选择题

You have been recently hired as a database administrator. Your senior manager asks you to study the production database server and submit a report on the settings done by the previous DBA.  While observing the server settings, you find that the following parameter has been set in the parameter file of the database: REMOTE_OS_AUTHENT = TRUE What could have been the reason to set this parameter as TRUE?()

题型:单项选择题

You find today’s performance of your production database to be the best ever. Therefore, you want to be notified in the future whenever the performance degrades by 10% of today’s performance. What is the first step that you would take to ensure this?()

题型:单项选择题

You plan to use static database registration for a new listener when you create it. What could be the two reasons for this?()

题型:多项选择题

The ST_INFO master table has millions of rows that are updated very rarely. It has a STATE_CODE column that contains the value for 25 states. The table is frequently queried on the STATE_CODE column. Which type of index would you suggest to improve the query performance?()

题型:单项选择题

Your database is configured in NOARCHIVELOG mode. All the control files have been lost due to a hard disk failure but the data files are not lost. You have the closed whole database backup available to you. Which two statements are true in this scenario?()

题型:多项选择题

The following are the details of your database:  Instance name:test  Host name:tech1.us.oracle.com  IP address:145.33.230.186 Enterprise Manager Console HTTP Port number:5500  You started the database instance and you want to manage your database remotely with Enterprise Manager through a Web browser. Which two URLs would you use to access the Database Control?()

题型:多项选择题

User SCOTT executes the following command on the EMP table but has not issued COMMIT, ROLLBACK,or any data definition language (DDL) command: SQL> SELECT job FROM emp 2  WHERE job=’CLERK’ FOR UPDATE OF empno; SCOTT has opened another session to work with the database. Which three operations would wait when issued in SCOTT’s second session?()

题型:多项选择题