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 same function can be used ______ in a SELECT statement.






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






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






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






5. What does SQL stand for?






6. LINESIZE






7. SELECT * FROM instructor ORDER BY phone






8. Explicit data type conversion is preferable to Oracle's...






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






10. __________________ inserts the current date and time.






11. FEEDBACK






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






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






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






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






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






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






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






19. All SQL statements contained within a script must end with a _______________ - even if they are done in SQL Developer.






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






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






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






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






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






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






26. The focus of the logical data model is _____________






27. Returns rows if the condition is true for all the values in the list






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






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






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






31. List 4 aggregate functions






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






33. An outer join includes the result rows returned by an __________ plus extra rows where no matches are found.






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






35. PAGESIZE






36. When disabling a unique or primary key - you can keep the index if you specify the __________________ clause in the ALTER TABLE statement.






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






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






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






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






41. What are the main components of a ROWID?






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






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






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






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


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






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






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






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






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







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