Oracle DBA Question $ Answers(Part 6)

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