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. List the different types of data dictionary views.






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






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






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






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






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






7. Which operator is most commonly used?






8. What are the main components of a ROWID?






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






10. What is the first column of a composite index called?






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






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






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






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






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






16. The COUNT function is useful for determining whether a table has...






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






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






19. What does SQL stand for?






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






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






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






23. A transaction is a...






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






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






26. _________________ relationships are always optional relationships.






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






28. ____________ are useful for analyzing and exploring the relationships within your data






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






30. The _______ operator determines common rows.






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






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






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






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






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






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






37. The ______ operator compares a list of values for equivalency






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






39. List 6 Table-Related Menu Choices






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






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






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






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






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






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






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






47. Comparison operators can compare multiple _________________.






48. LINESIZE






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






50. __________________ inserts the current date and time.







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