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. When using the following data: NUMBER(10 -4) - the lowest number you can possibly have is __________.






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






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






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






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






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






7. It is always good practice to include the old values in the WHERE clause of UPDATE to ensure that another session or user _________________ in the meantime.






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






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






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






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






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


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






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






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






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






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






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






19. The COUNT function uses the __________ wildcard.






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






21. FEEDBACK






22. The _______ operator determines common rows.






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






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






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






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






27. The _____________ clause determines how rows are grouped.






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






29. PAGESIZE






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






31. SELECT * FROM instructor ORDER BY phone






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






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






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






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






36. The focus of the logical data model is _____________






37. Explain how Substitution Variables are used when writing scripts.






38. SQL Developer provides an extensive list of useful reports and offers the capability to create your own...






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






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






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






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






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






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






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






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






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






48. NUMBER functions can be...






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






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