File Info
| Exam | Informix 11.70 Fundamentals |
| Number | C2090-558 |
| File Name | IBM.C2090-558.Pass4Sure.2018-12-12.67q.vcex |
| Size | 221 KB |
| Posted | Dec 12, 2018 |
| Download | IBM.C2090-558.Pass4Sure.2018-12-12.67q.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
Why would you want to create a table with a lock mode row as opposed to a lock mode page?
- to reduce disk I/O
- to keep more information in memory for each locked row
- to increase concurrency among multiple users on the same table
- 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?
- Dirty Read
- Cursor Stability
- Committed Read
- Repeatable Read
Correct answer: A
Question 3
Which of the following is true about system catalog tables access?
- Only user informix can read system catalog tables
- Only system administrators can read system catalog tables
- Only database administrators can read system catalog tables
- 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?
- use dbschema utility
- inspect ONCONFIG file
- List reserved pages with oncheck -pr
- 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?
- sqlhosts file must be called sqlhosts
- set INFORMIXSQLHOSTS variable to /newlocation/sqlhosts
- set INFORMIXSQLHOSTS variable to /newlocation/newsqlhosts
- 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?
- onlog
- ontape
- onspaces
- onparams
Correct answer: D
Question 7
What are two system level databases? (Choose two.)
- sysperf
- sysadmin
- sysmaster
- sysmonitor
- sysscheduler
Correct answer: BC
Question 8
Which two of the following are required for creating a dbspace? (Choose two.)
- a mirror chunk
- two or more chunks
- a cooked file or raw device
- a file owned by root or administrator
- 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.)
- Add space to the server.
- Compress server space.
- Encrypt the server space.
- Remove space from the server.
- 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?
- dbload
- dbexport
- external table
- SQL unload statement
Correct answer: C
