NiC IT Academy

SQL Quiz – 5

By Mr. Chandra

Loading

1) Which of the following events CANNOT cause a trigger to fire?

2) Which one of the following operators is not a SET operator?

3) Which one of the following is not a DB object?

4) What does "c" in Oracle 23c stand for?

5) What does "g" in Oracle 11g stand for?

6) What is the purpose of commit statement in Oracle?

7) What are the different Data type of Oracle?

8) Character data type is used for?

9) In Oracle, which of the following is non-Schema object?

10) Identify the invalid datatype in Oracle SQL

11) In a SELECT statement, which clause controls how the result set should be displayed?

12) Which clause has the highest priority in an SQL statement?

13) Select abs(-123) from dual;

14) What is the output of below query? Select LPAD(‘Oracle’,10,’*’) from dual;

15) What is the output of below query? Select length(“Oracle SQL”) from dual;

16) IN SQL, how can you insert a new record into the "CUSTOMER" table?

17) Views can be created from ----

18) What is the output of below query? Select concat(‘Oracle’,’SQL’) from dual;

19) Which SQL statement is used to update data in a database?

20) Which SQL statement is used to add a column to an existing table?

Login with your email & password

Sign up with your email & password

Signup/Registration Form

Registred Email:

- Not Updated -

Set/Update Password