We have sent an email with your new password.


Oracle SQL, Pl/SQL Quiz

30 Questions  I  By Maarsh
oracle SQL, pl/SQL quiz

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

Removing ad is a premium feature

Upgrade and get a lot more done!
Take Another Quiz