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

a) UPDATE TABLE
b) MODIFY TABLE
c) ALTER TABLE
d) CHANGE TABLE

Answer(s) : 
c) ALTER TABLE

2) Database normalisation typically

a) Reduces number of tables
b) Reduces database size
c) Reduces data constraints
d) Reduces chances of data anomalies

Answer(s) : 
b) Reduces database size
d) Reduces chances of data anomalies

3) A SQL database view

a) Contains data not stored in the database tables
b) Is computed using a SQL query
c) Takes up more disk space whenever more data is added to the database
d) Is a way to improve the read time of a table in a database

Answer(s) : 
b) Is computed using a SQL query

4) Which of the following are SQL aggregate functions?

a) MIN
b) AVG
c) SELECT
d) JOIN

Answer(s) : 
a) MIN
b) AVG

5) In a typical master/slave database system

a) Writes can be made on the slave
b) Reads can be made on the slave
c) Writes can be made on the master
d) Reads can be made on the master

Answer(s) : 
b) Reads can be made on the slave
c) Writes can be made on the master

6) A database index

a) Increases database size
b) Decreases database size
c) Doesn’t affect database size
d) Impacts database size differently in different cases

Answer(s) : 
a) Increases database size

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

a) Setting up a slave database
b) Sharding database
c) Archiving data
d) Setting up daily database dump

Answer(s) : 
b) Sharding database
c) Archiving data

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?

a) create index stu_sub_ind from student_subjects(roll_num, subject);
b) create index stu_sub_ind on student_subjects(roll_num, subject);
c) create index stu_sub_ind (roll_num, subject) on student_subjects;
d) It’s not possible to create an index on two columns

Answer(s) : 
b) create index stu_sub_ind on student_subjects(roll_num, subject);

9) Which of the following will typically improve database write times

a) Using a hard disk with faster write speeds
b) Normalising data to reduce amount of data to be written
c) Using transactions for every database operation
d) Removing unnecessary constraints

Answer(s) : 
a) Using a hard disk with faster write speeds
b) Normalising data to reduce amount of data to be written
d) Removing unnecessary constraints

10) For table CUSTOMERS

The query SELECT ID FROM CUSTOMERS WHERE SALARY > 5000 OR age < 25; will produce result

a) 3 4 5 6 7
b) 6 7
c) 3 4 5
d) 1 2 3 4 5 6 7

Answer(s) : 
a) 3 4 5 6 7 
Categories: NPTEL solution

16 Comments

Rajendra Patel · August 11, 2017 at 7:04 PM

Thank you so much friends for solution.God bless you!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

    SHAUNAK BHATTACHARJEE · August 13, 2017 at 4:40 PM

    Thanks. Can you please upload the solutions of Week 3? Tomorrow i.e. 14th August is the last date. Thank You!

      yashrs · August 13, 2017 at 6:53 PM

      We have already uploaded Week 3 Solution for IMAD.

        krishna · August 21, 2017 at 3:22 PM

        can u please upload week4 solutions for IMAD

NeoMatrix007 · August 21, 2017 at 2:34 PM

Can you please upload week 4 assignment answers the deadline is 31 august please upload it fast

Jagmohan · August 23, 2017 at 9:15 AM

Hi Hackademic Team,

Well done job !! , you have given life to many students pursuing the course but could not complete assignments to write test…I appreciate your work and Hope ” Hackademic Team ” will give solutions for coming weeks as well till the course end.

Thank you a lot…

sai · August 23, 2017 at 4:03 PM

yashrs can u upload week4 and week5 solutions please

    Mit Patel · August 24, 2017 at 7:23 PM

    Hello Sai. We will update it very soon.
    Please subscribe and keep visiting.
    Because here we aim to please 🙂
    -Hackademic Team

Shivam Shrivastava · August 23, 2017 at 5:12 PM

Dude could you please upload week 4 quiz of IMAD as soon as possible ?

    Smit Parmar · August 24, 2017 at 9:05 AM

    check now IMAD 4th week
    Please Subscribe hackademic if you like our work

nisha · August 24, 2017 at 7:53 AM

can uh please upload 4th week assignment solution.. deadline is near..

    Smit Parmar · August 24, 2017 at 8:49 AM

    Now U can check from IMAD 4th week

      sai · September 3, 2017 at 7:29 PM

      hai smit parmar can u upload IMAD 5th week solutions (introduction to mobile developement)

      Thanks&Regards

        Smit Parmar · September 4, 2017 at 4:31 PM

        Just Give one day,stay with hackademic, We here aim to please

manju · September 4, 2017 at 7:18 PM

imad 5th week solutions please

    Mit Patel · September 5, 2017 at 7:12 PM

    The solution has been posted. Keep visiting hackademic. Thank you.
    ~ Because here we aim to please

Leave a Reply

Your email address will not be published. Required fields are marked *