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. A calculation with a null always yields...
DROP INDEX need_to_pass_i
Another null
DECODE
VALUES

2. What is the main difference between the NOT EXISTS and the NOT IN operators?
Testing functions
The way NULL values are treated
Scale
SYSDATE

3. List 6 Table-Related Menu Choices
2000
FALSE
Logical unit of work
RENAME - COPY - DROP - TRUNCATE - LOCK - & COMMENT

4. To place a line comment in your SQL statements - you first place a // at the beginning of the line.
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
FALSE
Same
RIGHT LEFT JOIN

5. Explain how you can optimize your queries with subqueries and the main advantage of doing so.
2000
Business problems
Equijoin and identical column names
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

6. 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.
X
Same
LIKE

7. When using the following data: NUMBER(10 -4) - the # 10 is called the __________.
Precision
Semicolon or forward slash
Hide data
Has not changed the name

8. The _______ operator determines common rows.
DD-MON-YY
LIKE
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

9. You use the __________ keyword to change characteristics of a column.
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
Equijoin and correlated subquery
Implicit conversion
MODIFY

10. You can use the ________________ to subtract months from a given date.
DECODE
RIGHT LEFT JOIN
LENGTH
ADD_MONTHS function

11. Which format mask displays December 31st - 1999?
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
Month ddth - yyyy
IN ANY ALL SOME
Asterisk

12. When writing the syntax for finding information on three or more tables - the parenthesis around the ON clause is...
Both MIN and MAX
NATURAL JOIN
Semicolon or forward slash
Optional

13. List 4 aggregate functions
999999.9999
COUNT(registration_date) - AVG (capacity) - MIN (capacity) - MAX (capacity)
Any
Lists all objects accessible for the chosen database connection. Also lists a helpful dependencies report for accessing change impact.

14. The _____________ clause determines how rows are grouped.
NATURAL JOIN
GROUP BY
Business problems
RIGHT LEFT JOIN

15. SQL Developer's ____________________ option allows you to selectively export certain rows and columns.
INTERSECT
Export Data
User-defined reports
FALSE

16. A _____ is a query definition stored in the database that looks just like a table - but does not have any physical rows
Fractional seconds
X
DECODE
All

17. All SQL statements contained within a script must end with a _______________ - even if they are done in SQL Developer.
UNION operator
X
UNION
Semicolon or forward slash

18. Joins involving multiple columns must always follow the ____________ relationship path.
Primary key/foreign key
V$
Any
KEEP INDEX

19. The key that most database designers prefer and is chosen by the system is the _____________ key.
Static or dynamic
Has not changed the name
Surrogate
Hide data

20. What do views do that makes them so useful for security?
Hide data
CLOB
Lists all objects accessible for the chosen database connection. Also lists a helpful dependencies report for accessing change impact.
12:00:00 A.M

21. When you want to run a script in either SQL*Plus or SQL Developer - you can use a ______ or the _________ command.
@ or START
MODIFY
Orphan
ROLLBACK

22. The ______ depicts the M of a 1:M relationship.

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

23. _________ and __________ functions are opposites of each other and provide a value in a group of rows.
Correlated
NATURAL JOIN
Hide data
Both MIN and MAX

24. _________ rows are not allowed in the relational model.
99.99
Orphan
RENAME - COPY - DROP - TRUNCATE - LOCK - & COMMENT
UNION

25. SQL*Plus is used more than SQL Developer when you need to...
KEEP INDEX
Same
Run scripts
DICT_COLUMNS

26. It is considered good form to put all SQL commands in...
X
All caps
UTC
Implicit conversion

27. What is the tab in SQL Developer where data dictionary view information can be found?
Precision
Details
Any
Has not changed the name

28. The __________ operator is inclusive of the two values specified.
ADD
BETWEEN
Combine
SET clause of an UPDATE statement

29. LINESIZE
Equijoin
Twice
Command determines the total number of characters SQL *Plus displays in on line before beginning a new line.
Multiple rows

30. PAGESIZE
Default is 14; when you use the default - you repeat the heading every 14 rows.
ALL_OBJECTS
USER_ - ALL_ - DBA_ - and V$
All

31. The purpose of the HAVING clause is to eliminate___________.
Script
Groups
Structured Query Language
UTC

32. Explain the steps needed to run a script in SQL Developer
MODIFY
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.
Recursive
Another null

33. You can __________ DISTINCT and a GROUP BY clause in the same SELECT statement.
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
DD-MON-YY
Combine

34. What does SQL stand for?
Structured Query Language
12:00:00 A.M
The way NULL values are treated
Export Data

35. You use the _________ keyword to add columns or constraints to a table.
ANSI
ADD
**** 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
Twice

36. Write a solution that adds 20 minutes to a given date.
Retrieve
X
Non-matching rows
SELECT SYSDATE+1/96 - FROM dual

37. What does the following function return? SELECT LENGTH(NULL) - FROM dual
Null
UNION operator
BETWEEN
ON

38. List the steps performed by a correlated subquery.
**** 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
2000
All
KEEP INDEX

39. The query retrieves more than 5 to 15 percent of the rows
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.
999999.9999
The indexed column is part of an expression. In this case - consider creating a function-based index instead
Surrogate key

40. The ________ operator cannot compare against a list of values.
LIKE
Correlated
Results
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.

41. Self-joins are useful for performing comparisons and checking for ___________ in data.
Export 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
Inconsistencies
Lists all objects accessible for the chosen database connection. Also lists a helpful dependencies report for accessing change impact.

42. Explain how the SPOOL command is used and what program it can be used in.
Retrieve
Combine
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
Three

43. The time zone displacement value indicates the time difference from _______.
UTC
Common column value
Testing functions
Crow's foot

44. What is the name of the key automatically generated from a sequence?
Orphan
Fractional seconds
Surrogate key
Default is 14; when you use the default - you repeat the heading every 14 rows.

45. Comparison operators can compare multiple _________________.
ADD
When the table is small (unless your business rules require you too)
F12
Columns

46. The ___________ operator tests whether a matching row cannot be found.
Asterisk
X
SET clause of an UPDATE statement
Fractional seconds

47. When is it not a good idea to use an index?
Run scripts
Running a script file
When the table is small (unless your business rules require you too)
Equijoin and identical column names

48. Explain what a static data dictionary view is and how it is used
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.
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
Any

49. The _______ function adds values together for a group of rows.
Running a script file
Re-create
SUM
Both MIN and MAX

50. Another name for a data dictionary view is __________________ or _________________.
MODIFY
Static or dynamic
Common column value
INNER JOIN

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