[Free] 2017(Nov) EnsurePass Testinsides IBM C2090-558 Dumps with VCE and PDF 71-80

EnsurePass
2017 Nov IBM Official New Released C2090-558
100% Free Download! 100% Pass Guaranteed!
http://www.EnsurePass.com/C2090-558.html

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

  3. INSERT

  4. SELECT

  5. TRUNCATE

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?

  1. END WORK

  2. COMMIT WORK

  3. ROLLBACK WORK

  4. ROLLBACK WORK TO SAVEPOINT

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% Free Download!
Download Free Demo:C2090-558 Demo PDF
100% Pass Guaranteed!
Download 2017 EnsurePass C2090-558 Full Exam PDF and VCE

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

2017 EnsurePass IT Certification PDF and VCE

Leave a Reply