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

인쇄
퍼가기

순위표

비주얼 스타일

옵션

템플릿 전환하기

자동 저장된 게임을 복구할까요?