Top 61 Oracle DBA Real Time Questions and Answers:

1) How can you see the Current SCN number in the database?
  Select current_scn from v$database;

2) How can you see the Current log sequence number the logwriter is writing in to?
Select * from v$log;

3) If you are given a database, how will you know how many datafiles each tablespace contain?
Select distinct tablespace_name,file_name from dba_data_files;

4). How will you know which temporary tablepsace is allocated to which user?
Select temporary_tablespace from dba_users where username=’SCOTT’;

5) If you are given a database, how will you know whether it is locally managed or dictionary managed?
Select extent_management from dba_tablespaces where tablespace_name=’USERS’;
6) How will you list all the tablespaces and their status in a database?
Select tablespace_name,status from dba_tablespaces;

7) How will you find the system-wide 1) default permanent tablespace, 2) default temporary tablespace 3) Database time zone?
 Select property_name,property_value from database_properties where property_name like