C2090-558 Free Practice Test

Which two events can initiate a trigger on a table? (Choose two.)

1. A. DROP
2. B. ALTER
3. C. INSERT
4. D. SELECT
5. E. TRUNCATE

Correct Answer: CD

Which technology can be used to execute Data Definition Language (DDL) command across multiple instances?

1. A. Flexible Grid
2. B. Enterprise Replication
3. C. High Availability Cluster
4. D. High Availability Data Replication

Correct Answer: A

Which command could be used to display the definition of user-defined and complex data types?

1. A. onstat -g smb
2. B. oncheck -cc database_name
3. C. oncheck -pB database_name
4. D. dbschema -u all -d database_name

Correct Answer: D

Which of the following Informix server modes disable execution of SQL statements for all users while allowing administrative users to perform maintenance tasks?

1. A. Offline
2. B. On-Line
3. C. Quiescent
4. D. Administrative

Correct Answer: C

Which command would you execute to restore an instance without using or restoring the logical logs?

1. A. onbar -w
2. B. onbar -e
3. C. onbar -r -p
4. D. onbar -r -nolog

Correct Answer: C