Oracle Sql, Pl/sql Quiz

30 Questions  I  By Maarsh on February 22, 2013

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


to post comments.

Removing ad is a premium feature

Upgrade and get a lot more done!
Take Another Quiz