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. Write a statement that drops the index need_to_pass_i






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






3. It is always good practice to include the old values in the WHERE clause of UPDATE to ensure that another session or user _________________ in the meantime.






4. List 6 Table-Related Menu Choices






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






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






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


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






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






10. The _______ operator determines common rows.






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






12. If a graphical representation of a table's box has __________ it means that the relationship is identifying.






13. What is the Oracle data dictionary called that contains a set of tables and views containing the data about the database?






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






15. Information that is returned after you run your statement are found in the __________ tab in SQL Developer.






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






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






18. How many characters can be stored in the CHAR column/field?






19. FEEDBACK






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






21. The focus of the logical data model is _____________






22. When you have issued a DELETE command - you can still ________ those rows and restore the information.






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






24. The ________ operator cannot compare against a list of values.






25. List the steps performed by a correlated subquery.






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






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






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






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






30. The ____________ command makes changes permanent.






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






32. List the different types of data dictionary views.






33. NUMBER functions can be...






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






35. The Nonequijoin can use the ________________ operator to construct joins that are not based on equality of values.






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






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






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






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






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






41. The _______ function lets you perform if-then-else functionality with the SQL language.






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






43. LINESIZE






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






45. When you run a script in SQL*Plus you must give the...






46. What does SQL stand for?






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






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






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






50. What are the main components of a ROWID?