Question 1

Cascade option is used

technology databases

disable dependent integrity constraint
deactivate an integrity constraint
both of above
none of above

Answer

Correct Option: A

Question 2

To View all constraint definition and name table used is

technology databases

sys_constraints
user_constraints
tab_constraints
col_constraints

Answer

Correct Option: B

Question 3

View column associated with the constraint names view used is

technology databases

user_tab_columns
user_cons_columns
user_sys_columns
all of above

Answer

Correct Option: B

Question 4

can we insert a record in dual?

technology databases

True
False

Answer

Correct Option: A

Question 5

Can a primary key contain more than one columns?

technology databases

True
False

Answer

Correct Option: A

Question 6

Which one among the following is more faster?

technology databases

IN
EXISTS
LIKE
EXIST

Answer

Correct Option: B

Question 7

Can we use a scalar data type as return type for CURSOR?

technology databases

True
False

Answer

Correct Option: B

Question 8

Can cursor variables be stored in PL/SQL tables?

technology databases

True
False

Answer

Correct Option: B

Question 9

Can a function take OUT parameters.?

technology databases

True
False

Answer

Correct Option: B

Question 10

Can the default values be assigned to actual parameters?

technology databases

True
False

Answer

Correct Option: A

Question 11

Can you use a commit statement within a database trigger?

technology databases

True
False

Answer

Correct Option: B

Question 12

Can we call a procedure from Anonymous PL/SQL block?

technology databases

True
False

Answer

Correct Option: A

Question 13

can we have more than one column of BLOB(data type to store images) in a table?

technology databases

True
False

Answer

Correct Option: B

Question 14

Which of the following can duplicate the structure and related objects of a database table?

technology databases

Copy table
Alter table
Export table
Generate DDL

Answer

Correct Option: D

Question 15

DB2 Cursor Stablity i) Cursor Stablity Leads to Higher concurency ii) Repeatable Read Leads to Higher consistency

technology databases

Both are True
i) Is Only True
ii) is only True
Neither is True

Answer

Correct Option: A

Question 16

DB2 Indexes i ) Unique Index can be created only on Primary Key. ii) Query will execute faster if predicates are applied on Indexed column.

technology databases

Both are True
i) Is Only True
ii) is only True
Neither is True

Answer

Correct Option: A

Question 17

DB2 Index Storate Format Indexes is Stored in

technology databases

B - Tree format
Hash Table
AVL Tree
Red Black Tree

Answer

Correct Option: A

Question 18

When do you open cursor before Fetching i) Cursor should always be Opened before Fetching ii) Fetch Operation cursor retrieves Only ONE row for every execution.

technology databases

Both are True
i) Is Only True
ii) is only True
Neither is True

Answer

Correct Option: A

Question 19

Two or more transactions in a simultaneous wait state, each waiting for other to release before it can proceed, is called

technology databases

Lost Update
uncommitted dependency
infinite loop
Deadlock
With hold

Answer

Correct Option: D

Question 20

Which of the following is TRUE about Primary Key?

technology databases

Same value of Primary Key can appear in more than one row in the table
A Primary key defined column can be of type LONG
A column that is defined as Primary Key cannot contain NULL value.
Both A. and B.

AI Explanation

AI 1

To answer this question, you need to understand the concept of a primary key.

A primary key is a column or a set of columns that uniquely identifies each row in a table. It helps maintain data integrity and ensures that there are no duplicate or null values in the primary key column(s).

Let's go through each option to understand why it is correct or incorrect:

Option A) Same value of Primary Key can appear in more than one row in the table - This option is incorrect because a primary key must have unique values for each row in the table. Having the same value of a primary key in more than one row would violate the uniqueness constraint of the primary key.

Option B) A Primary key defined column can be of type LONG - This option is incorrect because a primary key column cannot be of type LONG. The primary key column must have a data type that supports uniqueness and indexing, such as integer, character, or date types.

Option C) A column that is defined as Primary Key cannot contain NULL value - This option is correct. A primary key column cannot contain NULL values. NULL represents the absence of a value, and the primary key must have a value in order to uniquely identify each row in the table. Therefore, a primary key column must have a non-null value.

Option D) Both A. and B. - This option is incorrect because option A is incorrect. The same value of a primary key cannot appear in more than one row in the table.

The correct answer is C) A column that is defined as Primary Key cannot contain NULL value. This option is correct because a primary key column must have a non-null value.

Answer

Correct Option: C

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

databases Online Quiz - 121

AI Explanation

Find more quizzes from top tags