Interview Questions

1) What are the precautions to be used before truncating a table?

A) We need to disable all the constraints associated to the table and need to drop the triggers on the table.

2) We have restored and recovered the database with 11.2.0.3 backup on 11.2.0.4 successfully, Can we open the database with reset logs?

A) No, We can not open the database with reset logs. We need to open the database as alter database open resetlogs upgrade and then upgrade the database to 11.2..4 by running running  catupgrd.sql. Then Startup the database and check the invalid objects in the database.

3) Are the password case sensitive or case in-sensitive in Oracle 11g?

A) The passwords from 11g are case sensitive which are controlled by sec_case_sensitive_logon initialization parameter, If the value is true then will enforce the case sensitivity. From 11g on wards the password column returns nothing.

4) Can we alter the user's password to same password?

A) Yes, We can do it from 11g by alerting the password_verify_function resource to null.

5) Do we take online backup using RMAN when database is in no archive log mode?

A) No, The database must and should running archivelog mode to take online backup using RMAN or hot backup.

6) Suppose I have a table with three columns say column A, Column B and Column C, among them Column A is primary key column and column B is not null column. Now I’m going to insert the data in to the table, Could you please let me know what are the columns must and should have some data in the insert statement?

A) Column A and Column B Since Constraints are imposed on the columns.

7) If I missed value for Column C, Will the insert statement will complete?

A) Yes

8) What value will be stored in Column C?

A) Nothing.

9) Are the database passwords are case sensitive from which version?

A) Oracle 11g