Question

27. Ananya uses Internet for her School Project. Suggest any five security measure to ensure
safety from online threats.
28. Explain the following terms :
a. Internet
b. LAN
c. Instant Messaging
d. Blog
e. P2P Architecture
29. Write command to create table named ‘BOOK ‘ with following fields:
BOOK ID Char(4)
Bname Varchar(15)
Author Varchar(20)
Price Decimal
a. Identify the primary key of the Book Table, also mention the suitable reason for
choosing it as a Primary Key
b. Differentiate between (i) char and varchar data type
(ii) DDL and DML
30. Write the SQL commands to answer the queries based on Fabric table
FabricID Fname Type Disc
F001 Shirt Woollen 10
F002 Suit Cotton 20
F003 Tunic Cotton 10
F004 Jeans Denim 5
F006 Shorts Cotton 7

Answer 1

27. 1- backup your important data

2- Limit sensitive personal info on social media.

3- Know your digital footprints.

4-Enable privacy and security settings.

5- Create strong passwords.