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 ___________ operator tests whether a matching row cannot be found.
VALUES clause of an INSERT statement
DICTIONARY
Month ddth - yyyy
X

2. What does the following function return? SELECT LENGTH(NULL) - FROM dual
Structured Query Language
CLOB
Null
Re-create

3. Explain what is found in the All Objects report folder in SQL Developer
Combine
Lists all objects accessible for the chosen database connection. Also lists a helpful dependencies report for accessing change impact.
Semicolon or forward slash
When the table is small (unless your business rules require you too)

4. SQL Developer provides an extensive list of useful reports and offers the capability to create your own...
Three
User-defined reports
UNION
Export Data

5. What is the main difference between the NOT EXISTS and the NOT IN operators?
GROUP BY
X
The way NULL values are treated
Script

6. The RTRIM function is useful for eliminating ________ in a string.
All caps
Semicolon or forward slash
Extra spaces
FALSE

7. List the reasons that a subquery could not be unnested.
GROUP BY
Self-joins
X
**** 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

8. When writing the syntax for finding information on three or more tables - the parenthesis around the ON clause is...
Optional
Same
VALUES clause of an INSERT statement
TO_CHAR function

9. Self-joins are useful for performing comparisons and checking for ___________ in data.
ON
Inconsistencies
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.
DECODE

10. What is the keyboard shortcut for the ROLLBACK command?
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.
V$
FALSE
F12

11. A join across three tables can be expressed with the ________ join syntax.
Correlated
ANSI
GROUP BY
@ or START

12. 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.
FALSE
SELECT DISTINCT menu FROM restaurant
SET clause of an UPDATE statement
ADD_MONTHS function

13. Explain the differences in how an ANSI Full Outer Join and a Full Outer Join using the UNION Operator work
KEEP INDEX
2000
F12
X

14. When returning multiple rows - a subquery must contain the _____ - _____ - _____ - or ______ operator - otherwise Oracle will return an error
RENAME just_two_more_weeks TO finally_i
Dynamic SQL is used to be continuously updated by the background processes in the Oracle instance but never by the user.
IN ANY ALL SOME
Lists all objects accessible for the chosen database connection. Also lists a helpful dependencies report for accessing change impact.

15. The COUNT function uses the __________ wildcard.
ON
Primary key/foreign key
Asterisk
MODIFY

16. The ____________ command makes changes permanent.
NATURAL JOIN
COMMIT
Results
Fractional seconds

17. What do views do that makes them so useful for security?
Multiple rows
SET clause of an UPDATE statement
Hide data
FALSE

18. What is Oracle's most popular index storage structure?
B-Tree Index
Twice
Asterisk
BETWEEN

19. What is the tab in SQL Developer where data dictionary view information can be found?
Equijoin and identical column names
RENAME - COPY - DROP - TRUNCATE - LOCK - & COMMENT
Details
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

20. ____________ are useful for analyzing and exploring the relationships within your data
Self-joins
SUM
FALSE
All

21. You can simplify the writing of SQL statements by writing SQL _________ that generate and execute other SQL statements.
Asterisk
RUN SCRIPT
Both MIN and MAX
Script

22. The ____________ icon allows you to execute multiple statements and emulates SQL *Plus as much as possible.
Mathematical equations
Inconsistencies
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.
RUN SCRIPT

23. SELECT * FROM instructor ORDER BY phone
A correct statement
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
Run scripts
Scale

24. Checks whether any value in the list makes the condition true.
Any
Lists all objects accessible for the chosen database connection. Also lists a helpful dependencies report for accessing change impact.
Dynamic SQL is used to be continuously updated by the background processes in the Oracle instance but never by the user.
Inconsistencies

25. When you have issued a DELETE command - you can still ________ those rows and restore the information.
Equijoin and correlated subquery
Retrieve
Same
Scalar

26. The __________ operator is inclusive of the two values specified.
99.99
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
BETWEEN
Multiple rows

27. You use the __________ keyword to change characteristics of a column.
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
MODIFY
DD-MON-YY

28. When you run a script in SQL*Plus you must give the...
Location of the file
ANY
ALL_OBJECTS
Logical unit of work

29. What is the name of the key automatically generated from a sequence?
Mathematical equations
Leading-edge
Surrogate key
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

30. The focus of the logical data model is _____________
4
Business problems
STORAGE
FALSE

31. The TIMESTAMP WITH LOCAL TIME ZONE data type allows...
User-defined reports
Data
Fractional seconds
RENAME - COPY - DROP - TRUNCATE - LOCK - & COMMENT

32. Explain how the SPOOL command is used and what program it can be used in.
Retrieve
Fractional seconds
ALL_OBJECTS
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

33. When using the following data: NUMBER(10 -4) - the # 4 is called the __________.
Scale
12:00:00 A.M
FALSE
Lists all objects accessible for the chosen database connection. Also lists a helpful dependencies report for accessing change impact.

34. The data type definitions NUMBER(10) and NUMBER(10 -0) are the...
INNER JOIN
@ or START
Implicit conversion
Same

35. List 4 aggregate functions
Multiple rows
Data
Rounded edges
COUNT(registration_date) - AVG (capacity) - MIN (capacity) - MAX (capacity)

36. The _______ operator determines common rows.
Combine
LENGTH
Details
INTERSECT

37. 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?
Actual column
LENGTH
DICTIONARY
RUN SCRIPT

38. List the steps performed by a correlated subquery.
Three
Equijoin and identical column names
**** 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
DESC dict;

39. The purpose of the HAVING clause is to eliminate___________.
Groups
Dynamic SQL is used to be continuously updated by the background processes in the Oracle instance but never by the user.
DECODE
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.

40. Write the syntax to rename index just_two_more_weeks_i to finally_i
DD-MON-YY
RENAME just_two_more_weeks TO finally_i
2000
Orphan

41. Comparison operators can compare multiple _________________.
BETWEEN
Columns
Rounded edges
TO_CHAR function

42. Queries that are found in parentheses are done first - just as in the order of operations when doing...
Mathematical equations
DECODE
NATURAL JOIN
Another null

43. The COUNT function is useful for determining whether a table has...
Equijoin and correlated subquery
Data
INTERSECT
Time zone

44. Match each of the SQL commands on the left with a verb from the list.
Control - Revoke - Define - TRUNCATE Manipulate - MERGE
12:00:00 A.M
User-defined reports
Any

45. The TRUNC function on a date without a format model truncates the timestamp to...
ADD
Any
Any
12:00:00 A.M

46. FEEDBACK
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
Command returns the number of records returned by a query.
DESC dict;
Results

47. The ________________ is a type of statement whereby you retrieve data that exists in one table - but not in another.
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.
All caps
MINUS
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

48. To revert back to a state that happened before you ran your change statement - you issue a ____________ command.
ROLLBACK
Data
CLOB
Mathematical equations

49. A _____ is a query definition stored in the database that looks just like a table - but does not have any physical rows
@ or START
Null
X
Multiple rows

50. All SQL statements contained within a script must end with a _______________ - even if they are done in SQL Developer.
Scalar
Semicolon or forward slash
Black
Orphan

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