Download Informix 11.70 Fundamentals.C2090-558.Pass4Sure.2018-12-12.67q.vcex

Vendor: IBM
Exam Code: C2090-558
Exam Name: Informix 11.70 Fundamentals
Date: Dec 12, 2018
File Size: 221 KB
Download Exam

How to open VCEX files?

Files with VCEX extension can be opened by ProfExam Simulator.

Download
ProfExam Simulator

Purchase
Coupon: EXAMFILESCOM

Discount: 20%

ProfExam Simulator ProfExam Simulator ProfExam Simulator ProfExam Simulator ProfExam Simulator

Demo Questions

Question 1
Why would you want to create a table with a lock mode row as opposed to a lock mode page?
  1. to reduce disk I/O
  2. to keep more information in memory for each locked row
  3. to increase concurrency among multiple users on the same table
  4. to reduce the number of locks when accessing rows out of the table
Correct answer: C
Question 2
Which isolation level is appropriate if you do not want your query to place any locks?
  1. Dirty Read
  2. Cursor Stability
  3. Committed Read
  4. Repeatable Read
Correct answer: A
Question 3
Which of the following is true about system catalog tables access?
  1. Only user informix can read system catalog tables
  2. Only system administrators can read system catalog tables
  3. Only database administrators can read system catalog tables 
  4. Any user that can connect to the database can read system catalog tables
Correct answer: D
Question 4
How can you determine which databases are created in an instance? 
  1. use dbschema utility
  2. inspect ONCONFIG file
  3. List reserved pages with oncheck -pr
  4. run SELECT name FROM sysmaster:sysdatabases
Correct answer: D
Question 5
You want to use sqlhosts file /newlocation/newsqlhosts. Which of the following is true?
  1. sqlhosts file must be called sqlhosts
  2. set INFORMIXSQLHOSTS variable to /newlocation/sqlhosts
  3. set INFORMIXSQLHOSTS variable to /newlocation/newsqlhosts
  4. sqlhosts file must be defined under $INFORMIXDIR/etc/ directory
Correct answer: C
Question 6
Which utility can be used to relocate the physical log to a new dbspace?
  1. onlog
  2. ontape
  3. onspaces
  4. onparams
Correct answer: D
Question 7
What are two system level databases? (Choose two.)
  1. sysperf
  2. sysadmin
  3. sysmaster
  4. sysmonitor
  5. sysscheduler
Correct answer: BC
Question 8
Which two of the following are required for creating a dbspace? (Choose two.) 
  1. a mirror chunk
  2. two or more chunks
  3. a cooked file or raw device
  4. a file owned by root or administrator
  5. dbspace name containing only letters, digits, underscores, or $ characters.
Correct answer: CE
Question 9
Which two operations are performed with the onspaces command? (Choose two.)
  1. Add space to the server.
  2. Compress server space.
  3. Encrypt the server space.
  4. Remove space from the server.
  5. Restrict access to the server space.
Correct answer: AD
Question 10
A progammer wants to unload a table to a file inside a stored procedure. What functionality listed below will help the programmer accomplish the task?
  1. dbload
  2. dbexport
  3. external table
  4. SQL unload statement 
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!