Db2 Mock Test 3

Reviewed by Editorial Team
The ProProfs editorial team is comprised of experienced subject matter experts. They've collectively created over 10,000 quizzes and lessons, serving over 100 million users. Our team includes in-house content moderators and subject matter experts, as well as a global network of rigorously trained contributors. All adhere to our comprehensive editorial guidelines, ensuring the delivery of high-quality content.
Learn about Our Editorial Process
| By Sharmiladevi
S
Sharmiladevi
Community Contributor
Quizzes Created: 4 | Total Attempts: 8,658
| Attempts: 1,851
SettingsSettings
Please wait...
  • 1/10 Questions

    What are the aggregate functions supported by DB2 ?  

    • SUM, MAX, MIN, AVG and COUNT
    • SUM and AVG
    • NONE
Please wait...
About This Quiz

This DB2 mock test assesses knowledge of database concepts, focusing on DB2 functionalities. It covers topics like SQL aggregate functions, query optimization, and stored procedures. Ideal for learners aiming to master DB2 database management.

Db2 Quizzes & Trivia

Quiz Preview

  • 2. 

    SELECT * FROM ………. will  retrieve all columns of the table meeting the selection criteria .

    • True

    • False

    Correct Answer
    A. True
    Explanation
    The SELECT * statement is used to retrieve all columns from a table. In this case, the query is not specifying any specific columns to retrieve, so it will retrieve all columns of the table that meet the selection criteria. Therefore, the given answer "True" is correct.

    Rate this question:

  • 3. 

    EXPLAIN allows the user to obtain information regarding the optimizer’s choice of access strategy for a given SQL statements

    • True

    • False

    Correct Answer
    A. True
    Explanation
    The explanation for the given correct answer is that the EXPLAIN command in SQL allows the user to retrieve information about the access strategy chosen by the optimizer for a specific SQL statement. This information can be helpful in analyzing and optimizing the performance of the query, as it provides insights into how the database engine plans to execute the statement and access the necessary data. By understanding the access strategy, users can make informed decisions to improve the efficiency and effectiveness of their SQL queries.

    Rate this question:

  • 4. 

    DB2 is

    • Relational Database Management system

    • D) Programming language

    • ) Database

    Correct Answer
    A. Relational Database Management system
    Explanation
    DB2 is a Relational Database Management system. It is a software system designed to manage and organize large amounts of data in a structured manner. It provides a set of tools and functions for creating, modifying, and querying databases. DB2 is widely used in enterprise environments for its reliability, scalability, and support for various platforms. It is not a programming language or a database itself, but rather a software system that manages databases.

    Rate this question:

  • 5. 

    What is the collection of data designed to be used by different people is called

    • File

    • Database

    • Table

    Correct Answer
    A. Database
    Explanation
    A collection of data designed to be used by different people is called a database. A database is a structured set of data that is organized and stored in a way that allows for efficient retrieval, manipulation, and management. It is designed to be accessed and used by multiple users simultaneously, making it suitable for collaborative work and sharing information among different individuals or groups.

    Rate this question:

  • 6. 

    How does the defining of a stored procedure affect the size of a DB2 database?

    • It decreases the size of the database.

    • It increases the size of the database.

    • It does not affect the size of the database. It does not affect the size of the database

    Correct Answer
    A. It does not affect the size of the database. It does not affect the size of the database
    Explanation
    Defining a stored procedure does not affect the size of the database. The size of the database is primarily determined by the amount of data stored in tables, indexes, and other database objects. A stored procedure is a set of SQL statements that are stored and executed on the database server, but it does not consume additional storage space in the database. Therefore, defining a stored procedure does not impact the overall size of the database.

    Rate this question:

  • 7. 

    Which system catalog view can be used to determine when a bind      operation was performed on a given package?

    • SYSCAT.PACKAGES

    • SYSCAT.TIMESTAMP

    • SYSCAT.ACCESSPLAN

    Correct Answer
    A. SYSCAT.PACKAGES
    Explanation
    SYSCAT.PACKAGES can be used to determine when a bind operation was performed on a given package. This system catalog view contains information about all the packages in the database, including the timestamp of the last bind operation performed on each package. By querying this view, one can retrieve the timestamp and determine when the bind operation was executed.

    Rate this question:

  • 8. 

    Which type of cursor should be used so that its position will be     maintained between transactions?

    • FOR FETCH

    • FOR UPDATE

    • WITH HOLD

    Correct Answer
    A. WITH HOLD
    Explanation
    The correct answer is WITH HOLD. When using the WITH HOLD cursor, its position is maintained between transactions, meaning that the cursor will stay at the same position even after a transaction is committed. This allows for easy navigation and retrieval of data in subsequent transactions without having to reposition the cursor.

    Rate this question:

  • 9. 

    Which authority can be granted to a group of users using the GRANT statement?

    • SYSCTRL

    • DBCTRL

    • SYSADM

    Correct Answer
    A. SYSADM
    Explanation
    The authority that can be granted to a group of users using the GRANT statement is SYSADM.

    Rate this question:

  • 10. 

    Given the statement      CREATE TABLE userid.test (      date_taken   DATE NOT NULL,      number       SMALLINT NOT NULL,      PRIMARY KEY (number))

    • Userid

    • Number

    • Test

    Correct Answer
    A. Userid

Quiz Review Timeline (Updated): Mar 20, 2023 +

Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.

  • Current Version
  • Mar 20, 2023
    Quiz Edited by
    ProProfs Editorial Team
  • Jul 28, 2011
    Quiz Created by
    Sharmiladevi
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.