Database Management System Case Study Based Questions 01 Term II

Information Technology TERM II

Database Management System

Class 10 Session 2021-2022

Case Study Questions 01

Direction Read the case and answer the following questions.

Consider the following SQL command to create a table:

CREATE TABLE MEMBER
( MEM_ID INTEGER NOT NULL,
NAME CHAR(15) NOT NULL,
DATE_JOIN DATE,
ADDRESS VARCHAR(100) NOT NULL,
PH_NO CHAR(15),
);

(i) NOT NULL ensures that

(a) Column cannot have blank value
(b) Column will not accept any value
(c) Column has a fixed value
(d) Column has a unique value

(a) By default column holds NULL value. To change it and not let the value to stored as blank, NOT NULL constraint is used.

(ii) By default format of date entered is

(a) DD-MM-YY
(b) MM-DD-YY
(c) YYY-MM-DD
(d) DD-MM-YYYY

(c) For date related data MySQL has three data types- DATE, DATETIME and TIMESTAMP.

(iii) The ……… constraint ensures that the value entered specifies a certain condition.

(a) NOT NULL
(b) NULL
(c) CHECK
(d) All of these

(c) The CHECK constraint ensures that all values in a column satisfy certain condition. It is used for quality control.

(iv) PRIMARY KEY in above example ensures that

(a) MEM_ID is entered primarily
(b) MEM_ ID will hold a uniquely identified value
(c) MEM_ ID will not remain blank
(d) All of these

(b) PRIMARY KEY constraint is used to uniquely identify each row in a table.

(v) Which SQL command is used to create a table?

(a) ALTER
(b) INSERT
(c) UPDATE
(d) CREATE

(d) The CREATE command is used to create the structure of a table. The syntax to create a table is:
CREATE table <Table name>
{
<Data type> <Field Name1>,
<Data type> <Field Name2>,
<Data type> <Field Name3>
};

Leave a Comment

Your email address will not be published.

error: Content is protected !!