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. Another name for a data dictionary view is __________________ or _________________.






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






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






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






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






6. _________ and __________ functions are opposites of each other and provide a value in a group of rows.






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






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






9. Comparison operators can compare multiple _________________.






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






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






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






13. The focus of the logical data model is _____________






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






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






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






17. What are the main components of a ROWID?






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






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






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






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






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






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






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






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






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






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






28. List 6 Table-Related Menu Choices






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






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






31. PAGESIZE






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






33. Subqueries can return...






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






35. Explain how Dynamic SQL is used and give an example of a Dynamic SQL statement.






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






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






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






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






40. A transaction is a...






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






42. _________ rows are not allowed in the relational model.






43. Self-joins are useful for performing comparisons and checking for ___________ in data.






44. A join across three tables can be expressed with the ________ join syntax.






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






46. Write a solution that adds 20 minutes to a given date.






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






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






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






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