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

Removing ad is a premium feature

Upgrade and get a lot more done!
Take Another Quiz