11- In which of the following circumstances a GROUP BY clause is mandatory?
(A) SELECT query having only two columns
(B) SELECT query having one aggregate function along with other columns
(C) SELECT query having two aggregate functions
(D) SELECT query having only one aggregate function
12- PL/SQL Varchar2 can hold as many as_________ characters.
(A) 4767
(B) 16767
(C) 32767
(D) None of the above
13- Which of the following conditions has to be satisfied for INNER JOIN to work?
(A) A column is not required for joining
(B) Columns used for joining must have different names
(C) Columns used for joining can have same or different name
(D) Columns used for joining must have same name
14- Which of the following lets you restrict an integer variable to the values -1, 0, and 1 that is useful in programming tri-state logic?
(A) Numeric
(B) Signtype
(C) Float
(D) Integer
15- Which join is to be used between two tables A and B when the resultant table needs rows from A and B that matches the condition and rows from A that does not match the condition.
(A) SELF JOIN
(B) INNER JOIN
(C) CROSS JOIN
(D) OUTER JOIN
16- Which of the following datatypes that cannot be defined in a PL/SQL block?
(A) Vector
(B) Scalar
(C) Composite
(D) All of the above
17- Which of the two statements are correct with reference index concept?
(A) Index decreases performance of Select statements
(B) Index neither increases nor decreases the performance of Select statements
(C) Index decreases performance of Insert, Update and Delete statements
(D) Index increases performance of Insert, Update and Delete statements
18- Which of the following is not a specialist concurrent manager in oracle E-business suite?
(A) Standard Manager
(B) Conflict Resolution Manager
(C) External Resolution Manager
(D) Internal Concurrent Manager
19- Which of the following are mandatory section in an anonymous PLSQL block?
(A) Exception Section
(B) Execution Section
(C) Declaration Section
(D) All of the above
20- A concurrent program that runs in a child process of the concurrent manager process is known as _________.
(A) Immediate Program
(B) Spawned program
(C) Parent program
(D) Child program
ANSWERS:
11-(B), 12-(C), 13-(C), 14-(B), 15-(D), 16-(A), 17-(C), 18-(), 19-(B), 20-(B)