Create Next App

Exam contains 131 questions

Page 9 of 22

Question 49 🔥

Which of the following statements is TRUE when a table is created?

Which database solution meets these requirements?

A. 3MB of temporary space is allocated on each dataslice for the table

Highly voted

B. One page of storage space is allocated on each dataslice for the table

Highly voted

C. One extent of storage space is allocated on each dataslice for the table

Highly voted

D. No space is allocated by the system until a record is inserted into the table

Highly voted

Discussion of the question

Question 50 🔥

Which of the following can the NZDUMPSCHEMA command be used for?

Which database solution meets these requirements?

A. Backup a database

Highly voted

B. Dump the entire system catalog

Highly voted

C. Output a shell script with SQL statements

Highly voted

D. Generate schema information, with its associated user data

Highly voted

Discussion of the question

Question 51 🔥

Dropping an external table does which of the following?

Which database solution meets these requirements?

A. Deletes the data but not the table definition

Highly voted

B. Deletes the table definition but not the data

Highly voted

C. Deletes both the table definition and the data

Highly voted

D. Deletes neither the table definition nor the data

Highly voted

Discussion of the question

Question 52 🔥

What will occur when two large tables are joined together and the data is NOT co-located?

Which database solution meets these requirements?

A. A hash join is not performed

Highly voted

B. No data movement is required

Highly voted

C. Data is dynamically redistributed or broadcasted

Highly voted

D. One of the tables must be manually redistributed

Highly voted

Discussion of the question

Question 53 🔥

Which of the following is FALSE?

Which database solution meets these requirements?

A. Outdated rows will cause queries to run slower

Highly voted

B. Outdated rows will cause disk space to be consumed by deleted data

Highly voted

C. Outdated rows consume space on a full backup

Highly voted

D. Outdated rows will show up in the query's result set

Highly voted

Discussion of the question

Question 54 🔥

Which statement regarding temporary tables is TRUE?

Which database solution meets these requirements?

A. They are limited to 1 terabyte in size

Highly voted

B. They may include a DISTRIBUTE ON clause

Highly voted

C. They are limited to 16 tables per user per database

Highly voted

D. They will be included in any nzbackup of the database

Highly voted

Discussion of the question

Ready to Pass Your Certification Test

ibm C2090_560

Exam contains 131 questions

Lorem ipsum dolor sit amet consectetur. Eget sed turpis aenean sit aenean. Integer at nam ullamcorper a.

Company

Product

Resources

Follow us