Question 1

Which of the query will print the output as 'TCS' (single quotes should come in the output)

technology databases

select ' ' ' || 'TCS' || ' ' ' from dual
select ' ' 'TCS' ' ' from dual
select 'TCS' from dual
select "TCS" from dual

Answer

Correct Option: B

Question 2

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 3

Which view contains details about locked objects ?

technology databases

v$lock
v$user_objects
v$locked_object
v$session

Answer

Correct Option: C

Question 4

A new table has been created in the employee. There are no rows in the table.What would be the output of the query?select count(*) from employee

technology databases

No data found
Error
1
0

Answer

Correct Option: D

Question 5

select INSTR('TCS_SQL','S',4) from dual;

technology databases

3
6
5
4

Answer

Correct Option: C

Question 6

MAX. NO OF ROWS PER PAGE?

technology databases

127
136
38
16

Answer

Correct Option: A

Question 7

What is the size of a data page?

technology databases

4K to 8K
4K to 10K
5K to 10K
5K to 15K

Answer

Correct Option: A

Question 8

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 9

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

technology databases

Twenty
Eight
Fifteen
Six

Answer

Correct Option: C

Question 10

Can I use DB2 Stored Procedures with Debug Tool?

technology databases

True
False

Answer

Correct Option: A

Question 11

When you COMMIT, is the cursor closed?

technology databases

True
False

Answer

Correct Option: A

Question 12

Is DECLARE CURSOR Executable?

technology databases

True
False

Answer

Correct Option: B

Question 13

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

technology databases

True
False

Answer

Correct Option: A

Question 14

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

technology databases

10 bytes
2 bytes
5 bytes
4 bytes

Answer

Correct Option: A

Question 15

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 16

Select odd item from the list.

technology databases

VARCHAR2
CHAR
NCHAR
VARCHAR

Answer

Correct Option: D

Question 17

Following datatype cannot be used twice in a table.

technology databases

NCHAR
LONG
INTEGER
TIMESTAMP

Answer

Correct Option: B

Question 18

CHAR is not compatible with.

technology databases

NCHAR
DATE
VARCHAR2
BLOB

Answer

Correct Option: D

Question 19

Which one is PL/SQL (but not SQL) datatype

technology databases

LONG
NUMBER
INTEGER
REF

Answer

Correct Option: C

Question 20

Select all ANSI supported datatypes.

technology databases

CHARACTER
NUMBER
INTEGER
REAL

Answer

Correct Option: A,C,D

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

databases Online Quiz - 241

Find more quizzes from top tags