[Free] 2018(Jan) Dumps4cert Examcollection IBM C2090-558 Dumps with VCE and PDF 71-80

By | February 1, 2018

Dumps4cert.com : Latest Dumps with PDF and VCE Files
2018 Jan IBM Official New Released C2090-558
100% Free Download! 100% Pass Guaranteed!

Informix 11.70 Fundamentals

Question No: 71 – (Topic 2)

What does the dbschema -ss option explicitly show besides lock mode, fragmentation strategy, and dbspace name?

  1. pagesize

  2. extent size

  3. creation date

  4. partition partnum

Answer: B

Question No: 72 – (Topic 2)

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

  1. onbar -w

  2. onbar -e

  3. onbar -r -p

  4. onbar -r -nolog

Answer: C

Question No: 73 – (Topic 2)

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

  1. Offline

  2. On-Line

  3. Quiescent

  4. Administrative

Answer: C

Question No: 74 – (Topic 2)

Which of the following statements is true about referential integrity?

  1. Primary and foreign key values must be integers.

  2. You must explicitly define constraint names for primary and foreign key columns.

  3. A row in a table cannot be deleted if it contains a foreign key value that exists as a primary key value in the referenced table.

  4. A row in a table cannot be deleted if it contains a primary key value that is referenced by a foreign key value in another table.

Answer: D

Question No: 75 – (Topic 2)

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

  1. DROP

  2. ALTER




Answer: C,D

Question No: 76 – (Topic 2)

Which one of the following is most suitable for scheduling administrative functions that need to be performed periodically?

  1. Task

  2. Trigger

  3. Stored Procedure

  4. User Defined Routine

Answer: A

Question No: 77 – (Topic 2)

When you execute an INSERT statement, the database server will insert a NULL value into any column that meets which two conditions? (Choose two.)

  1. Columns that are used in indexes.

  2. Columns that are used in constraints.

  3. You provide no value for a specific column.

  4. Where a zero is specified in the VALUES clause of a serial column.

  5. Where you specify the NULL keyword in the VALUES clause for a specific column.

Answer: C,E

Question No: 78 – (Topic 2)

Which of the following can be used to move the physical log?

  1. onlog

  2. ondblog

  3. onspaces

  4. onparams

Answer: D

Question No: 79 – (Topic 2)

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





Answer: D

Question No: 80 – (Topic 2)

Which phase of Fast Recovery rolls forward (restores) all transactions since the last checkpoint and rolls back any uncommitted transactions?

  1. Logical Recovery

  2. Physical Recovery

  3. Dbspace Recovery

  4. Transactional Recovery

Answer: A

100% Dumps4cert Free Download!
Download Free Demo:C2090-558 Demo PDF
100% Dumps4cert Free Guaranteed!
C2090-558 Dumps

Dumps4cert ExamCollection Testking
Lowest Price Guarantee Yes No No
Up-to-Dated Yes No No
Real Questions Yes No No
Explanation Yes No No
Free VCE Simulator Yes No No
Instant Download Yes No No

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.