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 function is used to find the total number of rows in a table in Oracle? COUNT SUM AVG MAX2. What does SQL stand for? Structured Language Standard Query Language System Query Language Sequential Query Language3. What is the default sorting order in an ORDER BY clause in Oracle? Descending Ascending Random Alphabetical4. 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 set5. In Oracle, which operator is used to combine the result sets of two or more SELECT statements? UNION JOIN CONCAT MERGE6. Which clause is used to sort the result set in descending order in Oracle? DESC ORDER DESC SORT DESC DESCENDING7. Which data type is used to store variable-length character strings in Oracle? CHAR VARCHAR CLOB BLOB8. Which Oracle command is used to commit the current transaction? ROLLBACK SAVEPOINT COMMIT BEGIN TRANSACTION9. Which SQL function is used to find the highest value in a column in Oracle? SUM MIN AVG MAX10. 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 subquery11. Which keyword is used to create an alias for a table or a column in Oracle? AS ALIAS NAME RENAME12. 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 table13. Which statement is used to update data in a table in Oracle? CHANGE MODIFY UPDATE ALTER14. Which SQL function is used to find the average value in a column in Oracle? AVG SUM MIN MAX15. 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 point16. What is the purpose of the CASE statement in Oracle? To define a loop in PL/SQL To handle exceptions To create a virtual column To perform conditional logic in a query17. 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 tables18. Which statement is used to remove a table from the database in Oracle? REMOVE TABLE DELETE TABLE DROP TABLE ERASE TABLE19. Which statement is used to delete data from a table in Oracle? DELETE REMOVE DROP TRUNCATE20. 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 out of 4Time is Up!
