Scribd
Upload
39 views2 pages

Term-II Question Paper Ip

This document contains 10 multiple choice questions about SQL queries and database concepts. The questions cover topics like: - Creating a table with specific fields and constraints - Writing SQL commands to insert, update, delete records and display data from a sample CUSTOMER table - Differences between SQL clauses and data types - Opening a database and displaying tables - Constraints like primary key and unique key - Data types of columns in a sample ORDER table - Concepts related to Internet of Things, Artificial Intelligence, Big Data, Cloud Computing, Virtual Reality and Blockchain Technology

Uploaded by

Nandini Vashisht
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
39 views2 pages

Term-II Question Paper Ip

This document contains 10 multiple choice questions about SQL queries and database concepts. The questions cover topics like: - Creating a table with specific fields and constraints - Writing SQL commands to insert, update, delete records and display data from a sample CUSTOMER table - Differences between SQL clauses and data types - Opening a database and displaying tables - Constraints like primary key and unique key - Data types of columns in a sample ORDER table - Concepts related to Internet of Things, Artificial Intelligence, Big Data, Cloud Computing, Virtual Reality and Blockchain Technology

Uploaded by

Nandini Vashisht
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 2

PRABIIU DAYAL PUBLIC SCIIOOL

TERM 2 EXAMINATION (MARCI 2022)


CLASS XI
INFORMATICS PRACTICES(065) TIME:2 hours
MM.35

9.Write SQL query to erente tuble "sluden" witlh the following niructure
Field
Type Construint
Adn id Char 5 Primury key
Nanme Vurchar 20
DOR dute

Q.2 Write MYSQL commands for the


Table Name CUSTOMER following: (uny 8)

CUSTID NAME TYPE DOJ


GENDER
AMT
CNR_101 Manoj Saving 10250 1999-02-199 M

CNR 102 Rahul Current 1998-01-1 1 M


3260
CNR_103 John
Saving null 1999-02-04 M

CNR_104 Steve Saving 18250


1998-02-21 M

CNR_105 Manpree Current 1250 1998-05-12


Insert a record in the above table
To display all the customer of Current account
To list the names of customer with their
date of joining in ascending oruc
To display the customers whose name start with 'M".
To set the amount of cust id CNRI05 to 20000.
To add a ficld address of data
type varchar(50)
gTo display those records where amount is not cntered
h. To delete the record of John
T o display name of those whose amount is more than 16000
To display gender without duplicate
Q.3 What is the cardinality and degree of the above customer table

Q.4 Identily the primary key in eustomer table in q2.


Q.5 Give outputs for SQL queries based on above table customer:
a. SELECT DISTINCT type FROM CUSTOMER:
b. SELECT COUNT(") FROM CUSTOMER
c. SELECT Min(AMT) FROM CUSTOMER;
d. SELECT NAME FROM CUSTOMER WHERE NAME LIKE %';

1|Page
Q.6. Ditlerentnte between he following with exumple (any 4)
i alter table and ereate
tablo statement
Ii where und order by claus
i chur and varchar datatype
IV insert and update statement

v. Record and Field

Q.7 Write SQL commands for following


Open database school
databuse
11Display the tables present in the current

from primary key


Q.8 How is unique constraint different
OR
characteristics
What is MySql. State any one

table:
Q.9 Anitu has erented the given order

Column Nome Constrult


Orderld Primary Key
OrderDate Not Null
OruerAmoun
Storeld
One of the rows Inserted is as follows

Storeld
Orderld OrderDate OrderAmount
0101 2015-02-12 34000 SI04
Order?
(i) What is the data type of columns Orderld and OrderDate in the table
(i)Anita is now trying to insert the following row
OrderAmount Storcld
Orderld OrderDate
O102 NULL 59000 SI05
Will she be able to successfully insert it ? Give reason.

Q.10 Answer the following questions: (any 5) 5


i. What do you understand by Internet of Things?

ii. Explain Artificial Intelligence with example.


ii. Write a short note on Big Data.
V. What do you understand by Cloud Computing?
v. Define Virtual Reality.
vi. What is Block Chain Technology ?

2 P age

You might also like