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. What is Oracle's most popular index storage structure?






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






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






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






5. Which one of the following string functions tells you how many characters are in a string?






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






7. List 4 aggregate functions






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






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






10. The ____________ command makes changes permanent.






11. What does SQL stand for?






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






13. PAGESIZE






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






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






16. Explain how Dynamic SQL is used and give an example of a Dynamic SQL statement.






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






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






19. Subqueries can return...






20. _________________ relationships are always optional relationships.






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






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






23. What are the main components of a ROWID?






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






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






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






27. List the steps performed by a correlated subquery.






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






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






30. LINESIZE






31. The focus of the logical data model is _____________






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






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


34. Self-joins are useful for performing comparisons and checking for ___________ in data.






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






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






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






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






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






40. Write the syntax to rename index just_two_more_weeks_i to finally_i






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






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






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






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






45. Write a statement that drops the index need_to_pass_i






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






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






48. NUMBER functions can be...






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






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