Oracle Sql, Pl/sql Quiz

30 Questions  I  By Maarsh on February 22, 2013

  

Question Excerpt

Removing question excerpt is a premium feature

Upgrade and get a lot more done!
1.  Which clause would you use in a SELECT statement to limit the display to those employees whose salary is greater than 5000?
A.
B.
C.
D.
2.  Which four are types of functions available in SQL? (Choose 4)
A.
B.
C.
D.
E.
F.
G.
H.
3.  Maximum number of columns in a table or view in Oracle 9i?
A.
B.
C.
D.
E.
4.  In a SELECT statement that includes a WHERE clause, where is the GROUP BY clause placed in the SELECT statement?
A.
B.
C.
D.
E.
5.  The primary key is selected from the:
A.
B.
C.
D.
6.  Which of the following statements contains an error?
A.
B.
C.
D.
7.  Oracle UTL_FILE Package is used :
A.
B.
C.
D.
8.  Which is following Statements to create users?
A.
B.
C.
D.
9.  The command to remove rows from a table 'CUSTOMER' is:
A.
B.
C.
D.
10.  What does the TRUNCATE statement do?
A.
B.
C.
D.
E.
11.  What is true about the WITH GRANT OPTION clause?
A.
B.
C.
D.
E.
12.  Which is a valid CREATE TABLE statement?
A.
B.
C.
D.
13.  How do you select all the records from a table named "EMP" where the value of the column "Last_Name" is "KING"?
A.
B.
C.
D.
14.  What is true about sequences?
A.
B.
C.
D.
15.  What is the Datatype of NULL in Oracle?
A.
B.
C.
D.
16.  How to check the version of Oracle?
A.
B.
C.
D.
17.  Which four are valid Oracle constraint types? (Choose four.)
A.
B.
C.
D.
E.
F.
G.
18.  Which three statements about subqueries are true? (Choose three.)
A.
B.
C.
D.
E.
F.
19.  Can you delete a column in table with data in Oracle?
A.
B.
C.
20.  A tuple is a?
A.
B.
C.
D.
21.  Maximum characters allowed in dbms_out.put_line()
A.
B.
C.
D.
E.
22.  Which SQL statement is used to insert new data in a database?
A.
B.
C.
D.
23.  Which of the following functions are available in SQL?
A.
B.
C.
D.
E.
F.
24.  Which one is a system privilege?
A.
B.
C.
D.
E.
25.  The SQL ALTER statement can be used to:
A.
B.
C.
D.
26.  Which is an /SQL*Plus command?
A.
B.
C.
D.
E.
27.  Which command is used to remove the table 'DEPTT'?
A.
B.
C.
D.
28.  Which one of the following sorts rows in SQL?
A.
B.
C.
D.
29.  Can you commit inside a Trigger?
A.
B.
C.
D.
30.  How to Kill a Session in Oracle?
A.
B.
C.
D.
Back to top


to post comments.

Removing ad is a premium feature

Upgrade and get a lot more done!
Take Another Quiz