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
0 Comments