Starting Up and Shutting Down - Oracle placement test

Starting Up and Shutting Down - Oracle placement test

1) In starting up a Database which is used to execute STARTUP and SHUTDOWN commands?

A) SQL*Plus
B) Recovery Manager
C) Enterprise Manager
D) None of the above
View Answer / Hide Answer


2) In the platform-specific default location, Oracle Database locates your initialization parameter file by examining filenames in which of the following order?

A) spfile$ORACLE_SID.ora, init$ORACLE_SID.ora, spfile.ora
B) spfile.ora, spfile$ORACLE_SID.ora, init$ORACLE_SID.ora
C) spfile$ORACLE_SID.ora, spfile.ora, init$ORACLE_SID.ora
D) Intit$ORACLE_SID.ora, spfile.ora, spfile$ORACLE_SID.ora
View Answer / Hide Answer


3) Abbreviate the term DBCA?

A) Database Control Assistant
B) Database Configuration Application
C) Database Control Application
D) Database Configuration Assistant
View Answer / Hide Answer


4) You cannot start a database instance if you are connected to the database through a shared server process?

A) True
B) False
View Answer / Hide Answer


5) Which mode is used for Shutting down a Database using these following situations?

1) To initiate an automated and unattended backup
2) When a power shutdown is going to occur soon
3) When the database or one of its applications is functioning irregularly and you cannot contact users to ask them to log off or they are unable to log off

A) Shutting Down with the NORMAL Clause
B) Shutting Down with the IMMEDIATE Clause
C) Shutting Down with the TRANSACTIONAL Clause
D) Shutting Down with the ABORT Clause
View Answer / Hide Answer


6) Quiesced state, in the sense that no ongoing non-DBA transactions, queries, fetches, or PL/SQL statements are running in the system?

A) True
B) False
View Answer / Hide Answer


7) Viewing the Quiesce State of an Instance You can query the ACTIVE_STATE column of the V$INSTANCE view to see the current state of an instance, the column values has one of these values?

A) NORMAL
B) QUIESCING
C) QUIESCED
D) All mentioned above
View Answer / Hide Answer


8) You can use the RESETLOGS clause with a READ ONLY clause?

A) True
B) False
View Answer / Hide Answer


9) To start an instance, the database must read instance configuration parameters (the initialization parameters) from either a?

A) SPFILE
B) PFILE
C) Both A & B
D) None of the above
View Answer / Hide Answer


10) Changes made to parameter file PFILE, Database need to be restarted to take effect the changes?

A) True
B) False
View Answer / Hide Answer


11) An aborted database shutdown proceeds with which of the following conditions?

A) New connections are allowed, nor are new transactions not allowed to be started, after the statement is issued

B) Current client SQL statements not being processed by Oracle Database are immediately terminated

C) Uncommitted transactions are rolled back

D) Oracle Database does wait for users currently connected to the database to Connect. The database implicitly connects all connected users

E) None of the above
View Answer / Hide Answer