Scribd
Upload
24 views2 pages

Periodic Test-I 2024-25

This document outlines the structure and content of Periodic Test-I for Class X in Information Technology for the academic year 2024-25. It includes various types of questions such as multiple-choice, short answers, and SQL queries, covering topics like database management, communication barriers, and report creation. The test is designed to assess students' understanding and application of key concepts in the subject.

Uploaded by

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

Periodic Test-I 2024-25

This document outlines the structure and content of Periodic Test-I for Class X in Information Technology for the academic year 2024-25. It includes various types of questions such as multiple-choice, short answers, and SQL queries, covering topics like database management, communication barriers, and report creation. The test is designed to assess students' understanding and application of key concepts in the subject.

Uploaded by

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

PERIODIC TEST- I 2024-25

Class : X Subject Time :


Date : .07.2024 Information Technology MM :40
1.Attempt all Questions
Instruction : 2.Write all the output based answer sequentially

Section A
Q1 Do as directed: 05
A) Common DDL statements are create, alter and ___________
i) Select. ii) Update. iii) Delete. iv)drop
B) There are three types of Relationships in a table.
i) Two. ii) Three. iii) Four. iv) Eight
C) I had _________ trouble reaching youre house
i) a lot of ii) lots of iii) a lots . iv) None of the above
D) Her parents _________ in a factory
i) work ii) works iii) working iv) Worked
E) Which of the following is not an example of DBMS?
i) MySQL ii) Microsoft Acess iii) IBM DB2 iv) Google

Q2 What is Referential Integrity? 01


Q3 What is the difference between ‘Rows’ and ‘Columns’ in a table 02
Q4 A table named School (containing data of students of the whole school) is created, 02
where each record consists of several fields including AdmissionNo (Admission
Number), RollNo (Roll Number), Name. Which field out of these three should be set as
the primary key and why?
Q5 Write the steps to create table using Design view? 02

Q6 State the relationship and difference between a primary key and foreign key? 02
Q7 What are wild card characters? Explain 02
OR
Write the advantages of DBMS?
Q8 What is Query? Write the steps to display ename and sal from the table employee 02
using sql view.

Q9 What are communication barriers? Name some of the communication barriers. 02


Q10 How many types of relationships can be created in Base? Explain each of them 03
Q11 Write the different methods of communication? 03
Q12 What is feedback? Write the types of feedback and tell us about the features of good 05
feedback
Q13 What do you mean by form and report? Write the steps for creating report of the 04
table employee given in question no 8.
Q14 Define Cardinality and Degree? If a table employee contains 7 rows and 6 columns 02
after adding 10 more rows in the table what will be the cardinality and degree of the
table
Q15 Write SQL query on the basis of the table given below : 03

a) To display Fare and Flight no from the table fare.


b) To Display Airlines and Fare with increment of 100 in fare.
c) Select Airlines, Fare from Fares where Fl_No = ‘IC701’ ;
d) Select * from Fares where Fare>9000;
*****************************

You might also like