单项选择题

Which statement regarding the contents of the V$PARAMETER view is true？（）

A.displays only the list of default values
B.displays only the list of all basic parameters
C.displays the currently in effect parameter values
D.displays only the list of all advanced parameters
E.displays the list of all the parameter files of a database

<上一题目录下一题>

热门试题

多项选择题Whichthreestatementsarecorrectabouttemporarytables？（）

A.Indexes and views can be created on temporary tables.
B.Both the data and the structure of temporary tables can be exported.
C.Temporary tables are always created in a user’s temporary tablespace.
D.The data inserted into a temporary table in a session is available to other sessions.
E.Data manipulation language （DML） locks are never acquired on the data of temporary tables.

单项选择题TheUNDO_RETENTIONparameterinyourdatabaseissetto1000andundoretentionisnotguaranteed.Whichstatementregardingretentionofundodataiscorrect？（）

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