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 keyword is used to create an alias for a table or a column in Oracle? AS ALIAS NAME RENAME2. In Oracle, what does the term "DDL" stand for? Data Definition Language Data Description Language Database Definition Language Database Description Language3. Which SQL operator is used for pattern matching in Oracle? LIKE IN BETWEEN EXISTS4. Which function is used to convert a character string to uppercase in Oracle? UPPER LOWER INITCAP UCASE5. 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 condition6. Which Oracle command is used to commit the current transaction? ROLLBACK SAVEPOINT COMMIT BEGIN TRANSACTION7. 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 point8. Which SQL function is used to find the average value in a column in Oracle? AVG SUM MIN MAX9. 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 set10. 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 string11. Which SQL function is used to find the highest value in a column in Oracle? SUM MIN AVG MAX12. 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 condition13. Which function is used to find the total number of rows in a table in Oracle? COUNT SUM AVG MAX14. What is the default sorting order in an ORDER BY clause in Oracle? Descending Ascending Random Alphabetical15. What does SQL stand for? Structured Language Standard Query Language System Query Language Sequential Query Language16. Which function is used to find the minimum value in a column in Oracle? MIN AVG MAX SUM17. In Oracle, which operator is used to combine the result sets of two or more SELECT statements? UNION JOIN CONCAT MERGE18. Which clause is used to sort the result set in descending order in Oracle? DESC ORDER DESC SORT DESC DESCENDING19. 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 savepoint20. Which statement is used to grant privileges to a user in Oracle? ALLOW GRANT GIVE PERMISSION5 out of 4Time is Up!
