-
What is cursor stability?
Cursor stability means that DB2 takes a lock on the page the cursor is accessing and releases the lock when the cursor moves to another page.
sintalam4
- Dec 21st, 2010
The Cursor Stability (CS) isolation level is the default isolation level and locks any row on which the cursor is positioned during a unit of work. The lock on the row is held until the next row is fe...
radibioinfo
- Oct 2nd, 2007
Cursor stability isolation level ensures that any row that was changed by an application process cannot be read untill committed by that process. It ensures that the current row of every updatab...
-
A table called EMPLOYEE has the following columns: name, department, and phone_number. Which can limit read access to the phone_number column?
A table called EMPLOYEE has the following columns: name, department, and phone_number. Which of the following can limit read access to the phone_number column? A. Using a view to access the table B. Using a referential constraint on the table C. Revoking access from the phone_number column D. Defining a table check constraint on the table
davindersingh29
- Jun 22nd, 2009
A. Using a view to access the tableOne should create a VIEW, this way the phone number column can be made read only.
-
Locked Space
What is meant by locked space? Describe locking concepts?
vjjammi
- Aug 25th, 2010
DB2 Supports Locking mechanism at three levels. 1. Space Level. 2. Table Level. 3. Page Level. The above hierarchy has some significance and in order to lock a page at the higher level, you needn&#...
-
Explain the use of the WHERE clause. WHERE is used with a relational statement to isolate the object element or row.
Srinivas17738
- Aug 17th, 2010
1. WHERE clause is used to filter the result set records with different predicates like -- BETWEEN, =, = and many more....2. WHERE Clause is used to Isolate rows.
mahadev mahajan
- Sep 30th, 2005
where clause is use to extrct only one record.it is used with GROUP BY CLAUSE. EG:-SELECT DNO FROM EMP WHERE SAL=4200 ...
-
What techniques are used to retrieve data from more than one table in a single SQL statement?
Joins, unions and nested selects are used to retrieve data.
AR
- Mar 16th, 2007
The two tables has to be linked.EXEC SQL
SELECT A.EMP_ID, B.WAGE FROM Table1 A, Table2 B WHERE A.EMP_ID = B.EMP_ID
AND A.EMP_ID = 100001 END-EXEC. -
Bind process
What happens during pre-compilation and finally bind process?
naga1126
- Jun 16th, 2010
Bind process is mainly for two processes:1. To syntax check the Query (To see the Columns and tables referred are actually present etc. )2. To find the efficient access path.Result of Bind is an Executable form of the DBRM.
yuvaevergreen
- Apr 11th, 2010
Precompilation:Separates out the SQL statements in the COBOL program and creates the DBRM.BIND:Creates the executable format of DBRMs.
-
What is normalization and what are the five normal forms?
Normalization is a design procedure for representing data in tabular format. The five normal forms are progressive rules to represent the data with minimal redundancy.
muamee
- Jun 14th, 2010
Normalization in DB2 is used to reduce data redundancy and maintain integrity.There are 4 types normalization1st type: Every instances of an entiry should contain only one value.2nd type: Each at...
-
Attributes to Read & Write DB2 file
What are the attributes that needs to be defined in order to read & write DB2 file in Cobol program?
shak_techm
- May 26th, 2010
To see the attributes of RW DB2 file do the following:Go to DB2 regionSelect 3 admin tool1 - DB2 system catalogT - Tables, views, and aliasesD - DatabaseDIS - Display databaseYou will get screen ...
-
What happens when more than one row satisfies a Select statement that is executed outside of any cursor processing?
pawan_singh
- May 14th, 2010
If you using just a simple select SQL statement and it is giving you more than one row as output than you will get a SQL code retrun -811. To avaoid this depending your requirement you can modify your query or if you need more than one row than just use cursor.ThanksPawan
-
Referential Integrity
Which one of the following does not help to maintain referential integrity?a. Unique constraintsb. Primary keysc. Cascading actions d. Foreign keys
-
Group By
Can you select any column in a Group by query even if that column is not groupable?e.g. Select Dept, Empno, Ave(salary) From T1 Group by DeptCan we select empno in the above query?
-
What is the result of the following statement?
Given the following transaction in an embedded SQL application: CREATE TABLE dwaine.mytab (col1 INT, col2 INT) INSERT INTO dwaine.mytab VALUES (1,2) INSERT INTO dwaine.mytab VALUES (4,3) ROLLBACK What is the result of issuing the following statement? SELECT * FROM dwaine.mytab
-
Explain about CHAR function and it's use in DB2
yuvaevergreen
- Mar 26th, 2010
Returns a fixed-length character string representation of Datetime Character Integer Decimal Floating-point number Row ID
kalone
- Feb 1st, 2010
If we want to concatenate date or time values to some text ,then we have to convert those values to string char first ,for this in DB2 we have CHAR() function.Eg. CHAR(CURRENT DATE)
-
How do we unload the DB2 tables using JCL?
yuvaevergreen
- Mar 26th, 2010
We can use UNLOAD utility for loading a table to file. Following is a sample JCL.//STEP1 EXEC DSNUPROC,UID='SMPLUNLD',UTPROC='',SYSTEM='DSN'//SYSREC DD DSN=USERID.SMPLUNLD.SYSREC,// DISP=...
Smitha Brindavan
- Mar 15th, 2007
If DBP1 is the subsystem name, then the below unload step can be used//STEP001 EXEC DBP1UNLD,USER='USERNAME',ULDTAB='FILE1',DATE='UNLOAD(+1)' //UNLOAD.SYSREC00 DD SPACE=(CYL,(6...
-
DB2 Storage groups
Select the correct statement 1 Storage groups can be altered2 Database can be altered3 Tablespace can be altered4 All of the Choices
All of the Choices -
DB2 Synonyms
i) Synonyms can refer to local and remote table ii) Alias can refer only to local tables Of the Statement 1 Both are TRUE2 Both Are False3 i) is Only True4 ii) is Only True Both Are False
-
Which of the following is not true about Bind ?
a.Programs bound to packages must still be designated in a plan.b.SQL statements are validated during Bind.c.Authorization is verified during bind.d.SQL statements cannot be executed unless bind is performed.e.The program should determine the db2 access path before the bind is performed.The program should determine the db2 access path before the bind is performed.
yuvaevergreen
- Mar 26th, 2010
The program should determine the db2 access path before the bind is performed.
-
DB2 View Purpose
Which of the following is not a purpose of a View ?a.To simplify the appearance of data to different usersb.To control access to a tablec.To show more meaningful data, such as summaryd.To store data separately for user copye.To get data from multiple tables To store data separately for user copy
ambareeshtss
- Oct 19th, 2008
DB2 table may have many fields, All the users are not intended to see some fields. To customise this, Views are created for DB2 tables. A single DB2 tables can have any no.of views.
-
How to retrieve n-th row ie n-th record of any table irrespective of the columns and the values present in the table without using ROWID(As it is not supported in DB@)?
dyury
- Mar 8th, 2010
We can use scrollable cursor ( with DB2 V8 and higher).FETCH FIRST ROWSET STARTING AT ABSOLUTE N FROM CURSOR1 FOR 1 ROW.
kaviarasu
- Jun 23rd, 2006
SELECT * FROM TABLE_NAME AAWHERE 5 = (SELECT COUNT (FIRST_FIELD) FROM TABLE_NAME WHERE FIRST_FIELD <= AA.FIRST_FIELD )WITH UR;
-
What are db2 pre compilers?
kalone
- Jan 31st, 2010
DB2 pre-compiler extracts all the SQL stmnts from the appln prg and keeps them in DBRM and comments those SQL stmnts (in the appln prg) and replaces them with a CALL.
DB2 Interview Questions
Ans