Ticker

6/recent/ticker-posts

SQL Online Quiz


SQL Online Quiz





Organized by: Pune Vidyarthi Griha's , College of Engineering , Nashik

About the Quiz

✅Free Registration
✅Free E-Certificate will be provided to the participants who secure more than 60%
Note: Only 100 certificates will be awarded per day, if the Participants response not recorded in a Single day, they Can try on the next day
✅Who Can Attempt the Quiz: Faculty Members, UG & PG Students.
✅Quiz Pattern: There are 15 Multiple choice type questions to be answered


After Quiz Completion Everyone Get This Type of Certificate



Here You Can See All The Questions Which are asked in this quiz competition.

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

A. DML
B. DDL
C. VDL
D. SDL

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

A. DCL
B. DML
C. DDL
D. None of Above

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

A. SELECT NULL FROM SALES;
B. SELECT NAME FROM SALES;
C. SELECT * FROM SALES WHEN PRICE = NULL;
D. SELECT # FROM SALES;

4) The COUNT function in SQL returns the number of

A. Values
B. Distinct values
C. Group By
D. Columns

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

A. No
B. Yes

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

A. ALTER
B. UPDATE
C. CREATE
D. SELECT

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

A. View
B. Synonym
C. Sequence
D. Transaction

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

A. DECIMAL
B. NUMERIC
C. FLOAT
D. CHARACTER

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

A.TRUE
B.FALSE

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

A. UNION
B. INTERSECTION
C. DIFFERENCE
D. ALL OF THESE

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

A. ADD
B. CREATE
C. INSERT
D. MAKE

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

A. LIKE only
B. IN only
C. NOT IN only
D. IN and NOT IN

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

A. report
B. form
C. file
D. table

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

A. ONLY
B. UNIQUE
C. DISTINCT
D. SINGLE

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

A. SELECT
B. READ
C. QUERY
D. None of the above is correct



For Answers of This Quiz Competition Click On The Following Video 







Please Like and Subscribe My Youtube Channel (CS TECH)  For More Quizzes and Free Certification Courses Click On The Following Link


Youtube Channel Link:CS TECH

Post a Comment

0 Comments

Ad Code