Oracle SQL Interview Questions Quiz (Multiple Choice)

Which SQL command is used to remove all records from a table without removing the table structure?

What type of SQL join returns only matching records from both tables?

Which function is used to get the current date in Oracle SQL?

Which constraint ensures that a column does not have duplicate values?

Which SQL clause is used to filter records in a SELECT query?

Which SQL keyword is used to retrieve only unique values from a column?

Which operator is used for pattern matching in SQL?

Which SQL function is used to count the number of rows in a table?

Which SQL clause is used to filter records based on aggregate functions?

Which SQL command is used to give a user specific privileges?

What is the difference between UNION and UNION ALL?

Which index type is best suited for high-cardinality columns?

What does the ROWNUM pseudocolumn do in Oracle SQL?

Which SQL hint is used to force an index scan?

What is the purpose of the COALESCE function?

Which SQL statement is used to add a new column to an existing table?

How do you retrieve the second highest salary from an employee table?

What is the difference between a primary key and a unique key?

Which clause is used to return records where a column is NULL?

How can you improve performance of a SQL query?