Welcome to CHOOLS ORACLE ASSESSMENT (YOU HAVE ONLY 30 MINUTES TO COMPLETE THIS PART [20 Questions]) **** Wishing You All The Best **** Instructions : To start the quiz, please provide your name, email id and phone number. All questions are mandatory* Answering each question is required before going on to the next page of questions. Your response is subject to change at any time. After completed the quiz click the submit button. If, once the time is up, it will be automatically submitted. The report will be mailed to your email address after the quiz is finished. 1. What is the purpose of the OUTER JOIN in Oracle? To exclude rows that do not meet the condition To include only rows that meet the condition To include all rows from both tables, even if there is no match To filter rows based on a condition2. Which statement is used to delete data from a table in Oracle? DELETE REMOVE DROP TRUNCATE3. Which data type is used to store variable-length character strings in Oracle? CHAR VARCHAR CLOB BLOB4. Which Oracle command is used to commit the current transaction? ROLLBACK SAVEPOINT COMMIT BEGIN TRANSACTION5. Which function is used to find the total number of rows in a table in Oracle? COUNT SUM AVG MAX6. Which SQL function is used to find the average value in a column in Oracle? AVG SUM MIN MAX7. What is the purpose of the HAVING clause in Oracle? To filter rows in a query To filter columns in a query To filter groups in a query To filter results based on a condition8. Which function is used to convert a character string to uppercase in Oracle? UPPER LOWER INITCAP UCASE9. Which function is used to find the minimum value in a column in Oracle? MIN AVG MAX SUM10. What is the purpose of the UNION ALL operator in Oracle? To combine the result sets of two or more SELECT statements To join tables based on a condition To filter rows in a query To exclude duplicate rows from the result set11. What is the purpose of the EXISTS operator in Oracle? To check if a table exists in the database To check if a column exists in a table To check if a value exists in a column To check if a subquery returns any rows12. What does DML stand for in the context of Oracle? Data Manipulation Language Database Modification Language Data Modeling Language Database Management Language13. In Oracle, what is the purpose of the SAVEPOINT statement? To undo changes made by the current transaction To create a checkpoint within a transaction To commit the current transaction To create a subquery14. In Oracle, what is a foreign key used for? To enforce uniqueness in a column To establish relationships between tables To provide a default value for a column To sort the result set15. What does SQL stand for? Structured Language Standard Query Language System Query Language Sequential Query Language16. Which statement is used to add a new column to an existing table in Oracle? ADD COLUMN CREATE COLUMN ALTER TABLE ADD COLUMN INSERT COLUMN17. Which SQL operator is used for pattern matching in Oracle? LIKE IN BETWEEN EXISTS18. What is the purpose of the WHERE clause in a SQL query? To specify the order of the result set To filter the rows returned by a query To join tables To group rows based on a column19. In Oracle, what is a primary key used for? To enforce uniqueness in a column To establish relationships between tables To provide a default value for a column To sort the result set20. In Oracle, what does the acronym PL/SQL stand for? Procedural Language/Structured Query Language Programming Language/Standard Query Language Procedure Language/Structured Question Language Procedural Logic/Structured Query Language5 out of 4Time is Up!