ORACLE MCQ Test - 4
Que.1. Oracle creates an index for the _____________ in the snapshot base table
A: Primary key
B: Foreign key
C: Super key
D: Both a and c
Right
Answer: A
Que.2.
How should a many-to-many relationship be handled?
A: By adding an join entity table
B: By adding intersection entity table
C: By adding union entity table
D: By adding Cartesian entity table
Right
Answer: B
Que.3.
The delay between the time a DML change is applied at the originating database
and the time the transaction reaches the destination databases is called as
A: Propagation
B: Propagation latency
C: Conflict
D: Conflict latency
Right
Answer: B
Que.4.
Which of the following rule below is FALSE for a database object?
A: Has a unique name within that schema
B: Object names cannot be longer than 30
bytes
C: Must begin with a letter
D: None of the above
Right
Answer: D
Que.5.
More than one materialized view cannot use a materialized view log
A: True
B: False
Right
Answer: B
Que.6.
Name the tool for tuning SQL statements.
A: TUNEUP SYS
B: EXPLAIN SYS
C: DB_TUNEUP
D: EXPLAIN PLAN
Right
Answer: D
Que.7.
What is the probable cause for getting the following error stack?
ERROR:
ORA-01034: ORACLE not available
ORA-07318:
smsget: open error when opening sgadef.dbf file.
HP-UX
Error: 2: No such file or directory
A: The Oracle segment is shutdown that they
are trying to access
B: The Oracle namespace is shutdown that
they are trying to access
C: The Oracle instance is shutdown that
they are trying to access
D: None of the above
Right
Answer: C
Que.8.
A ____________________ is a structure that contains definitions, blocks of
PL/SQL code, or both in a single unit
A: Package body
B: Package
C: Procedure
D: Both a and b
Right
Answer: B
Que.9.
Which of the following is the fastest query method for a table?
A: Fetch by columnid
B: Fetch by tableid
C: Fetch by rowid
D: Fetch by indexid
Right
Answer: C
Que.10.
By default which refresh on a snapshot is performed by Oracle?
A: Fast refresh
B: Complete refresh
C: Automatic refresh
D: Attempts fast refresh, if it cannot be
preformed server performs a complete refresh
Right
Answer: D
Que.11.
What do you mean by Quiescence?
A: act of suspending DML activity for all
tables in a given replication group
B: act of suspending DML activity for
selected tables in a given replication group
C: act of granting DML activity for selected
tables in a given replication group
D: act of granting DML activity for all
tables in a given replication group
Right
Answer: A
Que.12.
Which of the following below is a type of replication?
A: Update replication
B: Read-only materialized views
C: Multi replication
D: All of the above
Right
Answer: B
Que.13.
Using synonyms is a good way to implement location transparency.
A: True
B: False
Right
Answer: A
Que.14.
What are the two ways to determine the structure of a table in database?
A: Using DESCRIBE command and
dbms_metadata_get_commit package
B: Using METADATA command STRUCTURE
commands
C: Using DATA_ON_DATA and STRUCTURE
commands
D: Using DESCRIBE command and
dbms_metadata_get_ddl package
Right
Answer: D
Que.15.
Where would you look for errors from the database engine?
A: In the error log
B: In the alter log
C: In the alert log
D: In the recovery log
Right
Answer: C
Que.16.
Which of the following are three advisory statistics to collect?
A: Buffer Cache Table, Segment Level Statistics,
Timed Statistics
B: Buffer Table Cursor statistics, Segment
Level Cursor statistics, Timed statistics
C: Segment Table statistics, Buffer and
Cursor statistics, Timed Cursor statistics
D: Buffer Index statistics, Segment Index
Statistics, Timed Index Statistics
Right
Answer: A
Que.17.
A cluster is a schema object that contains data from _____________ , all of
which have one or more columns in common.
A: one table
B: one or more tables
C: two or more tables
D: atleast two tables
Right
Answer: C
Que.18.
A _______________ is a collection of one or more replicated objects (typically
tables) that are administrated together
A: Replica
B: Replica group
C: Replication
D: Replication group
Right
Answer: D
Que.19.
A hot backup is
A: taking up the backup of the database
while it is still up and running
B: taking up the backup of the database
after the user logs off
C: taking up the backup followed by taking
cold backup
D: None of the above
Right
Answer: A
Que.20.
What command is used to encrypt a PL/SQL application?
A: DB_ENCRYPT
B: DBMS_ENCRYPT
C: DBMS_WRAP
D: WRAP
http://mcqtestanswers.blogspot.com/
