Question 1

Which datatype you use to store a large block of text data having size around 3,500 characters in length ?

technology databases

CLOB
BLOB
BFILE
VARCHAR2

Answer

Correct Option: D

Question 2

Which of the following are transactional control commands? A.COMMIT B.UPDATE C.SAVEPOINT D.SET TRANSACTIONS

technology databases

COMMIT
UPDATE
SAVEPOINT
SET TRANSACTIONS

Answer

Correct Option: A,C,D

Question 3

The scale of a numeric value is the total length allowed for values.

technology databases

True
False

Answer

Correct Option: B

Question 4

Having no duplicate or redundant data in a database and having everything in the database normalized is always the best way to go.

technology databases

True
False

Answer

Correct Option: B

Question 5

If you have committed several transactions and have several more transactions that have not been committed and you issue a rollback command, all your transactions for the same session will be undone.

technology databases

True
False

Answer

Correct Option: B

Question 6

A SAVEPOINT actually saves transactions after a specified amount of transactions have executed.

technology databases

True
False

Answer

Correct Option: B

Question 7

The AVG function returns an average of all rows from a select column including any NULL values.

technology databases

True
False

Answer

Correct Option: B

Question 8

You must also use the GROUP BY clause whenever using the HAVING clause.

technology databases

True
False

Answer

Correct Option: B

Question 9

The HAVING clause tells the GROUP BY which groups to include.

technology databases

True
False

Answer

Correct Option: A

Question 10

The main reason for a composite index is for aggregate function usage in an index.

technology databases

True
False

Answer

Correct Option: B

Question 11

What type of join would you use to return records from one table, regardless of the existence of associated records in the related table?

technology databases

OUTER JOIN
RIGHT JOIN
INNER JOIN
LEFT JOIN

Answer

Correct Option: A

Question 12

Which of the following statements about roles are true?

technology databases

Roles can be granted to other roles
Privileges can be granted to roles
Roles can be granted to synonyms
Roles can be granted to users

Answer

Correct Option: A,B,D

Question 13

Which of the following dictionary views gives information about the position of a column in a primary key?

technology databases

ALL_PRIMARY_KEYS
ALL_TABLES
ALL_IND_COLUMNS
USER_CONSTRAINTS

Answer

Correct Option: C

Question 14

Which of the following is the transaction control that prevents more than one user from updating data in a table?

technology databases

Commits
Locks
Savepoints
Rollbacks

Answer

Correct Option: B

Question 15

Which of the following methods should you use to increase the number of nullable columns for a table?

technology databases

Use the alter table statement
Ensure that all column values are NULL for all rows
First, increase the size of adjacent column datatypes, and then add the column
Add the column, populate the column, and then add the not NULL constraint

Answer

Correct Option: A

Question 16

Once defined, how long will a variable remain defined in SQL*Plus?

technology databases

Until the database is shut down
Until the instance is shut down
Until the statement completes
Until the session completes

Answer

Correct Option: D

Question 17

Which of the following product will not accept remote database request?

technology databases

DB2 UDB WSUE
DB2 UDB PE
DB2 UDB WSE
DB2 UDB ESE

Answer

Correct Option: B

Question 18

Which of the following does DB2 Configuration Advisor recommend?

technology databases

SQL statements
Views
DDL
Database configuration parameter settings

Answer

Correct Option: D

Question 19

What is the prefix key for executing an OS command in the DB2 CLP?

technology databases

&
%
!
@

Answer

Correct Option: C

Question 20

Which of the following tool allows you to display data of a table?

technology databases

Task Center
Command Center
Health Center
All of above

Answer

Correct Option: B

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

databases Online Quiz - 203

Find more quizzes from top tags