Computer Science - SQL, PLUS SQL, PL/SQL , Forms and Reports – Multiple Choice Question

Question 1 of 240

1. Question

Which of the following activities are you allowed to do after executing the DISCONNECT command?

Roconnect
Exit the SQL* plus session
Execute certain SQL* plus commands
None of the above

Question 2 of 240

2. Question

What does the / command do?

Does nothing
Prints the character /
Re-executes the non SQL*Plus command that was most recently executed.
Re-executes the most recently executed command

Question 3 of 240

3. Question

What command should you try if DBMS_OUTPUT.PUT_LINE is not doing what it is supposed to do?

SET ECHO ON
SET TERMOUT ON
SET DISPLAY ON
SET SERVEROUTPUT ON

Question 4 of 240

4. Question

SQL*Plus will know you are typing a PL/SQL block when it encounters the keyword

PL/SQL
BEGIN
EXCEPTION
DECLARE

Question 5 of 240

5. Question

Which of the following is buffered by SQL*Plus?

SQL statements
SQL*Plus commands
PL/SQL block
None of the these

Question 6 of 240

6. Question

A script file that is executed by SQL*Plus cannot contain

SQL*Plus commands
SQL statements
PL/SQL block
none of the above

Question 7 of 240

7. Question

Script files can be executed by the

START command
STA command
@ command
EXECUTE command

Question 8 of 240

8. Question

To change the format of of the date returned by SYSDATE., use the command

ALTER SESSION RESET DATE
ALTER SESSION CHANGE DATE
ALTER SESSION SET SYSDATE
ALTER SESSION SET NLS_DATE_FORMAT

Question 9 of 240

9. Question

Which of the following methods cannot be used to specify a comment in SQL*Plus scripts?

--
REMARK
/*....*/
None of the above

Question 10 of 240

10. Question

The DUAL table has

One row with many columns
One column with many rows
One row and one column
Many rows and many columns

Question 11 of 240

11. Question

The DESCRIBE command if used on a table, will not display information about

Primary key
Default Values
Indexes
Triggers

Question 12 of 240

12. Question

The ALL Data Dictionary view lets you access any object

owned by you
for which you have access rights
in the database
none of these

Question 13 of 240

13. Question

A PL/SQL block can return data to SQL*Plus through

bind variables
substitution variables
local variables
none of these

Question 14 of 240

14. Question

Which of the following is not a type of data dictionary view?

USER
ALL
DBA
SYS

Question 15 of 240

15. Question

Which of the following information will be displayed when you use the DESCRIBE command on functions?

Data type of the return value
Data type of the parameters
Mode of the parameters
Default value of the parameters

Question 16 of 240

16. Question

The owner of the DUAL table is

SYS
SUPERUSER
SCOTT
MANAGER

Question 17 of 240

17. Question

Which of the following data dictionary view is used by the DESCRIBE command to extract information about the column?

ALL-TABLES
ALL_COLUMNS
ALL_COLS
ALL_TAB_COLUMNS

Question 18 of 240

18. Question

SGA stands for

Show Ghlobal Area
Start Global Area
System Global Area
Shut Global Area

Question 19 of 240

19. Question

You are executing a SELECT statements. In the display, each row that is displayed spans more than a line and you see a line after a set of 5 records. You can fix this problem by using the

SET LINESIZE command
SET PAGESIZE command
SET LINESIZE and SET PAGESIZE commands
SET SCREENWIDTH command

Question 20 of 240

20. Question

Which command is used to get input from the user?

GET
ACCEPT
READ
CIN

Question 21 of 240

21. Question

Which of the following remarks about SQL*Plus are correct ?

It is a PL/SQL development tool
It works in character mode
It is an integral part of the standard Oracle installation
It does not have a PL/SQL engine

Question 22 of 240

22. Question

To interactively assign a value to a variable, precede the variable name with

:
--
getVal
&

Question 23 of 240

23. Question

Which of the following SQL*Plus commands can be used to see the compilation errors in a PL/SQL code?

TRACE
SHOW ERRORS
PROGILE
DEBUG

Question 24 of 240

24. Question

NOT BETWEEN 10 AND 20

displays NULL values
does not display NULL values
may display NULL values
none of these

Question 25 of 240

25. Question

The SQL statement
SELECT SUBVSTR(‘123456789’,INSTR(‘abcabcabc’), 4) FROM DUAL ;
prints

6789
2346
1234
456789

Question 26 of 240

26. Question

The SELECT statement
SELECT ‘Hi’ FROM DUAL WHERE 1 = NULL;
outputs

Hi
FALSE
TRUE
nothing

Question 27 of 240

27. Question

Which of the following group functions ignore NULL values?

MAX
COUNT
SUM
COUNT(*)

Question 28 of 240

28. Question

Table Employee has 10 records. It has a non-NULL SALARY column which is also UNIQUE The SQL statement
SELECT COUNT(*) FROM EMPLOYEE WHERE SALARY > ANY (SELECT SALARY FROM EMPLOYEE);
prints

