Oracle SQL, Pl/SQL Quiz

30 Questions  I  By Maarsh

  
Changes are done, please start the quiz.


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