You work as a database administrator for Supportcenter.cn. Users complain that their query is taking a long time to complete. You suspect the database buffer cache size to be the reason， and you define an alert to be generated when the buffer cache hit metric goes below 85%. When you observe the dynamic performance views， you find that the buffer cache hit ratio is 81% but no alerts are being generated. 
What could be the reason for this problem？（）

单项选择题Exhibit You work as a database administrator for Supportcenter.cn. While creating a new user or changing the password for existing users， the password must adhere to the restrictions specified in the exhibit. Which option would you use to achieve this objective？（）

A.Use a trigger to validate the password
B.Use a user defined PL/SQL block to validate the password
C.Use a profile to include the password verify function to validate the password
D.Use Oracle’s default password verification procedure to validate the password
E.Use a procedure name in the CREATE USER command to validate the password

单项选择题YouworkasadatabaseadministratorforSupportcenter.cn.Youareusingthreedatabase，SupportCenterDB01，SupportCenterDB02，andSupportCenterDB03，ondifferenthostmachinesinyourdevelopmentenvironment.Thedatabaseserverconfiguration，suchasIPaddressandlistenerportnumber，changefrequentlyduetodevelopmentrequirements，andyouhavethetaskofnotifyingthedevelopersofthechanges.Whichconnectionmethodwouldyouusetoovercomethisoverhead？（）

A.Host naming
B.Local naming
C.Easy Connect
D.External naming
E.directory naming

多项选择题YouworkasadatabaseadministratorforSupportcenter.cn.YourdatabaseisopenedinNOARCHIVEKLOGmode.YoudecidetoplacethedatabaseinARCHIVELOGmode.Howwouldyoudothis？（）

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.

单项选择题YouworkasadatabaseadministratorforSupportcenter.cn.YourdatabaseisinNOARCHIVELOGmode.Thedatabasehasbeenconfiguredwiththreeredologsgroups，andtherehavebeenfivelogswitches.Youlostonenon-system-criticaldatafilefromyourdatabase.Whichmethodwouldyouusetorecoverthedatafile？（）

A.Restore all the data files and open the database
B.Create the data file and perform tablespace recovery
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

单项选择题YourbossatSupportcenter.cnwantsyoutoclarifyOracle10g.Whichconditioninyourdatabaseforcesyoutoperformonlyconsistentbackups？（）

A.The database is in mount state.
B.One of the tablespaces is offline.
C.One of the tablespaces is read only.
D.The database operates in ARCHIEVELOG mode. 
E.The database operates in NOARCHIEVELOG mode.