Which command option should be used to resume an interrupted onbar restore?

A. -RETRY

B. -RESTART

C. -REINTIIALZE

D. -BEGIN_AGAIN

Click the Exhibit button.

In the exhibit, which statement is true regarding the update statement of Client 2 if both of the clients are connected to the same logged database?

A. Client 2 will update col2 of the rows having col1=20.

B. Client 2 will return successfully without updating any rows.

C. Client 2 will keep waiting for client 1 to finish its transaction.

D. Client 2 will get an error that the "record is locked" or the "table is locked".

Which of the following is true about system catalog tables access?

A. Only user informix can read system catalog tables

B. Only system administrators can read system catalog tables

C. Only database administrators can read system catalog tables

D. Any user that can connect to the database can read system catalog tables

How can you determine which databases are created in an instance?

A. use dbschema utility

B. inspect ONCONFIG file

C. List reserved pages with oncheck -pr

D. run SELECT name FROM sysmaster:sysdatabases

You want to use sqlhosts file /newlocation/newsqlhosts. Which of the following is true?

A. sqlhosts file must be called sqlhosts

B. set INFORMIXSQLHOSTS variable to /newlocation/sqlhosts

C. set INFORMIXSQLHOSTS variable to /newlocation/newsqlhosts

D. sqlhosts file must be defined under $INFORMIXDIR/etc/ directory

Which two of the following are required for creating a dbspace? (Choose two.)

A. a mirror chunk

B. two or more chunks

C. a cooked file or raw device

D. a file owned by root or administrator

E. dbspace name containing only letters, digits, underscores, or $ characters.

Which of the following can be used to create and drop logical logs?

A. onlog

B. ondblog

C. onspaces

D. onparams

Assuming the tables and columns mentioned below exist, which of the following SQL statements will return an error?

A. INSERT INTO orders SELECT * FROM new_orders;

B. SELECT company, fname, lname, state FROM customer WHERE state = (SELECT state, zipcode FROM customer WHERE fname = "John");

C. DELETE FROM stock WHERE 0 = (SELECT count(*) FROM manufact WHERE manufact.manu_code = stock.manu_code)

D. UPDATE customer SET (address, city, state, zip) = (SELECT address, city, state, zip FROM newaddr WHERE newaddr.customer_num = customer.customer_num) WHERE customer_num IN (SELECT customer_num FROM newaddr);

What functionality is exclusive to onbar (i.e. not present in ontape)?

A. Restore of a single dbspace

B. Level 1 archive of the instance

C. Parallel restore of the instance

D. Change logging modes of a database

Adding a row to which one of the following tables is required to create a database scheduler job?

A. ph_task

B. ph_alert

C. ph_sensor

D. ph_scheduler