Test your basic knowledge |

Oracle SQL

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. To restart a sequence at a lower number - you can drop and ________ the sequence.
Inconsistencies
12:00:00 A.M
DECODE
Re-create

2. Explain what is found in the All Objects report folder in SQL Developer
BETWEEN
Lists all objects accessible for the chosen database connection. Also lists a helpful dependencies report for accessing change impact.
INNER JOIN
Recursive

3. If a graphical representation of a table's box has __________ it means that the relationship is identifying.
Leading-edge
Rounded edges
Any
ADD_MONTHS function

4. Explicit data type conversion is preferable to Oracle's...
Implicit conversion
Correlated
ALL_OBJECTS
X

5. Which format mask displays December 31st - 1999?
Common column value
Month ddth - yyyy
Crow's foot
DICT_COLUMNS

6. The ____________ command makes changes permanent.
Asterisk
Twice
COMMIT
The static data dictionary stores details about database objects - such as tables - indexes - and views. Whenever a new object is added or an object is changed - data about the object is recorded in the data dictionary.

7. List the steps performed by a correlated subquery.
**** Select a row from the outer query - Determine the value of the correlated column - Execute the inner query for each record of the outer query. - Feed the results of the inner query to the outer query and evaluate it. It if satisfies the criteria
Default is 14; when you use the default - you repeat the heading every 14 rows.
X
Control - Revoke - Define - TRUNCATE Manipulate - MERGE

8. The ___________ operator tests whether a matching row cannot be found.
To achieve good performance for data retrieval and data manipulation statements Oracle uses indexes. In the same way you would use an index in the back of a book to quickly find information - Oracle uses indexes to speed up data retrieval. If the app
X
LENGTH
ANY

9. The ______ operator compares a list of values for equivalency
DICT_COLUMNS
Data
ANY
@ or START

10. The COUNT function is useful for determining whether a table has...
Data
DD-MON-YY
UTC
2000

11. _________ rows are not allowed in the relational model.
Orphan
Scalar
Leading-edge
Equijoin

12. What is the tab in SQL Developer where data dictionary view information can be found?
DECODE
Recursive
INNER JOIN
Details

13. UNION ALL does not sort - therefore it is less time consuming to use than the...
Groups
Mathematical equations
RENAME just_two_more_weeks TO finally_i
UNION operator

14. The DUAL table can be used for...
LENGTH
Testing functions
Multiple rows
VALUES

15. PAGESIZE
Control - Revoke - Define - TRUNCATE Manipulate - MERGE
Orable's flashback query feature allows you to look at values of a query at a specific time in the past - such as before specfic DML statements occured. This can be usefull in case a suer accidentally performs an unintended but committed DML change.
GROUP BY
Default is 14; when you use the default - you repeat the heading every 14 rows.

16. When writing the syntax for finding information on three or more tables - the parenthesis around the ON clause is...
Lists all objects accessible for the chosen database connection. Also lists a helpful dependencies report for accessing change impact.
ON
Optional
Month ddth - yyyy

17. To join four tables - you must have at least _____ join conditions.
Three
User-defined reports
ROLLBACK
The indexed column is part of an expression. In this case - consider creating a function-based index instead

18. The focus of the logical data model is _____________
SYSDATE
Re-create
Business problems
USER_ - ALL_ - DBA_ - and V$

19. What is the first column of a composite index called?
Leading-edge
Multiple rows
999999.9999
Any

20. List the reasons that a subquery could not be unnested.
X
UNION operator
Data
@ or START

21. Subqueries can return...
Static or dynamic
SYSDATE
SELECT DISTINCT menu FROM restaurant
Multiple rows

22. What is the Oracle data dictionary called that contains a set of tables and views containing the data about the database?
Structured Query Language
ALL_OBJECTS
DECODE
Common column value

23. What is the most common DATE format found in SQL?
Run scripts
2000
FALSE
DD-MON-YY

24. When is it not a good idea to use an index?
When the table is small (unless your business rules require you too)
INTERSECT
UTC
UNION

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

26. The ____________ keywords and the USING clause of the ANSI join syntax are mutually exclusive.
NATURAL JOIN
Actual column
Location of the file
Committed

27. 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.
RIGHT LEFT JOIN
Twice
999999.9999
ON

28. When returning multiple rows - a subquery must contain the _____ - _____ - _____ - or ______ operator - otherwise Oracle will return an error
Command returns the number of records returned by a query.
12:00:00 A.M
IN ANY ALL SOME
SELECT DISTINCT menu FROM restaurant

29. Write an SQL statement for SQL *Plus in which you want any unique menu items to be displayed from the restaurant table
When you issue a INSERT - UPDATE - DELETE - or MERGE statement - Oracle automatically locks the modified rows. The lock prevents other sessions from making changes to these rows. The lock is released when the session initiating change commits or roll
ANSI
SELECT DISTINCT menu FROM restaurant
USER_ - ALL_ - DBA_ - and V$

30. When you run a script in SQL*Plus you must give the...
When the table is small (unless your business rules require you too)
INNER JOIN
COUNT(registration_date) - AVG (capacity) - MIN (capacity) - MAX (capacity)
Location of the file

31. Which one of the following string functions tells you how many characters are in a string?
Rounded edges
LENGTH
Leading-edge
COUNT(registration_date) - AVG (capacity) - MIN (capacity) - MAX (capacity)

