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. 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 savepoint2. Which SQL function is used to find the highest value in a column in Oracle? SUM MIN AVG MAX3. Which clause is used to sort the result set in descending order in Oracle? DESC ORDER DESC SORT DESC DESCENDING4. 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 table5. What is the purpose of the CONSTRAINT keyword in Oracle? To specify a default value for a column To enforce referential integrity To create a virtual column To filter rows in a query6. 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 string7. In Oracle, what is the purpose of the SELECT statement? To update records To retrieve data To delete records To insert records8. In Oracle, which operator is used to combine the result sets of two or more SELECT statements? UNION JOIN CONCAT MERGE9. Which SQL function is used to find the average value in a column in Oracle? AVG SUM MIN MAX10. Which function is used to convert a character string to uppercase in Oracle? UPPER LOWER INITCAP UCASE11. Which statement is used to grant privileges to a user in Oracle? ALLOW GRANT GIVE PERMISSION12. Which keyword is used to create an alias for a table or a column in Oracle? AS ALIAS NAME RENAME13. What is the purpose of the INDEX in Oracle? To define a unique constraint To enforce referential integrity To improve query performance To create a virtual column14. 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 key15. Which statement is used to add a new column to an existing table in Oracle? ADD COLUMN CREATE COLUMN ALTER TABLE ADD COLUMN INSERT COLUMN16. 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 column17. Which Oracle command is used to commit the current transaction? ROLLBACK SAVEPOINT COMMIT BEGIN TRANSACTION18. Which statement is used to remove a table from the database in Oracle? REMOVE TABLE DELETE TABLE DROP TABLE ERASE TABLE19. 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 query20. 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 condition5 out of 4Time is Up!
