What are two system level databases? (Choose two.)
A. sysperf
B. sysadmin
C. sysmaster
D. sysmonitor
E. sysscheduler
Which Informix utility listed below will allow an administrator to run ad hoc SQL against the instance?
A. onsql
B. onadmin
C. dbaccess
D. dbschema
Which of the following can be used to create and drop logical logs?
A. onlog
B. ondblog
C. onspaces
D. onparams
Given the query shown below:
What will happen?
A. All rows will be retrieved in which item_desc contains the characters 'pencil'.
B. All rows will be retrieved in which item_desc does not contain the characters 'pencil'.
C. All rows will be retrieved in which item_desc contains the letters 'p', 'e', 'n', 'c', 'i' and 'l' in any order.
D. All rows will be retrieved in which item_desc contains the letters "P', 'E', 'N, C', I' and 'L' in any order.
Business rules require that every time a row in table A is updated in your OLTP database, a row in table B must also be updated. How can you guarantee this rule will be maintained correctly and consistently when there are multiple applications and developers?
A. Use a trigger.
B. Create a foreign key.
C. Use a nightly batch process.
D. Define a task in the sysadmin database.
Which one of the following is most suitable for scheduling administrative functions that need to be performed periodically?
A. Task
B. Trigger
C. Stored Procedure
D. User Defined Routine
Which two statements will update all rows in the customer table? (Choose two.)
A. update customer set fname = "xyz";
B. modify customer set fname = "xyz";
C. modify customer set fname = "xyz" where 1 = 1;
D. update customer set fname = "xyz" where 1 = 1;
E. update customer set fname = "xyz" for all;
Which of the following methods can be used to tranfer data in EXPRESS mode?
A. dbload
B. external tables
C. onload/onunload
D. dbexport/dbimport
Which statement is used to create a permanent nonlogged table in a logged database?
A. CREATE TABLE tab1 (col1 INTEGER, col2 INTEGER)
B. CREATE RAW TABLE tab1 (col1 INTEGER , col2 INTEGER)
C. CREATE STATIC TABLE tab1 (col1 INTEGER , col2 INTEGER)
D. CREATE NONLOGGING TABLE tab1 (col1 INTEGER , col2 INTEGER)
What does the dbschema -ss option explicitly show besides lock mode, fragmentation strategy, and dbspace name?
A. pagesize
B. extent size
C. creation date
D. partition partnum