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 TIMESTAMP WITH LOCAL TIME ZONE data type allows...
Fractional seconds
Black
Implicit conversion
All caps

2. You use the __________ keyword to change characteristics of a column.
Committed
Non-matching rows
GROUP BY
MODIFY

3. The COUNT function uses the __________ wildcard.
Asterisk
IN ANY ALL SOME
Logical unit of work
Lists all objects accessible for the chosen database connection. Also lists a helpful dependencies report for accessing change impact.

4. Checks whether any value in the list makes the condition true.
ADD_MONTHS function
UTC
Common column value
Any

5. Write a solution that adds 20 minutes to a given date.
DICT_COLUMNS
DECODE
SELECT SYSDATE+1/96 - FROM dual
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

6. Which operator is most commonly used?
Mathematical equations
UNION
DROP INDEX need_to_pass_i
ROLLBACK

7. __________________ inserts the current date and time.
SYSDATE
COUNT(registration_date) - AVG (capacity) - MIN (capacity) - MAX (capacity)
Optional
The way NULL values are treated

8. NUMBER functions can be...
Self-joins
ON
Nested
COMMIT

9. Which one of the following string functions tells you how many characters are in a string?
UTC
LENGTH
FALSE
ROLLBACK

10. What does the following function return? SELECT LENGTH(NULL) - FROM dual
Common column value
Both MIN and MAX
Null
TO_CHAR function

11. To revert back to a state that happened before you ran your change statement - you issue a ____________ command.
VALUES clause of an INSERT statement
SUM
Control - Revoke - Define - TRUNCATE Manipulate - MERGE
ROLLBACK

12. What is the Oracle data dictionary called that contains a set of tables and views containing the data about the database?
All
ALL_OBJECTS
Leading-edge
GROUP BY

13. Which format mask displays December 31st - 1999?
MINUS
Month ddth - yyyy
ADD
BETWEEN

14. The NEXTVAL and CURRVAL pseudocolumns can be used in which of the following SQL constructs? Select all that apply.
VALUES clause of an INSERT statement
X
V$
INTERSECT

15. Write a statement that drops the index need_to_pass_i
Actual column
DICTIONARY
DROP INDEX need_to_pass_i
DICT_COLUMNS

16. The COUNT function is useful for determining whether a table has...
4
Data
Static or dynamic
ALL_OBJECTS

17. The __________ operator is inclusive of the two values specified.
Default is 14; when you use the default - you repeat the heading every 14 rows.
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
Month ddth - yyyy
BETWEEN

18. When column names on the tables are different - you use the ______ condition.
BETWEEN
ON
V$
ANY

19. A join across three tables can be expressed with the ________ join syntax.
All caps
Twice
ANSI
INNER JOIN

20. SQL Developer provides an extensive list of useful reports and offers the capability to create your own...
X
Orphan
RENAME - COPY - DROP - TRUNCATE - LOCK - & COMMENT
User-defined reports

21. SELECT * FROM instructor ORDER BY phone
VALUES
A correct statement
BETWEEN
Script

22. PAGESIZE
Any
Default is 14; when you use the default - you repeat the heading every 14 rows.
X
12:00:00 A.M

23. Subqueries can return...
DD-MON-YY
Leading-edge
INNER JOIN
Multiple rows

24. The _______ function lets you perform if-then-else functionality with the SQL language.
DECODE
Details
MINUS
V$

25. ___________ subqueries allow you to reference columns from the outer query and execute the inner query repeatedly
Committed
Combine
Correlated
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

26. The ALTER SESSION statement can change the session's...
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
Structured Query Language
GROUP BY
Time zone

27. If a graphical representation of a table's box has __________ it means that the relationship is identifying.
Self-joins
Business problems
X
Rounded edges

28. The ______ operator compares a list of values for equivalency
DROP INDEX need_to_pass_i
Three
99.99
ANY

29. _________________ relationships are always optional relationships.
Null
Scale
@ or START
Recursive

30. SQL*Plus is used more than SQL Developer when you need to...
Asterisk
INTERSECT
SET clause of an UPDATE statement
Run scripts

31. The using clause of the ANSI join syntax always assumes an...
Equijoin and identical column names
Twice
Null
SELECT SYSDATE+1/96 - FROM dual

32. What is the main difference between the NOT EXISTS and the NOT IN operators?
Committed
Twice
The way NULL values are treated
Null

33. To equijoin a table with another table involves matching the...
UNION
@ or START
Command determines the total number of characters SQL *Plus displays in on line before beginning a new line.
Common column value

34. A transaction is a...
Three
Committed
Logical unit of work
COUNT(registration_date) - AVG (capacity) - MIN (capacity) - MAX (capacity)

35. What is the command you would type into SQL*Plus if you needed to know the definition for each column of a 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
Implicit conversion
Retrieve
DICT_COLUMNS

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.
Has not changed the name
Precision
Same
Static or dynamic

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

38. The ROWID pseudocolumn is not an ________- but it acts like one.
Scalar
COMMIT
ANY
Actual column

39. List the reasons that a subquery could not be unnested.
Equijoin and correlated subquery
Command returns the number of records returned by a query.
X
Black

40. 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.
B-Tree Index
Precision
VALUES
Scalar

41. The Nonequijoin can use the ________________ operator to construct joins that are not based on equality of values.
SYSDATE
Results
BETWEEN
RIGHT LEFT JOIN

42. UNION ALL does not sort - therefore it is less time consuming to use than the...
UNION operator
Implicit conversion
999999.9999
Business problems

43. The TRUNC function on a date without a format model truncates the timestamp to...
SELECT SYSDATE+1/96 - FROM dual
12:00:00 A.M
Any
The way NULL values are treated

44. When using the following data: NUMBER(10 -4) - the # 4 is called the __________.
Scale
Details
ALL_OBJECTS
All

45. In SQL Developer field names and table names are shown in the color _______.
User-defined reports
Black
99.99
Any

46. 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.
ON
VALUES clause of an INSERT statement
FALSE
COUNT(registration_date) - AVG (capacity) - MIN (capacity) - MAX (capacity)

47. How many characters can you have using the VARCHAR data type?
4000
Default is 14; when you use the default - you repeat the heading every 14 rows.
Optional
MODIFY

48. Explain what is found in the All Objects report folder in SQL Developer
RIGHT LEFT JOIN
Lists all objects accessible for the chosen database connection. Also lists a helpful dependencies report for accessing change impact.
Orphan
Null

49. The ____________ clause on a CREATE TABLE statement can specify how much space to allocate.
When the table is small (unless your business rules require you too)
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
Non-matching rows
STORAGE

50. What is the most common DATE format found in SQL?
DD-MON-YY
Hide 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
BETWEEN

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