ORACLE DBA INTERVIEW QUESTION & ANSWERS
ORACLE DBA INTERVIEW QUESTION &
ANSWERS
1.
Which of the following does not affect the size of the SGA.
a)
Database buffer
b)
Redo log buffer
c)
Stored procedure
d)
Shared pool
Answer:
c
2.
A set of Dictionary tables are created
a)
Once for the Entire Database
b)
Every time a user is created
c)
Every time a Tablespace is created
d)
None of the above
Answer:
a
3.
The order in which Oracle processes a single SQL statement is ?
A.
execute, parse, fetch
B.
execute, fetch, parse
C.
parse, execute, fetch
D.
parse, fetch, execute
Answer:
c
4.
What are the mandatory datafiles to create a database in Oracle 11g?
A.
SYSTEM, SYSAUX
B.
SYSTEM, USERDATA, TEMP
C.
SYSTEM, SYSAUX, UNDO
Answer:
c
5.
In one server can we have different oracle versions?
A.
No
B.
Yes
Answer:
b
6.
How do sessions communicate with database?
A.
Server processes use oracle net to connect to the instance.
B.
Background processes use oracle net to connect to the database
C.
User processes read from the database and write to the instance;
D.
Server processes execute SQL received from user processes.
Answer:
d
7.
Which SGA memory structure cannot be resized dynamically after instance
startup?
A.
Database Buffer Cace
B.
Java Pool
C.
Large pool
D.
Log buffer
E.
Shared Pool
Answer:
d
8.
When a session changes data, where does the change get written?
A.
To the data block in the cache, and the redo log buffer
B.
To the data block on disk, and the current online redo log file
C.
The session writes to the database buffer cache, and the log writer writes to
the current online redo logfile
D.
Nothing is written until the change is committed
Answer:
a
9.
How many maximum no of control files we can have within a database
A
3
B.5
C.1
D.8
Answer:
d
10.System
Data File Consists of
A.Metadata
B.Business
Data
C.Temporary
Data
D.Undo
Data
Answer:
a
11.
What is the function of SMON in instance recovery?
A.It
writes data to the archive log files.
B.It
writes data to the online redo log files.
C.It
frees resources held by user processes.
D.It
synchronizes data file header and control files.
E.It
roles forward by applying changes in the redo log.
F.It
writes dirty buffers from the buffer cache to the data files.
Answer:
e
12.
Which action occur during a checkpoint?
A.Oracle
updates a control file.
B.Oracle
performs a delayed block clean-out.
C.Oracle
copies the online redo-log to the archive destinations. `
D.Oracle
flushes the dirty blocks in the database buffer cache to disk.
Answer:
d
13.
SMON process is used to write into LOG files.
a.TRUE
b.FALSE
Answer:
b
14.
Oracle does not consider a transaction committed until.
A.
The Data is written back to the disk by DBWR
B.
The LGWR successfully writes the changes to redo
C.
PMON Process commits the process changes
D.
SMON Process Writes the data
Answer:
b
15.
How many maximum DBWn(Db writers) we can invoke?
A.
3
B.
1
C.
10
D.
20
Answer:
d
16.
Which activity would generate less undo data?
A.INSERT
B.UPDATE
C.SELECT
D.DELETE
Answer:
a
17.
What happens when a user issues a COMMIT?
A.
The CKPT process signals a checkpoint.
B.
The DBWn process wrtes the transactions changed buffers to the datafiles.
C.
The LGWR flushes the log buffer to the online redo log.
D.
The ARCn process writes the change vectors to the archive redo log
Answer:
c
18.What
happens when a user process fails?
A.PMON
performs process recovery.
B.SMON
performs ICR
C.SMON
frees resources held by user process.
D.Oracle
Updates a controlfile.
Answer:
a
19.What
are the free buffers in the database buffer cache.
A.Buffer
that have changed should be pushed to the disk.
B.Buffers
that are currently in use.
C.Buffer
that are being written to disk.
D.Buffer
that can be overwritten.
Answer:d
20.When
thw SMON Procees perform ICR.
A.For
every startup
B.Only
at the time of startup after graceful shutdown
C.Only
at the time of startup after abort shutdown
Answer:
c
21.
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
Answer:
b
22.
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
Answer:
a
23.
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.
Answer:
d
24.
Which is the component of an Oracle instance?
A.
The SGA
B.
The redo logs
C.
The control cache
D.
The password file
Answer:
a
25.
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 system monitor (SMON) process
D.
The process monitor (PMON) process
Answer:
b
26.
In the event of an Instance failure, which files store command data NOT written
to the datafiles?
A.
Control files
B.
Online redo logs
C.
Network segment
D.
Archived redo logs
Answer:
b
27.
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
Answer:
b
28.
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
Answer:
b
29.
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
Answer:
c
30.
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
Answer:
a
31.
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
Answer:
c
32.
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.
Answer:
b
33.
Which data dictionary view shows the available free space in a certain
tablespace? (9-16)
A.
DBA_EXTENTS
B.
V$FREESPACE
C.
DBA_FREE_SPACE
D.
DBA_TABLESPACE
E.
DBA_FREE_EXTENTS
Answer:
c
34.
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.
Answer:
a
35.
What does the command ALTER DATABASE . . . RENAME DATAFILE do? (8-37) (Not
proper description of the ans.)
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.
Answer:
b
36.
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
Answer:
b
37.
SYSTEM TABLESPACE can be made off-line.
a)
Yes
b)
No
Answer:
b
38.
Datadictionary can span across multiple Tablespaces.
a)
TRUE
b)
FALSE
Answer:
b
39.
Multiple Tablespaces can share a single datafile.
a)
TRUE
b)
FALSE
Answer:
b
40.
All datafiles related to a Tablespace are removed when the Tablespace is
dropped?
a)
TRUE
b)
FALSE
Answer:
b
41.
What is a default role?
A.
A role that requires a password.
B.
A role that requires no password.
C.
A role automatically enabled when the user logs on.
D.
A role automatically assigned when the user is created.
Answer:
c
42.
Who is the owner of a role?
A.
SYS
B.
Nobody
C.
SYSTEM
D.
The creator
Answer:
b
43.
When granting the system privilege, which clause enables the grantee to further
grant the privilege to other users or roles?
A.
PUBLIC
B.
WITH PRIVILEGE
C.
WITH ADMIN OPTION
D.
WITH GRANT OPTION
Answer:
c
44.
Which view will show a list of privileges that are available for the current
session to a user?
A.
SESSION_PRIVS
B.
DBA_SYS_PRIVS
C.
DBA_COL_PRIVS
D.
DBA_SESSION_PRIVS
Answer:
a
45.
Which view shows all of the objects accessible to the user in a database?
A.
DB_OBJECTS
B.
ALL_OBJECTS
C.
DBA_OBJECTS
D.
USER_OBJECTS
Answer:
b
46.
Which statement about profiles is false?
A.
Profile assignments do not affect current sessions.
B.
Profiles enable group resource limits for similar users.
C.
Profiles are assigned to users, roles, and other profiles.
D.
The ALTER USER command can be used to assign profiles to users.
Answer:
c
47.
Which password management feature is NOT available by using a profile?
A.
Account locking
B.
Password history
C.
Password change
D.
Password aging and expiration
Answer:
c
48.
Which resource can not be controlled using profiles?
A.
Idle time
B.
CPU time
D.
PGA memory allocations
E.
Number of concurrent sessions for a user name
Answer:
d
49.
You want to retrieve information about account expiration dates from the data
dictionary. Which view do you use?
A.
DBA_USERS
B.
DBA_PROFILES
C.
DBA_EXP_DATES
D.
V$ACC_EXPIRATION
Answer:
a
50.
It is very difficult to grant and manage common privileges needed by different
groups of database users using roles.
A.
TRUE
B.
FALSE
Answer:
b
51.
Which data dictionary view would you query to retrieve a table's header block
number?
A.
DBA_TABLE
B.
DBA_TABLES
C.
DBA_OBJECT
D.
DBA_OBJECTS
E.
DBA_SEGMENT
F.
DBA_SEGMENTS
Answer:
f
52.
When tables are stored in locally managed tablespaces, where is extent
allocation information stored?
A.
Memory
B.
Data Dictionary
C.
Temporary tablespace
D.
Corresponding tablespace itself
Answer:
d
53.
Which of the following three portions of a data block are collectively called
as Overhead?
A.table
directory, row directory and row data
B.data
block header, table diretory and free space
C.table
directory, row directory and data block header
D.
data block header, row data and row header
Answer:
c
54.
Can a tablespace hold objects from different schemes?
A.
Yes.
B.
NO
Answer:
a
55.
Which data dictionary view would you query to retrieve a table's header block
number? (11-41)
A.
DBA_TABLE
B.
DBA_TABLES
C.
DBA_OBJECT
D.
DBA_OBJECTS
E.
DBA_SEGMENT
F.
DBA_SEGMENTS
Answer:
f
56.
What is default value for storage parameter INITIAL in 10g if extent management
is Local ?
A.
8k
B.
40k
C.
16k
Answer:
b
57.
Using which package we can convert Tablespace from DMTS to LMTS?
A.
DBMS_TABLESPACE
B.
DBMS_SPACE_ADMIN
C.
DBMS_LOCAL_TABLESPACE
Answer:
b
58.
Is it Possible to Change ORACLE Block size after creating database?
A.
Yes
B.
No
Answer:
b
59.
Locally Managed table spaces will increase the performance?
A.
TRUE
B.FLASE
Answer:
a
60.Index
is a Space demanding Object ?
A.Yes
B.No
Answer:
a
61.
What is a potential reason for a Snapshot too old error message?
a.
You did not refresh your snapshots in time.
b.
An ITL entry in a data block has been reused.
c.
Rollback segment extent sizes are too large.
d.
Your online redo log files are not big enough to snap your largest
transactions.
Answer:
b
62.
An Oracle user receives the following error:
ORA-01555
SNAPSHOP TOO OLD
What
is the possible solution? (10-36)
A.
Increase the extent size of the rollback segments.
B.
Perform media recovery.
C.
Increase the number of rollback segments.
D.
Increase the size of the rollback segment tablespace.
Answer:
a
63.
The status of the Rollback segment can be viewed through
A.
DBA_SEGMENTS
B.
DBA_ROLES
C.
DBA_FREE_SPACES
D.
DBA_ROLLBACK_SEG
Answer:
d
64.
Explicitly we can assign transaction to a rollback segment
A.
TRUE
B.
FALSE
Answer:
a
65)
Are uncommitted transactions written to flashback redologs?
A.
Yes
B.
No
Answer:
a
66)
Is it possible to do flashback after truncate?
A.No
B.
Yes
Answer:
a
67)
Can we restore a dropped table after a new table with the same name has been
created?
A.
Yes
B.
No
Answer:
a
68.
Which following command will clear database recyclebin?
A.delete
recyclebin;
B.
clear recyclebin;
C.
purge recyclebin;
D.
truncate recyclebin
Answer:
c
69.
What is the OPTIMAL parameter?
A.
length of a rollback segment.
B.
Optimizer mode
C.
Size of the undo tablespace
D.
None of the above
Answer:
a
70.
Flashback query time depends on ____?
A.
Undo_retention
B.
Flashback_timeout
Answer:
a
71.
Can we create spfile in shutdown mode?
A.Yes
B.
No
Answer:
a
72.
Can we alter static parameters by using scope=both?
A.
Yes
B.
No
Answer:
b
73.
Can we take backup of spfile in RMAN?
A.
Yes
B.
No
Answer:
a
74.
Does Drop Database command removes spfile?
A.
Yes
B.
No
Answer:
a
75.
Using which SQL command we can alter the parameters?
A.
Alter database
B.
Alter parameter
C.
Alter system
Answer:
c
76.OMF
database will Improve the performance?
A.
Yes
B.
No
Answer:
b
77.Max
number of controlfiles that can be multiplexed in an OMF database?
A.
1
B.
5
C.
8
D.
unlimited
Answer:
b
78.
Which environment variable is used to help set up Oracle names?
A.
ADMIN_TNS
B.
TNS_NAMES
C.
TNS_ADMIN
D.
NAMES_TNS
E.
NAMES_ADMIN
F.
ADMIN_NAMES
Answer:
c
79.
Which Net8 component waits for incoming requests on the server side?
A.
Port
B.
Server
C.
Listener
D.
Dispatcher
E.
Background process
Answer:
c
80.
What is the listener name when you start the listener without specifying an
argument?
A.
LIST
B.
LISTENER
C.
LISTENER_NAME
D.
The same as the instance name.
Answer:
b
81.
When is a request sent to a listener?
A.
After every call.
B.
Before every call.
C.
After name resolution.
D.
Before name resolution.
Answer:
c
82.
In which file is the information that host naming is enabled stored?
A.
init.ora
B.
sqlnet.ora
C.
tnsnames.ora
D.
listener.ora
Answer:
b
83.
Which protocols can oracle Net 11g Use
A.TCP
B.UDP
C.SPX/IPX
Answer:
a
89.
Which of the following statements about listeners is correct?
A.
A listener can connect you to one instance only.
B.
A listener can connect you to one service only.
C.
Multiple listeners can share one network interface card.
D.
An instance will only accept connections from the listener specified on the
local_listener parameter.
Answer:
c
90.
Can we perform DML operation on Materialized view?
A.Yes
B.No
Answer:
b
91.Materialized
views are schema objects, that can be used to summarize pre compute replicate
and distribute data?
A.True
B.False
Answer:
a
92.
Does a materialized view occupies space?
A.
Yes
B.
No
Answer:
a
93.
Can we name a Materialized View log?
A.
Yes
B.
No
Answer:
b
94.
By using which view can a normal user see public database link?
A.
USER_DB_LINKS
B.
DBA_DB_LINKS
C.
ALL_DB_LINKS
Answer:
c
95.
Can we change the refresh interval of a Materialized View?
A.
YES
B.
NO
Answer:
a
96.
Can we use a database link even after the target user has changed his password?
A.
Yes
B.
No
Answer:
a
97.
Can we convert a materialized view from refresh fast to complete?
A.
Yes
B.
No
Answer:
a
98.
A normal user can create public database link?
A.
True
B.
False
Answer:
b
99.
If we truncate the master table, materialized view log on that table__
A.
Will be truncated
B.
Wont be truncated
C.
Will be dropped
Answer:
c
100.
What is the correct procedure for multiplexing online redo logs?
A.
Issue the ALTER DATABASE. . . ADD LOGFILE GROUP command.
B.
Issue the ALTER DATABASE. . . ADD LOGFILE MEMBER command.
C.
Shut down the database, copy the online redo-log, and start up the database.
D.
Shut down the database, copy the online redo-log, edit the REDO_LOG_FILES
parameter, and start up the database
Answer:
b
101.
In which situation would you need to create a new control file for an existing
database?
A.
When all redo-log files are lost.
B.
When MAXLOGMEMBERS needs to be changed.
C.
When RECOVERY_PARALLELISM needs to be changed.
D.
When the name of the parameter file needs to be changed
Answer:
b
102.
When configuring a database for ARCHIVELOG mode, you use an initialisation
parameter to specify which action?
A.
The size of archived log files.
B.
How frequently log files will be archived.
C.
That the database is in ARCHIVELOG mode.
d.
To Store Archive log Files
Answer:
d
103.
Which command creates a text backup of the control file?
A.
ALTER DATABASE BACKUP CONTROLFILE TO TRACE;
B.
ALTER DATABASE BACKUP CONTROLFILE TO BACKUP;
C.
ALTER DATABASE BACKUP CONTROLFILE TO filename;
D.
ALTER DATABASE BACKUP CONTROLFILE TO TEXT filename;
Answer:
a
104.
You are configuring a database for ARCHIVELOG mode. Which initialization
parameter should you use?
A.
LOG_ARCHIVE_SIZE
B.
ARCHIVELOG_MODE
C.
LOG_ARCHIVE_DEST
Answer:
c
105.
How does a DBA specify multiple control files?
A.
With the ADD CONTROLFILE command.
B.
By using the files in the STARTUP command.
C.
With the MULTIPLEX control file command.
D.
By listing the files in the CONTROL_FILES parameter.
Answer:
d
106.
Which dynamic view should a DBA query to obtain information about the different
sections of the control file? (6-10)
A.
V$CONTROLFILE
B.
DBA_CONTROLFILE
C.
V$CONTROLFILE_RECORD_SECTION
D.
DBA_CONRTOLFILE_RECORD_SECTION
Answer:
c
107.
What is the characteristics of the control file?
A.
It is a text file
B.
It is a fixed size.
C.
It is required to start the instance.
D.
It must be updated at every log switch.
nswer:
d
108.
Which statements about online redo log members in a group are true?
A.
All files in all groups are the same size.
B.
All members in a group are the same size.
C.
The rollback segment size determines the member size.
D.
Differently size of transactions requires that the DBA should differently sized
members.
Answer:
b
109.
Which command does a DBA use to list the current status of archiving?
A.
ARCHIVE LOG LIST;
B.
FROM ARCHIVE LOGS;
C.
SELECT * FROM VITEREAD
Answer:
a
110.
When performing an open database backup, which statement is NOT true?
A.The
database is fully accessible to all users.
B.The
database must be operating in ARCHIVELOG mode.
C.The
database can be open but only in READ ONLY mode.
D.The
database tablespaces should be in BEGIN BACKUP mode.
Answer:
c
111
.Which task can a DBA perform using the export/import facility?
A.Examine
log files.
B.Recreate
the control file.
C.Transport
tablespaces between databases.
D.Make
a logical backup of the rollback segment tablespace.
Answer:
c
112.Why
does this command cause an error?
exp
system/manager inctype=full file=expdat.dnp
A.The
tables to export are not identified.
B.The
user system cannot perform exports.
C.The
full=y parameter needs to be specified.
D.The
inctype parameter is not valid parameter.
Answer:
c
113.
Which import option do you use to create tables without data?
A.
ROWS
B.
CREATE
C.
INDEXES
D.
CONSISTENT
Answer:
a
114.
Which export option will generate code to create an initial extent that is
equal to the sum of the sizes of all the extents currently allocated to an
object?
A.
FULL
B.
DIRECT
C.
COMPACT
D.
COMPRESS
Answer:
d
115.
Can I take 1 dump file set from my source database and import it into multiple
databases?
A.
Yes
B.
No
Answer:
a
116.
EXP command is used
A.
To take Backup of the Oracle Database
B.
To import data from the exported dump file
C.
To create Rollback segments
D.
None of the above
Answer:
a
117.
Can we export a dropped table?
A.
No
B.
Yes
Answer:
a
118.
What is the default value for IGNORE parameter in EXP/IMP?
A.
Yes
B.
No
Answer:
b
120.
Why is Direct Path Export Faster?
A.
This option By Passes the SQL Layer
B.
All SGA is used for Export
C.
All of the above
D.
None of the above
Answer:
a
121.
Is there a way to estimate the size of an export job before it gets underway?
A.
NO
B
yes
Answer:
b
122.
Can I monitor a Data Pump Export or Import job while the job is in progress?
A.
Yes
B.
No
Answer:
a
123.
If a job is stopped either voluntarily or involuntarily, can I restart it?
A.
No
B.
Yes
Answer:
b
124.
Does Data Pump support Flashback?
A.
Yes
B.
no
Answer:
a
125.
If the tablespace is Read Only,Can we export objects from that tablespaces?
A.
Yes
B.
No
Answer:
a
126.
Dump files exported using traditional EXP are compatible with DATAPUMP?
A.
True
B.
False
Answer:
b
127.
Before a DBA creates a transportable tablespace, which condition must be
completed?
A.
All indexes are disabled or dropped.
B.
The target system has precreated the tablespace.
C.
The target system is in the same operating system.
D.
The tables containing nested tables are contained in the same tablespace.
Answer:
c
128.
Can we transport tablespace from one database to another database which is
having SYS owned objects?
A.
Yes
B.
No
Answer:
b
129.
What is default value for TRANSPORT_TABLESPACE Parameter in EXP?
A.
Yes
B.
No
Answer:
b
130.
How to find whether tablespace is created in that database or transported from
another database?
A.
V$database
B
Dba_tablespaces
C.
Dba_data_files
D.
V$transport_tablespace
Answer:
b
131.
Can we Perform TTS using EXPDP?
A.
Yes
B.
No
Answer:
a
132.
Can we Transport Tablespace which has Materialized View in it?
A.
Yes
B.
No
Answer:
b
133.
When would a DBA need to perform a media recovery?
A.
After instance failure occurs.
B.
After abnormal termination of client program.
C.
After the failure of an Oracle background process.
D.
After the database is shutdown by using SHUTDOWN TRANSACTIONAL.
E.
When a data file is not synchronized with the other data files, redo logs, and
control files.
Answer:
e
134.
Why would you set a data file offline when the database is in MOUNT state?
A.To
minimize downtime.
B.To
allow for automatic data file recovery.
C.To
prevent further corruption of a damaged data file.
D.To
recover it later, when database is in NOARCHIVELOG mode.
Answer:
b
135.
What is the causes of media failures?
A.The
server computer loses power.
B.A
table is accidentally truncated.
C.The
user issues an abnormal interrupt.
E.There
is a logic error in the application.
F.There
is a head crash on the disk containing a database file.
Answer:
f
136.
Which of the following would not require you to perform an incomplete recovery?
A.
Instance failure
B.
Missing archived redo log files during a media recovery
C.
Loss of all copies of the control file
D.
Media failure in a user tablespace in ARCHIEVELOG mode
Answer:
a
137.
In what scenario you have to open a database with reset logs option?
A.
Rename Database
B.
Point in time recovery
C.
All of the above
Answer:
c
138.
Is it possible take consistent backup if the database is in NOARCHIVELOG mode?
A.
Yes
B.
No
Answer:
a
139.
Database is in Archivelog mode and Loss of unbackedup datafile is__?
A.
Complete Online Recovery
B.
Incomplete Recovery
C.
Complete Offline recovery
Answer:
a
140.
You should issue a backup of the control file after issuing which command?
A.
ALTER TABLE
B.
CREATE TABLE
C.
CREATE TABLESPACE
D.
CREATE ROLLBACK SEGMENT
Answer:
c
141.
The alert log will never contain specific information about which database
backup activity) ?
A.
Placing tablespaces in begin backup mode.
B.
Shutting the database down with an ABORT.
C.
Performing an operating system backup of the database files.
D.
Changing the database backup mode from ARCHIVELOG to NOARCHIVELOG
Answer:
c
142.
A tablespace becomes unavailable because of a failure. The database is running
in NOARCHIVELOG mode? What should the DBA do to make the database available?
A.
Perform a tablespace recovery.
B.
Perform a complete database recovery.
C.
Restore the data files, redo log files, and control files from an earlier copy
of a full database backup.
D.
There is no possibility to make the database available.
Answer:
c
143.
How often does a read-only tablespace need to be backed up?
A.
At all database backups
B.
Whenever the control file is recreated
C.
Only once after the tablespace becomes read-only
D.
When the database is put into ARCHIVELOG mode
Answer:
c
144.
With the instance down, how would you recover a lost control file?
A.
Restore backup control file & recover using backup controlfile
B.
Use the CREATE CONTROLFILE command
C.
Use the ALTER DATABASE BACKUP CONTROLFILE TO TRACE command
D.
Use the ALTER DATABASE RECOVER CONTROLFILE FROM TRACE command
Answer:
a
145.
Which action does Oracle recommend after a DBA recovers from the loss of the
current online redo-log?
A.
Back up the data files
B.
Back up the instance
C.
Back up the database
D.
Back up the control file
E.
Archive any unarchived online redo-logs
Answer:
c
146.
Which command creates a text backup of the control file?
A.
ALTER DATABASE BACKUP CONTROLFILE TO TRACE;
B.
ALTER DATABASE BACKUP CONTROLFILE TO BACKUP;
C.
ALTER DATABASE BACKUP CONTROLFILE TO filename;
D.
ALTER DATABASE BACKUP CONTROLFILE TO TEXT filename;
Answer:
a
147.
Which option is used in the parameter file to detect corruptions in an Oracle
data block?
A.
DBVERIFY
B.
DBMS_REPAIR
C.
DB_BLOCK_CHECKING
D.
VALIDITY_STRUCTURE
Answer:
a
148.
Your database is configured in ARCHIVELOG mode. Which backups cannot be
performed?
A.Open
database backups.
B.Operating
system backups when the database is closed.
C.Online
control file backups using the ALTER CONTROLFILE BACKUP command
Answer:
c
149.
Which statement about an open database backup is NOT true?
A.
The database must be available in ARCHIVELOG mode.
B.
The database is available for use during backups.
C.
All the database files copied are consistent to a point-in-time.
D.
An operating system backup of the database file is required.
Answer:
c
150.
When performing an open database backup, which statement is NOT true?
A.
The database is fully accessible to all users.
B.
The database must be operating in ARCHIVELOG mode.
C.
The database can be open but only in READ ONLY mode.
D.
The database tablespaces should be in BEGIN BACKUP mode.
Answer:
c
151.
You are using hot backup without being in archivelog mode, can you recover in
the event of a failure?
A.
Yes
B.
No
Answer:
b
152.
Which following statement is true when tablespaces are put in backup mode for
hot backups?
A.
High Volume of REDO is generated
B.
No updates to tables in that tablespace
C.
All of the above
D.
None of the above
Answer:
a
153.
Can Consistant Backup be performed when the database is open ?
A.
Yes
B.
No
Answer:
b
154.
Can we shutdown the database if it is in BEGIN BACKUP mode?
A.
Yes
B.
No
Answer:
a
155.
Which data dictionary view helps you to view whether tablespace is in BEGIN
BACKUP Mode or not?
A.
v$tablespace
B.
V$datafile
C.
V$backup
Answer:
c
156.
Which command is used to allow RMAN to store a group of commands in the
recovery catalog?
A.ADD
SCRIPT
B.CREATE
SCRIPT
C.CREATE
COMMAND
D.ADD
BACKUP SCRIPT
Answer:
b
157.When
using Recovery Manager without a catalog, the connection to the target database
A.Must
be a local connection.
B.Must
be a remote connection.
C.Can
be a local or a remote connection.
D.Must
be specified using a Net8 service name.
Answer:
c
158.
Work is done by Recovery Manager through ____
A.
PL/SQL packages.
B.
External procedures.
C.
Operating system scripts.
D.
Operating system commands
Answer:
d
159.
You perform an incomplete database recovery using RMAN. Which state of target
database is needed?
A.
Mount
B.
Nomount
C.
Open, initially open
D.
Open, initially closed
Answer:
a
160.
Is it possible to perform Transportable tablespace(TTS) using RMAN ?
A.
Yes
B.
No
Answer:
a
161.
Which type of file does Not RMAN include in its backups?
A.
Data files
B.
Control files
C.
Password files
E.
Online redo-logs
F.
Archived redo-logs
Answer:
e
162.
When using Recovery Manager without a catalog, the connection to the target
database should be made as _____.
A.
User SYSDBA
B.
User SYSTEM
C.
A user with SYSDBA privilege
D.
A user that owns the RMAN catalog
Answer:
c
167.
RMAN online backup generates excessive Redo information
A.
True
B.
Flase
Answer:
b
168.
Which background process will be invoked when we enable BLOCK CHANGE TRACKING?
A.
Rvwr
B.
CTWr
C.
ARCn
D.
RECO
Answer:
b
169.
Where should a recovery catalog be created?
A.
In the target database
B.
In the source database
C.
In the auxiliary database
D.
In a database different from the target database
Answer:
a
170.
How to list restore points in RMAN?
A.
RC_RESTORE_POINT view
B.
LIST RESTORE POINT
C.
All of the above
Answer:
a
171.
Without LIST FAILURE can we say ADVISE FAILURE in Data Recovery Advisor?
A.
Yes
B.
No
Answer:
a
172.
Import Catalog Command is used for ____
A.
Take Backup of catalog
B.
To Merge Two diff catalogs
C.
Catalog Recovery
Answer:
b
173.
Interfile backup parallelism does
A.
Divide files into Multiple sections & take backup parallel
B.
Database backup parallely
C.
Datafiles Backup Parallely
Answer:
a
174.
What command would you use to create a backup control file?
Answer:
Alter database backup control file to trace.
175.What
are the steps involved in Database Startup?
Answer: Start an instance, Mount the Database and Open the Database.
176.
Can Full Backup be performed when the database is open?
Answer: No.
177.
What are the steps involved in Database Shutdown?
Answer:
Close the Database, Dismount the Database and Shutdown the Instance.
178.
What is Archived Redo Log?
Answer:
Archived Redo Log consists of Redo Log files that have archived before being
reused.
179.
What is Restricted Mode of Instance Startup?
Answer:
An instance can be started in (or later altered to be in) restricted mode so
that
when
the database is open connections are limited only to those whose user
accounts
have been granted the RESTRICTED SESSION system privilege.
180.
Explain the difference between a data block, an
extent and a segment.
Answer: A data block is the smallest unit of logical storage for a database object. As objects grow they take chunks of additional storage that are composed of contiguous data blocks. These groupings of contiguous data blocks are called extents. All the extents that an object takes when grouped together are considered the segment of the database
object.
181.
How do you switch from an init.ora file to a spfile?
Answer: Issue the create spfile from pfile command
Answer: Issue the create spfile from pfile command
182.
Give two examples of how you might determine the structure of the table
DEPT.
Answer: Use the describe command or use the dbms_metadata.get_ddl package.
185.
Where would you look for errors from the database engine?
Answer: In the alert log.
186.
What command would you use to encrypt a PL/SQL application?
Answer: WRAP
187.
How would you determine the time zone under which a database was operating?
Answer: Select DBTIMEZONE from dual;
Answer: Select DBTIMEZONE from dual;
188.
When a user process fails, what background process cleans up after it?
Answer: PMON
Answer: PMON
189.
Describe what redo logs are.
Answer: Redo logs are logical and physical structures that are designed to hold all the changes made to a database and are intended to aid in the recovery of a database.
Answer: Redo logs are logical and physical structures that are designed to hold all the changes made to a database and are intended to aid in the recovery of a database.
190.
How would you force a log switch?
Answer: ALTER SYSTEM SWITCH LOGFILE;
Found the best posts Oracle DBA Interview question & answers!...
ReplyDeletePretty Blog! I found some useful information in your blog, it was awesome to read, thanks for sharing this great content to my vision, keep sharing. Click here to know more about Interview Questions on Oracle DBA.
ReplyDeleteGreat article 150 oracle dba questions
ReplyDeletelist-of-100-mysql-interview-questions
ReplyDeleteI really enjoy simply reading all of your weblogs. Simply wanted to inform you that you have people like me who appreciate your work. Definitely a great post. Hats off to you! The information that you have provided is very helpful.
ReplyDeleteSalesforce Training in Chennai
Salesforce Online Training in Chennai
Salesforce Training in Bangalore
Salesforce Training in Hyderabad
Salesforce training in ameerpet
Salesforce Training in Pune
Salesforce Online Training
Salesforce Training