10
9
5
0

Question 29 of 240

29. Question

The SQL statement
SELECT SUBSTR(‘abcdefghij’. INSTR(“123321234′,’2′,3,2), 2) FROM DUAL:
prints

gh
23
bc
ab

Question 30 of 240

30. Question

From the following combinations of wildcard characters, choose those that are equivalent

%
_%
%_
- -

Question 31 of 240

31. Question

THE SQL statement
SELECT ROUND (45.926.-1) FROM DUAL;

is illegal
prints garbage
prints 045.926
prints 50

Question 32 of 240

32. Question

Which of the following must be enclosed in double quotes ?

Dates
Column Alias
Strings
All of these

Question 33 of 240

33. Question

If the SQL statement
SELECT NEXT_DAY(’01-SEP-95′,’FRIDAY’) FROM DUAL;
prints
08-SEP-95
what will the SQL statements
SELECT NEXT_DAY(’01-SEP-95′,’SATURDAY’) FROM DUAL ;
print?

09-SEP-95
02-SEP-95
05-SEP-95
06-SEP-95

Question 34 of 240

34. Question

The SELECT statement
SELECT ‘Hi’ FROM DUAL WHERE 1 !=NULL;
outputs

TRUE
Hi
FALSE
nothing

Question 35 of 240

35. Question

In SQL, 10/NULL will evaluate to

FALSE
-1
NULL
10

Question 36 of 240

36. Question

Almost all the DATE functions return a value of data type DATE, except

MONTHS_BETWEEN
ROUND
NEXT_DAY
TRUNC

Question 37 of 240

37. Question

The SELECT statement
SELECT LOWER(‘ABCd’), UPPER (‘ABCd’), INITCAP(‘ABCd eFgh’) FROM DUAL ;
will print

abcd ABCD Abcd Efgh
abcd ABCD ABCD EFGH
abcd ABCD abcd efgh
abcd ABCD aBCD eFGH

Question 38 of 240

38. Question

The SQL statement
SELECT TRUNC(45.926, -1) FROM DUAL;

is illegal
5
prints 45.9
prints 40

Question 39 of 240

39. Question

The SQL statement
SELECT SUBSTR(‘123456789′,INSTR(abcabcabc’, ‘b’,4)) FROM DUAL;
prints

2345
6789
56789
89

Question 40 of 240

40. Question

The SQL statement
SELECT SYSDATE FROM DUAL ;
prints
06-FEB-05
Consider the three SQL statements
SELECT TO_DATE( )LTRIM (RTRIM(‘NOV 23,2005′))),’Mon DD, YY’) FROM DUAL; – Statement 1
SELECT TO_DATE( )RTRIM (LTRIM(‘NOV 23,2005′))),’Mon DD, YY’) FROM DUAL; – Statement 2
SELECT TO_DATE( ‘NOV 23,2005′))),’Mon DD, YY’) FROM DUAL; – Statement 3
Which of these statements gives the same output?

Only Statement 1 and Statement 2
Only Statement 1 and Statement 3
Only Statement 2 and Statement 3
All the three statements give the same output

Question 41 of 240

41. Question

Which of the following could be the primary key of the OrderInfo table?

OrderNum
OrderDate
OrderedItem
None of the above

Question 42 of 240

42. Question

Which of the following could be the secondary key of the OrderInfo table?

OrderNum
OrderDate
OrderedItem
None of the above

Question 43 of 240

43. Question

If someone talks of order header information, probably he/she is referring to the table,

Custinfo
OrderInfo
ItemInfo
none of the above

Question 44 of 240

44. Question

The SQL statement
SELECT SUM(B.Quantity * C.UnitPrice)
FROM CustInfo A, OrderInfo B, ItemInfo C
WHERE A.custNum = 1009
AND A.OrderNum = B.OrderNum
AND B.OrderedItem = C.ItemName;
prints,

101
an unpredictable value
1139
none of these

Question 45 of 240

45. Question

To answer the question – Whose bill is the highest, we need to write a SQL query that joins the tables

CustInfo, OrderInfo, and ItemInfo
OrderInfo and ItemInfo
CustInfo and ItemInfo
none of these

Question 46 of 240

46. Question

How many rows does the following SQL query print?
SELECT DISTINCT A.OrderNum, B.OrderNum
FROM CustInfo A, OrderInfo B
GROUP BY (A.OrderNum, B.OrderNum);

10
24
100
240

Question 47 of 240

47. Question

Fill the blanks in the following query that finds the number of orders that ordered for either pen or pencil.
SELECT _________ (DICTINCT __________)
FROM OrderInfo B
WHERE B. OrderItem =’Pen’ ____ B. OrderedItem = _________ ;

COUNT, OrderNum, OR, 'Pencil'
COUNT, OrderNum, 'OR', 'Pencil'
UNIQUE, OrderNum, OR, 'Pencil'
None of the above

