SQL MCQ Questions and Answers for Practice

1. Which SQL statement is used to update a database table schema?

1. MODIFY TABLE
2. ALTER TABLE
3. CHANGE TABLE
4. UPDATE TABLE

2. Database normalisation typically

1. Reduces database size
2. Reduces data constraints
3. None of the above
4. Reduces number of tables

3. A SQL database view

1. Is computed using a SQL query
2. Takes up more disk space whenever more data is added to the database
3. Is a way to improve the read time of a table in a database
4. Contains data not stored in the database tables

4. Which of the following are SQL aggregate functions?

1. Insert
2. SELECT
3. JOIN
4. MIN

5. In a typical master/slave database system

1. Reads can be made on the slave and Writes can be made on the master
2. Reads can be made on the master and Writes can be made on the master
3. Reads can be made on the master and Writes can be made on the slave
4. Reads can be made on the slave and Writes can be made on the slave

6. A database index

1. Decreases database size
2. Doesn’t affect database size
3. Impacts database size differently in different cases
4. Increases database size

7. Which of the following will help when a database begins to become too large to keep on one system

1. Sharding database and Archiving data
2. Archiving data Only
3. Setting up daily database dump
4. Setting up a slave database

8. Which of the following code will create an index named stu_sub_ind on the columns roll_num and subject of the student_subjects table?

1. create index stu_sub_ind on student_subjects(roll_num, subject);
2. create index stu_sub_ind (roll_num, subject) on student_subjects;
3. It’s not possible to create an index on two columns
4. create index stu_sub_ind from student_subjects(roll_num, subject);