Which one of the following does not help to maintain referential integrity?a. Unique constraintsb. Primary keysc. Cascading actions d. Foreign keys
Latest Answer: Answer is be Unique constraints. ...
What are the attributes that needs to be defined in order to read & write DB2 file in Cobol program?
What are the flavours of DB2?
Latest Answer: Oracle, Siebel like all relational databases are flavours of db2. ...
why do we declare include in between exec sql and end exec and why cant we declare copybook in place of include. Is their any reason why we declare include only
Latest Answer: In addition to the answers posted one of the additional things to have an INCLUDE between EXEC SQL and END-EXEC is that:You INCLUDE most likely will be a DCLGEN and it is going to have non COBOL language variables that is the table column names which ...
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?
Latest Answer: No, It is not posssible to select ungrouped column in a query. ...
What happens during pre-compilation and finally bind process?
Latest Answer: Pre-compilation---> Pre compiler check's the program for any embedded sql statements if found than separates them into a DBRM and an object module is formed for the host language to be compiled by the compiler.....On the otherhand the DBRM that is formed ...
what is a db2 precompiler?
Latest Answer: Consistency token and time stamp are same thing. ...
In DB2, Large Objects (LOB) Columns are used to store large objects (Documents, pictures, voice, and mixed media) in database. Which of the following clauses can't be used on LOB columns?a) GROUP
Latest Answer: None of the above ...
How many DB2 plans can be connected to CICS region at a time? a). Infinite b). 1 c). Depends on CICS region definitions d). 255 e). None of the above
Latest Answer: Plans are allocated to transactions rather than regions. For every transaction there exsists an entry for the Plan in the RCT table.In a region multiple transactions can be present so multiple Plans can be holded to each region. ...
If, for a given table, the Control Center does not show the choice Generate DDL, which of the following describes the reason? A. The table is a system object. B. The table is a summary table. C. The table
View page [1] 2 3 4 5 6 7 8 9 10 Next >>
Go Top