Question 48 of 240

48. Question

Fill the blanks in the following query that finds the number of customers who ordered for either pen or pencil.
SELECT COUNT(_______ A. CustNum)
FROM CustInfo A, OrderInfo B
WHERE A.OrderNum = B.OrderNum
_______ B. OrderedItem _____ (‘Pen’,’Pencil’);

ALL, AND, NOT IN
ALL. OR, IN
DISTINCT, AND, IN
DISTINCT, OR, IN

Question 49 of 240

49. Question

Which of the following CustNum will not be displayed by the following SQL query?
SELECT A.CustNum
FROM CustInfo A, OrderInfo B
WHERE A.OrderNum = B.OrderNum
AND B.OrderedItem = ‘pen’
UNION
SELECT A.CustNum
FROM CustInfo A, OrderInfo B
WHERE A.OrderNum = B.OrderNum
AND B.OrderedItem = ‘pencil’;

1006
1007
1008
1009

Question 50 of 240

50. Question

How many rows will be displayed by the following SQL query?
SELECT A.CustNum
FROM CustInfo A, OrderInfo B
WHERE A.OrderNum = B.OrderNum
AND B.OrderedItem = ‘pen’
UNION ALL
SELECT A.CustNum
FROM CustInfo A, OrderInfo B
WHERE A.OrderNum = B.OrderNum
AND B.OrderedItem = ‘pencil’;

7
8
9
10

Question 51 of 240

51. Question

Which CustNum will not be displayed by the following SQL query?
SELECT A.CustNum
FROM CustInfo A, OrderInfo B
WHERE A.OrderNum = B.OrderNum
AND B.OrderedItem = ‘pen’
INTERSECT
SELECT A.CustNum
FROM CustInfo A, OrderInfo B
WHERE A.OrderNum = B.OrderNum
AND B.OrderedItem = ‘pencil’;

1001
1002
1006
1009

Question 52 of 240

52. Question

How many CustNum will be displayed by the following SQL query?
SELECT DISTINCT A.CUStNum
FROM CustInfo A, OrderInfo B
WHERE A.OrderNum = B.OrderNum
AND B.OrderedItem NOT IN (SELECT A.OrderedItem
FROM OrderInfo A
WHERE A.OrderNum IN (2001, 2002));

4
5
6
7

Question 53 of 240

53. Question

How many CustNum will be displayed by the following SQL query?
SELECT A.CUSTNUM
FROM CustInfo A, OrderInfo B
WHERE A.OrderNum = B.OrderNum
AND B.OrderedItem IN (‘pen’, ‘Pencil’)
INSTERSECT
SELECT A.CustNum
FROM CustInfo A, OrderInfo B
WHERE A.OrderNum = B.OrderNum
AND B.OrderedItem NOT IN (‘Pen’, ‘Pencil’);

0
1
4
5

Question 54 of 240

54. Question

How many CustNum will be displayed by the following SQL query?
SELECT A.DISTINCT CustNum
FROM CustInfo A, OrderInfo B
WHERE A.OrderNum = B.OrderNum
AND A.CIty IN (‘Kanpur’, ‘Guntur’)
AND B.OrderedItem IN (‘Table’, ‘Chair’);

0
1
2
3

Question 55 of 240

55. Question

How many CustNum will be displayed by the following SQL Query ?
SELECT DISTINCT (A.CustNum)
FROM CustInfo A, OrderInfo B
WHERE A.OrderNum = B.OrderNum
AND B.OrderedItem IN (‘Table’, ‘chair’, ‘Pen’, ‘Pencil’) ;
MINUS
SELECT DISTINCT(A.CustNum)
FROM CustInfo A, OrderInfo B
WHERE A.OrderNum = B.OrderNum
AND A.City In (‘Kanpur’, ‘Vizag’, ‘Guntutr’, ‘Agra’, ‘Pune’, ‘Dehli’, ‘Imphal’) ;

0
1
2
3

Question 56 of 240

56. Question

Which of the following remarks about the following query are true?
SELECT DISTINCT(A.CustNum)
FROM CustInfo A, OrderInfo B
WHERE A.OrderNum = B.OrderNum
AND B.OrderedItem = SELECT C.ItemName
FROM ItemInfo C
WHERE C.UnitPrice = (SELECT Max (C.UnitPrice)
FROM ItemInfo C));

This query is syntactically wrong
It returns 5 rows
One of the CustNum returned is 1008
It returns all CustNum that ordered a table

Question 57 of 240

57. Question

Which of the listed options can fill the blank if the following query displayed exactly 6 rows?
SELECT DISNICT(A.CustNum)
FROM CustInfo A, OrderInfo B
WHERE A.OrderNum = B.OrderNum
AND B.OrderedItem = (SELECT C.ItemName
FROM ItemInfo C
WHERE C.UnitPrice> ____);

2
8
20
30

Question 58 of 240

