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 # 10 is called the __________.






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






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






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






5. All SQL statements contained within a script must end with a _______________ - even if they are done in SQL Developer.






6. FEEDBACK






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






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






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






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






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






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






13. The COUNT function uses the __________ wildcard.






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






15. PAGESIZE






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






17. Converting a text literal to DATE format requires the use of the...






18. SELECT LIST of a subquery in an INSERT statement






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






20. The focus of the logical data model is _____________






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






22. The _______ operator determines common rows.






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






24. Which operator is most commonly used?






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






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






27. The _____________ clause determines how rows are grouped.






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






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






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






31. List 4 aggregate functions






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






33. List the different types of data dictionary views.






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






35. What are the main components of a ROWID?






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






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






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






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






40. NUMBER functions can be...






41. SQL Developer's ____________________ option allows you to selectively export certain rows and columns.






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






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






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






45. __________________ inserts the current date and time.






46. What does the following function return? SELECT LENGTH(NULL) - FROM dual






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






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






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






50. What is the name of the view where you can find the collection of static and data dictionary tables and views - along with their descriptions?