Category Archives: Oracle Database Interview Questions

Explain the difference between $ORACLE_HOME and $ORACLE_BASE. – ORACLE_BASE is the root directory for oracle. | Oracle DBA Questions

ORACLE_HOME located beneath ORACLE_BASE is where the oracle products reside.

Posted in Oracle Database Interview Questions | Leave a comment

What type of index should you use on a fact table? | Oracle DBA Questions

A Bitmap index.

Posted in Oracle Database Interview Questions | Leave a comment

Give the two types of tables involved in producing a star schema and the type of data they hold. | Oracle DBA Questions

Fact tables and dimension tables. A fact table contains measurements while dimension tables will contain data that will help describe the fact tables.

Posted in Oracle Database Interview Questions | Leave a comment

Give two examples of how you might determine the structure of the table DEPT. | Oracle DBA Questions

Use the describe command or use the dbms_metadata.get_ddl package.

Posted in Oracle Database Interview Questions | Leave a comment

What Happens If You Use a Wrong Connect Identifier? | Oracle Database Questions

Of course, you will get an error, if you use a wrong connect identifier. Here is an example of how SQL*Plus react to a wrong connect identifier: SQL> CONNECT ggl/retneclgg@WRONG; ERROR: ORA-12154: TNS:could not resolve the connect identifier specified Warning: … Continue reading

Posted in Oracle Database Interview Questions | Leave a comment

How To Connect a SQL*Plus Session to an Oracle Server? | Oracle Database Questions

In order to connect a SQL*Plus session to an Oracle server, you need to: 1. Obtain the connection information from the Oracle server DBA. 2. Define a new “connect identifier” called “ggl_XE” in your tnsnames.org file with the given connection … Continue reading

Posted in Oracle Database Interview Questions | Leave a comment

What Is a Connect Identifier? | Oracle Database Questions

A “connect identifier” is an identification string of a single set of connection information to a specific target database instance on a specific Oracle server. Connect identifiers are defined and stored in a file called tnsnames.ora located in $ORACLE_HOME/network/admin/ directory. … Continue reading

Posted in Oracle Database Interview Questions | Leave a comment

What Information Is Needed to Connect SQL*Plus an Oracle Server? | Oracle Database Questions

If you want to connect your SQL*Plus session to an Oracle server, you need to know the following information about this server: * The network hostname, or IP address, of the Oracle server. * The network port number where the … Continue reading

Posted in Oracle Database Interview Questions | Leave a comment

How To Get Help at the SQL Prompt? | Oracle Database Questions

Once SQL*Plus is started, you will get a SQL prompt like this: SQL>. This where you can enter commands for SQL*Plus to run. To get help information at the SQL prompt, you can use the HELP command as shown in … Continue reading

Posted in Oracle Database Interview Questions | Leave a comment

How To Start the Command-Line SQL*Plus? | Oracle Database Questions

If you Oracle server or client installed on your windows system, you can start the command-line SQL*Plus in two ways: 1. Click Start > All Programs > Oracle … > Start SQL Command Line. The SQL*Plus command window will show … Continue reading

Posted in Oracle Database Interview Questions | Leave a comment