Unit 1(Laboratory)

Question 1

Creating tables in sqlserver

Answer 1

create table tbl_sample (
s_id int not null identity(1,1) primary key,
s_name varchar(500),
s_amt money,
s_unit int,
s_price decimal(10,4))

Question 2

Creating tables in mysql

Answer 2

create table tbl_sample (
s_id int not null auto_increment primary key,
s_name varchar(500),
s_amt decimal(10,4),
s_unit int,
s_price decimal(10,4))

Question 3

the difference between the foreign keys of Sql Server and MySQL

Answer 3

s_id int not null identity(1,1) primary key – SQL Server

s_id int not null auto_increment primary key – MySQL

Question 4

creating indexes in sql server and mysql

Answer 4

//SQL Server
create unique index emp_testdex on tbl_test(emp_num, test_code, test_date);
//MySQL
create unique index emp_testdex on tbl_test(emp_num(15), test_code(10), test_date);

Question 5

if you want to put the indexes into asc and desc

Answer 5

//SQL Server and MYSQL
create index prod_pricex on tbl_product(p_price desc);

Question 6

deleting an index

Answer 6

drop index indexname on tablename

Question 7

dropping or eliminating an index

Answer 7

//SQL Server and MYSQL
drop index prod_pricex on tbl_product;