58. Question

What is the CustNum will be displayed by the following SQL query?
SELECT DISTINCT(A.CustNum)
FROM CustInfo A, OrderInfo B
WHERE A.OrderNum = B.OrderNum
AND B.OrderDate = SELECT MAX (C.OrderDate)
FROM OrderInfo C);

1001
1002
1003
1004

Question 59 of 240

59. Question

How many rows are returned by the following query ?
SELECT DISTINCT(A.CustNum)
FROM CustInfo A, OrderInfo B
WHERE A.OrderNum = B.OrderNum
AND B.OrderDate = BETWEEN ’11-JUN-04′ AND ’02-FEB-05′;

4
5
6
7

Question 60 of 240

60. Question

The query
SELECT SYSDATE FROM DUAL;
displays
02-FEB-05
How many rows will be displayed by the following query?
SELECT DISTINCT(A.CustNum)
FROM CustInfo A, OrderInfo B
WHERE A.OrderNum = B.OrderNum
AND SUBSTR(TO-CHAR”(B.OrderDate), 8) = (SELECT SUBSTR(To_CHAR(SYSDATE), 8) FROM DUAL);

1
2
3
4

Question 61 of 240

61. Question

Which of the following combinations of wildcard characters has the same meaning as the wildcard character % ?

%%
_%
%_
_ _

Question 62 of 240

62. Question

The SELECT statement
SELECT ‘Hi’ FROM DUAL WHERE NULL = NULL;
outputs

Hi
FALSE
TRUE
nothing

Question 63 of 240

63. Question

Which of the following is illegal ?

SELECT SYSDATE _ SYSDATE FROM DUAL ;
SELECT SYSDATE _ (SYSDATE - 2) FROM DUAL ;
SELECT SYSDATE _ (SYSDATE + 2) FROM DUAL ;
None of the above

Question 64 of 240

64. Question

When a SELECT statement displays data

dates and strings will be justified to the left by default
numbers will be justified to the right by default
dates and strings will be justified to the right by default
numbers will be justified to the left by default

Question 65 of 240

65. Question

If a query involves NOT, AND OR with no parenthesis

NOT will be evaluated first; AND will be evaluated second; OR will be evaluated last.
NOT will be evaluated first; OR will be evaluated second; AND will be evaluated last.
AND will be evaluated first; OR will be evaluated second; NOT will be evaluated last.
the order of occurrence determines the order of evaluation.

Question 66 of 240

66. Question

Choose the correct statements.

ORDER BY NAME ASC, displays NULLs last
ORDER BY NAME DESC, displays NULLs first
ORDER BY NAME ASC, displays NULLs first
ORDER BY NAME DESC, displays NULLs last

Question 67 of 240

67. Question

The SQL statement
SELECT LENGTH (”)FROM DUAL ; –” us two single quotes
prints,

0
a garbage value
NULL
1

Question 68 of 240

68. Question

The SQL statement
SELECT INSTR (‘abcdecfg’,’e’) FROM DUAL ;
prints,

2
3
5
6

Question 69 of 240

69. Question

The SQL statement
SELECT LPAD (‘abcd’.10.’10,’*’)FROM DUAL ;
prints,

abcd******
******abcd
***abcd***
**********

Question 70 of 240

70. Question

Table EMPLOYEE has 5 rows. Consider the following sequence of SQL statements.
SQL> CREATE TABLE myTable AS (SELECT * FROM EMPLOYEE);
SQL> INSERT INTO myTable SELECT * FROM myTable;
SQL> INSERT INTO myTable SELECT * FROM myTable;
SQL> INSERT INTO myTable SELECT * FROM myTable;
SQL> INSERT INTO myTable SELECT * FROM myTable;
If the SQL statement
SELECT COUNT (*) FROM MYEMP;
is executed after executing all the statements listed above, what will be printed is

80
25
20
5

Question 71 of 240

71. Question

Let the statement
SELECT column1 FROM myTable;
return 10 rows. The statement
SELECT ALL column1 FROM myTable;
will return

less than 10 rows
more than 10 rows
exactly 10 rows
none of the above

Question 72 of 240

72. Question

The SQL statement
SELECT (NVL(NVL(NULL, 3), 4)) FROM DUAL;

prints 3
prints 4
prints NULL
is illegal

Question 73 of 240

73. Question

Table Employee has 10 records. It has a non-NULL SALARY column which is also UNIQUE The SQL statement
SELECT COUNT(*) FROM EMPLOYEE WHERE SALARY > ALL (SELECT SALARY FROM EMPLOYEE);
prints

10
9
5
0

Question 74 of 240

74. Question

The SELECT statement
SELECT ‘Hi’ FROM DUAL WHERE 1 !=NULL;
outputs

Hi
FALSE
TRUE
nothing

Question 75 of 240

75. Question

Which of the following SQL commands can be used to add data to a database table?

ADD
UPDATE
APPEND
INSERT

