Db2 Mock Test 3

10 Questions | By Sharmiladevi | Last updated: Mar 20, 2022 | Total Attempts: 1806

Questions

Settings

Create your own Quiz

Questions and Answers

1.

What is the collection of data designed to be used by different people is called
- A.
  
  File
- B.
  
  Database
- C.
  
  Table
2.

DB2 is
- A.
  
  Relational Database Management system
- B.
  
  D) Programming language
- C.
  
  ) Database
3.

What are the aggregate functions supported by DB2 ?
- A.
  
  SUM, MAX, MIN, AVG and COUNT
- B.
  
  SUM and AVG
- C.
  
  NONE
4.

EXPLAIN allows the user to obtain information regarding the optimizer’s choice of access strategy for a given SQL statements
- A.
  
  True
- B.
  
  False
5.

SELECT * FROM ………. will retrieve all columns of the table meeting the selection criteria .
- A.
  
  True
- B.
  
  False
6.

How does the defining of a stored procedure affect the size of a DB2 database?
- A.
  
  It decreases the size of the database.
- B.
  
  It increases the size of the database.
- C.
  
  It does not affect the size of the database. It does not affect the size of the database
7.

Which authority can be granted to a group of users using the GRANT statement?
- A.
  
  SYSCTRL
- B.
  
  DBCTRL
- C.
  
  SYSADM
8.

Given the statement CREATE TABLE userid.test ( date_taken DATE NOT NULL, number SMALLINT NOT NULL, PRIMARY KEY (number))
- A.
  
  Userid
- B.
  
  Number
- C.
  
  Test
9.

Which system catalog view can be used to determine when a bind operation was performed on a given package?
- A.
  
  SYSCAT.PACKAGES
- B.
  
  SYSCAT.TIMESTAMP
- C.
  
  SYSCAT.ACCESSPLAN
10.

Which type of cursor should be used so that its position will be maintained between transactions?
- A.
  
  FOR FETCH
- B.
  
  FOR UPDATE
- C.
  
  WITH HOLD

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: 11091 | 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: 8842 | 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: 5759 | Last updated: Mar 21, 2022