pass4sure ibm 000-910

By PassGuide-IBM Study Guide | Oct 12, 2008
Visited 129 times, 1 so far today

managing and optimizing informix dynamic server databases : 000-910 Exam
Test information:
• Number of questions: 70
• Time allowed in minutes: 90
• Required passing score: 80%

Related certifications:
• IBM Certified Solutions Expert — Informix Dynamic Server V7 System Administrator
• IBM Certified Solutions Expert — Informix Dynamic Server V9 System Administrator

Exam Topics Include:
• Informix Dynamic Server Terminology
• Managing Databases and Tables
• Fragmentation
• Concurrency Control
• Indexing Strategy
• Referential and Entity Integrity
• Modes and Violation Detection
• Cost-Based Optimizer
• Update Statistics
• Data Security
• Views
• Data Movement Utilities
Product Description

Exam Number/Code: 000-910

Exam Name:managing and optimizing informix dynamic server databases

“managing and optimizing informix dynamic server databases”, also known as 000-910 exam, is a IBM certification. With the complete collection of questions and answers, Pass4sure has assembled to take you through 140 Q&As to your 000-910 Exam preparation. In the 000-910 exam resources, you will cover every field and category in Solutions Expert helping to ready you for your successful IBM Certification.

Exam Details

Job Role Description / Target Audience:If you are knowledgeable with Informix Dynamic Server Version 9 and are capable of performing the intermediate to advanced skills required in the day-to-day administration of Informix databases, you may benefit from this certification role. To attain the IBM Certified Solutions Expert – Informix Dynamic Server V9 System Administrator certification, candidates must be Certified as a System Administrator for Informix Dynamic Server Version 7, and pass 1 test.

Question: 1
Where are table spaces (tblspaces) created?

A. in dbspaces
B. in pages C. in extents D. in chunks
Answer: A Question: 2
What is database administration NOT concerned with?

A. indexing
B. creating tables
C. accessing data
D. application building
Answer: D Question: 3
Disk space for a table is allocated in one or more units called what?

A. tblspaces
B. extents C. blobs D. chunks
Answer: B Question: 4
What is a chunk when using raw devices?

A. a contiguous unit of disk space
B. a dynamic unit of disk space C. a location in shared memory D. a data table
Answer: A Question: 5
Which statement correctly changes the next extent size?

A. ALTER TABLE customer MODIFY NEXT SIZE 300
B. ALTER TABLE customer MODIFY NEXT EXTENT SIZE 300
C. ALTER TABLE customer MODIFY EXTENT SIZE 300
D. ALTER TABLE customer NEXT SIZE 300
Answer: A Question: 6
What is the system catalog?

A. A catalogued set of index criteria
B. A set of tables created by the administrator.

C. A set of tables that managed the operating system
D. A set of tables that describe the structure of the database
Answer: A Question: 7
With database logging, where are transaction records first placed?

A. in a temporary database table
B. in the logical log buffer
C. in the primary chunk
D. in the physical buffer
Answer: B Question: 8
Where is fragment information stored?

A. in the system catalog tables
B. in the physical logs
C. in the reserved pages
D. in the first page of the database tblspace
Answer: A Question: 9
Which two types of fragmentation are allowed in a CREATE TABLE statement?

A. disk striping
B. dbspace
C. indexing
D. round robin
E. mirroring F. tblspace G. sorting
H. expression
Answer: D, H Question: 10
Why is a hash function advantageous in an expression-based distribution?

A. Because it creates an even distribution of data. B. Because it creates an unevn distribution of data.
C. Because it does not do expression testing
D. Because it places all data in one dbspace.
Answer: A Question: 11
Which two happen when the ALTER FRAGMENT statement is run?

A. Transaction logging, if present is suspended.
B. The table is locked until the statement is completed.
C. The database is locked until the statement is complete.

D. For databases with logging the statement executes as a single transaction
Answer: B, D Question: 12
Which fragments an index by expression?

A. FRAGMENT BY EXPRESSION col_1
B. FRAGMENT BY EXPRESSION col_2>=10000IN dbspace 1 AND col_2>10000IN dbspace2
C. FRAGMMENT BY EXPRESSION col_1<10000 AND col_2 IN dbspace 2
D. FRAGMENT BY EXPRESSION col <20000 IN dbspace 1, col> = 20000 IN dbspace 2
Answer: D Question: 13
What are four valid logical and relational operators that can be used with expression-based distribution?

A. AND B. IN
C. < D. >= E. I=
F. MATCHES
Answer: A, B, C, D Question: 14
In which two situations would you use a round robin fragmentation strategy?

A. When all fragments must be second
B. To create uneven data distributions
C. When queries perform sequential scans and you have little information about the data being stored.
D. When tables are accessed with a high degree of selectivity
Answer: A, C Question: 15
What are three advantages of fragmentation?

A. higher availability
B. reduced disk space requirements
C. parallel scans are possible with PDQ
D. finer granularity of archives and resources
Answer: A, C, D Question: 16
What does the ATTACH clause in the ALTER FRAGMENT statement do?

A. It adds extents to a table.
B. It attaches a raw data file to a table
C. It combines two unregimented tables
D. It combines two fragmented tables

Answer: C

Question: 17
Which statement fragments a table as round robin?

A. FRAGMENT AS ROUND ROBIN IN dbspace 1, dbspace 2
B. FRAGMENT TABLE BY ROUND ROBIN IN dbspace1, dbspace 2
C. FRAGMENT BY ROUND ROBIN IN dbspace1, dbspace 2
D. FRAGMENT BY ROUND ROBIN
Answer: C Question: 18
Given that the SQL statement SET LOCK MODE TO WAIT has not been executed, if a statement attempts to alter a row that another process has locked, what happens?

A. The lock is released
B. An error is returned
C. The row is immediately updated.
D. The row is updated after the lock is removed.
Answer: B Question: 19
Which isolation level does a database without logging default to?

A. committed read
B. dirty read
C. mode ANSI
D. repeatable read
Answer: B Question: 20
Which three can be locked?

A. a row
B. a page
C. a column
D. a key
E. shared memory
Answer: A, B, D Question: 21
If there is a lock on an adjacent key, an insert will fail if the isolation level is set to what?

A. committed read B. repeatable read C. share read
D. indexed read

Answer: B

* pass4sure ibm 000-910 Questions and Answers : 140 Q&As
* Updated: October 1st , 2008
* Price: $159.99 $99.99

Free down:Testking ibm 000-910
Free down:Pass4sure ibm 000-910