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. Explain how the SPOOL command is used and what program it can be used in.






2. If a graphical representation of a table's box has __________ it means that the relationship is identifying.






3. Queries that are found in parentheses are done first - just as in the order of operations when doing...






4. When disabling a unique or primary key - you can keep the index if you specify the __________________ clause in the ALTER TABLE statement.






5. 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.






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






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






8. Explain what is found in the All Objects report folder in SQL Developer






9. Self-joins are useful for performing comparisons and checking for ___________ in data.






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






11. The COUNT function uses the __________ wildcard.






12. NUMBER functions can be...






13. The COUNT function is useful for determining whether a table has...






14. The ______ depicts the M of a 1:M relationship.

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


15. When you INSERT new information into a table - it is followed with a _______ keyword that contains the information that is going to be added to the table.






16. Which one of the following string functions tells you how many characters are in a string?






17. Write a statement that drops the index need_to_pass_i






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






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






20. The time zone displacement value indicates the time difference from _______.






21. What do views do that makes them so useful for security?






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






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






24. The ROWID pseudocolumn is not an ________- but it acts like one.






25. List the different types of data dictionary views.






26. Explain the steps needed to run a script in SQL Developer






27. When you want to run a script in either SQL*Plus or SQL Developer - you can use a ______ or the _________ command.






28. List the reasons that a subquery could not be unnested.






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






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






31. The _______ operator determines common rows.






32. When is it not a good idea to use an index?






33. Another name for a data dictionary view is __________________ or _________________.






34. Write the syntax to rename index just_two_more_weeks_i to finally_i






35. A _____ is a query definition stored in the database that looks just like a table - but does not have any physical rows






36. Returns rows if the condition is true for all the values in the list






37. The data type definitions NUMBER(10) and NUMBER(10 -0) are the...






38. A calculation with a null always yields...






39. The using clause of the ANSI join syntax always assumes an...






40. The ____________ keywords and the USING clause of the ANSI join syntax are mutually exclusive.






41. When using the data NUMBER(10 -4) there will be _______ digits following the decimal point.






42. What is the first column of a composite index called?






43. You use the __________ keyword to change characteristics of a column.






44. The ____________ command makes changes permanent.






45. What is the data type you can use if you need an unlimited number of textual characters?






46. When you run a script in SQL*Plus you must give the...






47. Explain how you can optimize your queries with subqueries and the main advantage of doing so.






48. When writing an ANSI outer join - the keywords _________ OUTER and _________ OUTER are added to the __________ keyword to indicate the rows from which table to use.






49. 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


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