Question 1

You are defining the operational process of your RDBMS. Referring to the scenario above, which one of the following is a valid ongoing "operational process?"

technology databases

OS requirement
User analysis
Performance monitoring
Data dictionary specification
System requirement

Answer

Correct Option: C

Question 2

You have been asked to construct a query in the company's RDBMS. You have deployed a Right Outer Join operation. Referring to the scenario above, what will happen to the final results when there is NO match between the tables?

technology databases

The right table will return ALL rows.
The right table will return NULL.
Both tables will return NULL.
The left table will return ALL rows.
The left table will return NULL.

Answer

Correct Option: D

Question 3

Which phase of the data modeling process contains security review?

technology databases

Structure
Design issue
Data source
Storage issue
Operational process

Answer

Correct Option: B

Question 4

Which one of the following is NOT a characteristic of metadata?

technology databases

Data about data
Describes a data dictionary
Self-describing
Includes user data
Supports its own structure

Answer

Correct Option: D

Question 5

Which one of the following capabilities do you expect to see in a majority of RDBMS extensions to ANSI SQL-92?

technology databases

Encryption key management
Graphical User Interface Widgets
Thread creation, execution, & coordination
Network socket creation/operation
If/Then, for, do/while statements

Answer

Correct Option: E

Question 6

What can a mandatory one to one relationship indicate?

technology databases

More entities are needed.
The model should be denormalized.
The tables are not properly indexed.
The model cannot be implemented physically.
More attributes are needed.

Answer

Correct Option: E

Question 7

For performance, you denormalize your database design and create some redundant columns. Referring to the scenario above, what RDBMS construct can you use to automatically prevent the repeated columns from getting out of sync?

technology databases

Cursors
Constraints
Views
Stored procedures
Trigger

Answer

Correct Option: E

Question 8

You are running a query against a relational database. Referring to the scenario above, what clause or command do you use in the query to help avoid a costly tablescan?

technology databases

GROUP BY clause
INDEX command
HAVING clause
FROM clause
WHERE clause [/quote]

Answer

Correct Option: B

Question 9

The query performance increases by using NOT operator.

technology databases

True
False

Answer

Correct Option: B

Question 10

If there are 3 persons with last names JOHN, J and JAMES how many of them are included in the result set of the query "SELECT LAST_NAME FROM STAFF WHERE LAST_NAME BETWEEN 'A' AND 'J'"

technology databases

3
2
1
0

Answer

Correct Option: C

Question 11

NULL values are ingnored for all SQ: 2008 aggregate functions.

technology databases

True
False

Answer

Correct Option: A

Question 12

Which operators can be used to produce summary totals in the result sets of SQL 2008.

technology databases

GROUPING
WITH ROLL UP
WITH CUBE
WITH SUMMARY

Answer

Correct Option: B,C

Question 13

UNION ALL is faster than a UNION

technology databases

True
False

Answer

Correct Option: A

Question 14

The query performance increases by using NOT operator.

technology databases

True
False

Answer

Correct Option: B

Question 15

NULL values are ingnored for all SQL: 2008 aggregate functions.

technology databases

True
False

Answer

Correct Option: A

Question 16

Which one is single-row function

technology databases

STDDEV
VARIANCE
ROUND
COUNT

Answer

Correct Option: C

Question 17

which of this Operator Precedence is correct??

technology databases

- , + (Unary operators, negation)
- , / (Multiplication, division)
+, - , || (Addition, subtraction, concatenation)
NONE of these

Answer

Correct Option: A,B,C

Question 18

Which of these is NOT a inequality symbol ??

technology databases

!=
<>
=^
^=

Answer

Correct Option: C

Question 19

When you try to save 34567.2255 into a column defined as NUMBER(7,2) what value is actually saved?

technology databases

34567.00
34567.22
34567.23
3456.22

Answer

Correct Option: C

Question 20

What is the default display length of the DATE datatype column?

technology databases

8
9
6
16

Answer

Correct Option: B

Description: databases Online Quiz - 115
Number of Questions: 20
Created by: Aliensbrain Bot
Tags: databases

databases Online Quiz - 115

Find more quizzes from top tags