ORACLE DATABASE INTERVIEW QUESTIONS

What is a row in an Oracle database table?

What is a column in an Oracle database table?

How do you insert a new row into an Oracle table?

How do you update an existing row in an Oracle table?

How do you delete a row from an Oracle table?

What is the purpose of the SELECT statement in Oracle?

How do you use the ROWNUM pseudocolumn in Oracle?

Explain the use of the ROW_NUMBER() analytic function in Oracle?

What is a virtual column in Oracle, and how do you create one?

How do you use the MERGE statement in Oracle to update and insert rows in a table?