If you are hunting for the best Oracle DBA interview questions with answers you are at the right place, here's a list of most frequently asked interview questions to crack a job easily even with high competition.
Q. List four possible ways (direct or indirect) to execute an SQL query against an Oracle Database?
- Using the SQL*Plus command line tool. With this tool, you can directly execute SQL commands.
- Using a GUI (Graphical User Interface) tool like SQL Developer. You can directly execute SQL commands with such tools.
- Using Oracle Enterprise Manager. This is an indirect way of executing an SQL query. When you perform certain operations with Oracle Enterprise Manager, they are converted to SQL queries implicitly and these SQL queries are executed against the database.
- Writing your own program. This is not a conventional way of executing your queries but actually it is widely used. Any web or windows program that uses Oracle database at backend, executes SQL queries. These programs are written using a programming language like .NET or JAVA and they use a driver to connect to database.
Q. What is SQL*Plus? How can one acquire it and what kind of operations can be performed with it?
- SQL*Plus is a command line tool developed by Oracle Corporation.
- It is freely distributed. It is shipped with Oracle client installations or Oracle database installations as a default. So, if Oracle client or Oracle database software is installed on a computer, you can find it under “$ORACLE_HOME/bin/” directory. The name of the executable is “sqlplus” on Linux systems and “sqlplus.exe” on Microsoft Window Systems.
- You can connect to an Oracle database with it. Once connected, you can execute Oracle commands or SQL queries against the connected database. SQL*Plus has also its own commands for formatting the output so that you can display the results in a meat way.
Loading
