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. Users can only see changes made to a database once they have been...






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






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






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






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






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






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






8. Subqueries can return...






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






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






11. Which format mask displays December 31st - 1999?






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






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






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






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






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






17. NUMBER functions can be...






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






19. List the steps performed by a correlated subquery.






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






21. Which operator is most commonly used?






22. What does SQL stand for?






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






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






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






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






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






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






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






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






31. Write a statement that drops the index need_to_pass_i






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






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






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


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






36. The TIMESTAMP WITH LOCAL TIME ZONE data type allows...






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






38. The COUNT function uses the __________ wildcard.






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






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






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






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






43. List the different types of data dictionary views.






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






45. SELECT * FROM instructor ORDER BY phone






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






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






48. What is the command you would type into SQL*Plus if you needed to know the definition for each column of a table?






49. You use the __________ keyword to change characteristics of a column.






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