A2090-558 Exam Questions and Training

A2090-558 Exam
Exam Number/Code : A2090-558
Exam Name : Assessment: Informix Fundamentals 11.70 Assessment
A2090-558 exam is an important IBM certifications I certification which can test your professional skills. Candidates want to pass the exam successfully to prove their competence. Passokay IBM certifications I technical experts have collected and certified 246 questions and answers of A2090-558 exam which are designed to cover the knowledge points of the Interconnecting IBM certifications I Networking Devices Part 1 and enhance candidates' abilities. With Passokay A2090-558 preparation tests you can pass the A2090-558 exam easily, get the CCENT certification and go further on IBM certifications I career path.
Questions and Answers : 120 Q&As
Update Time: 2014-06-05
http://www.passokay.com/A2090-558.html
http://www.passokay.com/pdf/A2090-558.pdf

Question: 1
When restoring data, which granularity of object may NOT be restored?
A. a single table
B. a single chunk
C. a single dbspace
D. an entire instance
Answer: B

Question: 2
Which command would you execute to restore to a specific moment-in-time?
A. onbar -t timestamp
B. onbar -r -log lognum
C. onbar -r -t timestamp
D. onbar -r -l timestamp
Answer: C

Question: 3
Which command option should be used to resume an interrupted onbar restore?
A. -RETRY
B. -RESTART
C. -REINTIIALZE
D. -BEGIN_AGAIN
Answer: B

Question: 4
Under which of the following conditions does the LAST COMMITTED option have an effect on the COMMITTED READ isolation level?
A. Row level lock
B. Page level locking
C. RAW or unlogged tables
D. Tables containing complex data types
Answer: A

Question: 5
You have a database server environment where all databases use buffered logging. In which two conditions are the logical-log buffers in shared memory flushed to the logical log on disk? (Choose two.)
A. When the buffer is full.
B. When a checkpoint occurs.
C. When a user issues a begin work.
D. When a user commits the transaction.
E. When a user rolls back the transaction.
Answer: A, B

Question: 6
What are two ways to create table t1 with row level locking? (Choose two.)
A. Execute the command "create table t1 (c1 int) locking row".
B. Execute the command "create table t1 (c1 int) lock level row".
C. Execute the command "create table t1 (c1 int) lock mode row".
D. Set DEF_TABLE_LOCKMODE to ROW in ONCONFIG before executing "create table t1 (c1 int)".
E. Set the environment variable DEF_TABLE_LOCKMODE to ROW before executing "create table t1 (c1 int)".
Answer: C, D