×
Detail Form
We will send your result on your email id and phone no. please fill detail
1.
Your company has a new business requirement concerning the maximum amount of data loss in the event that the database host server and entire disk subsystem suffer from complete hardware failure. The new requirement says that on average no more than 10 minutes worth of data must be at risk. Which action should you take?
2.
The system is performing poorly. The vmstat listing indicates the following:
502773 Active virtual pages
Size of free list is 85116
Processes swapped in 20
Processes swapped out 30
P Pages paged out 17
Device interrupts per second 1503
System calls per second 1102
Context switch rate 353
What must be done to improve performance?
502773 Active virtual pages
Size of free list is 85116
Processes swapped in 20
Processes swapped out 30
P Pages paged out 17
Device interrupts per second 1503
System calls per second 1102
Context switch rate 353
What must be done to improve performance?
3.
Considering this message in the online.log:
14:01:45 Action: Run oncheck -cd 1048992
Which command would be used to perform the recommended action?
14:01:45 Action: Run oncheck -cd 1048992
Which command would be used to perform the recommended action?
4.
A select that returns exactly one row is performed to a remote server over a TCP/IP connection. The buffer size returned is 8K. The following environment variables are set:
IFX_DEFERRED_PREPARE = 1
FET_BUF_SIZE = 10000
OPTOFC = 1
IFX_AUTOFREE = 1
How many messages will be exchanged?
IFX_DEFERRED_PREPARE = 1
FET_BUF_SIZE = 10000
OPTOFC = 1
IFX_AUTOFREE = 1
How many messages will be exchanged?
5.
Given the following entries in the onconfig file on machine unix_host, which sqlhost file is correct?
DBSERVERNAME phoenix_ids NETTYPE tlitcp,2,100,CPU
DBSERVERNAME phoenix_ids NETTYPE tlitcp,2,100,CPU
6.
A database server has 10 dbspaces and each of them consist of four 2GB chunks. Onbar is used as the backup utility. The database administrator performs a whole-system backup everyday and it takes 10 hours to complete. What should be done to reduce the backup time?
7.
Which oninit option allows the database server to quickly return to online mode, yet space used by temporary tables on disk is not reclaimed?
8.
Which class of VP can only have a single VP allocated?
9.
A database administrator (DBA) is performing an onbar restore and the restore process is taking a long time to complete. The DBA does not know how far the restore has completed. Which configuration parameter should a DBA set to monitor the restore process?
10.
What is a way that a non-privileged database administrator can change the database server operating modes from one to another (e.g.. online to quiescent)?