Test your basic knowledge |

Oracle SQL

Subjects : oracle, it-skills
Instructions:
  • Answer 50 questions in 15 minutes.
  • If you are not ready to take this test, you can study here.
  • Match each statement with the correct term.
  • Don't refresh. All questions and answers are randomly picked and ordered every time you load a test.

This is a study tool. The 3 wrong answers for each question are randomly chosen from answers to other questions. So, you might find at times the answers obvious, but you will see it re-enforces your understanding as you take the test each time.
1. Queries that are found in parentheses are done first - just as in the order of operations when doing...






2. What is the maximum value for a column defined as NUMBER(4 -2)?






3. Write a statement for SQL*Plus that shows the dictionary.






4. The Nonequijoin can use the ________________ operator to construct joins that are not based on equality of values.






5. What is the syntax used to indicate that you are using the Oracle Outer Join operator?






6. List 4 aggregate functions






7. To revert back to a state that happened before you ran your change statement - you issue a ____________ command.






8. When returning multiple rows - a subquery must contain the _____ - _____ - _____ - or ______ operator - otherwise Oracle will return an error






9. UNION ALL does not sort - therefore it is less time consuming to use than the...






10. Write an SQL statement for SQL *Plus in which you want any unique menu items to be displayed from the restaurant table






11. Explain how the SPOOL command is used and what program it can be used in.






12. __________________ inserts the current date and time.






13. Write a statement that drops the index need_to_pass_i






14. _________ and __________ functions are opposites of each other and provide a value in a group of rows.






15. What is the command you would type into SQL*Plus if you needed to know the definition for each column of a table?






16. Explain why constraints are used when building tables.

Warning: Invalid argument supplied for foreach() in /var/www/html/basicversity.com/show_quiz.php on line 183


17. Write the syntax to rename index just_two_more_weeks_i to finally_i






18. Checks whether any value in the list makes the condition true.






19. It is always good practice to include the old values in the WHERE clause of UPDATE to ensure that another session or user _________________ in the meantime.






20. Explain how Dynamic SQL is used and give an example of a Dynamic SQL statement.






21. Users can only see changes made to a database once they have been...






22. When you have issued a DELETE command - you can still ________ those rows and restore the information.






23. The __________ operator is inclusive of the two values specified.






24. When using the following data: NUMBER(10 -4) - the # 4 is called the __________.






25. List the different types of data dictionary views.






26. To equijoin a table with another table involves matching the...






27. Joins involving multiple columns must always follow the ____________ relationship path.






28. When column names on the tables are different - you use the ______ condition.






29. Oracle uses the outer join operator to indicate that nulls are shown for...






30. FEEDBACK






31. When using the following data: NUMBER(10 -4) - the lowest number you can possibly have is __________.






32. Explain what a static data dictionary view is and how it is used






33. You can __________ DISTINCT and a GROUP BY clause in the same SELECT statement.






34. Checks whether any value in the list makes the condition true.






35. To join four tables - you must have at least _____ join conditions.






36. The _______ function lets you perform if-then-else functionality with the SQL language.






37. LINESIZE






38. The key that most database designers prefer and is chosen by the system is the _____________ key.






39. What is the tab in SQL Developer where data dictionary view information can be found?






40. The ________________ is a type of statement whereby you retrieve data that exists in one table - but not in another.






41. The _____________ clause determines how rows are grouped.






42. The purpose of the HAVING clause is to eliminate___________.






43. The _______ function adds values together for a group of rows.






44. The same function can be used ______ in a SELECT statement.






45. The query retrieves more than 5 to 15 percent of the rows






46. What is the name of the key automatically generated from a sequence?






47. A _________ subquery returns a single column with a single row






48. Explain Flashback queries and how they are used. Give an example of a FLASHBACK_TRANSACTION query and explain what it does row by row.

Warning: Invalid argument supplied for foreach() in /var/www/html/basicversity.com/show_quiz.php on line 183


49. You can simplify the writing of SQL statements by writing SQL _________ that generate and execute other SQL statements.






50. Explain in detail the impact of INDEXES and how they are used by Oracle.