We have sent an email with your new password.


Oracle SQL, Pl/SQL Quiz

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

Removing ad is a premium feature

Upgrade and get a lot more done!
Take Another Quiz