×
Detail Form
We will send your result on your email id and phone no. please fill detail
1.
Which type of backup and restore (BAR) utility would be suited for restoring a single table from a level 0 backup to a specific point in time?
2.
When determining the physical log size, what should you consider?
3.
An IDS server has its LRU_MIN_DIRTY set to 1 and its LRU_MAX_DIRTY set to 2. Occasionally the checkpoint blocks user transactions from doing updates to the database for too long. How should the database administrator correct this situation?
4.
Which memory area is used for log records for smart objects?
5.
Given the following onstat -g arc information:
IBM Informix Dynamic Server Version 11.10.FC1 -- On-Line -- Up 45:18:13 -- 38912 Kbytes
num DBSpace Q Size Q Len Buffer partnum size scanner
Dbspaces - Archive Status
name number level date log log-position
rootdbs 1 0 02/11/2007.22:01 43 0x5338c
1 02/14/2007.22:01 66 0x1b2e8
2 02/16/2007.22:01 75 0x1d2e8
dbs1 2 0 02/14/2007.22:01 43 0x5338c
1 02/14/2007.22:01 66 0x1b2e8
2 02/16/2007.22:01 75 0x1d2e8
On February 16, 2007, at 1:00 PM, a chunk in dbspace bs1 encountered hardware failure.
Which method will restore all of the data, to the point of failure, to a replacement disk drive?
IBM Informix Dynamic Server Version 11.10.FC1 -- On-Line -- Up 45:18:13 -- 38912 Kbytes
num DBSpace Q Size Q Len Buffer partnum size scanner
Dbspaces - Archive Status
name number level date log log-position
rootdbs 1 0 02/11/2007.22:01 43 0x5338c
1 02/14/2007.22:01 66 0x1b2e8
2 02/16/2007.22:01 75 0x1d2e8
dbs1 2 0 02/14/2007.22:01 43 0x5338c
1 02/14/2007.22:01 66 0x1b2e8
2 02/16/2007.22:01 75 0x1d2e8
On February 16, 2007, at 1:00 PM, a chunk in dbspace bs1 encountered hardware failure.
Which method will restore all of the data, to the point of failure, to a replacement disk drive?
6.
What will the setting SQLTRACE level=LOW,ntraces=2000,size=2,mode=global within the Informix onconfig file record?
7.
Which command would be used to monitor disk activity per chunk?
8.
An Informix database server has been configured with the following parameters:
BAR_MAX_BACKUP 5
BAR_NB_XPORT_COUNT 4
BAR_XFER_BUF_SIZE 10
How many data buffers will be created during an onbar parallel backup attempt?
BAR_MAX_BACKUP 5
BAR_NB_XPORT_COUNT 4
BAR_XFER_BUF_SIZE 10
How many data buffers will be created during an onbar parallel backup attempt?
9.
The table called state has lock mode set to row within an unbuffered logged database. The onconfig file has USELASTCOMMITTED COMMITTED READ set. One user session has run the following:
begin work;
select from state where code = AK;
update state set sname = ALASKA where code = AK;
The results from the SQL select statement run by user one was:
AK Alaska
Session two runs the following (session one is still connected):
set isolation to dirty read;
select from state where code = AK;
What will session two see when they run the above SQL statements?
begin work;
select from state where code = AK;
update state set sname = ALASKA where code = AK;
The results from the SQL select statement run by user one was:
AK Alaska
Session two runs the following (session one is still connected):
set isolation to dirty read;
select from state where code = AK;
What will session two see when they run the above SQL statements?
10.
You are receiving an error when trying to drop a chunk that you think is empty. Which command will show you if any object is still allocating part of the chunk?