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. It is considered good form to put all SQL commands in...
@ or START
SELECT DISTINCT menu FROM restaurant
All caps
KEEP INDEX

2. When returning multiple rows - a subquery must contain the _____ - _____ - _____ - or ______ operator - otherwise Oracle will return an error
ALL_OBJECTS
IN ANY ALL SOME
RENAME - COPY - DROP - TRUNCATE - LOCK - & COMMENT
Retrieve

3. To place a line comment in your SQL statements - you first place a // at the beginning of the line.
Precision
FALSE
Rounded edges
+

4. List the reasons that a subquery could not be unnested.
X
99.99
VALUES clause of an INSERT statement
Command determines the total number of characters SQL *Plus displays in on line before beginning a new line.

5. What is the Oracle data dictionary called that contains a set of tables and views containing the data about the database?
VALUES
The way NULL values are treated
LIKE
ALL_OBJECTS

6. Joins involving multiple columns must always follow the ____________ relationship path.
Semicolon or forward slash
The way NULL values are treated
Primary key/foreign key
Hide data

7. SQL Developer provides an extensive list of useful reports and offers the capability to create your own...
RENAME - COPY - DROP - TRUNCATE - LOCK - & COMMENT
DESC dict;
User-defined reports
Extra spaces

8. The RTRIM function is useful for eliminating ________ in a string.
Extra spaces
CLOB
Nested
Time zone

9. The ____________ icon allows you to execute multiple statements and emulates SQL *Plus as much as possible.
RUN SCRIPT
Surrogate key
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.
Equijoin and identical column names

10. You use the __________ keyword to change characteristics of a column.
Lists all objects accessible for the chosen database connection. Also lists a helpful dependencies report for accessing change impact.
COMMIT
SYSDATE
MODIFY

11. The DUAL table can be used for...
V$
Testing functions
ALL_OBJECTS
MINUS

12. Explain Flashback queries and how they are used. Give an example of a FLASHBACK_TRANSACTION query and explain what it does row by row.

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

13. A _____ is a query definition stored in the database that looks just like a table - but does not have any physical rows
SELECT DISTINCT menu FROM restaurant
Same
X
ALL_OBJECTS

14. List the different types of data dictionary views.
F12
Combine
USER_ - ALL_ - DBA_ - and V$
UNION operator

15. 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?
X
SYSDATE
DICTIONARY
VALUES clause of an INSERT statement

16. The COUNT function is useful for determining whether a table has...
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.
A correct statement
All caps
Data

17. What are the main components of a ROWID?
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.
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
A correct statement

18. Explain the steps needed to run a script in SQL Developer
V$
ON
DROP INDEX need_to_pass_i
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.

19. What is Oracle's most popular index storage structure?
B-Tree Index
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 identical column names
LIKE

20. How many characters can be stored in the CHAR column/field?
Extra spaces
2000
ON
Rounded edges

21. Checks whether any value in the list makes the condition true.
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.
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
IN ANY ALL SOME

22. What is the name of the key automatically generated from a sequence?
RUN SCRIPT
DD-MON-YY
Null
Surrogate key

23. When disabling a unique or primary key - you can keep the index if you specify the __________________ clause in the ALTER TABLE statement.
DECODE
Scalar
All caps
KEEP INDEX

24. All SQL statements contained within a script must end with a _______________ - even if they are done in SQL Developer.
Static or dynamic
DESC dict;
Semicolon or forward slash
X

25. ____________ are useful for analyzing and exploring the relationships within your data
Another null
Self-joins
UNION operator
UNION

26. List 4 aggregate functions
Hide data
KEEP INDEX
Scalar
COUNT(registration_date) - AVG (capacity) - MIN (capacity) - MAX (capacity)

27. To restart a sequence at a lower number - you can drop and ________ the sequence.
DROP INDEX need_to_pass_i
Optional
Re-create
Correlated

28. SQL*Plus is used more than SQL Developer when you need to...
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
Another null
Run scripts
Testing functions

29. What is the maximum value for a column defined as NUMBER(4 -2)?
99.99
ROLLBACK
+
Committed

30. Which format mask displays December 31st - 1999?
Common column value
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.
Month ddth - yyyy
ANSI

31. A transaction is a...
ADD_MONTHS function
ADD
Logical unit of work
MODIFY

32. When using the data NUMBER(10 -4) there will be _______ digits following the decimal point.
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
Another null
4
ON

33. The _______ function lets you perform if-then-else functionality with the SQL language.
DECODE
Equijoin and identical column names
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.
RIGHT LEFT JOIN

34. Information that is returned after you run your statement are found in the __________ tab in SQL Developer.
Results
B-Tree Index
99.99
DICT_COLUMNS

35. In a view you can give a column a different name than it has in the...
Parent table
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
Running a script file
Groups

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

37. Explain how Oracle treats locks when a database is being updated and needs to be viewed by other users.
GROUP BY
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
X
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

38. A join across three tables can be expressed with the ________ join syntax.
Re-create
ANSI
RIGHT LEFT JOIN
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

39. The _____________ clause determines how rows are grouped.
GROUP BY
CLOB
SUM
Any

40. Write a statement that drops the index need_to_pass_i
Equijoin and identical column names
KEEP INDEX
Any
DROP INDEX need_to_pass_i

41. Explain what is found in the All Objects report folder in SQL Developer
Testing functions
Groups
Non-matching rows
Lists all objects accessible for the chosen database connection. Also lists a helpful dependencies report for accessing change impact.

42. An outer join includes the result rows returned by an __________ plus extra rows where no matches are found.
Equijoin
DICTIONARY
Correlated
SELECT DISTINCT menu FROM restaurant

43. The ALTER SESSION statement can change the session's...
MINUS
RENAME just_two_more_weeks TO finally_i
LENGTH
Time zone

44. Dynamic views begin with a ___________.
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.
V$
COUNT(registration_date) - AVG (capacity) - MIN (capacity) - MAX (capacity)
Equijoin and correlated subquery

45. Subqueries can return...
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.
Correlated
Multiple 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.

46. The ____________ keywords and the USING clause of the ANSI join syntax are mutually exclusive.
NATURAL JOIN
Three
Testing functions
Surrogate

47. When is it not a good idea to use an index?
A correct statement
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 the table is small (unless your business rules require you too)
Has not changed the name

48. The same function can be used ______ in a SELECT statement.
CLOB
Twice
ALL_OBJECTS
FALSE

49. What is the tab in SQL Developer where data dictionary view information can be found?
Orphan
12:00:00 A.M
Details
2000

50. Comparison operators can compare multiple _________________.
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.
Columns
SELECT DISTINCT menu FROM restaurant

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