0

databases Online Quiz - 242

Description: databases Online Quiz - 242
Number of Questions: 20
Created by:
Tags: databases
Attempted 0/20 Correct 0 Score 0
  1. By value

  2. By reference

  3. By type

  4. none of the above


Correct Option: A
  1. Real abstarct clusters

  2. Real application cursors

  3. Real application clusters

  4. none of the above


Correct Option: C

One Terabyte equals to

  1. 10 ^ 6

  2. 10 ^ 9

  3. 10 ^ 12

  4. 10 ^ 15


Correct Option: C

Predefined, stored set of SQL statements is called Macro

  1. True

  2. False


Correct Option: A

The output of the hashing algorithm is called the hash synonyms

  1. True

  2. False


Correct Option: B

MAX. NO OF ROWS PER PAGE?

  1. 127

  2. 136

  3. 100

  4. 38


Correct Option: A

What is the size of a data page?

  1. 5K to 10K

  2. 4K to 8K

  3. 4K to 10K

  4. 3K to 9K


Correct Option: B

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

  1. TWO

  2. ONE

  3. FIVE

  4. EIGHT


Correct Option: B

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

  1. Twenty

  2. Eight

  3. Fifteen

  4. Six


Correct Option: C

AI Explanation

To answer this question, we need to understand the concept of joining tables in a database.

When working with databases, it is possible to join multiple tables together based on a common column or key. This allows us to combine data from different tables into a single result set.

The maximum number of tables that can be joined depends on the database system and its limitations. However, in general, there is no hard limit on the number of tables that can be joined in a single query.

Therefore, none of the options given (A, B, C, or D) accurately represents the maximum number of tables that can be joined.

Can I use DB2 Stored Procedures with Debug Tool?

  1. True

  2. False


Correct Option: A

When you COMMIT, is the cursor closed?

  1. True

  2. False


Correct Option: A

Is DECLARE CURSOR Executable?

  1. True

  2. False


Correct Option: B

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

  1. True

  2. False


Correct Option: A

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

  1. 10 Bytes

  2. 3 Bytes

  3. 8 Bytes

  4. 15 Bytes


Correct Option: A

AI Explanation

To answer this question, you need to understand the physical storage length of the TIMESTAMP data type in DB2.

Option A) 10 Bytes - This option is correct. The physical storage length of the TIMESTAMP data type in DB2 is 10 bytes. The TIMESTAMP data type represents a date and time value, including the fractional seconds. It requires 10 bytes of storage to store the date, time, and fractional seconds.

Option B) 3 Bytes - This option is incorrect. The physical storage length of the TIMESTAMP data type in DB2 is not 3 bytes.

Option C) 8 Bytes - This option is incorrect. The physical storage length of the TIMESTAMP data type in DB2 is not 8 bytes.

Option D) 15 Bytes - This option is incorrect. The physical storage length of the TIMESTAMP data type in DB2 is not 15 bytes.

The correct answer is Option A) 10 Bytes. This option is correct because the physical storage length of the TIMESTAMP data type in DB2 is indeed 10 bytes.

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

  1. 2 Bytes

  2. 4 Bytes

  3. 8 Bytes

  4. 6 Bytes


Correct Option: B

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

  1. 20090525

  2. Error

  3. 2009-may-25

  4. may-25-2009


Correct Option: B
- Hide questions