IBM IBM Certifications C2090-558 Questions & Answers

• Question 61:

  Business rules require that every time a row in table A is updated in your OLTP database, a row in table B must also be updated. How can you guarantee this rule will be maintained correctly and consistently when there are multiple applications and developers?

  A. Use a trigger.

  B. Create a foreign key.

  C. Use a nightly batch process.

  D. Define a task in the sysadmin database.

  Correct Answer: A

• Question 62:

  What functionality is exclusive to onbar (i.e. not present in ontape)?

  A. Restore of a single dbspace

  B. Level 1 archive of the instance

  C. Parallel restore of the instance

  D. Change logging modes of a database

  Correct Answer: C

• Question 63:

  Which command could be used to display the definition of user-defined and complex data types?

  A. onstat -g smb

  B. oncheck -cc database_name

  C. oncheck -pB database_name

  D. dbschema -u all -d database_name

  Correct Answer: D

• Question 64:

  Which table type is always nonlogging?

  A. RAW

  B. TEMP

  C. STATIC

  D. STANDARD

  Correct Answer: A

• Question 65:

  You are about to create and load a table that will initially have a size of 50,000 KB. Once the table has been loaded, there will be very few additional inserts or updates to the table. When you create the table, which of the following extent size definitions would make the most effective use of disk space over time?

  A. EXTENT SIZE 75000 NEXT SIZE 0

  B. EXTENT SIZE 1000 NEXT SIZE 50000

  C. EXTENT SIZE 50000 NEXT SIZE 1000 D. EXTENT SIZE 50000 NEXT SIZE 50000

  Correct Answer: C

• Question 66:

  Which of the following is true about star schemas?

  A. A star schema is optimal for OLTP systems.

  B. A star schema is also known as a 3rdNormal Form schema.

  C. A star schema is associated with master-detail relationships between tables.

  D. A star schema is not necessarily a snowflake schema, but a snowflake schema is always a star schema.

  Correct Answer: D

• Question 67:

  Click the Exhibit button.

  

  The tables shown in the exhibit have been created for a class enrollment system where a course can be assigned to many classes. The class table joins to the course table on the course_num columns. Which two of the following SQL statements are required to establish a referential integrity relationship between these tables? (Choose two.)

  A. ALTER TABLE class ADD CONSTRAINT (PRIMARY KEY (class_id));

  B. ALTER TABLE class ADD CONSTRAINT (PRIMARY KEY (course_num));

  C. ALTER TABLE course ADD CONSTRAINT (PRIMARY KEY (course_num));

  D. ALTER TABLE class ADD CONSTRAINT (FOREIGN KEY (course_num) REFERENCES course);

  E. ALTER TABLE course ADD CONSTRAINT (FOREIGN KEY (course_num) REFERENCES class);

  Correct Answer: CD

• Question 68:

  Which of these commands will create a table containing a column that will be automatically populated with a numeric value starting from an initial value of 2301 and incremented as rows are inserted?

  A. CREATE TABLE customer (cust_num SERIAL(2301), ?;

  B. CREATE TABLE customer (cust_num SERIAL INIT 2301,?;

  C. CREATE TABLE customer (cust_num INT SET SERIAL 2301,?;

  D. CREATE TABLE customer (cust_num SERIAL,? SET SERIAL 2301;

  Correct Answer: A

• Question 69:

  Which of the following statements can be used to prevent duplicate values in an indexed column?

  A. CREATE HASH INDEX

  B. CREATE UNIQUE INDEX

  C. CREATE DISTINCT TYPE

  D. CREATE CLUSTER INDEX

  Correct Answer: B

• Question 70:

  Click the Exhibit button.

  

  The query.sql file contains the information shown in the exhibit. The following command is run: dbaccess ?query.sql How many rows will be returned by the select query?

  A. 1

  B. 2

  C. 3

  D. 4

  Correct Answer: B