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 ____________ clause on a CREATE TABLE statement can specify how much space to allocate.






2. The COUNT function uses the __________ wildcard.






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






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






5. The _______ operator determines common rows.






6. LINESIZE






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






8. The focus of the logical data model is _____________






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






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






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






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






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






14. Subqueries can return...






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






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






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






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






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






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






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






22. The _____________ clause determines how rows are grouped.






23. _________ rows are not allowed in the relational model.






24. Dynamic views begin with a ___________.






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






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






27. Write a statement that drops the index need_to_pass_i






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






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






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






31. The ____________ command makes changes permanent.






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






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






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






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






36. List 4 aggregate functions






37. What does SQL stand for?






38. Comparison operators can compare multiple _________________.






39. SELECT * FROM instructor ORDER BY phone






40. List the steps performed by a correlated subquery.






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






42. SELECT LIST of a subquery in an INSERT statement






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






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






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






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






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






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






49. What are the main components of a ROWID?






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