Database Management System Question
Database Management System Question With Answer & Solution
Que. - Which datatype is not allowed in the definition of PL/SQL record?
Que. - In the SQL Cursor, which attribute is TRUE when a cursor has some remaining rows to fetch, and FALSE when a cursor has no rows left to fetch?
Que. - For which Exception, if a SELECT statement attempts to retrieve data based on its conditions, this exception is raised when no rows satisfy the SELECT criteria?
Que. - In the PL/SQL block below, how many rows will be inserted in the messages table? DECLARE v_start_salesNUMBER := 2; v_end_sales NUMBER := 100; BEGIN FOR i IN v_start_sales..v_end_sales LOOP INSERT INTO messages(msgid) VALUES v_start_sales; END LOOP; END;
Que. - Which collection types is also known as index-by tables, lets you look up elements Using arbitrary numbers and strings for subscript values?
Que. - Assigning a value to a collection element can cause exceptions, such as
Que. - Which is a procedural extension of Oracle- SQL that offers language constructs similar tothose in imperative programming languages?
Que. - Which of the following retains duplicate rows in the result of a query or in an Aggregate expression?
Que. - Which of the following is an aggregate function in SQL?
Que. - Which command is used to add a column to an existing table?
Showing
1211
To
1220 of 1293 results