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






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






3. The _____________ clause determines how rows are grouped.






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






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






6. List the steps performed by a correlated subquery.






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






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






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






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






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






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






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






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






15. Checks whether any value in the list makes the condition true.






16. SELECT LIST of a subquery in an INSERT statement






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






18. The ________________ is a type of statement whereby you retrieve data that exists in one table - but not in another.






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






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






21. NUMBER functions can be...






22. When you create a report in SQL Developer all the column names must match identically the names of the columns found in the tables you are referencing.






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






24. The ROWID pseudocolumn is not an ________- but it acts like one.






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






26. Information that is returned after you run your statement are found in the __________ tab in SQL Developer.






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






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






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






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






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






32. The COUNT function uses the __________ wildcard.






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






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 ____________ icon allows you to execute multiple statements and emulates SQL *Plus as much as possible.






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






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






38. Write an SQL statement for SQL *Plus in which you want any unique menu items to be displayed from the restaurant table






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






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






41. Which operator is most commonly used?






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






43. Dynamic views begin with a ___________.






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






45. The focus of the logical data model is _____________






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






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






48. The ____________ keywords and the USING clause of the ANSI join syntax are mutually exclusive.






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


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