QUESTION 29
Which type of INSERT statement allows inserting rows into multiple tables using a single SELECT query?

QUESTION 30
What is the result of the following query?
SELECT employee_id
FROM employees
WHERE EXISTS (SELECT 1 FROM departments WHERE department_id = 10);

QUESTION 31
What is the purpose of using external tables in Oracle Database?

QUESTION 32
What does the UNION ALL operation do when selecting matching columns from different tables?
SELECT employee_id, salary FROM employees
UNION ALL
SELECT employee_id, bonus FROM bonuses;

QUESTION 33
What is a subquery in SQL?

QUESTION 34
Which SQL JOIN keyword retrieves all rows from both tables, including those without matches?

QUESTION 35
Which SET operator returns rows from the first query that are not present in the second query?

QUESTION 36
Which clause is used to ensure that only specific rows are deleted in a DELETE statement?

QUESTION 37
The column data type is converted to a primary key.

QUESTION 38
Which function returns the current system date and time in the database session’s time zone?

QUESTION 39
Which of the following statements creates an ascending sequence starting at 100 and incrementing by 10?

QUESTION 40
What does the INTERSECT operator do in SQL?

QUESTION 41
What happens when the TRUNCATE TABLE statement is executed?

QUESTION 42
What does the following command do?
GRANT CREATE SESSION TO user_name;

QUESTION 43
Which type of join includes rows that do not have matching values in the joined table?

QUESTION 44
Which SQLPlus command displays defined substitution variable values?

QUESTION 45
What is the purpose of the MERGE statement in SQL?

QUESTION 46
What is the result of the following SQL query?
SELECT COALESCE(NULL, 100, 200) AS result FROM dual;