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 writing an ANSI outer join - the keywords _________ OUTER and _________ OUTER are added to the __________ keyword to indicate the rows from which table to use.






2. The _____________ clause determines how rows are grouped.






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






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






5. To restart a sequence at a lower number - you can drop and ________ the sequence.






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






7. When using the following data: NUMBER(10 -4) - the lowest number you can possibly have is __________.






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






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






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






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






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






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






14. Explain Flashback queries and how they are used. Give an example of a FLASHBACK_TRANSACTION query and explain what it does row by row.

Warning: Invalid argument supplied for foreach() in /var/www/html/basicversity.com/show_quiz.php on line 183


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






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






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






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






19. To revert back to a state that happened before you ran your change statement - you issue a ____________ command.






20. When you run a script in SQL*Plus you must give the...






21. PAGESIZE






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






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






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


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






26. The TIMESTAMP WITH LOCAL TIME ZONE data type allows...






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






28. Which operator is most commonly used?






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






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






31. A transaction is a...






32. List the different types of data dictionary views.






33. The _______ operator determines common rows.






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






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






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






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






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






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






40. What are the main components of a ROWID?






41. List the steps performed by a correlated subquery.






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






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






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






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






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






47. What is the syntax used to indicate that you are using the Oracle Outer Join operator?






48. What does SQL stand for?






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






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







Sorry!:) No result found.

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