Free C2090-619 Exam Dumps

Question 6

The following message is received: Lock table overflow - user id user32, session id 54. What action should be taken to prevent this problem in the future?

A. Run onclean utility to clear the lock table.
B. Increase the LOCKS configuration parameter.
C. Turn on the AUTO_TUNE configuration parameter.
D. Change the DEF_TABLE_LOCKMODE configuration parameter from page to row.

Correct Answer:B

Question 7

Which statement accurately describes the mapped user functionality in Informix?

A. The DBSA can control the access to the database at the table level by creating different security labels for each user.
B. The DBSA can create different roles for each user in order to verify whether the user who is attempting an operation has the necessary privileges.
C. The DBSA can configure the server to allow database access by external users who do not have operating system accounts on the host computer.
D. The DBSA can grant access to the database server to users of the host computer operating system by implementing different authentication mechanisms for each user.

Correct Answer:C

Question 8

Which Enterprise Replication command CANNOT be used on replicates that include TimeSeries columns?

A. cdr start
B. cdr sync
C. cdr realize
D. cdr remaster

Correct Answer:D

Question 9

Which statement is true about log salvaging?

A. ontape cannot perform salvage of logs.
B. Log salvaging cannot be avoided if onbar is used for restore.
C. Log salvaging is the act of restoring logical logs after physical restore, but before logical restore.
D. Log salvaging allows for recovery of data up to the last available and uncorrupted logical-log file and the last complete transaction.

Correct Answer:D

Question 10

In an organization, all employees are authenticated via domain wide Kerberos single sign- on. The DBSA wants to provide access to the database server for an employee without requesting the Operating System (OS) administrator to create a OS level user account. Which Informix feature does the DBSA need to leverage?

A. Mapped users
B. Role based users
C. Table level access for users
D. Label based access for users

Correct Answer:A