Is it possible to create an Instance in DB2 using DB2 Control Center ?
No Answer is Posted For this Question
Be the First to Post Answer
How do you simulate the EXPLAIN of an embedded SQL statement in SPUFI/QMF? Give an example with a host variable in WHERE clause)
What is the syntax for seeing the columns and data types of a table in the db2 database?
What is a page?
When do you specify the isolation level?
What do you mean by NOT NULL? When will you use it?
Are views updatable ?
What is nvl in db2?
Name some fields from SQLCA.
Can we update view in db2?
Why select is not preferred in embedded sql programs?
Describe what a storage group(STOGROUP) is?
SI Stud name Subject Marks Pass/Fail 1 Sham Maths 40 P 1 Sham Physics 50 P 1 Sham Bio 20 F 2 Ram Maths 40 P 2 Ram Physics 50 P 2 Ram Bio 60 P For the above data , write the SQL query for the student who passed in all the subjects . For eg : I want the data of only Ram coz he passed all subjects .