C2090-558

C2090-558 practice questions, page 3 of 5, with answer review and explanations.

Question 11

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

  1. Only user informix can read system catalog tables
  2. Only system administrators can read system catalog tables
  3. Only database administrators can read system catalog tables
  4. Any user that can connect to the database can read system catalog tables

Question 12

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

  1. use dbschema utility
  2. inspect ONCONFIG file
  3. List reserved pages with oncheck -pr
  4. run SELECT name FROM sysmaster:sysdatabases

Question 13

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

  1. sqlhosts file must be called sqlhosts
  2. set INFORMIXSQLHOSTS variable to /newlocation/sqlhosts
  3. set INFORMIXSQLHOSTS variable to /newlocation/newsqlhosts
  4. sqlhosts file must be defined under $INFORMIXDIR/etc/ directory

Question 14

Which utility can be used to relocate the physical log to a new dbspace?

  1. onlog
  2. ontape
  3. onspaces
  4. onparams

Question 15

What are two system level databases? (Choose two.)

  1. sysperf
  2. sysadmin
  3. sysmaster
  4. sysmonitor
  5. sysscheduler