Oracle SQL, Pl/SQL Quiz

30 Questions  I  By Maarsh

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