* 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