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

Right Answer: D