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. Checks whether any value in the list makes the condition true.






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






3. Write a statement that drops the index need_to_pass_i






4. What does SQL stand for?






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






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






7. __________________ inserts the current date and time.






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






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






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






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






12. List 6 Table-Related Menu Choices






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






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






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






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






17. Explain why constraints are used when building tables.

Warning: Invalid argument supplied for foreach() in /var/www/html/basicversity.com/show_quiz.php on line 183


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






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






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






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






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






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






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






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






26. List 4 aggregate functions






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






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






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






30. SQL*Plus is used more than SQL Developer when you need to...






31. Dynamic views begin with a ___________.






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






33. SELECT LIST of a subquery in an INSERT statement






34. _________________ relationships are always optional relationships.






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






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






37. 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?






38. Explicit data type conversion is preferable to Oracle's...






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






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






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






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






43. Which operator is most commonly used?






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






45. What is the main difference between the NOT EXISTS and the NOT IN operators?






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






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






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






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






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