Db2 Mock Test 3

10 Questions | By Sharmiladevi | Last updated: Jan 28, 2013 | Total Attempts: 1789

Questions

Settings

or Create Online Test

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

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: 8814 | Last updated: May 29, 2013

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

Chromium Steel

Silicon Iron

Cobalt Steel

Alnico

Pspo 1 Mock Test - Open Assessment

Be prepared for PSPO 1 Scrum Exam with this Mock Test. 29 basic questions in the pool. Instructions: Number of questions: 15 Has a time limit of: 20 minutes Questions displayed per page: 1 Has...

Questions: 29 | Attempts: 7963 | Last updated: Aug 24, 2020

Sample Question
The Product Owner manages the Product Backlog. Who is accountable for estimating the effort to complete the Product Backlog items?

The Development Team. As a collective, they have a complete view of the work needed to transform Product Backlog items into Increments of product.

The PMO. They have all the history on projects delivered, and this enables the IT department to make delivery commitments.

The Product Owner. The Product Owner is required to commit on delivery to the users and the stakeholders.

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: 5625 | Last updated: Jan 12, 2018