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 TIMESTAMP WITH LOCAL TIME ZONE data type allows...






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






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






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






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






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






7. The focus of the logical data model is _____________






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


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






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






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






12. Comparison operators can compare multiple _________________.






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






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






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






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






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






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






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






20. Explain in detail the impact of INDEXES and how they are used by Oracle.






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






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






23. A _____ is a query definition stored in the database that looks just like a table - but does not have any physical rows






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






25. The ____________ command makes changes permanent.






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






27. List the steps performed by a correlated subquery.






28. When you want to run a script in either SQL*Plus or SQL Developer - you can use a ______ or the _________ command.






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






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






31. List 6 Table-Related Menu Choices






32. The _____________ clause determines how rows are grouped.






33. Write the syntax to rename index just_two_more_weeks_i to finally_i






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






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






36. Another name for a data dictionary view is __________________ or _________________.






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






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






39. UNION ALL does not sort - therefore it is less time consuming to use than the...






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






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






42. NUMBER functions can be...






43. The _______ operator determines common rows.






44. __________________ inserts the current date and time.






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






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






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






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






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






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