CBSE Class 8 Computer Science Sample Paper Set D

CBSE Class 8 Computer Science Sample Paper Set D. It’s always recommended to practice as mane sample papers as possible before the examinations. Students can download the sample papers and also question papers of previous years to practice and score better marks in examinations. Refer to other links too for more sample papers.

1. Answer  the  following questions briefly 

: (1) How are  single tab  queries useful?

(2)  Explain  the  use  of WHERE·clause  in  SQL.

(3)  How  can  we maintain  col4mn integrity  of any  table?

2. Identify  the  valid  field names  from  the  following 

: "cust_id" , Address,  cust-id, order_number

3. List  errors  (if any)  in the  following SQL 

statements  : (1) Select from Movie  * 

(2)  Select  Name  from Movie where  Movie_id  2

4. Briefly  describe the advantages  of  DBMS.

5. Name  the  following datatypes  :

(a)  This  field  is  set  to·handle  a  Yes/No, True/False input. . 

(b)  This  field  accepts integers  with  a  fixed  length  of ten spaces.

6.  Explain  the  role  of a  Database  administrator .  (2)

7.  Consider  the  following table  and  write  SQL commands for  the  following  to : 

Table  :  Items

No  Product  Price  Supplier Stock

1  Motherboard  7000  Intel  20

2  Keyboard  1000  TVSE  70

3  Mouse  500  Logitech  60

4  Soundcard  600  Samsung  ...  50

5  Speaker  600  Samsung  25

6  Monitor  3000  Philips  22

7  CD-ROM  2800  Creative  32

8  Printer  7900  HP  10

(1)  Display  Product, Supplier Name  &  Price of  all  the  Items.

(2)  Display No, name  of  all  the  products where stock  is morethan  50.'

(3)  Display  Product of  Supplier  -  "Samsung".

(4) Display records of all the products  who arehaving  Supplier=  "Samsung" and Stock=50.  .. 

(5)  Display records of  all  the  products who  are  having  stock between  10 and 50..

{ 6)  Display all  records with  Product-Motherboard, Monitor,.Printer 

Please click the link below to download CBSE Class 8 Computer Science Sample Paper Set D.

Tags: 

 


Click to View or Download pdf file
Click for more Computer Science Study Material

Latest NCERT & CBSE News

Read the latest news and announcements from NCERT and CBSE below. Important updates relating to your studies which will help you to keep yourself updated with latest happenings in school level education. Keep yourself updated with all latest news and also read articles from teachers which will help you to improve your studies, increase motivation level and promote faster learning

Checking of Boards Answer sheets starts today

CBSE has instructed almost 3000 schools to start the evaluation work for class 10th and class 12th board exam answer sheets from today. The checking of answer sheets for class 10th and class 12th was stopped earlier due to covid crisis in the country. Now in order to...

Board Exams helpline by CBSE

According to the recent announcement of CBSE, the pending Class 10 and 12 Board exams are going to be held from 01 July to 15 July 2020 in India. Along with this, it has also been decided to resume the free of cost tele-counseling service for students from 9.30 am to 5...

Art Integrated Project work for classes 1 to 10

CBSE Board has decided to introduce Art-Integrated Project work for classes I to X to promote Art-Integrated Learning in schools to make teaching learning Competency-Based and joyful. As part of this, at least one Art-Integrated Project in each subject shall be taken...

Board Exams Class 10 and Class 12 Datesheet 2020

CBSE has announced the datesheet for the remaining exams of class 10 and class 12 exams. The exams are going to start in July. The class 10 and 12th board exams will be conducted for the remaining 29 papers from July 1 to July 15, 2020, at various centers nominated by...

Class 10 Board Exams to be held

The CBSE board has announced that there is no change in the decision of conducting the CBSE board exams for the 29 subjects, which were canceled due to coronavirus crisis. So when the lockdown gets relaxed completely, the board will conduct the exams for the students,...

CBSE advisory on student marks

CBSE has issued a public advisory for all students to be careful from unscrupulous persons impersonating themselves as officers/officials of CBSE. These people have been contacting parents and have been telling them that they have access to student marks data for Board...

×
Studies Today