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. NUMBER functions can be...
Nested
TO_CHAR function
Scalar
VALUES clause of an INSERT statement

2. What is Oracle's most popular index storage structure?
Lists all objects accessible for the chosen database connection. Also lists a helpful dependencies report for accessing change impact.
Combine
B-Tree Index
Groups

3. When using the following data: NUMBER(10 -4) - the lowest number you can possibly have is __________.
NATURAL JOIN
Command determines the total number of characters SQL *Plus displays in on line before beginning a new line.
999999.9999
Twice

4. The _______ operator determines common rows.
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.
INNER JOIN
Scale
INTERSECT

5. SQL Developer's ____________________ option allows you to selectively export certain rows and columns.
Export Data
X
DD-MON-YY
X

6. Which one of the following string functions tells you how many characters are in a string?
LENGTH
Business problems
SELECT DISTINCT menu FROM restaurant
Re-create

7. The key that most database designers prefer and is chosen by the system is the _____________ key.
**** 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
Surrogate
Details
99.99

8. Explain the differences in how an ANSI Full Outer Join and a Full Outer Join using the UNION Operator work
Command returns the number of records returned by a query.
Actual column
X
Dynamic SQL is used to be continuously updated by the background processes in the Oracle instance but never by the user.

9. You use the __________ keyword to change characteristics of a column.
MODIFY
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
Any
X

10. Joins involving multiple columns must always follow the ____________ relationship path.
INNER JOIN
Primary key/foreign key
CLOB
DD-MON-YY

11. Checks whether any value in the list makes the condition true.
FALSE
Script
Results
Any

12. The term ____________ ___________ is used to express a join that satisfies the join condition.
LENGTH
INNER JOIN
COMMIT
RUN SCRIPT

13. FEEDBACK
Scale
User-defined reports
Null
Command returns the number of records returned by a query.

14. Explain why constraints are used when building tables.

Warning: Invalid argument supplied for foreach() in /var/www/html/basicversity.com/show_quiz.php on line 183

15. Comparison operators can compare multiple _________________.
Columns
SELECT DISTINCT menu FROM restaurant
All caps
USER_ - ALL_ - DBA_ - and V$

16. The _______ function adds values together for a group of rows.
FALSE
Month ddth - yyyy
A correct statement
SUM

17. The ____________ clause on a CREATE TABLE statement can specify how much space to allocate.
NATURAL JOIN
Dynamic SQL is used to be continuously updated by the background processes in the Oracle instance but never by the user.
X
STORAGE

18. Self-joins are useful for performing comparisons and checking for ___________ in data.
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.
UNION
Inconsistencies
RIGHT LEFT JOIN

19. When is it not a good idea to use an index?
Twice
Control - Revoke - Define - TRUNCATE Manipulate - MERGE
Equijoin and identical column names
When the table is small (unless your business rules require you too)

20. List 6 Table-Related Menu Choices
When the table is small (unless your business rules require you too)
RENAME - COPY - DROP - TRUNCATE - LOCK - & COMMENT
STORAGE
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.

21. _________________ relationships are always optional relationships.
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.
Recursive
FALSE
Primary key/foreign key

22. The ____________ keywords and the USING clause of the ANSI join syntax are mutually exclusive.
DICT_COLUMNS
Any
Any
NATURAL JOIN

23. When using the following data: NUMBER(10 -4) - the # 4 is called the __________.
Scale
Semicolon or forward slash
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.
99.99

24. When returning multiple rows - a subquery must contain the _____ - _____ - _____ - or ______ operator - otherwise Oracle will return an error
Extra spaces
IN ANY ALL SOME
Combine
Both MIN and MAX

25. SQL*Plus is used more than SQL Developer when you need to...
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.
ROLLBACK
ANSI
Run scripts

26. When disabling a unique or primary key - you can keep the index if you specify the __________________ clause in the ALTER TABLE statement.
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
Surrogate key
KEEP INDEX
Command returns the number of records returned by a query.

27. What are the main components of a ROWID?
MINUS
ADD
DESC dict;
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.

28. You can use the ________________ to subtract months from a given date.
ADD_MONTHS function
X
X
Optional

29. Converting a text literal to DATE format requires the use of the...
TO_CHAR function
F12
SET clause of an UPDATE statement
Actual column

30. The using clause of the ANSI join syntax always assumes an...
Export Data
Three
All
Equijoin and identical column names

31. To equijoin a table with another table involves matching the...
LIKE
Semicolon or forward slash
Common column value
Twice

32. When using the following data: NUMBER(10 -4) - the # 10 is called the __________.
UTC
NATURAL JOIN
Precision
Another null

33. The __________ operator is inclusive of the two values specified.
BETWEEN
ON
ANSI
RENAME just_two_more_weeks TO finally_i

34. How many characters can be stored in the CHAR column/field?
Details
2000
Nested
BETWEEN

35. Match each of the SQL commands on the left with a verb from the list.
4000
Columns
Another null
Control - Revoke - Define - TRUNCATE Manipulate - MERGE

36. 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.
Equijoin and correlated subquery
Black
Has not changed the name
Running a script file

37. The TRUNC function on a date without a format model truncates the timestamp to...
12:00:00 A.M
@ or START
Run scripts
NATURAL JOIN

38. Explain the steps needed to run a script in SQL Developer
LIKE
Control - Revoke - Define - TRUNCATE Manipulate - MERGE
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.
2000

39. SELECT LIST of a subquery in an INSERT statement
USER_ - ALL_ - DBA_ - and V$
DICT_COLUMNS
SET clause of an UPDATE statement
SUM

40. List 4 aggregate functions
COUNT(registration_date) - AVG (capacity) - MIN (capacity) - MAX (capacity)
Implicit conversion
Export Data
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

41. The focus of the logical data model is _____________
F12
Business problems
Inconsistencies
Surrogate key

42. An outer join includes the result rows returned by an __________ plus extra rows where no matches are found.
BETWEEN
12:00:00 A.M
Equijoin
Command returns the number of records returned by a query.

43. Returns rows if the condition is true for all the values in the list
DESC dict;
Logical unit of work
SET clause of an UPDATE statement
All

44. Write the syntax to rename index just_two_more_weeks_i to finally_i
ROLLBACK
Surrogate
RENAME just_two_more_weeks TO finally_i
INNER JOIN

45. UNION ALL does not sort - therefore it is less time consuming to use than the...
UNION operator
RENAME just_two_more_weeks TO finally_i
Equijoin and correlated subquery
Actual column

46. Oracle uses the outer join operator to indicate that nulls are shown for...
ANSI
Twice
CLOB
Non-matching rows

47. How many characters can you have using the VARCHAR data type?
DROP INDEX need_to_pass_i
4000
ALL_OBJECTS
A correct statement

48. Explicit data type conversion is preferable to Oracle's...
SELECT SYSDATE+1/96 - FROM dual
Implicit conversion
Data
TO_CHAR function

49. A _____ is a query definition stored in the database that looks just like a table - but does not have any physical rows
ON
X
Scale
Correlated

50. The ________________ is a type of statement whereby you retrieve data that exists in one table - but not in another.
Control - Revoke - Define - TRUNCATE Manipulate - MERGE
COUNT(registration_date) - AVG (capacity) - MIN (capacity) - MAX (capacity)
MINUS
Optional

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

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