Question 76 of 240

76. Question

THE SQL statement
SELECT DECODE(2, 2, DECODE (3, 3, 2)) FROM DUAL;

is illegal
prints garbage
3
2

Question 77 of 240

77. Question

Which of the following joins is also called as an ‘inner join’?

Non-Equijoin
Self-Join
Equijoin
None of these

Question 78 of 240

78. Question

The SQL statement
SQL>SELECT COUNT(*) FROM train_info
WHERE through 1 LIKE ‘%ad%’:
will prints

1
2
3
4

Question 79 of 240

79. Question

How many record(s) will be printed by the following SQL query?
SQL>SELECT A.From. B.To FROM train_info A, train_info B
WHERE A.TO = B.From”

No record
1 record
2 records
None of these

Question 80 of 240

80. Question

The SQL statement
SQL> SELECT COUNT(*) FROM train-info A,train_info B
WHERE A.start_city = B.start_city AND A.destination_city = B.destination-city;
will prints,

6
7
8
none of the above

Question 81 of 240

81. Question

The SQL statement
SQL> SELECT COUNT(*) FROM train-info A,train_info B
WHERE A.start_city = B.start_city AND A.destination_city = B.destination_city
AND A.trainNum <> B.trainNum;
will print,

0
1
2
none of the above

Question 82 of 240

82. Question

The SQL statement
SQL> SELECT COUNT(*) FROM train-info A,train_info B, train_info C;
will print,

6
18
12
216

Question 83 of 240

83. Question

The SQL statement
SQL> SELECT * FROM train_info
MINUS
SELECT * FROM train_info WHERE MOD(trainNum.2) = 0.
will print,

no records
3 records
5 records
6 records

Question 84 of 240

84. Question

The SQL statement
SQL> SELECT * FROM train-info A,train_info B WHERE A.trainNum < 3 UNION SELECT * FROM train_info B WHERE A.trainNum >= 3:
will print,

no records
6 records
12 records
36 records

Question 85 of 240

85. Question

The SQL statement
SQL> SELECT * FROM train-info A,train_info B
WHERE A.from = Chennai’ OR B.To = ‘New Delhi’;
will prints,

12 records
22 records
24 records
none of the above

Question 86 of 240

86. Question

The SQL statement
SQL> SELECT * FROM train-info A,train_info B
= WHERE A.From = ‘chennai’ OR A.From = ‘Hyderabad’
MINUS
SELECT* FROM train-info A,train_info B WHERE B.To = ‘Kanpur’;
will print,

12 records
16 records
18 records
24 records

Question 87 of 240

87. Question

The SQL statement
SQL> SELECT * FROM train-info A,train_info B
= WHERE A.From = ‘chennai’ and B.From = ‘Chennai’
will print,

no record
4 records
6 records
12 records

Question 88 of 240

88. Question

The SQL statement
SQL> SELECT * FROM train-info WHERE MOD(trainNUM, 2) = 1
MINUS
SQL> SELECT * FROM train-info WHERE MOD(trainNUM, 3) = 0;
will print,

no record
1 record
2 records
3 records

Question 89 of 240

89. Question

The SQL statement
SQL> SELECT * A.FROM, B.From
FROM train_info A, train_info B
GROUP BY (A.From, B.From);
will print,

6 records
8 records
12 records
none of the above

Question 90 of 240

90. Question

The SQL statement
SQL> SELECT * A.FROM. B.From FROM train-info A, train_info B
GROUP BY (A, From. B. From)
HAVING A.From = ‘Vijayawada’:
will print,

3 records
4 records
5 records
6 records

Question 91 of 240

91. Question

Choose the correct statements.

column alias cannot be used in the ORDER BY clause
column alias can be used in the ORDER BY clause
column alias can be used in the WHERE clause
column alias cannot be used in the WHERE clause

Question 92 of 240

92. Question

The WHERE clause – WHERE city LIKE ‘%a\_%b’
cannot display

ab
abb
a_b
a_%b

Question 93 of 240

93. Question

Choose the correct statements.

FALSE AND NULL is FALSE
TRUE AND NULL is NULL
NOT NULL is NULL
FALSE OR NULL is NULL

Question 94 of 240

94. Question

Choose the correct statement that is based on a SQL query that has its ORDER BY clause defined as ORDER BY name, game DESC

Vijay, Golf will be listed before Anand, Chess
Anand, Chess will be listed before Vijay, Golf
Bhupathi, Tennis will be listed before Anand, Chess
Bhupathi, Tennis will be listed before Vijay, Golf

Question 95 of 240

95. Question

Which of the following SELECT statements print the string 56?

SELECT SUBSTR('123456',5) FROM DUAL;
SELECT SUBSTR('123456',-2) FROM DUAL;
SELECT SUBSTR('123456',5, 2) FROM DUAL;
SELECT SUBSTR('123456',-2, 2) FROM DUAL;

Question 96 of 240

96. Question

