Overview of PL/SQL - questions and answers

Overview of PL/SQL - questions and answers

1) PL/SQL is a completely portable, high-performance transaction processing language.

A)True
B)False
View Answer / Hide Answer


2) Which of the following is used for reading and writing operating-system files?

A) UTL_FILE
B) UTL_HTTP
C) UTL_SMTP
D) None of the above
View Answer / Hide Answer


3) PL/SQL stored procedures move application code from the server to the client.

A) True
B) False
View Answer / Hide Answer


4) PL/SQL stands for -

A) Programming Language/SQL
B) Procedural Language/SQL
C) Portable Language/SQL
D) None of the above
View Answer / Hide Answer


5) Which of the following is used to declare a record?

A) %ROWTYPE
B) %TYPE
C) Both A & B
D) None of the above
View Answer / Hide Answer


6) Which of the following has a return type in its specification and must return a value specified in that type?

A) Function
B) Procedure
C) Package
D) None of the above
View Answer / Hide Answer


7) Which error occurs while the program is running and cannot be detected by the PL/SQL compiler?

A) Syntax error
B) Runtime error
C) Both A & B
D) None of the above
View Answer / Hide Answer


8) Which of the following results are true, when a ROLLBACK statement is issued to the database, the transaction has ended?

A) All work done by the transaction is undone, as if it hadn't been issued.
B) Any locks acquired by the transaction are released.
C) Both A & B
D) None of the above
View Answer / Hide Answer


9) PL/SQL is completely portable, high-performance transaction processing language that offers which of the following advantages -

A) Tight Integration with SQL
B) Better Performance
C) Higher Productivity,Full Portability,Tight Security
D) All mentioned above
View Answer / Hide Answer


10) Which of the following are used for displaying output on a web page?

A) HTF
B) HTP
C) Both A & B
D) None of the above
View Answer / Hide Answer