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. When using the following data: NUMBER(10 -4) - the # 4 is called the __________.






2. PAGESIZE






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






4. Instead of using the Oracle Outer Join Operator or the ANSI syntax - you can achieve the same result with two SQL statements: ____________ and a ____________






5. Which format mask displays December 31st - 1999?






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






7. The NEXTVAL and CURRVAL pseudocolumns can be used in which of the following SQL constructs? Select all that apply.






8. The TRUNC function on a date without a format model truncates the timestamp to...






9. Which operator is most commonly used?






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






11. SELECT LIST of a subquery in an INSERT statement






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






13. What is the most common DATE format found in SQL?






14. The ____________ command makes changes permanent.






15. The _______ operator determines common rows.






16. What is Oracle's most popular index storage structure?






17. SQL Developer provides an extensive list of useful reports and offers the capability to create your own...






18. You use the _________ keyword to add columns or constraints to a table.






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






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






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






22. What is the keyboard shortcut for the ROLLBACK command?






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






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






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






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






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






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






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






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






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






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






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






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






35. To restart a sequence at a lower number - you can drop and ________ the sequence.






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






37. Explain how Oracle treats locks when a database is being updated and needs to be viewed by other users.






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






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






40. When writing the syntax for finding information on three or more tables - the parenthesis around the ON clause is...






41. LINESIZE






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






43. ____________ are useful for analyzing and exploring the relationships within your data






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






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






46. The ______ operator compares a list of values for equivalency






47. You can use the ________________ to subtract months from a given date.






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






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






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