Q: For what purpose Projection is used?

A) Selecting the rows
B) Selecting columns
C) Creating
columns in a table
D) Selecting groups

Ans: B.

Q: You need to display the hire_date values in this format:
10 of October 1996
which
SELECT statement can you use?

A) SELECT hire_date (fmDD "of" MONTH YYYY) "Date Hired"
FROM employee;
B) SELECT hire_date(DD "of" MONTH
YYYY) "Date Hired"
FROM employee;
C) SELECT TO_CHAR(hire_date,DDspth of MONTH YYYY) "DATE HIRED"
FROM employee;
D) SELECT
TO_CHAR(hire_date,fmDD "of" Month YYYY) DATEHIRED
FROM employee;

Ans: D.


Q: You want to display each employees hire_date from earliest
to latest.
Which SQL statement would you use?
A) SELECT hire_date FROM employee;
B) SELECT hire_date FROM employee
ORDER BY hire_date;
C)
SELECT hire_date FROM employee
GROUP BY hire_date;
D) SELECT hire_date FROM employee
ORDER BY hire_date DESC;

Ans: B.

Q: Which of the
following operator is not used in non-equi joins?
A) Between
B) IN
C) LIST
D) =
Ans: D.

Q:How will the results differ?
A) Statement
1 will not execute; statement 2 will.
B) Statement 1 will execute; statement 2 will not.
C) Statement 1 is self-join; tatement 2 is not.
D)
The results will be the same, but the display will be different.

Ans: D.

Q:Define errors in the following:

1. CREATE TABLE salary
2.
(employee_id NUMBER(9)
3. CONSTRAINT salary_pk PRIMARY KEY,
4. 1995_salary NUMBER(8,2),
5. manager_name VARCHAR2(25)
6. CONSTRAINT
mgr_name_nn NOT NULL,
7. $salary_96 NUMBER(8,2));
Which two lines of this statement will return errors?

1,2,3,4,5,7.

Ans: 4,7.

Q:The
EMPLOYEE table has ten columns. Since you often query the table wih conditions based on four or more columns, you created an index on all the
columns in the table. Which result will oCCur?

A )Updates in the table will be slower.
B) The speed of inserts will be increased.
C) All
queries on the table will be faster.
D) The size of the EMPLOYEE table will be increased.

Ans: A.


Q: SELECT first_name, commission

FROM employee
WHERE commission =
( SELECT commission
FROM employee
WHERE UPPER(first_name) = SCOTT);
What would cause this statement to
fail?

A) Scott has a NULL commission value
B) Scott has a zero commission value.
C) There is no employee with the first name Scott.
D) The
First_Name values in the database are in lowercase.
E) There are more than one employee with forst name Scott.

Ans: E.



Q: Evaluate
this IF statement?

IF v_value > 100 THEN v_new_value := 2 * v_value;
ELSIF v_value > 200 THEN v_new_value := 3 * v_value;
ELSIF v_value <
300 THEN v_new_value := 4 * v_value;
ELSE v_new_value := 5 * v_value;
END IF;

What would be assigned to V_NEW_VALUE if V_VALUE is 250?
A)
250 B) 500 C) 750 D) 1000 E) 1250?

Ans: B.

---