Your database is in the NOARCHIVELOG mode. Since last night’s offline backup， the logs in group 1 have been written to twice. This morning， the SYSTEM data file has become corrupted. Up to what point can it be recovered？（）

单项选择题Youhavetwodatabases，FINDBandPAYDB，onsingleoperatingsystemandusingOptimalFlexiblearchitecture（OFA）.FINDBisfunctionalandiscurrentlybeingaccessedbytheusers.WhilestartinguptheinstanceforthePAYDBdatabaseyougetthefollowingerror：ORA-01081：cannotstart-alreadyrunningORACLE-shutitdownfirstWhichenvironmentalvariablewouldyousetbeforestartingupthePAYDBdatabasetoovercomethiserror？（）

A.ORA_PATH
B.ORACLE_SID
C.ORACLE_BASE
D.ORACLE_HOME
E.LD_LIBRARY_PATH

单项选择题Youhavebeenaskedtocreatethreeusers，PUB1，PUB2andPUB3，forthreenewlyhiredemployeesandtoallocateunlimitedquotaontheirdefaulttablespacePUBLISHER_TBSwithnootherprivileges.Aftercreatingtheusers，whichmethodcanyouuseforgrantingtherequiredprivileges？（）

A.grant CONNECT role to all of the three users
B.grant RESOURCE role to all of the three users
C.grant both CONNECT and RESOURCE role to all of the three users
D.execute ALTER USER .. QUOTA UNLIMITED ON publisher_tbs command for all of the three users
E.create role with UNLIMITED TABLESPACE system privilege and assign the role to all of the three users

单项选择题Youwanttobenotifiedwhenthespaceusageofanexistingcriticaltablespacehasreached75%oftheallocatedspace.Whichoptionwouldyouusetoachievethis？（）

A.run a procedure to check the tablespace space usage
B.define the warning threshold for the tablespace at 75% in Database Control
C.create a trigger to be executed when tablespace space usage reaches 75%
D.submit a job by using DBMS_JOB package to check the free space in the tablespace at regular intervals
E.define the warning threshold to be 75% for the tablespace by ALTER TABLESPACE .. ADD THRESHOLD command

单项选择题YouobservethatinyourPRODdatabase，customerinformationisbeingmodifiedbysomeunauthorizedusers.YouwanttokeeptrackofallofthetransactionshappeningonthetableusingPL SQL.WhichtypeofPL SQLsubprogramorconstructwouldyouusetoaccomplishthistask？（）

A.functions
B.packages
C.procedures
D.database triggers
E.anonymous PL/SQL block

单项选择题Youwanttocreateanewoptimizeddatabaseforyourtransactionalproductionenvironmenttobeusedbyafinancialapplication.Whilecreatingthedatabase，youwanttheOraclesoftwaretotakecareofallbasicsettingstooptimizethedatabaseperformance.Whichmethodwouldyouusetoachievethisobjective？（）

A.Use the CREATE DATABASE .. command to create the database with Oracle-managed files. 
B.Use the Database Configuration Assistant (DBCA) to create the database with Oracle-managed files. 
C.Use Enterprise Manager to create a new database with the Online Transaction Processing (OLTP) option. 
D.Use Database Configuration Assistant (DBCA) to create the database with Transaction Processing template. 
E.Use the CREATE DATABASE .. command to create the database with Automatic Storage Management (ASM) file system.