Lesson #3: Getting Started with Data Studio (Practice Questions)

An online table reorganization is preferred when ______ A. Access to database tables is critical while reorg is occurring. B. Data needs to be clustered perfectly. C. More storage space is required. D. Index rebuild is required. E. All of the above

A. Access to database tables is critical while reorg is occurring.

Which of the following is true about DB2 load utility? A. DB2 load utility is faster than DB2 import. B. DB2 load utility writes data in the database using normal insert operations. C. DB2 load utility logs database changes. D. DB2 load utility performs constraint validation

A. DB2 load utility is faster than DB2 import.

A system-managed tablespace can have containers of the following type: A. Directory. B. File. C. Raw Device. D. All of the above. E. None of the above

A. Directory.

Which of the following is NOT a feature of IBM Data Studio? A. Program Optimizer. B. Routine Wizards, Editor, and Debugger for Stored Procedures and UDFs. C. SQL Query Builder. D. XML Wizards and Editor

A. Program Optimizer.

While creating a table, when is an index automatically created? A. When you define the primary key. B. When you define a NOT NULL constraint for the column. C. When the column value is defined as auto-generated. D. No index gets created automatically. E. All of the above

A. When you define the primary key.

Which of the following commands allow you to list of existing databases? A. db2 list db directory. B. db2 dir. C. db2 list dir. D. db2 dir db

A. db2 list db directory.

Below is a set of commands that configures a table space for automatic storage management. line 1: CREATE DATABASE mydb STORAGE YES line 2: CONNECT TO mydb line 3: CREATE TABLESPACE tbsp1 MANAGED BY AUTOMATIC STORAGE Which of the following commands is/are syntactically incorrect? A. line 1. B. line 2 C. line 3 D. all lines

A. line 1.

What are "perspectives" in an Eclipse-based product such as Data Studio?

Are a grouping of views and tools based on a particular role or task. Integrated data management.

Which of the following is the lowest cost DB2 product that can be legally installed on a Windows server that has 2 CPUs? A. DB2 Everyplace. B. DB2 Express Edition. C. DB2 Workgroup Server Edition. D. DB2 Enterprise Server Edition

B. DB2 Express Edition.

Which editor can be used to alter table properties? A. SQL Editor. B. Data Object Editor. C. Routine Editor. D. Database table editor. E. All of the above

B. Data Object Editor.

Which of the following correctly reflects the downloadable package options for the Data Studio product? A. Binary and source. B. Integrated Development Environment (IDE) and stand-alone. C. C++ and Java. D. Free and chargeable. E. None of the above

B. Integrated Development Environment (IDE) and stand-alone.

An incremental backup backs up: A. All the data. B. Only the modified data after the last full backup. C. Only the modified data after the full or incremental backup. D. Only the modified data after any kind of backup. E. None of the above

B. Only the modified data after the last full backup.

In which Eclipse view do results of SQL operations appear? A. Data Source Explorer. B. Properties. C. Data Project Explorer. D. Editor. E. None of the above

B. Properties.

A buffer pool is used mainly ______ A. To store the intermediate results of queries. B. To fetch data from disk to volatile memory/RAM. C. To store updates to the data. D. To process the data before returning it to the application. E. All of the above

B. To fetch data from disk to volatile memory/RAM.

Which of the following is NOT an add-on feature/functionality of the DB2 Enterprise Edition? A. row compression. B. column compression. C. workload management. D. geodetic extender

B. column compression.

When is statistics collection recommended? A. When the data is fragmented. B. After many selects on the data. C. After many updates on the data. D. All of the above. E. None of the above

C. After many updates on the data.

What is the name of the Eclipse view used to browse of the projects that hold SQL scripts, Data Web Services artifacts, and stored procedures? A. Thin Client. B. Data Source Explorer. C. Data Project Explorer. D. Outline. E. None of the above

C. Data Project Explorer.

The following are the users/groups required to operate DB2 except. A. Instance Owner. B. Fenced Owner. C. Database Owner. D. DB2 Administration Server User

C. Database Owner.

Which of the following development capabilities is not included in Data Studio? A. Development of SQL and Java stored procedures. B. Development of SQL and Java user-defined functions. C. NET development. D. SQL and XQuery scripting. E. Data Web Services development

C. NET development.

Which of the following is NOT true about a buffer pool? A. Area of main memory used to cache table and index data. B. Each database must have at least one buffer pool. C. Some table space associates a specific buffer pool of the same page size. D. Self-Tuning Memory Manager (STMM) is available for buffer pool management

C. Some table space associates a specific buffer pool of the same page size.

Which of the following is NOT true about DB2 table space? A. They are logical objects in between logical table and physical containers. B. They allow assignment of the location of data to particular logical devices or portions thereof. C. Tables, indexes, and other data are not necessarily stored in a table space. D. Can be associated to a specific buffer pool

C. Tables, indexes, and other data are not necessarily stored in a table space.

When connecting to a database, which of these is a mandatory parameter? A. Port number. B. Hostname/IP Address. C. User name/password. D. All of the above. E. None of the above

D. All of the above.

You can create a view using: A. A full select on a table. B. By selecting a list of columns from the table. C. By joining mutliple tables. D. All of the above. E. None of the above

D. All of the above.

Which of the following is NOT true about Data Studio Administration Console (DSAC)? A. Web based tool for database health monitoring. B. Provides a single portal for viewing the status of all your databases. C. Available for Linux, UNIX and Windows. D. Available for a small license fee

D. Available for a small license fee

This specifies the order of operations for accessing data necessary to resolve a SQL or XQuery statement A. DB2 Instances. B. DB2 Instance Owner. C. DB2 Fenced User. D. DB2 Access Plan

D. DB2 Access Plan

DB2 Access Plan provides on the following objects/parameters except A. Tables. B. Statistics. C. Configuration Parameters. D. Sequence

D. Sequence

Which IBM products does Data Studio support?

DB2 (all platforms) and Informix Dynamic Server.

What are the file formats supported for exporting data?

Delimited (DEL), Worksheet format (WSF), and Integrated Exchange Format (IXF)

Which of the following database administrative capabilities is provided in Data Studio? A. Browse data objects and view their properties. B. Recover databases. C. Create, alter, and drop database objects. D. Authorize users to access database objects. E. All of the above

E. All of the above

What open source platform is Data Studio tooling built on?

Eclipse, which is an open source platform for building integrated development environments.

Which file format allows you to create the table while exporting?

IXF, because structural information about the table is included with the export.

When creating a new user in Data Studio, which tab in the object editor enables you to specify which objects that person has access to?

Privileges tab.

What two operations are combined to compose the Recover operation?

Restore and Rollforward.

Related database objects are grouped together in a _________.

Schema

How can you generate an Entity-Relationship diagram in Data Studio?

Select Add to Overview Diagram, and then select the list of tables you want to be shown in the diagram and click OK.

Why are connection profiles useful?

Sharing connection information with others by the ability to export and import connection information into a workspace.

What are the three types of table spaces in DB2 data servers?

System-managed (SMS), database-managed (DMS), automatic storage.

What is the default perspective after you install the IDE package of Data Studio?

The default perspective is the Data perspective. FYI, for the stand-alone package, the default perspective is the Database Administration perspective

Name the two different logging methods supported in DB2 data servers.

The two types of logging are circular and archive. Circular logging is only for uncommitted changes. To restore, you need to go to the last backup image. Archive logging logs all changes, committed and uncommitted and thus recovery can include changes made up to a specified point in time.

True or false: Data Studio can be used at no charge with supported databases.

True, Data Studio can be used at no additional charge with your DB2 server or Informix Dynamic Server database.