SQL Multiple Choice Question - SQL Basic
11. Create table student(name varchar ,id integer) What type of statement is this ?
A. DML
B. DDL
C. DCL
D. TCL
View Answer
Ans : A
Explanation: Data Definition language is the language which performs all the operation in defining structure of relation.
12. To remove a relation from an SQL database, we use the ______ command.
A. Delete
B. Purge
C. Drop table
D. Remove
View Answer
Ans : C
Explanation: Drop table deletes the whole structure of the relation .purge removes the table which cannot be obtained again.
13. Updates that violate __________ are disallowed .
A. Integrity constraints
B. Transaction control
C. Authorization
D. DDL constraints
View Answer
Ans : A
Explanation: Integrity constraint has to be maintained in the entries of the relation
14. Which of the following creates temporary relation for the query on which it is defined
A. With
B. From
C. Where
D. Select
View Answer
Ans : A
Explanation: The with clause provides away of defining a temporary relation whose definition is available only to the query in which the with clause occurs..
15. Which of the following is not a aggregate function ?
A. With
B. Avg
C. Sum
D. Min
View Answer
Ans : A
Explanation: With is used to create temporary relation and its not a aggregate function.
16. A Database Management System is
A. Collection of interrelated data
B. Collection of programs to access data
C. Collection of programs
D. None of the mentioned is correct.
View Answer
Ans : B
Explanation: Database Management System is Collection of programs to access data
17. Which of the following is not disadvantages of file system to store data?
A. Data redundancy and inconsistency
B. Difficulty in accessing data
C. Data isolation is not present
D. High Cost
View Answer
Ans : D
Explanation: High cost the following is not disadvantages of file system to store data.
18. Which of the following is not a features provided by DBMS?
A. Maintain accuracy of data
B. Utilities for performance analysis and logging
C. Ensure modifications are successful or not done at all
D. Recovery mechanism for data
View Answer
Ans : B
Explanation: Utilities for performance analysis and logging features not provided by DBMS
19. A relational database consists of a collection of
A. Table
B. Record
C. Fields
D. Attributes
View Answer
Ans : A
Explanation: A relational database consists of a collection of Tables.
20. The set of permitted values of an attribute is called
A. Tuple
B. Domain
C. Column
D. Table
View Answer
Ans : C
Explanation: The set of permitted values of an attribute is called Column.
Also check :
Discussion