• databases Online Quiz - 242
Back
0

databases Online Quiz - 242

Description: databases Online Quiz - 242
Number of Questions: 20
Created by:
Tags: databases
Start the Quiz
Attempted 0/20 Correct 0 Score 0
‹
›

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

technology databases

  1. DROP

  2. DELETE

  3. REMOVE

  4. TRUNCATE

Show answer
Correct Option: D

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

technology databases

  1. By value

  2. By reference

  3. By type

  4. none of the above

Show answer
Correct Option: A

What is RAC
technology databases

  1. Real abstarct clusters

  2. Real application cursors

  3. Real application clusters

  4. none of the above

Show answer
Correct Option: C

One Terabyte equals to
technology databases

  1. 10 ^ 6

  2. 10 ^ 9

  3. 10 ^ 12

  4. 10 ^ 15

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

Absence of value is NULL

technology databases

  1. True

  2. False

Show answer
Correct Option: A

Predefined, stored set of SQL statements is called Macro

technology databases

  1. True

  2. False

Show answer
Correct Option: A

Parsing engine Manages and retrieves data from disk storage

technology databases

  1. True

  2. False

Show answer
Correct Option: B

A user will always have a password

technology databases

  1. True

  2. False

Show answer
Correct Option: A

The output of the hashing algorithm is called the hash synonyms

technology databases

  1. True

  2. False

Show answer
Correct Option: B

MAX. NO OF ROWS PER PAGE?

technology databases

  1. 127

  2. 136

  3. 100

  4. 38

Show answer
Correct Option: A

What is the size of a data page?

technology databases

  1. 5K to 10K

  2. 4K to 8K

  3. 4K to 10K

  4. 3K to 9K

Show answer
Correct Option: B

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

technology databases

  1. TWO

  2. ONE

  3. FIVE

  4. EIGHT

Show answer
Correct Option: B

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

technology databases

  1. Twenty

  2. Eight

  3. Fifteen

  4. Six

Show answer
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?

technology databases

  1. True

  2. False

Show answer
Correct Option: A

When you COMMIT, is the cursor closed?
technology databases

  1. True

  2. False

Show answer
Correct Option: A

Is DECLARE CURSOR Executable?

technology databases

  1. True

  2. False

Show answer
Correct Option: B

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

technology databases

  1. True

  2. False

Show answer
Correct Option: A

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

technology databases

  1. 10 Bytes

  2. 3 Bytes

  3. 8 Bytes

  4. 15 Bytes

Show answer
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?
technology databases

  1. 2 Bytes

  2. 4 Bytes

  3. 8 Bytes

  4. 6 Bytes

Show answer
Correct Option: B

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

  1. 20090525

  2. Error

  3. 2009-may-25

  4. may-25-2009

Show answer
Correct Option: B
- Hide questions
ADVERTISEMENT

Find more quizzes from top tags

general knowledge
3615 Quizzes
119858 Questions
 technology
307 Quizzes
36705 Questions
 sports
963 Quizzes
19148 Questions
 history
1187 Quizzes
13475 Questions
 physics
598 Quizzes
13441 Questions
 biology
1160 Quizzes
12174 Questions
 science & technology
551 Quizzes
11015 Questions
 chemistry
490 Quizzes
9892 Questions
 maths
518 Quizzes
9324 Questions
 softskills
0 Quizzes
7131 Questions