SUBJECTS
|
BROWSE
|
CAREER CENTER
|
POPULAR
|
JOIN
|
LOGIN
Business Skills
|
Soft Skills
|
Basic Literacy
|
Certifications
About
|
Help
|
Privacy
|
Terms
|
Email
Search
Test your basic knowledge |
Oracle SQL
Start Test
Study First
Subjects
:
oracle
,
it-skills
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?
Let me suggest you:
Browse all subjects
Browse all tests
Most popular tests
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
Browse all subjects
Browse all tests
Most popular tests