Oracle Nihileswaran No Comment 10Feb Share 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 INDEX in Oracle? To define a unique constraint To enforce referential integrity To improve query performance To create a virtual column2. Which clause is used to sort the result set in descending order in Oracle? DESC ORDER DESC SORT DESC DESCENDING3. 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 subquery4. 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 set5. Which data type is used to store variable-length character strings in Oracle? CHAR VARCHAR CLOB BLOB6. 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 savepoint7. Which SQL operator is used for pattern matching in Oracle? LIKE IN BETWEEN EXISTS8. 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 condition9. 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 point10. Which function is used to find the minimum value in a column in Oracle? MIN AVG MAX SUM11. Which statement is used to remove a table from the database in Oracle? REMOVE TABLE DELETE TABLE DROP TABLE ERASE TABLE12. Which SQL function is used to find the highest value in a column in Oracle? SUM MIN AVG MAX13. 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. 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 query15. Which statement is used to delete data from a table in Oracle? DELETE REMOVE DROP TRUNCATE16. 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. Which Oracle command is used to commit the current transaction? ROLLBACK SAVEPOINT COMMIT BEGIN TRANSACTION18. 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 set19. What does DML stand for in the context of Oracle? Data Manipulation Language Database Modification Language Data Modeling Language Database Management Language20. 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 string5 out of 4Time is Up! Previous Postgre SQL February 10, 2024 Next Bootstrap February 10, 2024 You Might Also Like Hello world CHOOLS No Comment How to Disable Avast Antivirus CHOOLS No Comment AVG Review — Is the Absolutely free Version As effective as the Premium Version? CHOOLS No Comment Understanding the Limitations of Models of Managing CHOOLS No Comment Careers Similar To Teaching CHOOLS No Comment