NiC IT Academy

SQL Quiz – 4

By Mr. Chandra

Loading

1) When no join type between multiple tables in a query's FROM clause is specified, what type of join is assumed?

2) What is the result of this query? SELECT 123+'123' AS Result from dual;

3) To combine the results of two or more SELECT statements, removing duplicates, which keyword can you use?

4) SELECT 123+'abc' AS Result from dual;

5) Which answer is NOT a type of table index?

6) Which option is NOT suitable for filtering data?

7) In SELECT * FROM clients; what does clients represent?

8) In an efficiently designed relational database, what does every table have?

9) Which is a valid CREATE TABLE statement?

10) How many joining conditions are required to join 4 tables in SQL?

11) The SQL keyword(s) ________ is used with wildcards.

12) What is the maximum number of triggers, can apply to a single table?

13) What is the default return value of a function?

14) Which among the following keys are used to identify each row of the table uniquely?

15) Count function in SQL returns the number of

16) The SQL keyword BETWEEN is used:

17) In R-DBMS, the data is organized in the form of _____.

18) Insert command falls in which sub-language of SQL ?

19) Which of the following is a comparison operator in SQL?

20) Which one of the following is a DML statement?

Login with your email & password

Sign up with your email & password

Signup/Registration Form

Registred Email:

- Not Updated -

Set/Update Password