DBA-QUIZ 1

1. 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

correct answer: f

2. 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

correct answer: d

3. 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

correct answer: c

 4. Can a tablespace hold objects from different schemes?

A. Yes. B. NO

correct answer: a

5. 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

correct answer: f

6. What is default value for storage parameter INITIAL in 10g if extent management is Local ?

A. 8k B. 40k C. 16k correct answer: b

7. Using which package we can convert Tablespace from DMTS to LMTS?

A. DBMS_TABLESPACE B. DBMS_SPACE_ADMIN C. DBMS_LOCAL_TABLESPACE

correct answer: b

8. Is it Possible to Change ORACLE Block size after creating database?

A. Yes B. No

correct answer: b

9. Locally Managed table spaces will increase the performance?

A. TRUE B.FLASE

 correct answer: a

10.Index is a Space demanding Object ?

A.Yes B.No

correct answer: a

10. 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.

correct answer: b

11. 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.

correct answer: a

3. The status of the Rollback segment can be viewed through

A. DBA_SEGMENTS B. DBA_ROLES C. DBA_FREE_SPACES D. DBA_ROLL BACK_ SEG

correct answer: d

4. Explicitly we can assign transaction to a rollback segment A. TRUE B. FALSE

 correct answer: a

5) Are uncommitted transactions written to flashback redologs?

A. Yes B. No

correct answer: a

6) Is it possible to do flashback after truncate?

A.No B. Yes

 correct answer: a

7) Can we restore a dropped table after a new table with the same name has been created?

A. Yes B. No

 correct answer: a

8. Which following command will clear database recyclebin?

A.delete recyclebin; B. clear recyclebin; C. purge recyclebin; D. truncate recyclebin

correct answer: c

9. What is the OPTIMAL parameter? A. length of a rollback segment. B. Optimizer mode C. Size of the undo tablespace D. None of the

correct answer: a

10. Flashback query time depends on ____?

 A. Undo_retention B. Flashback_timeout

correct answer: a

11.  Can we create spfile in shutdown mode? A.Yes B. No correct answer: a

12. Can we alter static parameters by using scope=both A. Yes  B. No correct answer: b

13. Can we take backup of spfile in RMAN? A. Yes B. No correct answer: a

14. Does Drop Database command removes spfile? A. Yes B. No correct answer: a

15. Using which SQL command we can alter the parameters? A. Alter database B. Alter parameter C. Alter system correct answer: c

16.OMF database will Improve the performance? A. Yes B. No correct answer: b

17.Max number of controlfiles that can be multiplexed in an OMF database? A. 1 B. 5 C. 8 D. unlimited

correct answer: b

18. 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 correct answer: c

19 . Which Net8 component waits for incoming requests on the server side?

A.    Port B. Server C. Listener D. Dispatcher E. Background process

 correct answer: c

20. 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.

 correct answer: b

 21. When is a request sent to a listener?

A. After every call. B. Before every call. C. After name resolution. D. Before name resolution.

 correct answer: c

22. In which file is the information that host naming is enabled stored?

A. init.ora B. sqlnet.ora C. tnsnames.ora D. listener.ora

correct answer: b

      23. Which protocols can oracle Net 11g Use A.TCP B.UDP C.SPX/IPX

       correct answer: a