CBSE Class 8 Computer Science Sample Paper Set D

Scroll down for PDF

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 on the text For more study material for Computer Science please click here - Computer Science

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

Error in the evaluation of answer sheets in CBSE

The education board has witnessed many events where invigilators are being suspended for allotting wrong marks to the students.  This has affected students mainly of classes X and XII in the 2019 CBSE Board Exams. The central board of secondary education has taken...

CBSE to conduct a voluntary test for class 11th and 12th

Nowadays students have the liberty to choose the field they seem to fit in. A few years back the problem was parents who burdened children with their own choices. On the other side, now students along with their parent's support are free to choose their field. Not any...

CBSE examination board hike the fee for class 10th and 12th

The CBSE (Central Board Secondary Education) increased the examination fees for classes 10 and 12 of the 2020 boards, with no profit no loss principle, from Rs. 750 to Rs 1500, for all categories of students, including SC/ST candidates for all schools throughout India...

CBSE Circular Aryabhatta Ganit Challenge

For students with a keen interest in mathematics are now provided with a better opportunity to explore their knowledge. CBSE has announced to conduct an exam for the purpose of generating interest in maths among students. It is a trial to clarify the myth that...

CBSE Board Introduces Experiential Learning for Student

CBSE Academic Session 2019-20: Board Introduces Experiential Learning for Student: The education sector has grown for some new changes. As per the latest updates the Central Board of Secondary Education has been good in making all the possible efforts to improve...

×
Studies Today