The SQL statement
SELECT LPAD(‘abcd’,10,’wert’) FROM DUAL;
prints

wertweabcd
abcdwertwer
wertwertab
abwertwert

Question 97 of 240

97. Question

The SQL statement
SELECT ROUND (45.926, -2) FROM DUAL ;

is illegal
prints garbage
prints 45.92
prints 0

Question 98 of 240

98. Question

Choose the correct statements.
The SQL statement
SELECT SYSDATE FROM DUAL;
prints
19-FEB-05

The SQL statement - SELECT ROUND (SYSDATE, 'MONTH') FROM DUAL; will print 01-Mar-05
The SQL statement - SELECT TRUNC(SYSDATE, 'MONTH') FROM DUAL; will print 01-Feb-05
The SQL statement - SELECT ROUND(SYSDATE, 'YEAR') FROM DUAL; will print 01-JAN-05
The SQL statement - SELECT TRUNC(SYSDATE, 'YEAR') FROM DUAL; will print 01-JAN-05

Question 99 of 240

99. Question

The SQL statement
SELECT NVL(NVL(NULL, NVL(NULL, 3)), 4) FROM DUAL;

prints 3
prints 4
prints NULL
is illegal

Question 100 of 240

100. Question

The SQL statement
SELECT DECODE(2, 2, DECODE(3, 7, 2, 4, 5, 6)) FROM DUAL
prints,

2
5
6
7

Question 101 of 240

101. Question

Let email has the value of an email ID. Fill in the blanks in the following SQL statement that prints the domain name. (The domain name of myname@abcd.com is abcd.com)
SELECT SUBSTR(email,INSTR(email,_____) FROM DUAL;

'@',1)+1)
'@',1))
'@',1) -1
None of these

Question 102 of 240

102. Question

Consider the flowchart in Fig. 16.1.
Chart ?
Which of the following codes correctly implements this flowchart?

DECODE(MOD(YEAR, 4), 0,DECODE(MOD(YEAR, 100) ,0,DECODE(MOD(YEAR,400) '0' 'LY' ,'NLY') ,'LY') ,'NLY')
DECODE(MOD(YEAR, 4), 0,DECODE(MOD(YEAR, 100) ,0,DECODE(MOD(YEAR,400) '0' 'NLY' ,'LY') ,'LY') ,'NLY')
DECODE(MOD(YEAR, 4), 0,DECODE(MOD(YEAR, 100) ,0,DECODE(MOD(YEAR,400) '0' 'LY' ,'NLY') ,'NLY') ,'NLY')
None of the above

Question 103 of 240

103. Question

Table Employee has 10 records.It has a non-NULL SALARY column which is also UNIQUE.
The SQL statement
SELECT COUNT(SALARY) FROM EMPLOYEE WHERE SALARY NOT IN (NULL);
prints,

10
9
5
0

Question 104 of 240

104. Question

The FROM clause – EMPLOYEE LEFT OUTER JOIN DEPARTMENT

includes all employees not assigned to any department
includes all departments having no employee
includes only those employees who are assigned department
none of these

Question 105 of 240

105. Question

Which of the following SQL commands can be used to modify existing data in a database table?

MODIFY
UPDATE
CHANGE
NEW

Question 106 of 240

106. Question

Let the statement
SELECT * FROM nameList;
return 10 rows. The statement
SELECT * FROM nameList WHERE ROWNUM > 5;
will return

4 rows
5 rows
6 rows
none of these

Question 107 of 240

107. Question

The SELECT statement
SELECT ‘Hi’ FROM DUAL WHERE NULL IN (NULL);
outputs,

TURE
FALSE
'Hi'
nothing

Question 108 of 240

108. Question

The SQL statement
SELECT TRUNC (45.926, -2) FROM DUAL ;

is illegal
45
prints 45.92
prints 0

Question 109 of 240

109. Question

The SELECT statement
SELECT ‘Hi’ FROM DUAL
WHERE NULL is NULL:
outputs,

Hi
FALSE
TURE
nothing

Question 110 of 240

110. Question

Which of the following is considered to be a fourth generation language?

COBOL
Visual Basic
JAVA
SQL

Question 111 of 240

111. Question

Choose the correct PL/SQL statement.

last_name VARCHAR2(15) := "Coumar";
last_name VARCHAR2(15) := 'Coumar";
last_name VARCHAR2(15) = "Coumar";
last_name number(15) := "Coumar";

Question 112 of 240

112. Question

The basic programming unit of a PL/SQL code is a

procedure
Sub-program
module
block

Question 113 of 240

113. Question

Which of the following can be used to print the current user in a PL/SQL program?

SQLCURSURSER
PRINT_USER
USER
DISP_USER

Question 114 of 240

114. Question

Choose the correct statements.

OUT parameters are passed by reference
OUT parameters are passed by value
IN parameters are passed by value
IN parameters are passed by reference

Question 115 of 240

115. Question

