1. Home
  2. IBM
  3. C2090-730

DB2 9 Family Fundamentals

Exam Details

  • Exam Code
    :C2090-730
  • Exam Name
    :DB2 9 Family Fundamentals
  • Certification
    :IBM Certified Database Associate
  • Vendor
    :IBM
  • Total Questions
    :307 Q&As
  • Last Updated
    :Apr 07, 2025

IBM IBM Certified Database Associate C2090-730 Questions & Answers

  • Question 261:

    Which two of the following authorities allow a user to create a new database?

    A. SYSADMN

    B. SYSCTRL

    C. SYSMAINT

    D. DBADM

    E. CREATEDB

  • Question 262:

    In a client-server environment, which two of the following can be used to verify passwords?

    A. System Catalog

    B. User ID/password file

    C. Client Operating System

    D. Communications layer

    E. Application Server

  • Question 263:

    A table named DEPARTMENT has the following columns:

    DEPT_ID DEPT_NAME MANAGER AVG_SALARY Which of the following is the best way to prevent most users from viewing AVG_SALARY data?

    A. Encrypt the table's data

    B. Create a view that does not contain the AVG_SALARY column

    C. Revoke SELECT access for the AVG_SALARY column from users who should not see AVG_SALARY data

    D. Store AVG_SALARY data in a separate table and grant SELECT privilege for that table to the appropriate users

  • Question 264:

    Which of the following is NOT a valid method of authentication that can be used by DB2 9?

    A. SERVER

    B. SERVER_ENCRYPT

    C. CLIENT

    D. DCS

  • Question 265:

    Which of the following tools for DB2 V9 allows a user to create and debug a SQL stored procedure?

    A. Control Center

    B. Development Center

    C. Developer Workbench

    D. Stored Procedure Builder Security

  • Question 266:

    In which situation is shredding XML data recommended?

    A. When the data is naturally tabular

    B. When thenumber of nodes are volatile

    C. When the data by nature has sparse attributes

    D. When the data is of low volume and requires a complex star-schema topology

  • Question 267:

    Which of the following is a typical data warehouse query?

    A. What is this customer's address?

    B. Does this customer have any unpaid bills?

    C. What is the balance in this customers account?

    D. What are the total sales for each of the last 6 months?

  • Question 268:

    Which of the following best describes the age of the data in an OLTP system?

    A. Current

    B. Projected

    C. Historical

    D. Current and projected

  • Question 269:

    Which of the following describes the model used by the Geodetic Extender?

    A. Flat earth

    B. 3-D Square

    C. Trapezoidal

    D. Round earth

  • Question 270:

    Which of the following tools is used to view historical information about tasks, database changes, messages, and notifications?

    A. Journal

    B. Task Center

    C. Control Center

    D. Activity Monitor

Related Exams:

Tips on How to Prepare for the Exams

Nowadays, the certification exams become more and more important and required by more and more enterprises when applying for a job. But how to prepare for the exam effectively? How to prepare for the exam in a short time with less efforts? How to get a ideal result and how to find the most reliable resources? Here on Vcedump.com, you will find all the answers. Vcedump.com provide not only IBM exam questions, answers and explanations but also complete assistance on your exam preparation and certification application. If you are confused on your C2090-730 exam preparations and IBM certification application, do not hesitate to visit our Vcedump.com to find your solutions here.