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. When using the following data: NUMBER(10 -4) - the # 4 is called the __________.
Business problems
USER_ - ALL_ - DBA_ - and V$
MINUS
Scale

2. A transaction is a...
FALSE
Equijoin and correlated subquery
RENAME just_two_more_weeks TO finally_i
Logical unit of work

3. The COUNT function is useful for determining whether a table has...
ON
X
Data
DECODE

4. Explain the steps needed to run a script in SQL Developer
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.
Equijoin and correlated subquery
Dynamic SQL is used to be continuously updated by the background processes in the Oracle instance but never by the user.
Inconsistencies

5. Converting a text literal to DATE format requires the use of the...
Nested
TO_CHAR function
Multiple rows
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.

6. SQL Developer's ____________________ option allows you to selectively export certain rows and columns.
GROUP BY
Month ddth - yyyy
Logical unit of work
Export Data

7. List 6 Table-Related Menu Choices
Script
RENAME - COPY - DROP - TRUNCATE - LOCK - & COMMENT
DECODE
MINUS

8. To place a line comment in your SQL statements - you first place a // at the beginning of the line.
ANY
FALSE
MODIFY
VALUES

9. The _______ operator determines common rows.
MINUS
INTERSECT
Precision
DECODE

10. Match each of the SQL commands on the left with a verb from the list.
Inconsistencies
Run scripts
Retrieve
Control - Revoke - Define - TRUNCATE Manipulate - MERGE

11. Joins involving multiple columns must always follow the ____________ relationship path.
COUNT(registration_date) - AVG (capacity) - MIN (capacity) - MAX (capacity)
LENGTH
4000
Primary key/foreign key

12. SQL*Plus is used more than SQL Developer when you need to...
Surrogate key
Run scripts
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.
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

13. What is the syntax used to indicate that you are using the Oracle Outer Join operator?
Asterisk
+
Export Data
Leading-edge

14. When is it not a good idea to use an index?
Primary key/foreign key
When the table is small (unless your business rules require you too)
Data
Running a script file

15. The COUNT function uses the __________ wildcard.
LIKE
X
Equijoin and identical column names
Asterisk

16. The ____________ keywords and the USING clause of the ANSI join syntax are mutually exclusive.
BETWEEN
Extra spaces
Surrogate
NATURAL JOIN

17. ____________ are useful for analyzing and exploring the relationships within your data
Self-joins
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
**** 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
Asterisk

18. The ROWID pseudocolumn is not an ________- but it acts like one.
Actual column
Equijoin and identical column names
Recursive
X

19. What is the tab in SQL Developer where data dictionary view information can be found?
Recursive
KEEP INDEX
Details
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.

20. The ________________ is a type of statement whereby you retrieve data that exists in one table - but not in another.
ALL_OBJECTS
MINUS
999999.9999
Command returns the number of records returned by a query.

21. The ___________ operator tests whether a matching row cannot be found.
IN ANY ALL SOME
RENAME - COPY - DROP - TRUNCATE - LOCK - & COMMENT
X
SELECT DISTINCT menu FROM restaurant

22. ___________ subqueries allow you to reference columns from the outer query and execute the inner query repeatedly
X
Correlated
Three
Business problems

23. What is the first column of a composite index called?
Leading-edge
COUNT(registration_date) - AVG (capacity) - MIN (capacity) - MAX (capacity)
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
Recursive

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

25. List the different types of data dictionary views.
USER_ - ALL_ - DBA_ - and V$
Has not changed the name
Equijoin
DICT_COLUMNS

26. Explain in detail the impact of INDEXES and how they are used by Oracle.
RIGHT LEFT JOIN
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
Export Data
Null

27. Checks whether any value in the list makes the condition true.
UNION
Any
Same
Columns

28. _________________ relationships are always optional relationships.
LENGTH
ADD_MONTHS function
Recursive
Data

29. What is Oracle's most popular index storage structure?
Scalar
B-Tree Index
The indexed column is part of an expression. In this case - consider creating a function-based index instead
2000

30. Self-joins are useful for performing comparisons and checking for ___________ in data.
Inconsistencies
Orphan
FALSE
VALUES

31. Write a statement that drops the index need_to_pass_i
F12
@ or START
DROP INDEX need_to_pass_i
Scalar

32. A _____ is a query definition stored in the database that looks just like a table - but does not have any physical rows
+
STORAGE
X
Crow's foot

33. 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:00:00 A.M
@ or START
Rounded edges
DICTIONARY

34. You can use the ________________ to subtract months from a given date.
RENAME just_two_more_weeks TO finally_i
Mathematical equations
ADD_MONTHS function
F12

35. Write a statement for SQL*Plus that shows the dictionary.
Three
ALL_OBJECTS
Dynamic SQL is used to be continuously updated by the background processes in the Oracle instance but never by the user.
DESC dict;

36. The _______ function lets you perform if-then-else functionality with the SQL language.
Equijoin and identical column names
DECODE
IN ANY ALL SOME
Self-joins

37. Explain how Dynamic SQL is used and give an example of a Dynamic SQL statement.
Another null
Equijoin and correlated subquery
@ or START
Dynamic SQL is used to be continuously updated by the background processes in the Oracle instance but never by the user.

38. The time zone displacement value indicates the time difference from _______.
Dynamic SQL is used to be continuously updated by the background processes in the Oracle instance but never by the user.
UTC
Business problems
Default is 14; when you use the default - you repeat the heading every 14 rows.

39. The ALTER SESSION statement can change the session's...
SELECT SYSDATE+1/96 - FROM dual
Has not changed the name
INNER JOIN
Time zone

40. When using the following data: NUMBER(10 -4) - the lowest number you can possibly have is __________.
999999.9999
INNER JOIN
V$
Surrogate key

41. The key that most database designers prefer and is chosen by the system is the _____________ key.
NATURAL JOIN
Export Data
999999.9999
Surrogate

42. SQL Developer provides an extensive list of useful reports and offers the capability to create your own...
FALSE
2000
User-defined reports
ON

43. In a view you can give a column a different name than it has in the...
Black
The way NULL values are treated
Parent table
Inconsistencies

44. PAGESIZE
Default is 14; when you use the default - you repeat the heading every 14 rows.
Retrieve
A correct statement
Run scripts

45. 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
Asterisk
Null
LIKE

46. Subqueries can return...
Multiple rows
STORAGE
2000
LENGTH

47. What is the data type you can use if you need an unlimited number of textual characters?
X
CLOB
SYSDATE
DECODE

48. In SQL Developer field names and table names are shown in the color _______.
Black
DESC dict;
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.
Non-matching rows

49. When disabling a unique or primary key - you can keep the index if you specify the __________________ clause in the ALTER TABLE statement.
KEEP INDEX
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.
Script
ON

50. What does the following function return? SELECT LENGTH(NULL) - FROM dual
UNION
2000
ADD
Null

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