We have sent an email with your new password.

Close this window

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

Removing ad is a premium feature

Upgrade and get a lot more done!
Take Another Quiz