1.
Which of the following commands is used to control report headers in PL/SQL?
2.
Which of the following commands is used to control report footers in PL/SQL?
3.
In PL/SQL, which of the following statements about functions is correct?
4.
How is the size of the tablespaces increased in PL/SQL?
5.
In PL/SQL, how many rows will the following query return:
Select * from books Where rownum < 10;
6.
Which of the following is a notation in PL/SQL?
7.
In PL/SQL, which of the following functions can not include decision-making statements?
8.
What is the output of the following PL/SQL query:
select decode(totalsal = 12000, ’high’, 10000, ’medium’) as decode_tesr from smp where smpno in (10, 12, 14, 16);
9.
Which of the following functions is directly used in PL/SQL?
10.
In PL/SQL, which of the following architectures uses 40% of its memory as RAM?