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. The Nonequijoin can use the ________________ operator to construct joins that are not based on equality of values.
Leading-edge
BETWEEN
ON
Three

2. A transaction is a...
Equijoin
Surrogate key
Logical unit of work
Groups

3. Queries that are found in parentheses are done first - just as in the order of operations when doing...
Mathematical equations
Business problems
Scale
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

4. Explain how Dynamic SQL is used and give an example of a Dynamic SQL statement.
RUN SCRIPT
Dynamic SQL is used to be continuously updated by the background processes in the Oracle instance but never by the user.
KEEP INDEX
Implicit conversion

5. Explain what a static data dictionary view is and how it is used
Data
**** 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
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.
ANSI

6. The same function can be used ______ in a SELECT statement.
The indexed column is part of an expression. In this case - consider creating a function-based index instead
Testing functions
Twice
DICTIONARY

7. When you want to run a script in either SQL*Plus or SQL Developer - you can use a ______ or the _________ command.
Leading-edge
@ or START
The SPOOL command - together with a file name - spools any subsequently issued SQL Plus or SQL command to a file. Just as with other file names - you can add a path to store the file in a directory other than your SQL Plus default directory. SQL Deve
RENAME - COPY - DROP - TRUNCATE - LOCK - & COMMENT

8. You can simplify the writing of SQL statements by writing SQL _________ that generate and execute other SQL statements.
Script
ADD_MONTHS function
VALUES
FALSE

9. Another name for a data dictionary view is __________________ or _________________.
B-Tree Index
Self-joins
DESC dict;
Static or dynamic

10. SQL Developer's ____________________ option allows you to selectively export certain rows and columns.
Export Data
TO_CHAR function
Surrogate
CLOB

11. SQL Developer provides an extensive list of useful reports and offers the capability to create your own...
User-defined reports
+
Logical unit of work
Fractional seconds

12. When column names on the tables are different - you use the ______ condition.
ON
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
ADD
Script

13. A _________ subquery returns a single column with a single row
INTERSECT
The main components of a ROWID are the data object number - the number of the data block - the numbers of rows within the data block - and the data file number.
Scalar
Correlated

14. Self-joins are useful for performing comparisons and checking for ___________ in data.
Inconsistencies
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.
Columns
Any

15. The COUNT function is useful for determining whether a table has...
RIGHT LEFT JOIN
Data
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
ANSI

16. List the different types of data dictionary views.
Common column value
B-Tree Index
USER_ - ALL_ - DBA_ - and V$
Non-matching rows

17. SQL*Plus is used more than SQL Developer when you need to...
X
Structured Query Language
Export Data
Run scripts

18. When writing the syntax for finding information on three or more tables - the parenthesis around the ON clause is...
VALUES clause of an INSERT statement
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
ON
Optional

19. Users can only see changes made to a database once they have been...
X
Committed
A correct statement
Command determines the total number of characters SQL *Plus displays in on line before beginning a new line.

20. The ____________ keywords and the USING clause of the ANSI join syntax are mutually exclusive.
F12
NATURAL JOIN
Twice
Structured Query Language

21. What is the Oracle data dictionary called that contains a set of tables and views containing the data about the database?
Actual column
ALL_OBJECTS
Equijoin and identical column names
Inconsistencies

22. ____________ are useful for analyzing and exploring the relationships within your data
Recursive
DD-MON-YY
ANY
Self-joins

23. In a view you can give a column a different name than it has in the...
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.
Parent table
X
X

24. The key that most database designers prefer and is chosen by the system is the _____________ key.
Testing functions
BETWEEN
Surrogate
DESC dict;

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

26. SELECT * FROM instructor ORDER BY phone
A correct statement
RIGHT LEFT JOIN
ADD
MINUS

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

28. Match each of the SQL commands on the left with a verb from the list.
Inconsistencies
Recursive
Extra spaces
Control - Revoke - Define - TRUNCATE Manipulate - MERGE

29. List the steps performed by a correlated subquery.
SET clause of an UPDATE statement
ANSI
**** 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
Crow's foot

30. You can __________ DISTINCT and a GROUP BY clause in the same SELECT statement.
Columns
Combine
Scale
Nested

31. When using the following data: NUMBER(10 -4) - the # 10 is called the __________.
TO_CHAR function
BETWEEN
Precision
GROUP BY

32. What is the tab in SQL Developer where data dictionary view information can be found?
Same
Dynamic SQL is used to be continuously updated by the background processes in the Oracle instance but never by the user.
Details
Implicit conversion

33. What is the first column of a composite index called?
Leading-edge
Control - Revoke - Define - TRUNCATE Manipulate - MERGE
Implicit conversion
Common column value

34. Which one of the following string functions tells you how many characters are in a string?
Data
Asterisk
Hide data
LENGTH

35. Oracle uses the outer join operator to indicate that nulls are shown for...
Non-matching rows
**** 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
Logical unit of work
Inconsistencies

36. Joins involving multiple columns must always follow the ____________ relationship path.
Primary key/foreign key
Equijoin
+
Inconsistencies

37. To revert back to a state that happened before you ran your change statement - you issue a ____________ command.
INNER JOIN
Dynamic SQL is used to be continuously updated by the background processes in the Oracle instance but never by the user.
Export Data
ROLLBACK

38. In SQL Developer field names and table names are shown in the color _______.
V$
Self-joins
B-Tree Index
Black

39. What are the main components of a ROWID?
SELECT SYSDATE+1/96 - FROM dual
VALUES
X
The main components of a ROWID are the data object number - the number of the data block - the numbers of rows within the data block - and the data file number.

40. 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.
Any
Same
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
Has not changed the name

41. The ____________ command makes changes permanent.
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
INTERSECT
DICT_COLUMNS
COMMIT

42. The ______ operator compares a list of values for equivalency
ANY
Script
Rounded edges
Common column value

43. The ___________ operator tests whether a matching row cannot be found.
X
SYSDATE
Logical unit of work
Dynamic SQL is used to be continuously updated by the background processes in the Oracle instance but never by the user.

44. Subqueries can return...
Time zone
Primary key/foreign key
Multiple rows
X

45. What is the syntax used to indicate that you are using the Oracle Outer Join operator?
+
Surrogate key
X
LENGTH

46. Explain how Substitution Variables are used when writing scripts.
Details
INNER JOIN
Asterisk
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.

47. List 4 aggregate functions
Any
Equijoin
COUNT(registration_date) - AVG (capacity) - MIN (capacity) - MAX (capacity)
Month ddth - yyyy

48. _________ rows are not allowed in the relational model.
V$
SELECT DISTINCT menu FROM restaurant
Implicit conversion
Orphan

49. _________ and __________ functions are opposites of each other and provide a value in a group of rows.
TO_CHAR function
Both MIN and MAX
RUN SCRIPT
Asterisk

50. When is it not a good idea to use an index?
Semicolon or forward slash
When the table is small (unless your business rules require you too)
Dynamic SQL is used to be continuously updated by the background processes in the Oracle instance but never by the user.
Control - Revoke - Define - TRUNCATE Manipulate - MERGE

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