Join the discussion
Question 5/37
Which of the following SET operators combines results from two queries and removes duplicates?
Correct Answer: C
Add Comments
- Other Question (37q)
- Q1. Which command would drop an index from a table?...
- Q2. Which command creates a new role in Oracle Database?...
- Q3. Which SQL clause can be used in Oracle to limit the number of rows returned?...
- Q4. Which clause in a SQL SELECT statement is used to define the columns to be retrieved?...
- Q5. Which of the following SET operators combines results from two queries and removes duplica...
- Q6. Which command is used to add a new column to an existing table?...
- Q7. Which type of join returns all rows from the left table, even if there are no matches in t...
- Q8. Which of the following data dictionary views provides information about constraints on tab...
- Q9. What does the following query return? SELECT employee_id FROM employees WHERE department_i...
- Q10. What will the following query return? SELECT TO_CHAR(SYSDATE, 'DD-MM-YYYY') AS formatted_d...
- Q11. What does the following command do? GRANT CREATE SESSION TO user_name;...
- Q12. What will the following query do? DELETE FROM employees WHERE department_id = 20;...
- Q13. What does the following SQL statement do? CREATE TABLE employees ( employee_id NUMBER PRIM...
- Q14. What is the primary purpose of granting privileges in Oracle Database?...
- Q15. Which type of subquery returns exactly one value?...
- Q16. How can a synonym benefit database design?
- Q17. What will the following query result in? SELECT e.employee_id, e.manager_id FROM employees...
- Q18. How is the LOCALTIMESTAMP function different from CURRENT_TIMESTAMP?...
- Q19. Which of the following can be achieved using a correlated subquery?...
- Q20. What does the following query return? SELECT ROUND(123.456, 1) AS rounded_value FROM dual;...
- Q21. What does the COMMIT statement do in SQL?
- Q22. What will the following query do? SELECT employee_id, salary FROM employees WHERE salary &...
- Q23. Which of the following statements is true about constraints in Oracle Database?...
- Q24. In a relational database, what is a foreign key?...
- Q25. What is the primary purpose of a primary key in a relational database?...
- Q26. What does the following SQL query do? SELECT * FROM employees WHERE salary > 5000 ORDER...
- Q27. Which type of join includes rows that do not have matching values in the joined table?...
- Q28. The column data type is converted to a primary key....
- Q29. What will the following SQL query return? SELECT TRUNC(15.678, 2) AS truncated_value FROM ...
- Q30. Which function is used to extract the year from a date in SQL?...
- Q31. Which type of join retrieves only the rows with matching values in both tables?...
- Q32. What is the relationship between SQL and a relational database?...
- Q33. What is a role in Oracle Database?
- Q34. Which data dictionary view provides information about all tables accessible to the current...
- Q35. How does SQL handle NULL values in arithmetic expressions?...
- Q36. How can you ensure that data is sorted in descending order in a SQL query?...
- Q37. What happens when the maximum value of a sequence is reached?...
