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.


Question Excerpt

Removing question excerpt is a premium feature

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