Online Access Free C1000-085 Practice Test

To how many resource groups can a user be assigned?

• A.unlimited
• B.three
• C.one
• D.four

Which partition on the SPU node us used to store transient working data that is generated during query execution?

• A.Primary
• B.Nzscratch
• C.nzlocal
• D.Mirror

What are Clustered Base Tables (CBT)?

• A.Tables that contain sorted data using one to four columns.
• B.Tables that decrease allocated storage
• C.Tables that replicate the base table.
• D.Tables that increase pre-sorting of new table records before a loading operation.

Which log file provides a DBA with an actual SQL statement that was executed?

• A.pg.log
• B.dbos.log
• C.sysmgr.log
• D.clientmgr.log

What command is used to add an event?

• A.nzevent create
• B.nzevent add
• C.nzevent load
• D.nzevent insert