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


12. To remove a relation from an SQL database, we use the ______ command.

A. Delete
B. Purge
C. Drop table
D. Remove

View Answer


13.  Updates that violate __________ are disallowed .

A. Integrity constraints
B. Transaction control
C. Authorization
D. DDL constraints

View Answer


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


15. Which of the following is not a aggregate function ?

A. With
B. Avg
C. Sum
D. Min

View Answer


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


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


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


19.  A relational database consists of a collection of

A. Table
B. Record
C. Fields
D. Attributes

View Answer


20. The set of permitted values of an attribute is called

A. Tuple
B. Domain
C. Column
D. Table

View Answer






Also check :


Discussion


* You must be logged in to add comment.