IBM IBM Certified System Administrator C2090-919 Questions & Answers

• Question 31:

  Which role can create, alter, or delete trusted context objects?

  A.DBA

  B. DBSA

  C. DBSSO

  D. DBSECADM

  Correct Answer: D

• Question 32:

  Which statement regarding the Single Sign-On (SSO) feature is correct?

  A. You cannot use the Informix DB-Access client with SSO.

  B. The Informix implementation of SSO does not support PAM.

  C. Authentication for the DBMS happens when a user first logs in to the client computer or domain.

  D. The user is prompted for a password every time a user action tries to access an Informix database.

  Correct Answer: C

• Question 33:

  The ability for Informix to allow database access to users without a local operating system account is:

  A. Not allowed.

  B. Allowed and calledefault role-Allowed and called default role.

  C. Allowed and calledapped users-Allowed and called dapped users.

  D. Allowed and calledurrogate users-Allowed and called currogate users.

  Correct Answer: C

• Question 34:

  Which of the following privileges is NOT valid for a table fragment?

  A. ALL

  B. INSERT

  C. UPDATE

  D. CREATE INDEX

  Correct Answer: D

• Question 35:

  What are the main administrative roles involved in secure auditing and role separation?

  A. Database Security Administrator (DBSA), Audit Analysis Officer (AAO), Database Separation Officer (DBSO).

  B. Database Security Administrator (DBSA), Audit Trail Officer (ATO), Database System Security Officer (DBSSO).

  C. Database Server Administrator (DBSA), Audit Reader Admin (ARA), Database System Stability Officer (DBSSO).

  D. Database Server Administrator (DBSA), Audit Analysis Officer (AAO), Database System Security Officer (DBSSO).

  Correct Answer: D

• Question 36:

  On which node of an Informix H/A cluster can you execute an external backup without disturbing cluster operations?

  A. Primary

  B. Shared disk secondary

  C. Remote standalone secondary

  D. High-availability data replication secondary

  Correct Answer: C

• Question 37:

  Which $ONCONFIG parameter must be set enable parallel OnBar backup operations?

  A. BAR_MAX_BACKUP

  B. BAR_SIZE_FACTOR

  C. BAR_PERFORMANCE

  D. BAR_NB_XPORT_COUNT

  Correct Answer: A

• Question 38:

  What is used during Fast Recovery to return pages to the original state?

  A. Logical Log

  B. Physical Log

  C. External Tables

  D. TemporaryDBSpaces

  Correct Answer: B

• Question 39:

  Which two statements are true for onbar only but not for ontape? (Choose two.)

  A. It can apply external programs using filters.

  B. It can restart a restore from the place it failed.

  C. It can back up to or restore from cloud storage.

  D. It can restore data to a given point in time (PIT).

  E. It can execute an external backup and restore.

  Correct Answer: BD

• Question 40:

  Given the following statement:

  session A. setlock mode to wait;

  select* from tab1;

  ifsession A is blocked, which sysmaster table contains the session id holding the lock blocking session A?

  A. syslocks

  B. sysscblst

  C. syssessions

  D. syslockholders

  Correct Answer: A