NEW
Font size
S
M
L
XL
WorksheetsTest 2 T1
Total questions: 23
Worksheet time: 35mins
Name
Class
Date
1.
What is information about data called?
a)
Hyper data
b)
Tera Data
c)
Meta Data
d)
Super Data
e)
Info Data
2.
Which of the following is not a Data Model?
a)
Aggregate Model
b)
Network Model
c)
Hierarchical Model
d)
ER model
e)
Relational Model
3.
The Users who use easy-to-use menu are called____________________.
a)
Naïve User
b)
Database Administrator
c)
Sophesticated User
d)
Application Programmer
e)
Specialised User
4.
The ________ architecture leads to a performance loss with an increase in the number of users.
a)
two-tier DB
b)
three-tier DB
5.
A _________ DB architecture is comparatively much easier to maintain as well as build.
a)
two-tier DB
b)
three-tier DB
6.
______ manager controls the concurrency and atomicity in database system
a)
Authorization manager
b)
Integrity Manager
c)
Transaction Manager
d)
File manager
e)
Buffer Manager
7.
Multiple users are allowed to access data simaltenously is called ______
a)
Redundancy
b)
Integrety
c)
Atomicity
d)
Concurrency
8.
Role based authorities has been assigned can be called as ________
a)
Data Sharing
b)
Data Security
c)
Intergrety
d)
Data Accessing
9.
Data contained in the database is both correct and consistent
a)
Data Sharing
b)
Data Security
c)
Intergrety
d)
Data Accessing
10.
What is Composite key in DBMS
a)
a combination of multiple tables
b)
a combination of multiple Column
c)
a combination of multiple Rows
d)
None of Above
11.
A set of possible data values is called
a)
Domain
b)
Attribute
c)
Degree
d)
Tuple
12.
Consider the following schema for products:
Product(maker, model, type)
PC(model, speed, ram, hd, price)
Laptop(model, speed, ram, hd, screen, price)
Printer(model, color, type, price)
1. What PC models have a speed of at least 3.00?
a)
Πmodel(σ(speed>=3)(PC))
b)
Πmodel(σ(speed>3)(PC))
c)
Πmodel(σ(speed=3)(PC))
d)
σmodel(Π(speed>=3)(PC))
13.
Consider the following schema for products:
Product(maker, model, type)
PC(model, speed, ram, hd, price)
Laptop(model, speed, ram, hd, screen, price)
Printer(model, color, type, price)
2. Which manufacturers make laptops with a hard disk of at least 100GB?
a)
Πmaker(σ(Product.model=Laptop.model)∧(hd>=100)(Product × Laptop))
b)
Πmaker(σ(hd>=100)(Product × Laptop))
c)
Πmaker(σ(Product.model=Laptop.model)V(hd>=100)(Product × Laptop))
d)
Πmaker(σ(Product.model=PC.model)∧(hd>=100)(Product × Laptop × PC))
14.
Consider the following schema for products:
Product(maker, model, type)
PC(model, speed, ram, hd, price)
Laptop(model, speed, ram, hd, screen, price)
Printer(model, color, type, price)
3. Find the model numbers of all color laser printers.
a)
Πmodel(σ(type='Laser')∧(color='all')(Printer))
b)
Πmodel(σ(type='Color Laser')(Printer))
c)
Πmodel(σ(type='Laser')V(color='all')(Printer))
d)
Πmodel(σ(type='Laser')U(color='all')(Printer))
15.
Consider the following schema for products:
Product(maker, model, type)
PC(model, speed, ram, hd, price)
Laptop(model, speed, ram, hd, screen, price)
Printer(model, color, type, price)
4. Find those manufacturers that sell Laptops, but not PC’s.
a)
Πmaker(σ(Product.model=Laptop.model)(Product × Laptop)) - Πmaker(σ(Product.model=PC.model)(Product × PC))
b)
Πmaker(Product × Laptop) - Πmaker(Product × PC)
c)
Πmaker(σ(Product.model=Laptop.model)(Product × Laptop))
d)
Πmaker(σ(Product.model=Laptop.model)V (Product.model=Laptop.model)(Product × Laptop × PC))
16.
Consider the following schema for products:
Product(maker, model, type)
PC(model, speed, ram, hd, price)
Laptop(model, speed, ram, hd, screen, price)
Printer(model, color, type, price)
5. Find the model number and price of all products (of any type) made by manufacturer B
a)
Πmodel,price(σ(Product.model=Laptop.model)∧(Product.model=PC.model)∧(Product.model=Printer.model)(Product × Laptop × PC × Printer))
b)
Πmodel,price(σ(Product.model=Laptop.model)∧(Product.model=PC.model)(Product × Laptop × PC × Printer))
c)
Πmodel,price(σ(Product.model=Laptop.model)V(Product.model=PC.model)V(Product.model=Printer.model)(Product × Laptop × PC × Printer))
d)
Πmodel(σ(Product.model=Laptop.model)∧(Product.model=PC.model)∧(Product.model=Printer.model)(Product × Laptop × PC × Printer))
17.
Which is perfact syntax for adding column named Salary in employee table
a)
alter table employee add Salary type int;
b)
alter table employee add Column Salary type int;
c)
Insert column Salary into table employee;
d)
Add column Salary in table Employee;
18.
Which is perfact syntax for changing datatype of salary column to numeric in employee table
a)
alter table employee alter column salary type numeric(10) using salary::numeric(10);
b)
alter table employee alter column salary type numeric(10);
c)
alter table employee alter column salary numeric(10) using salary::numeric(10);
d)
alter employee alter column salary type numeric(10) using salary::numeric(10);
19.
Delete whole tuple of Ename deepika from the employee table
a)
Delete from employee where Ename='Deepika';
b)
Delete from employee for Ename='Deepika';
c)
Delete from employee into Ename='Deepika';
d)
Not possible in SQL
20.
How to create the user Jonh with 'abc' password
a)
CREATE USER JHON WITH PASSWORD 'abc';
b)
CREATE USER JHON PASSWORD 'abc';
c)
CREATE USER JHON HAVING PASSWORD 'abc';
d)
CREATE USER JHON WITH 'abc' PASSWORD;
21.
Change the designation of Gaurav from executive to manager in employee table
a)
Update employee set designation='manager' where name ='Gaurav';
b)
Update employee set designation='manager' where designation='executive';
c)
Update employee set designation=manager where name =Gaurav;
d)
Update set designation='manager' where name ='Gaurav';
22.
John have left the job so it need to update the table of employee by removing his name, give proper syntax in SQL
a)
Delete from employee where name='John';
b)
Update from employee where name='John';
c)
Update employee set name=NULL where name='John';
d)
Not possible in SQL
23.
Create a Customer_backup table containing all attribute of Customer table
a)
Create table Customer_backup as select * from Customer
b)
Create table Customer as select * from Customer_backup
c)
Create table Customer_backup as select ALL from Customer
d)
Create table Customer_backup from Customer
Reset
