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. The COUNT function is useful for determining whether a table has...






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






3. The TIMESTAMP WITH LOCAL TIME ZONE data type allows...






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






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






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






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






8. An outer join includes the result rows returned by an __________ plus extra rows where no matches are found.






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






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






11. When you create a report in SQL Developer all the column names must match identically the names of the columns found in the tables you are referencing.






12. PAGESIZE






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






14. Information that is returned after you run your statement are found in the __________ tab in SQL Developer.






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






16. How many characters can you have using the VARCHAR data type?






17. You can pass parameters from the operating system when ___________ in SQl*Plus






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






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






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






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






22. The ____________ icon allows you to execute multiple statements and emulates SQL *Plus as much as possible.






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






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






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






26. What is the Oracle data dictionary called that contains a set of tables and views containing the data about the database?






27. The _______ operator determines common rows.






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






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






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






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






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






33. Match each of the SQL commands on the left with a verb from the list.






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






35. To place a line comment in your SQL statements - you first place a // at the beginning of the line.






36. In SQL Developer field names and table names are shown in the color _______.






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






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






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






40. List 4 aggregate functions






41. NUMBER functions can be...






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






43. List the steps performed by a correlated subquery.






44. The ____________ command makes changes permanent.






45. It is considered good form to put all SQL commands in...






46. ___________ subqueries allow you to reference columns from the outer query and execute the inner query repeatedly






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






48. Explain the differences in how an ANSI Full Outer Join and a Full Outer Join using the UNION Operator work






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






50. The RTRIM function is useful for eliminating ________ in a string.