CBSE class 8 CBSE computer subject question paper solved

General Instructions:
All questions are compulsory.
Q.1	Select the correct option.	[8]
	Which view of a table in OpenOffice Base allows you to modify its structure?	(1) [R]
	SQL view	Data View
	Design view	All of these
	Source: pg. no. 46
	You are designing a database for a customer management system. One of the requirements is to store the customer's phone number and address. These fields do not require any calculations. Which data type should you use for these fields?	(1) [Ap]
	Text [VARCHAR]	Yes/No
	Integer	Decimal
	Source: pg. no. 47
	You are creating a database with a student table. One of the fields in this table with the Text data type has to follow the given requirements. Ensure that it must contain a value for each record. Limit the maximum length of the value of this field to 50 characters. Automatically fill in a default value of "N/A" for each new record if no value is provided. Based on these requirements, how would you set the Field Properties for this field?	(1) [Ap]
	Set the Entry required to ‘Yes’, Length to ‘255’, and Default value to ‘N/A’
	Set the Entry required to ‘Yes’, Length to ‘50’, and Default value to ‘N/A’
	Set the Entry required to ‘No’, Length to ‘50’, and Default value to ‘N/A’
	Set the Entry required to ‘Yes’, Length to ‘50’, and Default value to ‘ ’
	Source: pg. no. 50-51
	What is the use of a Form in a database management system?	(1) [U]
	View data without making changes.	Generate reports automatically based on the data.
	Display filtered records from a table based on conditions.	Enter new data and edit existing data.
	Source: pg. no. 61
	Rohit is a career consultant. He offers consultation service that guides students in future studies and career paths. Identify the party he belongs to in the e-commerce industry.	(1) [U]
	seller	merchant
	producer	buyer
	Source: pg. no. 71
	What is the best way to describe a podcast?	(1) [U]
	A television program that you can listen to and see.	A series of digital audio files that are broadcasted on the internet.
	An informative site of an individual’s ideas, activities, opinions and advice.	A website or app that enables users to communicate with other users of that site.
	Source: pg. no. 80
	What is the main advantage of using variables when creating a 3D object in Tinkercad Codeblocks?	(1) [U]
	Improves code readability	Allows for easier collaboration
	Reduces the number of code blocks needed	Enables quick modification of the size of the object
	Source: pg. no. 29
	Which of the following block sections in Codeblocks contains the given block?	(1) [R]
	Variables	Legacy
	Math	Control
	Source: pg. no. 31
Q.2	Answer the following questions in short.	[10]
	You are designing a database for a school to keep track of students. The database includes a table called Student_Details with the following fields:  Reg_No (Registration Number) Name DOB Address Phone_Number. The school principal wants to ensure that each student can be uniquely identified without any risk of duplicate or missing information. Which field should be designated as the primary key, and why?	(2) [Ap]
Ans:	The Reg_No should be set as the primary key because it will always have unique values for each student.  Other fields, such as Name, may have duplicates or DOB and Address, which might not be unique or could be blank. So, the Reg_No field provides a unique value for each record.
	Source: pg. no. 49
	Radhika is responsible for creating a report in OpenOffice Base from a monthly expense tracking database. Which type of report should she use, and why?	(2) [Ap]
Ans.	Radhika should use a dynamic report for the monthly expense tracking database. Dynamic reports can be updated to show the latest data or updated data.
	Source: pg. no. 65
	Identify the type of e-commerce described in the following statements.	(2) [Ap]
		You have a used guitar in good condition and want to sell it online to another person directly.
	Ans.	Customer to Customer (C2C)
		Hyundai Electronics is a large manufacturing company that purchases a bulk quantity of electronic components online for its new product line.
	Ans.	Business to Business (B2B)
	Source: pg. no. 72
	What is the role of a payment gateway provider in online transactions?	(2) [U]
Ans.	Payment gateways are like the middlemen between the buyer and the company providing the products. They provide a safe platform for transactions by encrypting the purchase information.
	Source: pg. no. 74
	Describe how the "Scale" block is used in Tinkercad Codeblocks.	(2) [U]
Ans.	The "Scale" block in Tinkercad Codeblocks is used to change the size of an object. The users can specify the X, Y, and Z dimensions to enlarge or reduce the size of the object.
	Source: pg. no. 36
Q.3	Do as directed.	[12]
	Khushi is using a technology that allows her to visualize the furniture in her house before purchasing them. Answer the following questions to help Khushi in understanding this emerging technology.	[Ap]
		Which technology is she using? Define what it does.	(2)
	Ans.	Augmented Reality. It is a technology that overlays computer-generated elements, such as images, videos, or interactive objects, onto the real-world environment.
		How can she access this technology?	(1)
	Ans.	She can access it using smartphones, tablets and special glasses
	Source: pg. no. 85
	Consider the following Employee table.	[An]
		What will be the result of the given query?	(2)
	Ans.
		How many records will the query return if the criteria is changed to ‘greater than 40000’ in the given query?	(1)
	Ans.	Four records
	Source: pg. no. 56-57
	What is the fillet feature used for in Tinkercad? How can you fillet an edge of an object?	(3) [U]
Ans.	A fillet is a rounded corner or edge of an object. These edges can be present either inside or outside an object. You can easily fillet an edge or a corner of an object using the MetaFillet shape. The MetaFillet shape is present in the Shape Generators section in Tinkercad. You can also create the MetaFillet shape by grouping a box with a hole cylinder.
	Source: pg. no. 28
	Surya is designing a Vase using the Extrusion shape in Tinkercad. Answer the given questions to help Surya with the design.	[R]
		What is the use of the window labelled ‘A’?	(1)
	Ans.	To view and edit the properties of a Extrusion shape.
		What is the name of the central points labelled ‘B’ from which the Bezier handles are dragged to reshape the object?	(1)
	Ans.	Anchor point
		How can you create smoother curves in the sketch using the Bezier handles?	(1)
	Ans.	Drag the Bezier handles away from the anchor point.

>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>