Oracle DBA Interview questions With Answer Part-III

                                                       ORACLE DBA INTERVIEW QUESTION'S WITH ANSWER

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

Question 2: Who is the owner of a role?

A. SYS
B. Nobody
C. SYSTEM
D. The creator

Question 3: 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

Question 4: 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

Question 5: 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

Question 6: 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.

Question 7: 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

Question 8: Which resource cannot be controlled using profiles?

A. Idle time
B. CPU time
D. PGA memory allocations
E. Number of concurrent sessions for a user name

Question 9: 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

Question 10: It is very difficult to grant and manage common privileges needed by different groups of database users using roles

A. TRUE
B. FALSE

Question 11: 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


Question 12: 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

Question 13: 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

Question 14: Can a tablespace hold objects from different schemes?

A. Yes.
B. NO

Question 15: 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

Question 16: What is default value for storage parameter INITIAL in 10g if extent management is Local?

A. 8k
B. 40k
C. 16k

Question 17: Using which package we can convert Tablespace from DMTS to LMTS?

A. DBMS_TABLESPACE
B. DBMS_SPACE_ADMIN
C. DBMS_LOCAL_TABLESPACE

Question 18: Is it Possible to Change ORACLE Block size after creating database?

A. Yes
B. No

Question 19: Locally Managed table spaces will increase the performance?

A. TRUE
B.FLASE

Question 20: Index is a Space demanding Object ?

A.Yes
B.No

Correct answer: 1(c), 2(b), 3(c), 4(a), 5(b), 6(c), 7(c), 8(c), 9(a), 10(b),
11(f), 11(d), 12(f), 13(c), 14(a),15(f),16(b),17(b),18(b),19(a),20(a)