×
Detail Form
We will send your result on your email id and phone no. please fill detail
1.
An unbuffered logging database has been created in a dbspace called dbs1. The system also has two temporary dbspaces created, which are tp1 and tp2. What will happen when the following SQL statement is run? create temp table t(a int) fragment by expression a = 1 in tp1, a = 2 in tp2;
2.
Given a datetime column, how should you find the last day of the month?
3.
Which mechanism would a database administrator use to create a SQL-like group of users to manage permissions?
4.
A user wants to ensure locking errors are not encountered when selecting data. What is the highest isolation level that the user may use?
5.
Which command can be used to get the value of CLIENT_LOCALE from a session?
6.
The table called customer contains 0.5 million rows and an index is being created on an integer column. While the index is being created, the statistical information is automatically collected. Which default resolution percentage will be used?
7.
If the user Informix is connected to a database called stores_demo, which command should be used to check the data for the part number shown?
8.
What is the purpose of FASTPOLL onconfig parameter?
9.
How should you convert an ASCII character to its decimal representation?
10.
How can a database administrator remotely view the entire online.log?