Online Access Free C2090-548 Exam Questions

What are database authorities in DB2?

• A.Database authorities are the main DBAs that control schema development in DB2.
• B.Database authorities do not exist in DB2.
• C.Database authorities provide a way both to group privileges and to control maintenance andutility operations for instances, databases, and database objects.
• D.Database authorities is a DB2 toolkit application that allows the DBA to set up privileges for thesuperusers who will administer the database.

What happens when an unqualified GN call is issued after a GB status code (end of database) is received?

• A.The GB status code is repeated.
• B.The last segment successfully retrieved is returned in the IOArea.
• C.The first segment in the database is retrieved.
• D.A GE status code (segment not found) is returned.

What is DB2 Express?

• A.DB2 Express is a faster version of DB2 that is more powerful and feature-rich than the regularDB2 version.
• B.DB2 Express is a version of DB2 that will only run on handhelds and PDAs and that is targetedfor the purposes of sales demonstrations.
• C.DB2 Express is an edition of DB2 specifically targeted towards SMBs and ISVs.
• D.DB2 Express is a wizard in DB2 that allows for the quick installation and setup of the DB2product.

DB2's High Availability and Disaster Recovery (HADR) feature provides a high availability solution for both partial and complete site failures. Given the sentences below, select the CORRECT statement about HADR.

• A.HADR protects against data loss by replicating data changes from a source database, called the primary, to a target database, called the standby.
• B.HADR protects against data loss by saving data changes from a source database into a local recovery log file.
• C.HADR protects against data loss by replicating data changes from a backup database file to a standby database.
• D.HADR feature is only available for DB2 Advanced Enterprise Edition.

What does the table partitioning feature in DB2 allow you to do?

• A.Table partitioning allows you to create result set tables from a join query, which automaticallysplits the data into smaller chucks, thereby increasing the performance of your DB2 database.
• B.Table partitioning is not a feature in DB2.
• C.Table partitioning allows you to create very large tables that are divided across multiplestorage objects and attach/detach large quantities of data quickly.
• D.Table partitioning allows you to make smaller tables automatically from large tables, therebyincreasing the performance of your DB2 database.