C2090-558 Informix 11.70 Fundamentals Exam (Exam 3)

C2090-558 Informix 11.70 Fundamentals Exam (Exam 3)

created by Fisher BRink (@fisher) at Feb. 8, 2016
  • Adding a row to which one of the following tables is required to create a database...

  • What is the purpose of DB_LOCALE?

  • Given the following table definition: CREATE TABLE t1(col1 BOOLEAN); Which of the ...

  • From the items listed below, what is the smallest granularity of item which may be...

  • Which command would you execute to restore an instance without using or restoring ...

  • Which of the following is required for a cold restore?

  • Which configuration parameters are used by ontape logical log backup?

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

  • There are two open sessions (session A and session B) that are updating the same t...

  • What is the only isolation level available on an unlogged database?

  • Which phase of Fast Recovery rolls forward (restores) all transactions since the l...

  • Which two commands would create a table t1 with page level locking assuming defaul...

  • Which two SQL commands can be used to invoke a stored procedure? (Choose two.)

  • Which of the following can be used in a SELECT statement to set one or more qualif...

  • Which statement can be used to roll back SQL statements within a transaction?

  • Which two statements will update all rows in the customer table? (Choose two.)

  • Which keyword is used to determine whether a comparison is true for every value re...

  • When you execute an INSERT statement, the database server will insert a NULL value...

  • Given the following: CREATE TABLE customer (customer_num INT, company CHAR(25)); W...

  • Which two statements cause Stored Procedure Language (SPL) routine optimization? (...

Dec. 5, 2016
review by shiny s (@jyothi)
Login and Review
  • info
    Quiz Info
  • date_range
    Feb. 8, 2016, 3:45 a.m.
    20 questions
    1 completed
    1 takers

  • C2090-558 Informix 11.70 Fundamentals Exam (Exam 3) QR code