Which of the following is TRUE? (1) Host variables are declared anywhere in the program (2) Host variables are declared in the DECLARE section

Related MCQs

• Which of the following is used to distinguish the variables in SQL from the host language variables?
• The variables in the triggers are declared using
• The variables in the triggers are declared using
• The Oracle RDBMS uses the           statement to declare a new transaction start and its properties.
• 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;
• Which of the following is used to access the database server at the time of executing the program and get the data from the server accordingly?
• Which of the following header must be included in java program to establish database connectivity using JDBC ?
• A                      is a program running on the server machine, which accepts requests from a Web browser and sends back results in the form of HTML documents.
• Which is a duplicate copy of a file program that is stored on a different storage media than the original location:
• Which is a duplicate copy of a file program that is stored on a different storage media than the original location: