IBM Informix 11.70 System Administrator - C2090-919 FREE EXAM DUMPS QUESTIONS & ANSWERS]

Question 1

Which of the following is NOT in the machine notes?

A. Features that are not available for the version and O/S. B. A descriptive list of the new features in the port. C. Operating system requirements. D. Critical kernel tuning parameters.

Discussion 0

Correct Answer: B Vote an answer

Question 2

Assuming the DBSPACETEMP onconfig and environment variables are set to valid dbspace names, where is the first location the instance will attempt to create a temporary non logged table?

A. The dbspace the database was created in. B. rootdbs. C. One of the dbspaces listed in the DBSPACETEMP configuration parameter. D. One of the dbspaces listed in the DBSPACETEMP environment variable.

Discussion 0

Correct Answer: D Vote an answer

Question 3

Which statement regarding default roles is true?

A. An administrator can define a default role to assign to individual users or to the PUBLIC group for a particular database. B. The privileges associated with a default role takes precedence over the privileges granted to an individual user. C. When a user connects to a database, it is necessary to use the SET ROLE DEFAULT statement in order to gain the default role privileges. D. An administrator can define a default role to assign only to the PUBLIC group for a particular database.

Discussion 0

Correct Answer: A Vote an answer

Question 4

Which statement about the scope of UPDATE STATISTICS is true?

A. If the FOR TABLE keywords are specified with a table but without specifying a list of columns, the database server will not recalculate distributions on all of the columns of the specified table. B. If the FOR PROCEDURE specification, Table and Column Scope, and Resolution clauses are NOT included, then the statistics are updated for every table and SPL routine in the current database. C. If the FOR TABLE keywords are used without specifying the name or synonym of a table, the database will not recalculate distributions for any table in the current database. D. If the FOR PROCEDURE keywords are included but the name of any SPL routine is not specified, an error will be returned.

Discussion 0

Correct Answer: B Vote an answer

Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).

Question 5

For a given procedure name, what is the objective of the SQL query shown below?

A. The query returns both ordered text and ordered compiled form of the specified procedure body. B. The query returns the ordered text form of the specified procedure body. C. The query returns neither the ordered text nor the ordered compiled form of the specified procedure body. D. The query returns the ordered compiled form of the specified procedure body.

Discussion 0

Correct Answer: B Vote an answer

Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).

Question 6

Which statement about mapped user functionality is true?

A. The DBSA can control the access to tables at a row level using security labels. B. Mapped users cannot execute distributed operations. C. Mapped users are allowed to run with multiple names. D. The DBSA can grant database server access to externally authenticated users with no local account.

Discussion 0

Correct Answer: D Vote an answer