Question
a.
EXEC SQL UPDATE c;
b.
EXEC SQL UPDATE c INTO :si, :sn;
c.
EXEC SQL
UPDATE instructor
SET salary = salary + 100
WHERE CURRENT OF c;
d.
EXEC SQL UPDATE END-SQL
Posted under SQL Queries,Constraints and Triggers DBMS
UPDATE instructor
SET salary = salary + 100
WHERE CURRENT OF c;
Engage with the Community - Add Your Comment
Confused About the Answer? Ask for Details Here.
Know the Explanation? Add it Here.
Q. The update statement can be executed in host language using
Similar Questions
Discover Related MCQs
Q. Which of the following is used to access large objects from a database ?
View solution
Q. Which of the following is used to input the entry and give the result in a variable in a procedure ?
View solution
Q. The format for compound statement is
View solution
Q. Repeat
sequence of statements;
__________________
end repeat
Fill in the correct option :
View solution
Q. Which of the following is the correct format for if statement ?
View solution
Q. A stored procedure in SQL is a___________
View solution
Q. Temporary stored procedures are stored in _________ database.
View solution
Q. Declare out of classroom seats condition
DECLARE exit handler FOR OUT OF classroom seats
BEGIN
SEQUENCE OF statements
END
The above statements are used for
View solution
Q. Trigger are supported in
View solution
Q. Which of the following is NOT an Oracle-supported trigger?
View solution
Q. What are the different in triggers ?
View solution
Q. Triggers ________ enabled or disabled
View solution
Q. Which prefixes are available to Oracle triggers?
View solution
Q. Any recursive view must be defined as the union of two subqueries: a _______ query that is nonrecursive and a __________ query.
View solution
Q. Ranking of queries is done by which of the following ?
View solution
Q. In rank() function if one value is shared by two tuples then
View solution
Q. The __________ function that does not create gaps in the ordering.
View solution
Q. SELECT ID, GPA
FROM student grades
ORDER BY GPA
____________;
Inorder to give only 10 rank on the whole we should use
View solution
Q. If there are n tuples in the partition and the rank of the tuple is r , then its ________ is defined as (r ā1)/(nā1) .
View solution
Q. Inorder to simplify the null value confusion in the rank function we can specify
View solution
Suggested Topics
Are you eager to expand your knowledge beyond DBMS? We've curated a selection of related categories that you might find intriguing.
Click on the categories below to discover a wealth of MCQs and enrich your understanding of Computer Science. Happy exploring!