32. List 6 Table-Related Menu Choices
Parent table
Subqueries allow you to nest multiple queries into each other. This gives you the ability to use one statement to break down a problem into individual components. Without nesting queries - you would be required to have multiple queries which could be
RENAME - COPY - DROP - TRUNCATE - LOCK - & COMMENT
Common column value

33. When disabling a unique or primary key - you can keep the index if you specify the __________________ clause in the ALTER TABLE statement.
LIKE
SELECT SYSDATE+1/96 - FROM dual
KEEP INDEX
Combine

34. To revert back to a state that happened before you ran your change statement - you issue a ____________ command.
ROLLBACK
**** Select a row from the outer query - Determine the value of the correlated column - Execute the inner query for each record of the outer query. - Feed the results of the inner query to the outer query and evaluate it. It if satisfies the criteria
Running a script file
X

35. 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.
VALUES
UTC
VALUES clause of an INSERT statement
Inconsistencies

36. You use the __________ keyword to change characteristics of a column.
MODIFY
**** Select a row from the outer query - Determine the value of the correlated column - Execute the inner query for each record of the outer query. - Feed the results of the inner query to the outer query and evaluate it. It if satisfies the criteria
Combine
DICTIONARY

37. ____________ are useful for analyzing and exploring the relationships within your data
When you want to run the same script repeatedly - but want to be able to change a variable you would use a substitution variable. During the execution of the script the user will be prompted to input the variable to use.
A correct statement
Surrogate key
Self-joins

38. To place a line comment in your SQL statements - you first place a // at the beginning of the line.
RENAME just_two_more_weeks TO finally_i
FALSE
4
Null

39. It is considered good form to put all SQL commands in...
All caps
Semicolon or forward slash
Actual column
Business problems

40. The NEXTVAL and CURRVAL pseudocolumns can be used in which of the following SQL constructs? Select all that apply.
4000
Load the file into the SQL Statement Box - by opening the location the file is stored and inserting it into the statement Box. Next you can press the F5 key.
DICTIONARY
VALUES clause of an INSERT statement

41. When column names on the tables are different - you use the ______ condition.
Common column value
Combine
ON
Has not changed the name

42. List 4 aggregate functions
UNION operator
COUNT(registration_date) - AVG (capacity) - MIN (capacity) - MAX (capacity)
Any
DROP INDEX need_to_pass_i

43. _________ and __________ functions are opposites of each other and provide a value in a group of rows.
Recursive
Constraints are used to enforce the business rules of a system. For instance - 'The salary of an employee may not be a negative number' may be enforced with a check constraint on the salary column. Constraints also ensure integrity and data consisten
Self-joins
Both MIN and MAX

44. When you want to run a script in either SQL*Plus or SQL Developer - you can use a ______ or the _________ command.
Three
@ or START
Running a script file
BETWEEN

45. The key that most database designers prefer and is chosen by the system is the _____________ key.
RUN SCRIPT
Groups
Surrogate
Equijoin and identical column names

46. The using clause of the ANSI join syntax always assumes an...
V$
Semicolon or forward slash
Equijoin and identical column names
Export Data

47. The ROWID pseudocolumn is not an ________- but it acts like one.
When the table is small (unless your business rules require you too)
Combine
VALUES
Actual column

48. A join across three tables can be expressed with the ________ join syntax.
Combine
ANSI
2000
Structured Query Language

49. SELECT * FROM instructor ORDER BY phone
DECODE
STORAGE
TO_CHAR function
A correct statement

50. A _____ is a query definition stored in the database that looks just like a table - but does not have any physical rows
Logical unit of work
Orphan
MODIFY
X

Sorry!:) No result found.

Can you answer 50 questions in 15 minutes?

Major Subjects
Tests & Exams AP CLEP DSST GRE SAT GMAT	Certifications CISSP go to https://www.isc2.org/ PMP ITIL RHCE MCTS More...	IT Skills Android Programming Data Modeling Objective C Programming Basic Python Programming Adobe Illustrator More...	Business Skills Advertising Techniques Business Accounting Basics Business Strategy Human Resource Management Marketing Basics More...
Soft Skills Body Language People Skills Public Speaking Persuasion Job Hunting And Resumes More...	Vocabulary GRE Vocab SAT Vocab TOEFL Essential Vocab Basic English Words For All Global Words You Should Know Business English More...	Languages AP German Vocab AP Latin Vocab SAT Subject Test: French Italian Survival Norwegian Survival More...	Engineering Audio Engineering Computer Science Engineering Aerospace Engineering Chemical Engineering Structural Engineering More...
Health Sciences Basic Nursing Skills Health Science Language Fundamentals Veterinary Technology Medical Language Cardiology Clinical Surgery More...	English Grammar Fundamentals Literary And Rhetorical Vocab Elements Of Style Vocab Introduction To English Major Complete Advanced Sentences Literature Homonyms More...	Math Algebra Formulas Basic Arithmetic: Measurements Metric Conversions Geometric Properties Important Math Facts Number Sense Vocab Business Math More...	Other Major Subjects Science Economics History Law Performing-arts Cooking Logic & Reasoning Trivia

Test your basic knowledge |

Oracle SQL

Sorry!:) No result found.

Can you answer 50 questions in 15 minutes?

Let me suggest you:

Browse all subjects

Browse all tests

Most popular tests

Major Subjects

Tests & Exams

Certifications

IT Skills

Business Skills

Soft Skills

Vocabulary

Languages

Engineering

Health Sciences

English

Math

Other Major Subjects

Browse all subjects

Browse all tests

Most popular tests