Skip to main content

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)
Labels:

Comments

Post a Comment

Popular posts from this blog

Oracle forms 11g default configuration file formsweb.cfg

#formsweb.cfg defines parameter values used by the FormsServlet # formsweb.cfg defines parameter values used by the FormsServlet (frmservlet) # This section defines the Default settings. Any of them may be overridden in the # following Named Configuration sections. If they are not overridden, then the # values here will be used. # The default settings comprise two types of parameters: System parameters, # which cannot be overridden in the URL, and User Parameters, which can. # Parameters which are not marked as System parameters are User parameters. # SYSTEM PARAMETERS
Post a Comment
Read more

No free space to rebalance ASM disk group

   To day we found below warning message from Exadata system: Warning: Software Alert 92_1 Event Time 2025-01-23T16:19:57+06:00 Description Insufficient free space to rebalance the ASM disk group: RECOC1 Affected Server Name ******* Server Model Oracle Corporation ORACLE SERVER X9-2 Chassis Serial Number 2217XCD00X Release Version 24.1.5.0.0.241016 RPM Version 24.1.5.0.0.241016 Recommended Action Please refer to MOS Doc 1551288.1                                                                                                I am search  Chatgpt and found below solutions. Rebalancing an ASM (Automatic Storage Management) disk group in Oracle is a process where the disk group redistributes data...
Post a Comment
Read more

Error Initializing Opera: module 15

Solutions: You should manually remove directories name as "Opera" from  %PROGRAMFILES% ,%APPDATA% and %USERPROFILE% . RUN(Windows Logo Key + R)-> Enter '%PROGRAMFILES%' -> Then press OK Button. Open a new window, There find Opera folder and delete it. Same as %APPDATA%  and %USERPROFILE%. What programming languages should I learn to make a website How do i transfer music from my mac to my iPhone using the iTunes HOW TO FIX ICE CREAM SANDWICH UPDATE ERRORS !!! Fix an app that isn't working properly in Nexus how to reset Google nexus 7 Screen flicker problem in iPhone 5 DATE AND TIME PROBLEM IN IPHONE5 Another way: IF it's install in C drive you can delete opera folder from below location : c: \ Program Files \ Opera \ c: \ Documents and Settings \ Username \ Application Data \ Opera \ c: \ Documents and Settings \ Username \ Local Settings \ Application Data \ Opera \ Any you getting any problem give a comments. You can also see...
Post a Comment
Read more