单项选择题
Your boss at Certkiller .com wants you to clarify Oracle 10g. 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
F.Displays the current contents of the server parameter file.
相关考题
-
单项选择题
YouworkasadatabaseadministratorforCertkiller.com.Youareusingthreedatabase，CertkillerDB01，CertkillerDB02，andCertkillerDB03，ondifferenthostmachinesinyourdevelopmentenvironment.Thedatabaseserverconfiguration，suchasIPaddressandlistenerportnumber，changefrequentlyduetodevelopmentrequirements，andyouhavethetaskofnotifyingthedevelopersofthechanges.Whichconnectionmethodwouldyouusetoovercomethisoverhead？（）
A.Host naming
B.Local naming
C.Easy Connect
D.External naming
E.directory naming -
多项选择题
You work as a database administrator for Certkiller .com. Your database is opened in NOARCHIVEKLOG mode. You decide to place the database in ARCHIVELOG mode. How would you do this？（）
A.Execute the ALTER DATABASE ARCHIVELOG statement
B.Select ARCHIVELOG option in the database control and restart the database to apply the changes.
C.Shut down and start the instance, and in the NOMOUNT state execute the ALTER DATABASE ARCHIVELOG statement.
D.Shut down and start the instance, mount the database, then execute the ALTER DATABASE ARCHIVELOG statement. -
单项选择题
You work as a database administrator for Certkiller .com. Your database is in NOARCHIVELOG mode. The database has been configured with three redo logs groups， and there have been five log switches. You lost one non-system-critical data file from your database. Which method would you use to recover the data file？（）
A.Restore all the data files and open the database
B.Create the data file and performtablespacerecovery
C.No need to restore any file， just recover the database
D.Restore only the system data file and recover the database
E.Restore only lost date file and performtablespacerecovery
