Db2 Mock Test Quiz

10 Questions | By Sharmiladevi | Last updated: Mar 22, 2022 | Total Attempts: 601

Questions

Settings

Create your own Quiz

Questions and Answers

1.

ENTITY INTEGRITY is a state where column that is part of a primary key can have null values.
- A.
  
  True
- B.
  
  False
2.

. SQLCODE -922 is for authorization failure
- A.
  
  True
- B.
  
  False
3.

We Can use MAX on a CHAR column
- A.
  
  True
- B.
  
  False
4.

Every SQL statement is executable.
- A.
  
  True
- B.
  
  False
5.

SUBSTR(CUSTNAME,1,3) will extract 1st 3 character from CUSTNAME string
- A.
  
  True
- B.
  
  False
6.

Which of the following DB2 objects allows multiple users to access data in a table with each only being able to access certain portions of the data?
- A.
  
  Views
- B.
  
  Aliases
- C.
  
  Indexes
7.

Which one of the following is NOT a DB2 object?
- A.
  
  Synonym
- B.
  
  Table
- C.
  
  Column
8.

What does a positive value of SQL code mean?
- A.
  
  Error
- B.
  
  Successful execution
- C.
  
  No rows found
9.

AUTOMATIC RECOMPILATION occurs when
- A.
  
  A existing index is dropped.
- B.
  
  A new index is created.
- C.
  
  Both (A) and (B).
10.

The final result of a DB2 BIND is
- A.
  
  Data Base Request Module
- B.
  
  DB2 (application) Plan
- C.
  
  DB2 catalog

Related Topics

More Mock Test Quizzes

Pspo 1 Mock Test - Open Assessment

We have this Pspo 1 Mock Test - Open Assessment quiz for you to test your knowledge and understanding of the subject. There are average level as well as difficult level questions included in the quiz. Do you think you will be...

Questions: 10 | Attempts: 10773 | Last updated: Apr 3, 2022

Sample Question
A Product Owner is entitled to postpone the start of a new Sprint after the conclusion of a previous Sprint for the following reason:

Not enough Product Backlog items are "Ready".

The Product Owner has not identified a Sprint Goal.

There is no acceptable reason. A new Sprint starts immediately after the conclusion of the previous Sprint.

The QA department needs more time to make the previous Increment “Done.”

The stakeholders are not happy with the value produced in the previous Sprint.

Bsnl Tta Online Mock 1

BSNL TTA Online Mock 1 The Questions give you a fair idea of the BSNL TTA Exam Question Paper Pattern and help you prepare better.The written examination consists of objective type paper including 3 parts that...

Questions: 20 | Attempts: 8831 | Last updated: Mar 21, 2022

Sample Question
Which one of the following is not a permanent magnetic material ?

Chromium Steel

Silicon Iron

Cobalt Steel

Alnico

Psc Repeated Questions : Mock Test (Quiz) 2

The quiz below is a set of simple and short-ended questions, which have been repeated in previous exams. They will help in your revision and also advance your knowledge. Take it up and see how it goes. All the best!

Questions: 10 | Attempts: 5709 | Last updated: Mar 21, 2022