Oracle SQL, Pl/SQL Quiz

30 Questions  I  By Maarsh
Please take the quiz to rate it.

Oracle Quizzes & Trivia

  
Changes are done, please start the quiz.


Questions and Answers

Removing question excerpt is a premium feature

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

Removing ad is a premium feature

Upgrade and get a lot more done!
Take Another Quiz
We have sent an email with your new password.