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 the most common DATE format found in SQL?






2. The same function can be used ______ in a SELECT statement.






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






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






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






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






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






8. SELECT * FROM instructor ORDER BY phone






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






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






11. The focus of the logical data model is _____________






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






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






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






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






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






17. Dynamic views begin with a ___________.






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






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






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






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






22. Write the syntax to rename index just_two_more_weeks_i to finally_i






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






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






25. Joins involving multiple columns must always follow the ____________ relationship path.






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


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






28. The ROWID pseudocolumn is not an ________- but it acts like one.






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






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






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






32. You can pass parameters from the operating system when ___________ in SQl*Plus






33. When you create a report in SQL Developer all the column names must match identically the names of the columns found in the tables you are referencing.






34. SELECT LIST of a subquery in an INSERT statement






35. How many characters can you have using the VARCHAR data type?






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






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






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






39. List 4 aggregate functions






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






41. What are the main components of a ROWID?






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






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






44. To place a line comment in your SQL statements - you first place a // at the beginning of the line.






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






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






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






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


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






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