mcqs bucket

  • SQL Mcqs Questions | MCQs Bucket Largest Mcqs Website

    mcqsbucket

      Best guide for exams of all nature, Competitive exams and Interviews
Here is the MCQs guide for the topic of SQL. you will find various types of questions along with there answers in this
Q. Which statement in SQL allows us to change the definition of a table is?
A.
ALTER
B.
UPDATE
C.
CREATE
D.
SELECT


Show Answer
Q. 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


Show Answer
Q. A database language used for defining the whole databasestructureand schema is called :
A.
DCL
B.
DML
C.
DDL
D.
All Of Above


Show Answer
Q. What is the full form of DDL ?
A.
Dynamic Data Language
B.
Detailed Data Language
C.
Data Definition Language
D.
Data Derivation Language


Show Answer
Q. Which function is used to divides one numeric expression by another and get the remainder ?
A.
POWER
B.
MOD
C.
ROUND
D.
REMAINDER


Show Answer
Q. Which data type can store unstructured data in a column?
A.
RAW
B.
CHAR
C.
NUMERIC
D.
VARCHAR


Show Answer
Q. The COUNT function in SQL returns the number of ______________
A.
Values
B.
Distinct values
C.
Group By
D.
Columns


Show Answer
Q. DCL provides commands to performactionslike
A.
Change thestructureof Tables
B.
Insert, Update or Delete Records and Values
C.
Authorizing Access and othercontrolover Database
D.
None of Above


Show Answer
Q. Which of the following is a 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;


Show Answer
Q. A SQL query automatically eliminates duplicates (True / False) ?
A.
TRUE
B.
FALSE


Show Answer