adplus-dvertising
frame-decoration

Question

In query result, the type of variable which is used to loop tuples is called

a.

cursor

b.

iterator variable

c.

loop variable

d.

both a and b

Posted under DBMS

Answer: (d).both a and b

Engage with the Community - Add Your Comment

Confused About the Answer? Ask for Details Here.

Know the Explanation? Add it Here.

Q. In query result, the type of variable which is used to loop tuples is called

Similar Questions

Discover Related MCQs

Q. The variable in DBMS used to communicate error conditions between database management system and program are

Q. In database management system, if the cursor is to be moved to next rows in queries result then the command is classified as

Q. The general purpose programming languages such as COBOL and ADA is classified as

Q. The kind of record which is used to keep the information of specific database connection is classified as

Q. In multiple tuples retrieval, the command which is used to fetch queries from database is classified as

Q. If the completion of processing is to be shown then the command which is used for this purpose is called

Q. In database management systems, the record which contains all the information needed for one statement of standard query language is called

Q. In SQL standard, the variable which is considered as communication variable and is string of five characters is named as

Q. The device which scans program code and extract them from database management system for processing is classified as

Q. The problem which arises because of the differences between model of programming language and model of database is classified as

Q. The other name of application programming interface in database management system is

Q. The statement which is used to invoke any stored procedure is classified as

Q. The type of clause in programming which is used to specify values that are to be retrieved from the database is classified as

Q. The kind of iterator which lists the types and names of attributes in the result of query is classified as

Q. In Standard Query Language, the types of DROP commands include

Q. In the SQL environment, the collection of schemas is classified as

Q. The data type which can be fixed length or varying length as CHAR(n) and VARCHAR(n) respectively is classified as

Q. When the schema is to be dropped in SQL which has no elements then the type of DROP Command used is called

Q. If the referential integrity constraint is violated then the specific action clause attached by the database designers other than by default action is classified as

Q. The data type DATE has three components where as its insertion considers