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






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






3. List the steps performed by a correlated subquery.






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






5. __________________ inserts the current date and time.






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






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






8. Oracle uses the outer join operator to indicate that nulls are shown for...






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






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






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






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






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






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






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






16. The _____________ clause determines how rows are grouped.






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






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






19. Write a statement that drops the index need_to_pass_i






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






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






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






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






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






25. Returns rows if the condition is true for all the values in the list






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






27. List the different types of data dictionary views.






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






29. A transaction is a...






30. The _______ operator determines common rows.






31. LINESIZE






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






33. Match each of the SQL commands on the left with a verb from the list.






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






35. Users can only see changes made to a database once they have been...






36. Which operator is most commonly used?






37. Explain how Oracle treats locks when a database is being updated and needs to be viewed by other users.






38. Subqueries can return...






39. The COUNT function uses the __________ wildcard.






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






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






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






43. A join across three tables can be expressed with the ________ join syntax.






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






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






46. Write the syntax to rename index just_two_more_weeks_i to finally_i






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


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






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






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






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