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. List the reasons that a subquery could not be unnested.






2. Write the syntax to rename index just_two_more_weeks_i to finally_i






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






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






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






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






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






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






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






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






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






12. The DUAL table can be used for...






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






14. What is the most common DATE format found in SQL?






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






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






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






18. Subqueries can return...






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






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






21. List 6 Table-Related Menu Choices






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






23. NUMBER functions can be...






24. SELECT LIST of a subquery in an INSERT statement






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






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


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






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






29. The term ____________ ___________ is used to express a join that satisfies the join condition.






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






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






32. What are the main components of a ROWID?






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






34. What does SQL stand for?






35. SELECT * FROM instructor ORDER BY phone






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






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






38. To equijoin a table with another table involves matching the...






39. Which operator is most commonly used?






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






41. The ALTER SESSION statement can change the session's...






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






43. The _____________ clause determines how rows are grouped.






44. Returns rows if the condition is true for all the values in the list






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






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






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






48. A transaction is a...






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






50. __________________ inserts the current date and time.