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 join four tables - you must have at least _____ join conditions.






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






3. LINESIZE






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






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






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






7. What does SQL stand for?






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






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






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






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






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






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






14. The TRUNC function on a date without a format model truncates the timestamp to...






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






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






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






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






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






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






21. Dynamic views begin with a ___________.






22. Write a statement for SQL*Plus that shows the dictionary.






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






24. The using clause of the ANSI join syntax always assumes an...






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






26. The ____________ command makes changes permanent.






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






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






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






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






31. SELECT LIST of a subquery in an INSERT statement






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






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






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






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






36. The focus of the logical data model is _____________






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






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






39. A transaction is a...






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






41. When writing an ANSI outer join - the keywords _________ OUTER and _________ OUTER are added to the __________ keyword to indicate the rows from which table to use.






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






43. Subqueries can return...






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






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






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






47. __________________ inserts the current date and time.






48. Write the syntax to rename index just_two_more_weeks_i to finally_i






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






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