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. Which data type is used to store variable-length character strings in Oracle? CHAR VARCHAR CLOB BLOB2. Which SQL operator is used for pattern matching in Oracle? LIKE IN BETWEEN EXISTS3. Which statement is used to update data in a table in Oracle? CHANGE MODIFY UPDATE ALTER4. 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 savepoint5. 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 tables6. In Oracle, which operator is used to combine the result sets of two or more SELECT statements? UNION JOIN CONCAT MERGE7. 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 Language8. 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 table9. 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 set10. 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 key11. 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 condition12. Which statement is used to remove a table from the database in Oracle? REMOVE TABLE DELETE TABLE DROP TABLE ERASE TABLE13. 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 set14. In Oracle, what does the term "DDL" stand for? Data Definition Language Data Description Language Database Definition Language Database Description Language15. 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 tables16. 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. 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 rows18. Which keyword is used to create an alias for a table or a column in Oracle? AS ALIAS NAME RENAME19. 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 string20. 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 subquery5 out of 4Time is Up!
