Oracle DBA Interview questions With Answer Part-II

                                          Oracle DBA Interview questions With Answer Part-II   

Question 01: Which dynamic view can be queried when a database is started up in no mount state?

A. V$LOGFILE
B. V$INSTANCE
C. V$CONTROLFILE
D. V$DATAFILE_HEADER

Question 02: Which two tasks occur as a database transitions from the mount stage to the open stage?

A. The online data files & Redo log files are opened.
B. Memory for the SGA is allocated.
C. the Oracle password file is opened.
D. Stored procedures are pinned in the library cache

Question 03: In which situation is it appropriate to enable the restricted session mode?

A. Creating a table
B. Dropping an index
C. Taking a rollback segment offline
D. Exporting a consistent image of a large number of tables.

Question 04: Which is the component of an Oracle instance?

A. The SGA
B. The redo logs
C. The control cache
D. The password file

Question 5: Which process is involved when a user starts a new session on the database server?

A. the Oracle login process
B. The Oracle server process
C. The systems monitor (SMON) process
D. The process monitor (PMON) process
 
Question 06: In the event of an Instance failure, which files store command data NOT written to the data files?

A. Control files
B. Online redo logs
C. Network segment
D. Archived redo logs

Question 07: When are the base tables of the data dictionary created?

A. When the instance is created
B. When the database is created
C. When the catalog.sql script is executed
D. When the catproc.sql script is executed

Question 08: Sequence of events takes place while starting a Database is

A. Database opened, File mounted, Instance started
B. Instance started, Database mounted & Database opened
C. Database opened, Instance started & file mounted
D. Files mounted, Instance started & Database opened

Question 09: The alert log will never contain information about which database activity?

A.Place tablespace in end backup mode
B.Altering the database to take a data file offline
C.Performing operating system restore of the database files
D.Changing the database mode from NOARCHIVELOG to ARCHIVELOG

Question 10: Where can you find the non-default parameters when an instance is started?

a. Alert log
b. Online redo log
c. Archived redo log
d. System user's trace

Question 11: Which tablespace is used as the temporary tablespace if TEMPORARY TABLESPACE is not specified for a user?

a. TEMP
b. DATA
c. SYSTEM
d. ROLLBACK

Question 12: User SCOTT creates an index with this statement: CREATE INDEX emp_indx on employee (empno). In which tablespace would be the index created?
 
 a. SYSTEM tablespace
b. SCOTTS default tablespace
c. Tablespace with rollback segments
d. same tablespace as the EMPLOYEE table.

Question 13: Which data dictionary view shows the available free space in a certain tablespace?

A. DBA_EXTENTS
B. V$FREESPACE
C. DBA_FREE_SPACE
D. DBA_TABLESPACE
E. DBA_FREE_EXTENTS

Question 14: Which method increase the size of a tablespace?

A. Add a datafile to a tablespace.
B. Use the ALTER TABLESPACE command to increase the MINEXTENTS for the tablespace.
C. Use the ALTER TABLESPACE command to increase the MAXEXTENTS for the tablespace.
D. Use the ALTER TABLESPACE command to increase the MINIMUM EXTENT for the tablespace.

Question 15: What does the command ALTER DATABASE . . . RENAME DATAFILE do?

A. It copies a data file.
B. It updates the control file.
C. It copies a data file and updates the control file.
D. It copies a data file, deletes the obsolete file, and updates the control file.

Question 16: Can you drop objects from a read-only tablespace?

A. No
B. Yes
C. Only when using the DBA role
D. Only when the tablespace is online

Question 17:  SYSTEM TABLESPACE can be made off-line

a) Yes
b) No

Question 18: Data dictionary can span across multiple Tablespaces

a) TRUE
b) FALSE

Question 19: Multiple Tablespaces can share a single datafile

a) TRUE
b) FALSE

Question 20. All datafiles related to a Tablespace are removed when the Tablespace is dropped?

a) TRUE
b) FALSE

Correct answer: 
01(b), 02(a), 03(d), 04(a), 05(b), 06(b), 07(b), 08(b), 09(c), 10(a), 11(c), 12(b), 13(c), 14(a), 15(b),16(b),17(b),18(b),19(b),20(b)