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 same function can be used ______ in a SELECT statement.






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






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






4. A transaction is a...






5. Write a solution that adds 20 minutes to a given date.






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






7. What is the syntax used to indicate that you are using the Oracle Outer Join operator?






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






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






10. The purpose of the HAVING clause is to eliminate___________.






11. Users can only see changes made to a database once they have been...






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






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






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






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


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






17. Comparison operators can compare multiple _________________.






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


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






20. The COUNT function uses the __________ wildcard.






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






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






23. List the steps performed by a correlated subquery.






24. The query retrieves more than 5 to 15 percent of the rows






25. List 4 aggregate functions






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






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






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






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






30. The ___________ operator tests whether a matching row cannot be found.






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






32. A join across three tables can be expressed with the ________ join syntax.






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






34. Explain how Substitution Variables are used when writing scripts.






35. In a view you can give a column a different name than it has in the...






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






37. Write a statement that drops the index need_to_pass_i






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






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






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






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






42. _________ and __________ functions are opposites of each other and provide a value in a group of rows.






43. Dynamic views begin with a ___________.






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






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






46. PAGESIZE






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






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






49. __________________ inserts the current date and time.






50. The focus of the logical data model is _____________