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. You can simplify the writing of SQL statements by writing SQL _________ that generate and execute other SQL statements.






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






17. LINESIZE






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






19. NUMBER functions can be...






20. The COUNT function uses the __________ wildcard.






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


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






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






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


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






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






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






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






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






30. The focus of the logical data model is _____________






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






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






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






34. Subqueries can return...






35. _________________ relationships are always optional relationships.






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






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






38. What is Oracle's most popular index storage structure?






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






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






41. Which operator is most commonly used?






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






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






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






45. List 4 aggregate functions






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






47. __________________ inserts the current date and time.






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






49. List the different types of data dictionary views.






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