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. SELECT * FROM instructor ORDER BY phone






2. When using the following data: NUMBER(10 -4) - the lowest number you can possibly have is __________.






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






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






5. You can simplify the writing of SQL statements by writing SQL _________ that generate and execute other SQL statements.






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






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






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






9. _________________ relationships are always optional relationships.






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






11. Explain why constraints are used when building tables.

Warning: Invalid argument supplied for foreach() in /var/www/html/basicversity.com/show_quiz.php on line 183


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






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






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






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






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






17. The focus of the logical data model is _____________






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






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






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






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






22. The _______ operator determines common rows.






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






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






25. Explain what a static data dictionary view is and how it is used






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






27. When writing the syntax for finding information on three or more tables - the parenthesis around the ON clause is...






28. The query retrieves more than 5 to 15 percent of the rows






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. What is the name of the key automatically generated from a sequence?






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






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






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






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






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






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






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






38. Explain how Substitution Variables are used when writing scripts.






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






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






41. SELECT LIST of a subquery in an INSERT statement






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


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






44. List the different types of data dictionary views.






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






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






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






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






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






50. __________________ inserts the current date and time.