Concepts and Architecture Question:
Download Job Interview Questions and Answers PDF
Explain what is the command to find the database that already present before connecting?
Answer:
As a sys or system user,select name from v$database;As a normal user,select global_name from global_name;select ora_database_name from dual; - dual is a dummy table in oracleshow parameter db_name - has to be given in sql prompt.
Download Oracle Architecture and Concepts Interview Questions And Answers
PDF
| Previous Question | Next Question |
| When does the LGWR writes all redo-enteries to the redo-log buffer? | What is a Data Segment in Oracle? |