File Info
| Exam | IBM Certified System Admin-Informix Server 12-10 |
| Number | C2090-619 |
| File Name | IBM.C2090-619.TestInside.2020-05-15.29q.vcex |
| Size | 17 KB |
| Posted | May 15, 2020 |
| Download | IBM.C2090-619.TestInside.2020-05-15.29q.vcex |
How to open VCEX & EXAM Files?
Files with VCEX & EXAM extensions can be opened by ProfExam Simulator.
Coupon: MASTEREXAM
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?
- Using dbschema utility
- Using 'oncheck -pT' command
- Querying sysdepends system catalog table
- 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?
- On-disk encryption
- Enterprise Replication
- High-Availability Data Replication
- Server-to-server distributed query communication
Correct answer: A
Question 3
What is the purpose of the GRANT ADMIN privilege?
- Grants the admin privilege to create role separation.
- Grants the admin privilege to perform DBSA functions.
- Grants the admin privilege to use the Open Admin Tool.
- 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?
- Mapped users
- Role based users
- Table level access for users
- 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?
- Shrink
- Repack
- Compress
- 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");
- Shuts down the primary server and converts the secondary server to be the primary.
- Clears the log position of the SDS servers and restarts replication.
- Converts the shared disk secondary server to a standard server and shuts down the primary server.
- 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?
- onbar -d unlock
- onpsm -C unlock
- onmode -C unlock
- 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?
- The user encounters a lock request error.
- More memory is allocated for additional lock structures from DS_TOTAL_MEMORY.
- More memory is allocated for additional lock structures in the VIRTUAL section of shared memory.
- 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?
- Logical Log IO is performed by the LIO VP.
- Physical Log IO is performed by the PIO VP.
- Logical Log IO is performed by the KAIO VP.
- Physical Log IO is performed by the CPU VP.
Correct answer: D
Question 10
What is the primary benefit of a Storage Pool?
- It allows data to be shared across instances.
- It allows data to be shared across dbspaces.
- It allows space to automatically be added to dbspaces.
- It allows space to be reserved for critical database operations.
Correct answer: C
