Freshers / Beginner level questions
Freshers / Beginner level questions & answers
Ques 1. What is IBM DB2?
IBM DB2 is a family of data management products, including database servers, developed by IBM.
Ques 2. What is a stored procedure in DB2?
A stored procedure is a set of SQL and procedural statements that are stored on the database server and can be invoked by a client application or another stored procedure.
Ques 3. Explain the purpose of the COMMIT statement in DB2.
The COMMIT statement in DB2 is used to save all the changes made during the current transaction to the database.
Ques 4. What is a foreign key in DB2?
A foreign key is a column or set of columns in a table that refers to the primary key of another table. It establishes a link between the two tables.
Ques 5. What is a trigger in DB2?
A trigger is a set of SQL statements that are automatically executed, or 'triggered,' in response to a specified event on a particular table or view.
Most helpful rated by users: