Download IBM Certified System Admin-Informix Server 12-10.C2090-619.TestInside.2020-05-15.29q.vcex

Vendor: IBM
Exam Code: C2090-619
Exam Name: IBM Certified System Admin-Informix Server 12-10
Date: May 15, 2020
File Size: 17 KB
Download Exam

How to open VCEX files?

Files with VCEX extension can be opened by ProfExam Simulator.

Download
ProfExam Simulator

Purchase
Coupon: EXAM_HUB

Discount: 20%

ProfExam Simulator ProfExam Simulator ProfExam Simulator ProfExam Simulator ProfExam Simulator

Demo Questions

Question 1
You have started a violations table for a target table with a non default name. (For example: "START VIOLATIONS TABLE FOR customer USING exceptions, reasons;"). How can you determine the relationship between the violations table and the target table later?
  1. Using dbschema utility
  2. Using 'oncheck -pT' command
  3. Querying sysdepends system catalog table
  4. Querying sysviolations system catalog table
Correct answer: D
Question 2
Which technology does NOT use the Secure Sockets Layer (SSL) protocol for an end-to- end secure connection?
  1. On-disk encryption
  2. Enterprise Replication
  3. High-Availability Data Replication
  4. Server-to-server distributed query communication
Correct answer: A
Question 3
What is the purpose of the GRANT ADMIN privilege?
  1. Grants the admin privilege to create role separation.
  2. Grants the admin privilege to perform DBSA functions.
  3. Grants the admin privilege to use the Open Admin Tool.
  4. Grants the admin privilege to run SQL administration API commands.
Correct answer: D
Question 4
In an organization, all employees are authenticated via domain wide Kerberos single sign- on. The DBSA wants to provide access to the database server for an employee without requesting the Operating System (OS) administrator to create a OS level user account. Which Informix feature does the DBSA need to leverage?
  1. Mapped users
  2. Role based users
  3. Table level access for users
  4. Label based access for users
Correct answer: A
Question 5
To potentially reduce table extent interleaving, an Informix administrator would execute which storage optimization operation?
  1. Shrink
  2. Repack
  3. Compress
  4. Defragment
Correct answer: D
Question 6
"informix_stores" is an established primary server with a SDS server. What is the effect of running the following command? EXECUTE FUNCTION sysadmin:admin("ha sds clear", "informix_stores");
  1. Shuts down the primary server and converts the secondary server to be the primary.
  2. Clears the log position of the SDS servers and restarts replication.
  3. Converts the shared disk secondary server to a standard server and shuts down the primary server.
  4. Stops replication to the shared disk secondary servers and converts the primary server to a standard server.
Correct answer: D
Question 7
What command unlocks the storage catalogs when using the Primary Storage Manager?
  1. onbar -d unlock
  2. onpsm -C unlock
  3. onmode -C unlock
  4. onsmsync -c unlock
Correct answer: B
Question 8
The total number of locks allocated equals the value specified by the LOCKS configuration parameter. What is the behavior of the database server when more locks are now requested?
  1. The user encounters a lock request error.
  2. More memory is allocated for additional lock structures from DS_TOTAL_MEMORY.
  3. More memory is allocated for additional lock structures in the VIRTUAL section of shared memory.
  4. More memory is allocated for additional lock structures in the RESIDENT section of shared memory.
Correct answer: C
Question 9
When KAIO is available and raw disk is used, which statement is true?
  1. Logical Log IO is performed by the LIO VP.
  2. Physical Log IO is performed by the PIO VP.
  3. Logical Log IO is performed by the KAIO VP.
  4. Physical Log IO is performed by the CPU VP.
Correct answer: D
Question 10
What is the primary benefit of a Storage Pool?
  1. It allows data to be shared across instances.
  2. It allows data to be shared across dbspaces.
  3. It allows space to automatically be added to dbspaces.
  4. It allows space to be reserved for critical database operations.
Correct answer: C
CONNECT US
HOW TO OPEN VCE FILES

Use VCE Exam Simulator to open VCE files
Avanaset

HOW TO OPEN VCEX AND EXAM FILES

Use ProfExam Simulator to open VCEX and EXAM files
ProfExam Screen

ProfExam
ProfExam at a 20% markdown

You have the opportunity to purchase ProfExam at a 20% reduced price

Get Now!