IBM DB2 Database Quiz

Approved & Edited by ProProfs Editorial Team

The editorial team at ProProfs Quizzes consists of a select group of subject experts, trivia writers, and quiz masters who have authored over 10,000 quizzes taken by more than 100 million users. This team includes our in-house seasoned quiz moderators and subject matter experts. Our editorial experts, spread across the world, are rigorously trained using our comprehensive guidelines to ensure that you receive the highest quality quizzes.

Learn about Our Editorial Process

| By Stephanie Young

Stephanie Young

Community Contributor

Quizzes Created: 85 | Total Attempts: 63,576

Questions: 10 | Attempts: 541 | Updated: Aug 27, 2023

Questions

Settings

Create your own Quiz

Share on Facebook Share on Twitter Share on Whatsapp Share on Pinterest Share on Email Copy to Clipboard Embed on your website

Welcome to this informative IBM DB2 Database quiz. IBM DB2 is a product that was developed by IBM. The most amazing part about this product is that it works on a relational model. Take this quiz, it's going to improve and ascertain your knowledge. Please make sure to read all the questions very carefully before attempting. Your scores will be reflected once the quiz is completed. You can take this quiz as many times as you like. There is no specific time limit. We wish you Good Luck!

Questions and Answers

1.

In which mode of Command Line Processor (CLP) must each command and SQL statements be prefixed by "db2"?
- A.
  
  Output mode
- B.
  
  Batch mode
- C.
  
  Command mode
- D.
  
  Interactive input mode
Correct Answer
C. Command mode

Explanation
In Command mode of Command Line Processor (CLP), each command and SQL statement must be prefixed by "db2". This mode allows the user to directly interact with the CLP and execute commands and SQL statements. By prefixing the commands and SQL statements with "db2", the CLP recognizes them as valid inputs and processes them accordingly. This mode is commonly used when executing individual commands or SQL statements in a sequential manner.

Rate this question:
2.

For DB2 Database Server, the default instance is:
- A.
  
  IBM2
- B.
  
  IBM1
- C.
  
  DB1
- D.
  
  DB2
Correct Answer
D. DB2

Explanation
The default instance for the DB2 Database Server is DB2.

Rate this question:
3.

Which of these expressions means no rows found?
- A.
  
  +101
- B.
  
  -101
- C.
  
  +100
- D.
  
  -100
Correct Answer
C. +100

Explanation
The expression "+100" means no rows found. In SQL, a positive number is often used to represent the number of rows affected or returned by a query. In this case, the "+100" expression implies that there are no rows affected or returned, indicating that no rows were found.

Rate this question:
4.

The SQL return code "0" means:
- A.
  
  Successful execution
- B.
  
  Unsuccessful execution
- C.
  
  Error information
- D.
  
  Empty rows and columns
Correct Answer
A. Successful execution

Explanation
The SQL return code "0" indicates that the execution of the SQL statement was successful. This means that the query was executed without any errors or issues, and it returned the expected results.

Rate this question:
5.

The following are constraints types except
- A.
  
  NOT NULL
- B.
  
  Unique
- C.
  
  Conditional
- D.
  
  Information
Correct Answer
A. NOT NULL

Explanation
The given answer is "NOT NULL" because it is not a type of constraint. The other options listed - Unique, Conditional, and Information - are all types of constraints that can be used in a database. NOT NULL is not a constraint type, but rather a property that can be applied to a column in a table to specify that the column must have a value and cannot be left empty.

Rate this question:
6.

A set of columns in a table which are required to match at least one primary key of a row in another table is
- A.
  
  Primary key
- B.
  
  Foreign key
- C.
  
  Unique
- D.
  
  Informational
Correct Answer
B. Foreign key

Explanation
A foreign key is a set of columns in a table that are required to match at least one primary key of a row in another table. It establishes a relationship between two tables by referencing the primary key of one table in another table. This ensures data integrity and allows for the creation of meaningful relationships between tables in a database.

Rate this question:
7.

The syntax for creating a sequence is
- A.
  
  Ibm sequence
- B.
  
  Db2 sequence
- C.
  
  Ibm create sequence
- D.
  
  Db2 create sequence
Correct Answer
D. Db2 create sequence

Explanation
The correct answer is "db2 create sequence" because it follows the syntax for creating a sequence. The "db2" keyword indicates that the sequence is being created in a DB2 database, and the "create sequence" command is used to create a new sequence in the database. The other options, "Ibm sequence" and "Ibm create sequence," do not follow the correct syntax and are therefore incorrect.

Rate this question:
8.

What is the physical storage length of DATE data type?
- A.
  
  20 bytes
- B.
  
  10 bytes
- C.
  
  4 bytes
- D.
  
  3 bytes
Correct Answer
C. 4 bytes

Explanation
The physical storage length of the DATE data type is 4 bytes. This means that when a date is stored in a database, it will take up 4 bytes of storage space. This is a relatively small amount of storage compared to other data types, such as strings or integers, which can take up more space. The 4 bytes are used to store the date in a specific format that allows for efficient storage and retrieval of date values.

Rate this question:
9.

What does a positive SQL code indicates?
- A.
  
  Exception
- B.
  
  Failure
- C.
  
  Success
- D.
  
  None of the above
Correct Answer
A. Exception

Explanation
A positive SQL code typically indicates an exception. In SQL, codes are used to indicate the success or failure of a statement or operation. A positive code usually signifies that an exception or error has occurred during the execution of the SQL statement. This could be due to various reasons such as invalid syntax, constraint violations, or data manipulation issues. Therefore, a positive SQL code generally suggests that there was an exception or error encountered while processing the SQL statement.

Rate this question:
10.

Which table space houses only one table?
- A.
  
  Partitioned Table space
- B.
  
  Segmented Table space
- C.
  
  Simple Table space
- D.
  
  All of the above
Correct Answer
A. Partitioned Table space

Explanation
A partitioned table space is a type of table space that is divided into multiple partitions, each of which can hold a subset of the data in the table. Each partition can be stored on a different storage device or in a different location. This allows for better performance and manageability of large tables. In contrast, segmented table spaces and simple table spaces do not have the concept of partitions and can house multiple tables. Therefore, the correct answer is partitioned table space.

Rate this question: