KENDRIYA VIDYALAYA WALTAIR
SEPTEMBER MONTHLY TEST – 2023-24
CLASS XII
SUBJECT: CS
MARKS 25 TIME 90 MINS
|
1 |
Which of the following methods returns list type of data a) read() b)
readline() c) readlines() d) writelines() |
1 |
|
2 |
Table A has the degree 2 , cardinality 4 and Table B has
degree 3 cardinality 2. What will be degree and cardinality of AXB |
1 |
|
3 |
In separated value files such as .csv and .tsv, what does
the first row in the file typically contain? a. The source of the data b. The
author of the table data c. Notes about the table data d. The column
names of the data |
1 |
|
4 |
Which of the following SQL command is used to delete a record to the table a) DELETE
b) ALTER c) UPDATE d) DROP |
1 |
|
5 |
Which of the following constraints will accept NULL values
in addition to non-repetition of values in MYSQL table. a) NOT NULL b)
UNIQUE c) PRIMARY KEY d)Candidate key |
1 |
|
Write a program to find the number of 4 letter words in a
text file . |
2 |
|
|
8 |
What are aggregate functions in MYSQL? Explain with
an example. |
2 |
|
9 |
i)Differentiate between count(attr) and count(*) with a
suitable example. ii) Differentiate between Where and HAVING clause in MYSQL |
2 |
|
10 |
Write a program to search for an employee(Ecode) in a
Binary file employee.DAT which is storing the details of employee records in
list [ Ecode , Name, salary Dept]. |
3 |
|
11 |
i)Consider the table student in Question 13, Identify
Primary key, Alternate key ii) Name the command which is used in the following
contexts a) Add new record
to a table b) Add new
column to the table c) deleting a
record from the table d) to display
all the tables in a database |
3 |
|
13 |
Consider the following table FURNITURE and answer the
questions  4.Write a query to increment discount value by 2 whose cost is more than 20000/- 5. write an SQL query to display the items of Bed variety |
3+2 |
|
14 |
Consider the tables given below and answer the questions.  |
3 |
No comments:
Post a Comment