Free IBM 000-556 Exam Dumps Questions & Answers

Which two statements are correct about privileges? (Choose two.)

• A.  Owner of a table can transfer ownership to another user.
• B.  User Informix can grant DBA privilege to a role.
• C.  RESOURCE privilege has all the capabilities of a CONNECT privilege.
• D.  A user with DBA privilege can alter, drop, or rename any database object.
• E.  A user would need RESOURCE privilege to run SET SESSION AUTHORIZATION statement.

What is an Informix database trigger?

• A.  A security event used by Informix auditing to warn the DBA of unwanted actions.
• B.  A way of rejecting unwanted database connections.
• C.  An automatically executed set of SQL statements when a specific activation event occurs.
• D.  An automatic event created by the database scheduling system to notify the DBA about a problem.

What is the syntax to query a table that resides on a remote Informix database?

• A.  database@server:user:password:[owner.]table
• B.  database@server:databasename:user:password:[owner.]table
• C.  database@server:[owner.]table
• D.  database@server:databasename:[owner.]table

Which languages are supported by Informix in the development of User-Defined Routines (UDRs)?

• A.  Perl, Ruby, Python
• B.  SQL, .NET and php
• C.  None. Informix uses a proprietary language to develop UDRs
• D.  Java, C and Stored Procedure Language (SPL)

What result will be returned for User B in the attached exhibit?

• A.  An account_balance of either 80 or 90 depending on when buffers were last flushed to disk.
• B.  An account_balance of 90.
• C.  An account_balance of 80.
• D.  A "row locked" error.