Assessment: System Administrator for Informix Server 11.70 (A2090-919) Free Practice Test

Question 1

A Connection Manager is started with the following Service Level Agreement:
SLA report=(SDS+report_server)
Where will a connection to the report SLA be redirected?

A. The server with the most available resources in the SLA list, including all SDS servers and report_server.

B. Any available SDS (Shared Disk Secondary) server, then report_server.

C. Report_server, then any available SDS server.

D. Report_server, then the SDS server with most available resources.

Correct Answer: A

Question 2

What does the following SQL statement do? execute function task("reset sysadmin", "admindbs");

A. Turns the whole Database Scheduler off and finally drops sysadmin database.

B. Locks sysadmin database in exclusive mode and recreates it in dbspace admindbs.

C. Purges all "mon_*" tables in sysadmin database as user admindbs.

D. Renames sysadmin database to admindbs.

Correct Answer: B

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

Question 3

Under which condition can table fragments NOT be eliminated during query processing?

A. Tables with non-overlapping fragments on a single column and a range query predicate.

B. Tables with overlapping or non-contiguous fragments on a single column and an equality query predicate.

C. Tables with round-robin distribution scheme and a range query predicate.

D. Tables with non-overlapping fragments and an equality query predicate.

Correct Answer: C

Question 4

Given the following SLA definition:
SLA group_1=HDR+(inst_2+inst_3)+SDS
How will new connections be routed through the SLA?

A. Load balanced between all secondary instances.

B. The HDR instance first, load balanced between inst_2 and inst_3, then to any SD secondary instance.

C. Load balanced between inst_2 and inst_3, then either HDR or any SD secondary instance.

D. The HDR instance first, then inst_2, followed by inst_3, finally to any SD secondary instance.

Correct Answer: B

Question 5

Which statement regarding default roles is true?

A. The privileges associated with a default role takes precedence over the privileges granted to an individual user.

B. An administrator can define a default role to assign to individual users or to the PUBLIC group for a particular database.

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.

Correct Answer: B

Question 6

When executing the SQL Admin API "defragment table" and "table repack" commands on the customer table, what will happen to the table? (Choose two.)
execute function sysadmin:task("defragment table","customer"); execute function sysadmin:task("table repack", "customer");

A. Rows will be moved to the beginning of table.

B. Free space at the end of the table will be released to the dbspace for other tables to use.

C. Fragments of a table will be combined.

D. The table will be locked preventing inserts from happening for the duration of the commands.

E. Given sufficient resources the number of extents in the table will be reduced.

Correct Answer: A,E

Question 7

Which two objects are NOT included in a backup? (Choose two.)

A. Simple blob data stored in simple blobspaces

B. External tables

C. Basic text search indexes stored in external dbspaces

D. Indexes

E. Tables

Correct Answer: B,C

Question 8

Which option would be used with "cdr define replicate" to create a shadow replicate?

A. --synchronize

B. --shadow

C. --backup

D. --mirrors

Correct Answer: D

Welcome to TestSimulate

IBM Assessment: System Administrator for Informix Server 11.70 (A2090-919) Free Practice Test