SQL Free Certificate Online | SQL | Free Certificate

* Attempt the Quiz only once .

* Score will be released only after closing of the quiz .

* If total marks scored is above 50 % of the maximum marks , then E- certificate will be emailed immediately . Or in 2minutes

* Only 100 E – certificates will be emailed per day .

* Link to Register / attempt the Quiz :

1) The SQL used by front-end application programs to request data from the DBMS is called

  • DML
  • DDL
  • VDL
  • SDL

2) The database langauge that allows us to access data in a database is called

  • DCL
  • DML
  • DDL
  • None of Above

3) Which of the following is the legal expression in SQL?

SELECT NULL FROM SALES;

SELECT NAME FROM SALES;

SELECT * FROM SALES WHEN PRICE = NULL;

SELECT # FROM SALES;

4) The COUNT function in SQL returns the number of

Values

Distinct values

Group By

Columns

5) A SQL query will not work if there are no indexes on the relation – is it true?

No

Yes

6) Which statement in SQL allows us to change the definition of a table is?

ALTER

UPDATE

CREATE

SELECT

7) The virtual table that its created by data from the result of an SQL ‘Select’ statement is called

View

Synonym

Sequence

Transaction

8) Which of the following is not a valid SQL type?

DECIMA

LNUMERIC

FLOAT

CHARACTER

9) A SQL query automatically eliminates duplicates (True / False) ?

TRUE

FALSE

10) Which of the following operations requires the relations to be union compatible?

UNION

INTERSECTION

DIFFERENCE

ALL OF THESE

11) You can add a row using SQL in a database with which of the following?    

ADD

CREATE

INSERT

MAKE

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

LIKE only

IN only

NOT IN only

IN and NOT IN

13) The result of a SQL SELECT statement is a(n) ________ .            

report

form

file

table

14) To remove duplicate rows from the results of an SQL SELECT statement, the ________ qualifier specified must be included.      

ONLY

UNIQUE

DISTINCT

SINGLE

15) The SQL statement that queries or reads data from a table is _____.  

SELECT

READ

QUERY

None of the above is correct

APPLY LINK

error: Content is protected !!
Scroll to Top