PL/SQL does not support arrays.However it has an equivalent construct which is

records
packages
types
collections

Question 116 of 240

116. Question

Which of the following packages can be used to build dynamic SQL?

UTL_SQL
UTL_ALERT
UTL_DSQL
DBMS_SQL

Question 117 of 240

117. Question

Which of the following sections of a PL/SQL program are optional?

Declarative Section
Executable Section
Exception Handler Section
All of these

Question 118 of 240

118. Question

Which of the following is the widely used tool for developing PL/SQL code?

Rapid SQL
SQL++
SQL Programmer
TOAD

Question 119 of 240

119. Question

If the mode of a formal parameter is not specified in the declaration of a PL/SQL function (or procedure),

it results in a compilation error
it results in a run time error
it defaults to IN
the parameter is assigned a garbage value

Question 120 of 240

120. Question

Which of the following keywords is not used in a PL/SQL procedure creation?

DECLARE
BEGIN
EXCEPTION
END

Question 121 of 240

121. Question

Which of the following comments about the RETURN statement (in a PL/SQL function) are not correct?

There must be at least one return statement
There must be exactly one return statement
The return statement must return a value whose data type is same as the data type specified in the declaration
Return statements can return more than one value.

Question 122 of 240

122. Question

The above procedure my_proc will compile successfully if

statement 3 is removed
statement 4 is removed
statement 5 is removed
statement 6 is removed

Question 123 of 240

123. Question

After removing the statement(s) that is/are illegal, when the procedure is called, statement 2 will print

garbage
out-param
22
NULL

Question 124 of 240

124. Question

After removing the statement(s) that is/are illegal, when the procedure is called, statement 3 will print

garbage
om_out_param
33
NULL

Question 125 of 240

125. Question

Statement 7 cannot be replaced by the statement

my_proc(input2, input1, input3);
my_proc(input2, input2, input2);
my_proc(input3, input1, input2);
none of these

Question 126 of 240

126. Question

Statement 7 cannot be replaced by the statement

my_proc(2, 3, 4);
my_proc(2, input3, input 2);
my_proc(2, 3, input 3);
all of these

Question 127 of 240

127. Question

Suppose a procedure my_proc is created with no formal parameter. Which of the following calls is correct?

my_proc
my_proc:
my_proc( )
my_proc( ):

Question 128 of 240

128. Question

Which of the following cannot be anonymous ?

Procedure
Fucntion
Package
None of the above

Question 129 of 240

129. Question

The design of PL/SQL language has a a lot of similarities with the design of

COBOL
ORACLE
ADA
LISP

Question 130 of 240

130. Question

Which of the following formal parameter declarations (inside the definition of a PL/SQL procedure or function) are not acceptable ?

last_name IN OUT VARCHAR2 (30)
last_name IN VARCHAR2
last name IN VARCHAR2
last_name OUT VARCHAR2(30)

Question 131 of 240

131. Question

Which of the following can be used to print the description about an error in a PL/SQL program?

SQLERRM
ERR_MESG
CURR_ERROR
DISP_ERR

Question 132 of 240

132. Question

If a function does not modify the database state, its purity level is

RNDS
WNPS
RNPS
WNDS

Question 133 of 240

133. Question

Which of the following types of triggers can be fired on DDL operations?

Instead-Of Trogger
DML Trigger
System Trigger
DDL Trigger

Question 134 of 240

134. Question

If a trigger is fired by an INSERT statement, the values of :old and “new are respectively

NULL and the value that is inserted
a garbage value and the value that is inserted
NULL and NULL
the value that is inserted and the value that is inserted

Question 135 of 240

135. Question

To have a variable in global scope, declare it inside a

function
procedure
package
none of these

Question 136 of 240

136. Question

In a PL/SQL code, uninitialized variables of type VARCHAR2 will have

garbage value
NULL value
0 value
none of these

Question 137 of 240

137. Question

Choose the correct statements.

The n in CHAR(n) can be missing in the declaration.
The n in CHAR(n) is mandatory in the declaration.
If the n in CHAR(n) is missing in the declaration, it defaults to 1.
If a 5 character string is stored in a variable that had been declared as CHAR(10), the string will be right padded with blanks to make it a 10 character string.

Question 138 of 240

138. Question

Consider the declaration
abc tableName%ROWTYPE;
The field name of abc

are undefined
are $1. $2, . . . .
will be the column names of tableName
none of these

Question 139 of 240

139. Question

Which of these are true of Collection types ?

They store data of the same data type.
They are sparse.
They are unconstrained
They can store data of different data type.

Question 140 of 240

140. Question

Which of the following keywords is used in the declaration of a PL/SQL function but not a procedure?

RETURN
BEGIN
END
EXCEPTION

Question 141 of 240

141. Question

Which of the following are operations?

OPEN
CLOSE
FETCH
DECLARE

Question 142 of 240

142. Question

Choose the correct statements.

