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

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

  1. By value

  2. By reference

  3. By type

  4. none of the above


Correct Option: A

What is RAC

  1. Real abstarct clusters

  2. Real application cursors

  3. Real application clusters

  4. none of the above


Correct Option: C
  1. 10 ^ 6

  2. 10 ^ 9

  3. 10 ^ 12

  4. 10 ^ 15


Correct Option: C
Explanation:

To solve this question, the user needs to know the basic unit of digital storage and its prefixes.

The basic unit of digital storage is a bit, which is represented by either a 0 or a 1. A byte is a group of 8 bits. The prefixes used to represent large amounts of bytes are kilo, mega, giga, and tera.

Now, let's go through each option and explain why it is right or wrong:

A. 10^6: This option is incorrect. One megabyte (MB) is equal to 10^6 bytes. One terabyte (TB) is equal to 10^12 bytes, which is a much larger quantity than 10^6.

B. 10^9: This option is incorrect. One gigabyte (GB) is equal to 10^9 bytes. One terabyte (TB) is equal to 10^12 bytes, which is a much larger quantity than 10^9.

C. 10^12: This option is correct. One terabyte (TB) is equal to 10^12 bytes. This is a very large quantity of data, and is often used to represent the storage capacity of hard drives and other digital storage devices.

D. 10^15: This option is incorrect. One petabyte (PB) is equal to 10^15 bytes. One terabyte (TB) is a much smaller quantity of data than 10^15 bytes.

Therefore, the answer is: C. 10^12

Predefined, stored set of SQL statements is called Macro

  1. True

  2. False


Correct Option: A

Parsing engine Manages and retrieves data from disk storage

  1. True

  2. False


Correct Option: B

A user will always have a password

  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

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

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 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