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