C2090-558 Dumps
C2090-558 Braindumps C2090-558 Real Questions C2090-558 Practice Test C2090-558 Actual Questions
Informix 11.70 Fundamentals
https://killexams.com/pass4sure/exam-detail/C2090-558
Question #110
What is true about poll threads?
poll threads always run on a CPU vp
poll threads always run on a NET vp
poll threads always run on an ADM vp
poll threads can be configured on a CPU or NET vp
Answer: D Question #111
Which database contains the system-monitoring interface (SMI) tables which provide information about the state of the database server?
sysutils
sysstate
sysmaster
sysmonitor
Answer: C Question #112
Which two storage objects exist in Informix? (Choose two.)
dbspace
flash space
smart rowspace
smart blobspace
encrypted space
Answer: AD Question #113
Which of the following is true about the remote query SELECT * FROM ABC@LMN:XYZ?
SELECT from table ABC at database LMN on server XYZ
SELECT from table ABC at server LMN on database XYZ
SELECT from table LMN on database ABC on server XYZ
SELECT from table XYZ on database ABC at server LMN
Answer: D Question #114
You create a table with the statement shown below: CREATE TABLE foo(col INTEGER) In which dbspace will the table reside?
in a temporary dbspace
in the default dbspace that is defined in onconfig
in the dbspace where the current database was created
in the dbspace specified by the IFX_DBSPACE environment variable
Answer: C Question #115
You received an error, "Chunk is not empty", while trying to remove a chunk. How do you verify which objects still occupy space in the chunk?
onspaces
onmonitor
oncheck -pe
SELECT * from SYSTABLES
Answer: C Question #116
Which of the following statement is true of System Monitoring Interface (SMI) tables?
SMI tables store database structures.
Contains tasks used by the database scheduler
SMI tables are also known as System Catalog tables
Contains tables that the database server maintains automatically
Answer: D Question #117
Which of the following statement is correct about Shared Disk (SD) secondary servers?
SD secondary servers support automatic index repair
SD secondary servers use paging files to track pages between checkpoints
SD secondary servers require an HDR secondary server to be present in order to function
SD secondary servers can become a High-Availability Data Replication (HDR) secondary server
Answer: B Question #118
Which technology can be used to execute Data Definition Language (DDL) command across multiple instances?
Flexible Grid
Enterprise Replication
High Availability Cluster
High Availability Data Replication
Answer: A Question #119
What is the lowest level of granularity supported by Enterprise Replication?
column
instance
database
fragment
Answer: A Question #120
Which of the following Informix server modes disable execution of SQL statements for all users while allowing administrative users to perform maintenance tasks?
Offline
On-Line
Quiescent
Administrative
Answer: C
6$03/( 48(67,216
7KHVH TXHVWLRQV DUH IRU GHPR SXUSRVH RQO\ )XOO YHUVLRQ LV XS WR GDWH DQG FRQWDLQV DFWXDO TXHVWLRQV DQG DQVZHUV
.LOOH[DPV FRP LV DQ RQOLQH SODWIRUP WKDW RIIHUV D ZLGH UDQJH RI VHUYLFHV UHODWHG WR FHUWLILFDWLRQ H[DP SUHSDUDWLRQ 7KH SODWIRUP SURYLGHV DFWXDO TXHVWLRQV H[DP GXPSV DQG SUDFWLFH WHVWV WR KHOS LQGLYLGXDOV SUHSDUH IRU YDULRXV FHUWLILFDWLRQ H[DPV ZLWK FRQILGHQFH +HUH DUH VRPH NH\ IHDWXUHV DQG VHUYLFHV RIIHUHG E\ .LOOH[DPV FRP
'PS .PSF FYBNT WJTJU IUUQT LJMMFYBNT DPN WFOEPST FYBN MJTU
.LOO \RXU H[DP DW )LUVW $WWHPSW *XDUDQWHHG