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 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 query2. 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 column3. Which function is used to find the total number of rows in a table in Oracle? COUNT SUM AVG MAX4. 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 rows5. 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. 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 column7. 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 tables8. Which SQL operator is used for pattern matching in Oracle? LIKE IN BETWEEN EXISTS9. Which data type is used to store variable-length character strings in Oracle? CHAR VARCHAR CLOB BLOB10. 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 condition11. Which function is used to convert a character string to uppercase in Oracle? UPPER LOWER INITCAP UCASE12. Which SQL function is used to find the highest value in a column in Oracle? SUM MIN AVG MAX13. In Oracle, what is a foreign 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. Which keyword is used to create an alias for a table or a column in Oracle? AS ALIAS NAME RENAME15. Which statement is used to remove a table from the database in Oracle? REMOVE TABLE DELETE TABLE DROP TABLE ERASE TABLE16. In Oracle, which operator is used to combine the result sets of two or more SELECT statements? UNION JOIN CONCAT MERGE17. Which statement is used to grant privileges to a user in Oracle? ALLOW GRANT GIVE PERMISSION18. What does DML stand for in the context of Oracle? Data Manipulation Language Database Modification Language Data Modeling Language Database Management Language19. In Oracle, what does the term "DDL" stand for? Data Definition Language Data Description Language Database Definition Language Database Description Language20. Which statement is used to add a new column to an existing table in Oracle? ADD COLUMN CREATE COLUMN ALTER TABLE ADD COLUMN INSERT COLUMN5 out of 4Time is Up!