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. The TIMESTAMP WITH LOCAL TIME ZONE data type allows...






2. What is the keyboard shortcut for the ROLLBACK command?






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






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






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






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






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






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






9. Write the syntax to rename index just_two_more_weeks_i to finally_i






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






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






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






13. NUMBER functions can be...






14. When using the data NUMBER(10 -4) there will be _______ digits following the decimal point.






15. Explain how the SPOOL command is used and what program it can be used in.






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






17. List 4 aggregate functions






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






19. When you INSERT new information into a table - it is followed with a _______ keyword that contains the information that is going to be added to the table.






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






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






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






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






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






25. PAGESIZE






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






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






28. SELECT * FROM instructor ORDER BY phone






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






30. LINESIZE






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






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






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






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. List the steps performed by a correlated subquery.






36. A transaction is a...






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






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






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






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






41. The term ____________ ___________ is used to express a join that satisfies the join condition.






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






43. FEEDBACK






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






45. What is the maximum value for a column defined as NUMBER(4 -2)?






46. Explain the differences in how an ANSI Full Outer Join and a Full Outer Join using the UNION Operator work






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






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






49. The COUNT function uses the __________ wildcard.






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