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. What does DML stand for in the context of Oracle? Data Manipulation Language Database Modification Language Data Modeling Language Database Management Language3. Which Oracle command is used to commit the current transaction? ROLLBACK SAVEPOINT COMMIT BEGIN TRANSACTION4. What is the purpose of the ORDER BY clause in Oracle? To filter rows in a query To sort the result set To group rows based on a column To join tables5. In Oracle, what is the purpose of the COMMIT statement? To undo changes made by the current transaction To permanently delete data from a table To commit the current transaction To create a savepoint6. Which statement is used to grant privileges to a user in Oracle? ALLOW GRANT GIVE PERMISSION7. What does SQL stand for? Structured Language Standard Query Language System Query Language Sequential Query Language8. What is the purpose of the ROWID in Oracle? To uniquely identify a row in a table To store the row count in a table To specify the order of the result set To create a primary key9. Which function is used to find the total number of rows in a table in Oracle? COUNT SUM AVG MAX10. Which function is used to convert a character string to uppercase in Oracle? UPPER LOWER INITCAP UCASE11. What is the purpose of the TRUNCATE statement in Oracle? To delete all rows from a table To remove a table from the database To empty a table without logging individual row deletions To drop a column from a table12. Which keyword is used to create an alias for a table or a column in Oracle? AS ALIAS NAME RENAME13. Which statement is used to update data in a table in Oracle? CHANGE MODIFY UPDATE ALTER14. 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 Language15. Which clause is used to sort the result set in descending order in Oracle? DESC ORDER DESC SORT DESC DESCENDING16. What is the purpose of the GROUP BY clause in Oracle? To filter rows in a query To sort the result set To group rows based on a column To join tables17. What is the purpose of the ROLLBACK statement in Oracle? To undo changes made by the current transaction To permanently delete data from a table To commit the current transaction To create a save point18. What is the purpose of the NVL function in Oracle? To convert a value to uppercase To replace NULL with a specified value To concatenate two strings To find the length of a string19. Which data type is used to store variable-length character strings in Oracle? CHAR VARCHAR CLOB BLOB20. In Oracle, which operator is used to combine the result sets of two or more SELECT statements? UNION JOIN CONCAT MERGE5 out of 4Time is Up!