IBM C2090-558 Online Practice Questions and Exam Preparation

IBM C2090-558 Online Questions & Answers

• Question 81:

  Which two database objects can be created using fragmentation? (Choose two.)

  A. view
  B. table
  C. index
  D. trigger
  E. synonym
  B. table
  C. index

• Question 82:

  Which of the following statements is true about referential integrity?

  A. Primary and foreign key values must be integers.
  B. You must explicitly define constraint names for primary and foreign key columns.
  C. A row in a table cannot be deleted if it contains a foreign key value that exists as a primary key value in the referenced table.
  D. A row in a table cannot be deleted if it contains a primary key value that is referenced by a foreign key value in another table.
  D. A row in a table cannot be deleted if it contains a primary key value that is referenced by a foreign key value in another table.

• Question 83:

  Which two statements will delete all rows from table_name? (Choose two.)

  A. DROP FROM table_name ;
  B. DELETE FROM table_name ;
  C. DELETE * FROM table_name ;
  D. TRUNCATE TABLE table_name ;
  E. DELETE ALL FROM table_name ;
  B. DELETE FROM table_name ;
  D. TRUNCATE TABLE table_name ;

• Question 84:

  Which statement is used to create a permanent nonlogged table in a logged database?

  A. CREATE TABLE tab1 (col1 INTEGER, col2 INTEGER)
  B. CREATE RAW TABLE tab1 (col1 INTEGER , col2 INTEGER)
  C. CREATE STATIC TABLE tab1 (col1 INTEGER , col2 INTEGER)
  D. CREATE NONLOGGING TABLE tab1 (col1 INTEGER , col2 INTEGER)
  B. CREATE RAW TABLE tab1 (col1 INTEGER , col2 INTEGER)

• Question 85:

  What is the purpose of DB_LOCALE?

  A. It enables operating system independent data storage.
  B. It enables Informix client connectivity by specifying where the instance is located.
  C. It defines conventions for a particular language, collation, or code set within a database.
  D. It defines conventions for a particular language, collation, or code set for a client application.
  C. It defines conventions for a particular language, collation, or code set within a database.

• Question 86:

  How does an administrator allocate a new dbspace from the storagepool?

  A. Use the SQL Admin API
  B. Use the oninit command
  C. Use the onadmin command
  D. Use the onspaces command.
  A. Use the SQL Admin API

• Question 87:

  Which of the following statement is correct about Shared Disk (SD) secondary servers?

  A. SD secondary servers support automatic index repair
  B. SD secondary servers use paging files to track pages between checkpoints
  C. SD secondary servers require an HDR secondary server to be present in order to function
  D. SD secondary servers can become a High-Availability Data Replication (HDR) secondary server
  B. SD secondary servers use paging files to track pages between checkpoints

• Question 88:

  What Informix data type is suitable for storing video clips up to a size of 4 TB?

  A. BLOB
  B. BYTE
  C. CLOB
  D. COLLECTION
  A. BLOB

• Question 89:

  Which configuration parameter allows you to reduce the dependency on local OS user accounts and to enable a DBSA to grant database server access to specific users without the OS user accounts?

  A. USERMAPPING
  B. IFX_EXTEND_ROLE
  C. SECURITY_LOCALCONNECTION
  D. ADMIN_USER_MODE_WITH_DBSA
  A. USERMAPPING

• Question 90:

  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);
  C. ALTER TABLE course ADD CONSTRAINT (PRIMARY KEY (course_num));
  D. ALTER TABLE class ADD CONSTRAINT (FOREIGN KEY (course_num) REFERENCES course);