Which configuration parameter allows you to reduce the dependency on local OS user accounts and to enable a DBSA to grant database server access to specific users without the OS user accounts?
Answer : A
From the items listed below, what is the smallest granularity of item which may be restored?
Answer : A
Given the following table definition: CREATE TABLE t1(col1 BOOLEAN); Which of the following statements will fail to insert a row?
Answer : C
What is the minimum database-level privilage required for a user to create Stored
Procedure Language routines?
Answer : D
There are two open sessions (session A and session B) that are updating the same tables.
Session B is trying to read all rows in the table and is continuously receiving the error "-143
ISAM error: deadlock detected". Which action in session B would allow it to read all of the rows?
Answer : B
Which two statements will update all rows in the customer table? (Choose two.)
Answer : A,D
Which two storage objects exist in Informix? (Choose two.)
Answer : A,D
Which of the following is true of system catalogs?
Answer : C
What is the default isolation level on a mode ANSI database?
Answer : D
Which of the following is true about the remote query SELECT * FROM ABC@LMN:XYZ?
Answer : D
What does the dbschema -ss option explicitly show besides lock mode, fragmentation strategy, and dbspace name?
Answer : B
Which command would you execute to restore an instance without using or restoring the logical logs?
Answer : C
Which of the following Informix server modes disable execution of SQL statements for all users while allowing administrative users to perform maintenance tasks?
Answer : C
Which of the following statements is true about referential integrity?
Answer : D