ROWCOUNT of an implicit cursor gives the total number of rows matched by the query.
ROWCOUNT of an explicit cursor gives the total number of rows fetched so far.
ROWCOUNT of an implicit cursor gives the total number of rows fetched so far.
ROWCOUNT of an implicit cursor gives the total number of rows matched by the query.

Question 143 of 240

143. Question

In PL/SQL

a block can access variables that are declared in the enclosing block
a block can access variables that are declared in the enclosed block
a block cannnot access variables that are declared in the enclosing block
a block cannot access variables that are declared in the enclosed block

Question 144 of 240

144. Question

Which of the following are pre-defined error conditions?

NO_DATA_FOUND
TOO_MANY_ROWS
CASE_NOT_FOUND
DUP_VAL_ON_INDEX

Question 145 of 240

145. Question

Choose the correct statements.
In a PL/SQL code

if the current block is not having the exception handler, the enclosing block will searched for one
if an error occurs in the DECLARE section of a block, immediately the enclosing block is searched
if an error occurs in the exception section of a block , immediately the enclosing block is searched
none of the above

Question 146 of 240

146. Question

Program units in a package can be overloaded based on the

number of parameters
data type family of the parameters
listed order of the parameters
modes of the parameters

Question 147 of 240

147. Question

Which of the following is not a cursor attribute?

ROWCOUNT
FOUND
NOTFOUND
None of the above

Question 148 of 240

148. Question

Choose the correct statements.
When a run-time error happens when a PL/SQL procedure is executed

an exception is raised
the value of the OUT parameters are copied to their corresponding actual parameters
the value of the IN OUT parameters are copied to their corresponding actual parameters
The values of the IN parameters are copied to their corresponding actual parameters

Question 149 of 240

149. Question

Consider the formal parameter declaration
input1 IN OUT NOCOPY VARCHAR2
Choose the correct statements

This declaration will result in compilation error.
input1 will be passed by reference
input1 will be passed by value
This declaration is acceptable but if the keyword OUT is removed, it becomes unacceptable.

Question 150 of 240

150. Question

To find the number of rows updated by a SQL statement use

SQL.ROWCOUNT
ROWCOUNT
SQL%ROWCOUNT
%SQL.ROWCOUNT

Question 151 of 240

151. Question

consider the flowchart in Fig. 16.2
pic ???
Which of the following codes correctly implement this flowchart?

IF (a=1) THEN BEGIN IF (b=5) THEN DBMS_OUTPUT.PUT_LINE('de'); END IF; END; ELSE IF (a <> 10) THEN DBMS_OUTPUT.PUT_LINE('abc'); END IF; END IF;
IF (a=1) THEN IF (b=5) THEN DBMS_OUTPUT.PUT_LINE('de'); ELSE IF (a <> 10) THEN DBMS_OUTPUT.PUT_LINE('abc'); END IF; END IF;
IF (a=1) THEN BEGIN IF (b=5) THEN DBMS_OUTPUT.PUT_LINE('de'); END IF; END; ELSE IF (a = 10) THEN NULL; DBMS_OUTPUT.PUT_LINE('abc'); END IF; END IF;
None of the above

Question 152 of 240

152. Question

Which of the following is not collection type in PL/SQL?

Varrays
Index-By tables
Nested Tables
None of these

Question 153 of 240

153. Question

Which of the following is not a valid parameter mode?

IN
OUT
IN OUT
None of the above

Question 154 of 240

154. Question

A compiled form module has the extension

fmb
fmx
exe
obj

Question 155 of 240

155. Question

The attributes of a Form object can be found in the

layout editor
program editor
property navigator
property palette

Question 156 of 240

156. Question

If the values of the properties of RELATION in a master-detail Form violates the constraints set forth in the database tables then

it results in an error
it results in a warning
what is defined in the database overrides what is defined in the RELATION
what is defined in the RELATION overrides that is defined in the database

Question 157 of 240

157. Question

Which of the following triggers can be used to disable the function keys?

WHEN-BUTTON-PRESSED Trigger
KEY-NULLIFY Trigger
WHEN-NEW-FORM-INSTANCE Trigger
KEY-OTHERS Triggers

Question 158 of 240

158. Question

A canvas is displayed in

an enclosing canvas
a tabbed page
a dialog box
a window

Question 159 of 240

159. Question

When w WHEN-VALIDATE-ITEM trigger fail, it

terminates the Form
displays a message in a dialog box
displays a message in the status line
none of these

Question 160 of 240

160. Question

A Data Block in a Form can be based on a

table
view
stored procedure
none of these

Question 161 of 240

161. Question

An LOV can be populated by

a record group
a static list of Values
an object group
an exception

Question 162 of 240

162. Question

During execution, the mode of Data Block in a Form has to be

Normal or Query
Normal or Enter Query
Query or Enter Query
Normal or Query or Enter Query

Question 163 of 240

163. Question

Trigger code is written in

SQL
PL/SQL