Download IBM Certified System Admin-Informix Server 12-10.test-inside.C2090-619.2020-05-15.1e.29q.vcex


Download Exam

File Info

Exam IBM Certified System Admin-Informix Server 12-10
Number C2090-619
File Name IBM Certified System Admin-Informix Server 12-10.test-inside.C2090-619.2020-05-15.1e.29q.vcex
Size 17 Kb
Posted May 15, 2020



How to open VCEX & EXAM Files?

Files with VCEX & EXAM extensions can be opened by ProfExam Simulator.

Purchase
Coupon: EXAMFILESCOM

Coupon: EXAMFILESCOM
With discount: 20%


 
 



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?

  • A: Using dbschema utility
  • B: Using 'oncheck -pT' command
  • C: Querying sysdepends system catalog table
  • D: Querying sysviolations system catalog table



Question 2
Which technology does NOT use the Secure Sockets Layer (SSL) protocol for an end-to- end secure connection?

  • A: On-disk encryption
  • B: Enterprise Replication
  • C: High-Availability Data Replication
  • D: Server-to-server distributed query communication



Question 3
What is the purpose of the GRANT ADMIN privilege?

  • A: Grants the admin privilege to create role separation.
  • B: Grants the admin privilege to perform DBSA functions.
  • C: Grants the admin privilege to use the Open Admin Tool.
  • D: Grants the admin privilege to run SQL administration API commands.



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?

  • A: Mapped users
  • B: Role based users
  • C: Table level access for users
  • D: Label based access for users



Question 5
To potentially reduce table extent interleaving, an Informix administrator would execute which storage optimization operation?

  • A: Shrink
  • B: Repack
  • C: Compress
  • D: Defragment



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");

  • A: Shuts down the primary server and converts the secondary server to be the primary.
  • B: Clears the log position of the SDS servers and restarts replication.
  • C: Converts the shared disk secondary server to a standard server and shuts down the primary server.
  • D: Stops replication to the shared disk secondary servers and converts the primary server to a standard server.



Question 7
What command unlocks the storage catalogs when using the Primary Storage Manager?

  • A: onbar -d unlock
  • B: onpsm -C unlock
  • C: onmode -C unlock
  • D: onsmsync -c unlock



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?

  • A: The user encounters a lock request error.
  • B: More memory is allocated for additional lock structures from DS_TOTAL_MEMORY.
  • C: More memory is allocated for additional lock structures in the VIRTUAL section of shared memory.
  • D: More memory is allocated for additional lock structures in the RESIDENT section of shared memory.



Question 9
When KAIO is available and raw disk is used, which statement is true?

  • A: Logical Log IO is performed by the LIO VP.
  • B: Physical Log IO is performed by the PIO VP.
  • C: Logical Log IO is performed by the KAIO VP.
  • D: Physical Log IO is performed by the CPU VP.



Question 10
What is the primary benefit of a Storage Pool?

  • A: It allows data to be shared across instances.
  • B: It allows data to be shared across dbspaces.
  • C: It allows space to automatically be added to dbspaces.
  • D: It allows space to be reserved for critical database operations.









CONNECT US


ProfExam
PROFEXAM WITH A 20% DISCOUNT

You can buy ProfExam with a 20% discount..

Get Now!


HOW TO OPEN VCEX AND EXAM FILES

Use ProfExam Simulator to open VCEX and EXAM files
ProfExam Screen



HOW TO OPEN VCE FILES

Use VCE Exam Simulator to open VCE files
Avanaset