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. To equijoin a table with another table involves matching the...






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






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






4. When using the following data: NUMBER(10 -4) - the # 4 is called the __________.






5. Dynamic views begin with a ___________.






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






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






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






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






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






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






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


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






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


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


16. When you INSERT new information into a table - it is followed with a _______ keyword that contains the information that is going to be added to the table.






17. All SQL statements contained within a script must end with a _______________ - even if they are done in SQL Developer.






18. NUMBER functions can be...






19. The _______ function adds values together for a group of rows.






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






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






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






23. What does SQL stand for?






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






25. What is the name of the view where you can find the collection of static and data dictionary tables and views - along with their descriptions?






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






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






28. List 4 aggregate functions






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






30. The __________ operator is inclusive of the two values specified.






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






32. The _____________ clause determines how rows are grouped.






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






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






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






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






37. The focus of the logical data model is _____________






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






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






40. A transaction is a...






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






42. PAGESIZE






43. Subqueries can return...






44. The ____________ clause on a CREATE TABLE statement can specify how much space to allocate.






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






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






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






48. The _______ operator determines common rows.






49. The ____________ command makes changes permanent.






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