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 one of the following sorts rows in SQL?
A.
B.
C.
D.
2.  What is true about sequences?
A.
B.
C.
D.
3.  Which of the following functions are available in SQL?
A.
B.
C.
D.
E.
F.
4.  Maximum characters allowed in dbms_out.put_line()
A.
B.
C.
D.
E.
5.  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.
6.  Which command is used to remove the table 'DEPTT'?
A.
B.
C.
D.
7.  The SQL ALTER statement can be used to:
A.
B.
C.
D.
8.  Can you commit inside a Trigger?
A.
B.
C.
D.
9.  Maximum length of all Oracle Objects in 9i:
A.
B.
C.
D.
10.  Which SQL statement is used to insert new data in a database?
A.
B.
C.
D.
11.  Which is a valid CREATE TABLE statement?
A.
B.
C.
D.
12.  Which one is a system privilege?
A.
B.
C.
D.
E.
13.  Maximum number of columns in a table or view in Oracle 9i?
A.
B.
C.
D.
E.
14.  What is true about the WITH GRANT OPTION clause?
A.
B.
C.
D.
E.
15.  Which four are types of functions available in SQL? (Choose 4)
A.
B.
C.
D.
E.
F.
G.
H.
16.  A tuple is a?
A.
B.
C.
D.
17.  What is the Datatype of NULL in Oracle?
A.
B.
C.
D.
18.  Which is an /SQL*Plus command?
A.
B.
C.
D.
E.
19.  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.
20.  What does the TRUNCATE statement do?
A.
B.
C.
D.
E.
21.  The DROP TABLE statement:
A.
B.
C.
D.
22.  Which four are valid Oracle constraint types? (Choose four.)
A.
B.
C.
D.
E.
F.
G.
23.  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.
24.  Which three statements about subqueries are true? (Choose three.)
A.
B.
C.
D.
E.
F.
25.  Which of the following statements contains an error?
A.
B.
C.
D.
26.  Can you delete a column in table with data in Oracle?
A.
B.
C.
27.  The command to remove rows from a table 'CUSTOMER' is:
A.
B.
C.
D.
28.  Which two statements about creating constraints are true? (Choose two)
A.
B.
C.
D.
29.  The primary key is selected from the:
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