Question 1

Which command will delete all data from a table and will not write to the rollback segment?

technology databases

DROP
DELETE
REMOVE
TRUNCATE

Answer

Correct Option: D

Question 2

What is the default behaviour of OUT parameter mode in PL/SQL

technology databases

By value
By reference
By type
none of the above

Answer

Correct Option: A

Question 3

What is RAC

technology databases

Real abstarct clusters
Real application cursors
Real application clusters
none of the above

Answer

Correct Option: C

Question 4

One Terabyte equals to

technology databases

10 ^ 6
10 ^ 9
10 ^ 12
10 ^ 15

Answer

Correct Option: C

Question 5

Absence of value is NULL

technology databases

True
False

Answer

Correct Option: A

Question 6

Predefined, stored set of SQL statements is called Macro

technology databases

True
False

Answer

Correct Option: A

Question 7

Parsing engine Manages and retrieves data from disk storage

technology databases

True
False

Answer

Correct Option: B

Question 8

A user will always have a password

technology databases

True
False

Answer

Correct Option: A

Question 9

The output of the hashing algorithm is called the hash synonyms

technology databases

True
False

Answer

Correct Option: B

Question 10

MAX. NO OF ROWS PER PAGE?

technology databases

127
136
100
38

Answer

Correct Option: A

Question 11

What is the size of a data page?

technology databases

5K to 10K
4K to 8K
4K to 10K
3K to 9K

Answer

Correct Option: B

Question 12

What is the maximum number of tables that can be stored on a Partitioned Table Space?

technology databases

TWO
ONE
FIVE
EIGHT

Answer

Correct Option: B

Question 13

What is the maximum number of tables that can be joined?

technology databases

Twenty
Eight
Fifteen
Six

Answer

Correct Option: C

Question 14

Can I use DB2 Stored Procedures with Debug Tool?

technology databases

True
False

Answer

Correct Option: A

Question 15

When you COMMIT, is the cursor closed?

technology databases

True
False

Answer

Correct Option: A

Question 16

Is DECLARE CURSOR Executable?

technology databases

True
False

Answer

Correct Option: B

Question 17

Can you have more than one cursor open at any one time in a program?

technology databases

True
False

Answer

Correct Option: A

Question 18

What is the Physical Storage Length of TIMESTAMP DB2 data type?

technology databases

10 Bytes
3 Bytes
8 Bytes
15 Bytes

Answer

Correct Option: A

Question 19

What is the Physical Storage Length of DATE DB2 data type?

technology databases

2 Bytes
4 Bytes
8 Bytes
6 Bytes

Answer

Correct Option: B

Question 20

What's the output select to_Date('2009-may-25','yyyymmdd') from dual

technology databases

20090525
Error
2009-may-25
may-25-2009

Answer

Correct Option: B

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

databases Online Quiz - 242

Find more quizzes from top tags