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