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. A calculation with a null always yields...






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






3. List 6 Table-Related Menu Choices






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






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






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






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






8. The _______ operator determines common rows.






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






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






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






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






13. List 4 aggregate functions






14. The _____________ clause determines how rows are grouped.






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






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






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






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






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






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






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






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


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






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






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






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






27. What is the tab in SQL Developer where data dictionary view information can be found?






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






29. LINESIZE






30. PAGESIZE






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






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






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






34. What does SQL stand for?






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






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






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






38. List the steps performed by a correlated subquery.






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






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






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






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






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






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






45. Comparison operators can compare multiple _________________.






46. The ___________ operator tests whether a matching row cannot be found.






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






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






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






50. Another name for a data dictionary view is __________________ or _________________.







Sorry!:) No result found.

Can you answer 50 questions in 15 minutes?


Let me suggest you:



Major Subjects



Tests & Exams


AP
CLEP
DSST
GRE
SAT
GMAT

Most popular tests