Podcast
Questions and Answers
What is the primary difference between the TRUNCATE and DELETE commands in SQL?
What is the primary difference between the TRUNCATE and DELETE commands in SQL?
- TRUNCATE is faster and does not log transactions, while DELETE is slower and logs transactions. (correct)
- TRUNCATE is used for temporary tables, while DELETE is used for permanent tables.
- TRUNCATE is used for DML operations, while DELETE is used for DDL operations.
- TRUNCATE is used for inserting data, while DELETE is used for updating data.
What is the purpose of the ROWID pseudo column in SQL?
What is the purpose of the ROWID pseudo column in SQL?
- To retrieve the highest salary of an employee.
- To retrieve the row number of a table.
- To retrieve the average salary of a department.
- To retrieve the unique identifier of a row. (correct)
What is the effect of the DENSE_RANK() function in SQL?
What is the effect of the DENSE_RANK() function in SQL?
- It assigns a null rank to each row.
- It assigns a random rank to each row.
- It assigns a unique rank to each row without gaps. (correct)
- It assigns a rank to each row with gaps.
What is the purpose of the CASE statement in the UPDATE command?
What is the purpose of the CASE statement in the UPDATE command?
What is the purpose of the correlated subquery in the SELECT command?
What is the purpose of the correlated subquery in the SELECT command?
What is the purpose of the CURRVAL pseudo column in SQL?
What is the purpose of the CURRVAL pseudo column in SQL?
What is the primary purpose of a global temporary table?
What is the primary purpose of a global temporary table?
What is the effect of using the ON COMMIT DELETE ROWS clause in a global temporary table?
What is the effect of using the ON COMMIT DELETE ROWS clause in a global temporary table?
What is the minimum privilege required to execute the MERGE statement?
What is the minimum privilege required to execute the MERGE statement?
What is the purpose of the MERGE statement?
What is the purpose of the MERGE statement?
What type of index is suitable for data with a high degree of repetition?
What type of index is suitable for data with a high degree of repetition?
What is the syntax to create a global temporary table?
What is the syntax to create a global temporary table?
What is the function of the REGEXP_REPLACE function in the given SQL query?
What is the function of the REGEXP_REPLACE function in the given SQL query?
What is the purpose of the dual table in Oracle?
What is the purpose of the dual table in Oracle?
What is the purpose of the REGEXP_LIKE function in the given SQL query?
What is the purpose of the REGEXP_LIKE function in the given SQL query?
What is the main difference between an inner join and an outer join?
What is the main difference between an inner join and an outer join?
What is the purpose of the TRANSLATE function in the given SQL query?
What is the purpose of the TRANSLATE function in the given SQL query?
What is an equi join, also known as an equality join?
What is an equi join, also known as an equality join?
Flashcards are hidden until you start studying
