多项选择题
Your boss at Certkiller .com wants you to clarify Oracle 10g. Which two statements regarding the LOGGING clause of the CREATE TABLESPACE... statement are correcte？（）
A.This clause is not valid for a temporary or undotablespace.
B.If thetablespaceis in the NOLOGGING mode， no operation on thetablespacewill generate redo.
C.Thetablespacewill be IntheNOLOGGING mode by default， if not specified while creating atablespace.
D.Thetablespace-level logging attribute can be overridden by logging specification at the table， index， materialized view， materialized view log， and partition levels.
相关考题
-
多项选择题
You work as a database administrator for Certkiller .com. In your development environmentenvironment， the developers are responsible for modifying the table structure according to the application requirements. However， you want to keep track of the ALTER TABLE commands being executed by developers， so you enable auditing to achieve this objective. Which two views would you refer to find out the audit information？（）
A.DBA_AUDIT_TRAIL
B.DBA_AUDIT_SESSION
C.DBA_FGA_AUDIT_TRAIL
D.DBA_COMMON_AUDIT_TRAIL -
单项选择题
YourbossatCertkiller.comwantsyoutoclarifyOracle10g.WhichstatementregardingthecontentsoftheV$PARAMETERviewistrue？（）
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
