Home
- Salesforce
- Nutanix
- Amazon
- Microsoft
- Cisco
- SAP
- Google
- MuleSoft
- IAPP
- PeopleCert
- Fortinet
- CompTIA
- See All Vendors
Contact Us
Register / Login

Home
IBM
IBM Certified Administrator
C1000-085 Free Questions
IBM C1000-085 Quiz:1 Topic:2 Questions:1-5

Home
IBM
IBM Certified Administrator
C1000-085 Free Questions
IBM C1000-085 Quiz:1 Topic:2 Questions:1-5

IBM C1000-085 Quiz:1 Topic:2 Questions:1-5

Free Practice Mock Questions Set 1-5 (Quiz # 1) for IBM C1000-085 Exam, according to official IBM Netezza Performance Server V11.x Administrator exam syllabus topic # 2

Question: 1

Which statement is true when executing the GROM command on a Clustered Base Table (CBT)?

AIt reclaims space from deleted rows and does not re-order data

BEnough space is required for GROOM to make a complete copy of the table

CGROOM uses CREATE TABLE AS SELECT (CATAS) for CBT to reclaim space and re-order data.

DIt reclaims space from deleted rows and re-orders data.

Answer : A

Show Answer

Hide Answer

Question: 2

What are two valid column constraints?

ADEFAULT

BINITIALLY IMMEDIATE

CINITIALLY DEFERRED

DNULL

EDEFERRABLE

Answer : C, D

Show Answer

Hide Answer

Question: 3

What happens to NFS mounts after a container failover?

ANFS is handled by Red Hat OpenShift and does not need to be mounted.

BSysmgr will remount it as part of the IBM Netezza Performance Server environment

CA containers do not allow for NFS mounts.

DIt will be automatically mounted by the ipsnfs service.

Answer : A

Show Answer

Hide Answer

Question: 4

Which level of transaction isolation does IBM Netezza Performance Server implement?

Auncommitted read

Bserializable

Crepeatable read

Dcommitted read

Answer : B

Show Answer

Hide Answer

Question: 5

Which is the most efficient data type for distribution keys?

Aintegers

Binternal datatypes (ROWID etc.)

Ctemporal types

Dstrings

Answer : D

Show Answer

Hide Answer

Quiz 1

Please Enter Your Email

You can try More Free Quizzes or Save Time by using our Premium Questions

Check Premium Offer (Limited Time Offer)
Try Free Quizzes