单项选择题
You have two databases, FINDB and PAYDB, on single operating system and using Optimal Flexible architecture (OFA). FINDB is functional and is currently being accessed by the users. While starting up the instance for the PAYDB database you get the following error: ORA-01081: cannot start - already running ORACLE - shut it down first Which environmental variable would you set before starting up the PAYDB database to overcome this error?()
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
