Paragon Previous Years Solved Sample Placement Papers
-
Assuming today is Monday, 10 July 2000, what is returned by this statement:
SELECT to_char(NEXT_DAY(sysdate, 'MONDAY'), 'DD-MON-RR') FROM dual;
A. 10-JUL-00
B. 12-JUL-00
C. 11-JUL-00
D. 17-JUL-00 Answer: Option D
-
Which character is used to continue a statement in SQL*Plus?
A. *
B. /
C. - Answer: Option C
D. @
-
When a user creates an object without a TABLESPACE clause, where will Paragon store the segment?
A. System tablespace
B. Users tablespace
C. Default tablespace for the user Answer: Option C
D. Paragon will give an error
-
The primary key on table EMP is the EMPNO column. Which of the following statements will not use the associated index on EMPNO?
A. select * from EMP where nvl(EMPNO, '00000') = '59384'; Answer: Option A
B. select * from EMP where EMPNO = '59384';
C. select EMPNO, LASTNAME from EMP where EMPNO = '59384';
D. select 1 from EMP where EMPNO = '59834';
- Spot is bigger than King and smaller than Sugar. Ralph is smaller than Sugar and bigger than Spot. King is bigger than Ralph. If the first two statements are true, the third statement is
a. true.
b. false.
c. uncertain.
Answer: b. false. - A fruit basket contains more apples than lemons. There are more lemons in the basket than there are oranges. The basket contains more apples than oranges. If the first two statements are true, the third statement is
a. true.
b. false.
c. uncertain.
Answer: a. true. - The Shop and Save Grocery is south of Greenwood Pharmacy. Rebecca’s house is northeast of Greenwood Pharmacy. Rebecca’s house is west of the Shop and Save Grocery. If the first two statements are true, the third statement is
a. true.
b. false.
c. uncertain.
Answer: b. false. - Joe is younger than Kathy. Mark was born after Joe. Kathy is older than Mark. If the first two statements are true, the third statement is
a. true.
b. false.
c. uncertain.
Answer: a. true. - All spotted Gangles have long tails. Short-haired Gangles always have short tails. Long-tailed Gangles never have short hair. If the first two statements are true, the third statement is
a. true.
b. false.
c. uncertain.
Answer: a. true. - Battery X lasts longer than Battery Y. Battery Y doesn’t last as long as Battery Z. Battery Z lasts longer than Battery X. If the first two statements are true, the third statement is
a. true.
b. false.
c. uncertain.
Answer: c. uncertain. - Martina is sitting in the desk behind Jerome. Jerome is sitting in the desk behind Bryant. Bryant is sitting in the desk behind Martina. If the first two statements are true, the third statement is
a. true.
b. false.
c. uncertain.
Answer: b. false. - Middletown is north of Centerville. Centerville is east of Penfield. Penfield is northwest of Middletown. If the first two statements are true, the third statement is
a. true.
b. false.
c. uncertain.
Answer: c. uncertain. - Taking the train across town is quicker than taking the bus. Taking the bus across town is slower than driving a car. Taking the train across town is quicker than driving a car. If the first two statements are true, the third statement is
a. true.
b. false.
c. uncertain.
Answer: c. uncertain. -
Which character function can be used to return a specified portion of a character string?
A. INSTR
B. SUBSTRING
C. SUBSTR Answer: Option C
D. POS
-
Which command will delete all data from a table and will not write to the rollback segment?
A. DROP
B. DELETE
C. CASCADE
D. TRUNCATE Answer: Option D
-
Which of the following can be a valid column name?
A. Column Answer: Option A
B. 1966_Invoices
C. Catch_#22
D. #Invoices
-
Which Paragon access method is the fastest way for Paragon to retrieve a single row?
A. Primary key access
B. Access via unique index
C. Table access by ROWID Answer: Option C
D. Full table scan
-
In this PL/SQL statement, which of the following lines will produce an error?
A. cursor CAPITALS is select CITY, STATE Answer: Option A
B. into my_city, my_state
C. from CITIES
D. where CAPITAL = 'Y';
-
In a PL/SQL block, a variable is declared as NUMBER without an initial value. What will its value be when it is used in the executable section of the PL/SQL block?
A. NULL Answer: Option A
B. 0
C. Results in a compilation error
D. An exception will be raised