1) Amit is in XII class, his father owns a pharmacy shop, he wants to help his father by computerizing the sales. Now he decided to store all data in MYSQL table named medicines. Which command he will use to store the data in a table. a) Create Database medicines b) Create Store medicines c) Database Table medicines d) Desc Table medicines e) Create Table medicines f) Create medicines 2) Amit wants to store M_Id in the format 'M001' . Which data type should he use? a) int b) varchar(4) c) char(4) d) int(4) e) float(4) f) blob 3) Amit has decided to have columns M_id, Med_name, qty, type, price, supp_city as columns. Which datatype combination will be feasible? a) char(4), varchar(20),int, varchar(10), float(4,2),varchar(10) b) varchar(4), varchar(20),float, int, float(4,2), varchar(10) c) int, varchar(20), int ,char(24), float(4,2), varchar(10) d) char(4), varchar(20),int, int, float(4,2),int e) date, varchar(20),int, varchar(10), float(4,2),varchar(10) f) char(4), varchar(20),int, varchar(10), varchar(10),varchar(10) 4) Amit wants to select values for column type as only 'Antibiotics', 'Analgesics', 'Sedatives', 'Vitamins','Anatcids'. Suggest a suitable data type to be chosen by him. a) int b) varchar c) char d) enum e) blob f) double 5) He wants the column qty to store value 0, if new record is inserted in the table without a value for column qty and no nulls. Which constraint is to be specified while creating table? a) primary key b) unique c) not null d) check e) references f) default

MySQL Basics-open Box

Print
Embed

Leaderboard

Visual style

Options

Switch template

Continue editing: ?