单项选择题

TheUNDO_RETENTIONparameterinyourdatabaseissetto1000andu……

The UNDO_RETENTION parameter in your database is set to 1000 and undo retention is not guaranteed. Which statement regarding retention of undo data is correct？（）

A.Undo data becomes obsolete after 1，000 seconds.
B.Undo data gets refreshed after every 1，000 seconds.
C.Undo data will be stored permanently after 1，000 seconds.
D.Committed undo data would be retained for 1，000 seconds if free undo space is available.
E.Undo data will be retained in the UNDO tablespace for 1，000 seconds，then it gets moved to the TEMPORARY tablespace to provide read consistency.

<上一题目录下一题>

热门试题

单项选择题YoureceivedcomplaintsaboutthedegradationofSQLqueryperformance.YouidentifiedtopSQLqueriesthatconsumetime.WhatwouldbeyournextsteptofindoutrecommendationsaboutstatisticscollectionandrestructuringoftheSQLstatementtoimprovequeryperformance？（）

A.run Segment Advisor
B.run SQL Tuning Advisor on top SQL statements
C.run the Automatic Workload Repository （AWR） report
D.run the Automatic Database Diagnostic Monitor （ADDM）on top SQL statements

多项选择题Whichthreestatementsaretrueaboutthestagesofdatabasestartup？（）

A.Data files and redo log files can be renamed at the MOUNT stage.
B.Control files are read at the OPEN stage for the location of data files.
C.Control files are required to bring the database to the NOMOUNT stage.
D.Data files and redo log files are made available to users at the OPEN stage.
E.Data files and online redo log files are checked for consistency while opening the database

多项选择题Whichthreepiecesofinformationareconsideredwhiledecidingthesizeoftheundotablespaceinyourdatabase？（）

A.the size of an undo block
B.the size of the redo log files
C.undo blocks generated per second
D.the size of the database buffer cache
E.the value of the UNDO_RETENTION parameter

多项选择题You connected to the database using the following connection string： CONNECT hr hr@test.us.oracle.com：1521 mydb Which three statements are correct regarding the connection string？（）

A.mydb is a service name.
B.test.us.oracle.com is a database name.
C.1521 is the listener port number.
D.mydb is a host name.
E.test.us.oracle.com is a net service name.
F.hr is a username.
G.test.us.oracle.com is an instance name.

单项选择题View the Exhibit to see the output of queries on DATABASEPROPERTIES and DBAUSERS. You observe that the current default permanent tablespace of the database is running out of space and you decide to change it to NEWDEFTBSP. You create a new user， USER04， after changing the default permanent tablespace of the database. What would be the new user’s default tablespace？（）

A.DEFTBSP
B.SYSTEM
C.NEWDEFTBSP
D.USERS and NEWDEFTBSP both
E.USERS