Oracle Installation Interview Questions

1. Oracle server configuration is dedicated for

A. One server process – Many user processes

B. Many server processes – One user process

C. One server process – One user process

D. Many server processes – Many user processes

Correct Answer is : One server process – One user process

2. What SYSTEM VARIABLE is used to refer DATABASE TIME ?

A. $$dbtime$$

B. $$time$$

C. $$datetime$$

D. None of the Mentioned

Correct Answer is : $$dbtime$$

3. You notice that the database instance takes a long time to start up after the instance crash. How will you resolve the problem?

A. Increase the size of the redo log files

B. Decrease the number of redo log members

C. Set LOG_CHECKPOINT_TO_ALERT to TRUE

D. Decrease the value for the FAST_START_MTTR_TARGET initialization parameter

Correct Answer is : Decrease the value for the FAST_START_MTTR_TARGET initialization parameter

4. Which statement is correct regarding undo management?

A. The database can have more than one undo tablespaces

B. The undo data must be purged manually when the transaction is over

C. The UNDO_TABLESPACE parameter is valid only if the UNDO_MANAGEMENT parameter is set AUTO OFF

D. Undo management is automatic by default even if the UNDO_MANAGEMENT initialization parameter is set to NULL

Correct Answer is : The database can have more than one undo tablespaces

5. Which operations can be performed using the Data Recovery Ad-visor?

A. Diagnosing data failure

B. It is a percentage of rows in which the statistics are collected incrementally for partitions

C. Presenting appropriate repair options

D. Generating reports for possible causes of failure

Correct Answer is : Diagnosing data failure

6. A user receives the following error while executing a query: ORA-01555: snapshot too old Predict one way to avoid such errors in near future.

A. Increase the size of redo log files

B. Increase the size of the undo tablespace

C. Increase the size of the Database Buffer Cache

D. Increase the size of the default temporary tablespace

Correct Answer is : Increase the size of the undo tablespace

7. You want to be warned automatically when more than 100 sessions are opened with your database instance.Identify the action that would help you achieve this.

A. Set the TRACE_ENABLED parameter to TRUE

B. Set the threshold for the Current Logons Count metric

C. Set the LOG_CHECKPOINT_TO_ALERT parameter to TRUE

D. Set the SESSIONS_PER_USER limit in the profiles used by users

Correct Answer is : Set the threshold for the Current Logons Count metric

8. While the database instance is up and running, you receive an out-of-memory error due to the under-sizing of the shared pool. You checked the trace file and observed that the following error was always recorded during peak hours: ORA-04031: unable to allocate 4000 bytes of shared memory On investigation, you found that SGA_MAX_SIZE was larger than the sum of the sizes of all System Global Area (SGA) components and you do not have the scope to increase it further. Identify a solution to reduce the probability of getting this error in future.

A. Set the PRE_PAGE_SGA parameter to TRUE

B. Set the LOCK_SGA initialization parameter to TRUE

C. Implement Automatic Shared Memory Management

D. Set the SGA_TARGET initialization parameter to zero

Correct Answer is : Implement Automatic Shared Memory Management

9. You created a new user on the database by executing the following command: SQL> CREATE USER user01 IDENTIFIED BY user01 DEFAULT TABLESPACE users TEMPORARY TABLESPACE temp; Then you granted the following privileges to user01 by executing the following command: SQL> GRANT CREATE SESSION, CREATE TABLE TO user01; Which of the following is true in this scenario?

A. The user can not create tables

B. The user can create tables

C. The user cannot query any tables

D. None of the Mentioned

Correct Answer is : The user can create tables

10. Examine the following settings for the initialization parameters: MEMORY_MAX_TARGET=0 MEMORY_TARGET=500M SGA_TARGET=300M PGA_AGGREGATE_TARGET=70M Which statement is true about the memory management for the newly started database instance?

A. MEMORY_TARGET defines the maximum limit for SGA_TARGET

B. SGA_TARGET and PGA_AGGREGATE_TARGET combined will never grow beyond 500M

C. The value for MEMORY_MAX_TARGET is the sum of SGA_TARGET and PGA_AGGREGATE_TARGET

D. SGA_TARGET and PGA_AGGREGATE_TARGET will keep growing till a maximum of 300M and 70M, respectively

Correct Answer is : SGA_TARGET and PGA_AGGREGATE_TARGET combined will never grow beyond 500M

Oracle Installation interview questions