Plus Two

Students can Download Chapter 4 Graphs and Charts for Business Data Questions and Answers, Plus Two Accountancy Chapter Wise Questions and Answers helps you to revise the complete Kerala State Syllabus and score more marks in your examinations.

Kerala Plus Two Chemistry Chapter Wise Questions and Answers Chapter 4 Graphs and Charts for Business Data

Plus Two Accountancy Graphs and Charts for Business Data One Mark Questions and Answers

Question 1.
_____________ are the visual representation of numerical data
Answer:
Chart/ Graph

Question 2.
Chart / Graph has at least ____________ dimenstional relationship
(a) Two
(b) Three
(c) Four
(d) Five
Answer:
(a) Two

Question 3.
____________ chart is suitable for comparing multiple.
Answer:
Bar Chart

Question 4.
In column chart, the X-axis shows
(a) Value of each category
(b) Different categories
(c) Height of the chart
(d) Depth of the value
Answer:
(b) Different categories

Question 5.
________ Chart is similar to the column chart, with the difference being that the data series are displayed horizontally
(a) Line chart
(b) Pie chart
(c) Barchart
(d) Area chart
Answer:
(c) Bar chart

Question 6.
________ chart shows data changes for a certain period of time.
Answer:
Line chart

Question 7.
_______ chart contains only one data series
Answer:
Pie chart

Question 8.
_______chart shows values as circular sectors to the total circle
Answer:
Pie chart

Question 9.
Pie chart don’t have more than __________ categories.
(a) Ten
(b) Twenty Five
(c) Seven
(d) Three
Answer:
(c) Seven

Question 10.
____________ is a pictorial representation of data, which has at least two dimensional relationships.
(a) Graph
(b) Chart
(c) Diagram
(d) All the above
Answer:
(d) All the above

Question 11.
_________ Chart is used to compare values across categories.
(a) Column chart
(b) Line chart
(c) Pie chart
(d) Barchart
Answer:
(a) Column chart

Question 12.
_________ chart is used to display trends over time.
Answer:
Line chart

Question 13.
The entire chart including all elements is termed as ________
Answer:
Chart area

Question 14.
In 3D chart, the area is bounded by three axes ie _____, _____ & _____
Answer:
X, Y, Z

Question 15.
In ______ chart, both axes display values ie they have no category axis.
Answer:
XY Chart or Scatter diagram

Question 16.
_______ specifices the colour, symbol or pattern used to mark data series.
Answer:
Legends

Question 17.
The change the location of a chart, right click the chart and select.
(a) Chart Type
(b) Source Data
(c) Move here
(d) Chart Options
Answer:
(c) Move here

Question 18.
In 3D chart X, Y & Z axes are used to show
(a) Category, Value, Total
(b) Depth, Vertical, Horizontal
(c) Length, Breadth, Depth
(d) Category, Value, Series.
Answer:
(d) Category, Value, Series

Question 19.
Legand can be repositioned on the chart
(a) Anywhere
(b) On right side only
(c) On the corner only
(d) On the left side only
Answer:
(a) Anywhere

Question 20.
Which chart element details the data values and categories below the chart?
(a) Data table
(b) Data marker
(c) Data labels
(d) Datapoint
Answer:
(c) Data labels

Question 21.

Which type of chart is this?
Answer:
Radar chart

Question 22.
The intersection of both the axis (X-axis and Y-axis) is called __________ of the graph.
Answer:
Origin (0)

Question 23.
_________ Chart display in rings, where each ring represents a data series
Answer:
Doughnut chart.

Question 24.
Name the given chart

Answer:
Bar Chart

Question 25.
In _________ chart, the area below the plotted lines is solid
Answer:
Area chart.

Question 26.
Radar chart / Net chart is also known as ______
(a) Doughnut chart
(b) Pie chart
(c) Ara chart
(d) Star chart
Answer:
(d) Star chart

Question 27.
Which among the following is the special feature of 3D chart
(a) Chart area
(b) X & Y axes
(c) Chart wall
(d) Legend
Answer:
(c) Chart wall

Question 28.
Give a suitable name to the diagram

(a) Barchart
(b) Single line graph
(c) Pie chart
(d) Area Chart
Answer:
(c) Pie Chart

Plus Two Accountancy Graphs and Charts for Business Data Two Mark Questions and Answers

Question 1.
Name the different chart formats in Libre Office Calc
Answer:
Barchart, Column Chart, Pie chart, Line chart, Area chart, Doughnut chart, etc.

Question 2.
What is the importance of charts and graphs in business?
Answer:

1. Chart and graphs covey lots of business information in a visual format
2. Different business Data variables plotted in charts and graphs show the trend of the business in an easy way

Question 3.
Identify the type of chart

Answer:
Line chart

Question 4.
Give a short note on it.

1. Barchart
2. Pie chart

Answer:
1. Bar Chart
This type of chart shows a bar graph or column chart with horizontal bars. The Y-axis shows categories and the X-axis shows the value for each category. It is suitable for comparing multiple values.

2. Pie chart
A pie chart displays the contribution of each value to a total. It represents multiple subgroup of a single variable. It contains only one data series. A pie chart shows values as circular sectors of the total circle. Pie chart may be

• Normal Pie chart
• Exploded Pie chart
• Doughnut chart or Donut chart
• Exploded Doughnut chart

Question 5.
What are the special features of graphs and charts?
Answer:

1. Graphs/charts are the pictorial representation of business data
2. A chart represents tabular numeric data
3. Dimensions in the data are often displayed on axes (X, Y, & Z)

Question 6.
Differentiate between Chart area and Chart wall?
Answer:
1. Chart area:
This is the total space that is enclosed by a chart. It is the background of the chart.

2. Chart wall:
In 2D chart, the wall or area is bounded by the X and Y-axis. In the 3D chart, the wall is bounded by three axes X, Y and Z

Question 7.
Quarterly sales of a business firm is used to create a bar graph. Identify the Data variables plotted on X and Y-axis
Answer:
X-axis – I^st Quarter, II^nd Quarter, III^rd Quarter, IV^th Quarter,
Y-axis – Sales in I^st Quarter, Sales in I^nd Quarter, Sales in III^rd Quarter, Sales in IV^th Quarter

Question 8.
Identify the type of chart

Answer:
(a) 2D Chart
(b) 3D Chart

Question 9.
What is the use of Auto shapes in LibreOffice Calc?
Answer:
Auto shapes tool bar allows drawing a number of geometrical shapes, arrows; flow chart elements, etc.

Question 10.
What is PIE chart? What are the specialties of PIE chart.
Answer:
Pie chart:
A pie chart displays the contribution of each value to a total. It represents multiple subgroup of a single variable. It contains only one data series. A pie chart shows values as circular sectors of the total circle. Pie chart may be

1. Normal Pie chart
2. Exploded Pie chart
3. Doughnut chart or Donut chart
4. Exploded Doughnut chart

Question 11.
Choose the right statements from the following.

1. We can put on the right side of the origin positive values and on left side of the origin negative values of data on X-axis
2. The upward side of origin shows postiive values and downward side of the origin shows negative values of data on Y-axis.
3. We can put on the right side of the origin negative values and on left side of the origin positive values of data on X-axis.
4. The upward side of origin shows negative values and downward side of the origin shows positive values of data on Y-axis.

Answer:
Right statements a & b

Question 12.
Identify the type of given chart. List down its features.

Answer:

1. It is a Doughnut chart
2. Features of the doughnut chart
   • It displays data in rings
   • Each ring represents a data series
   • The first data series is displayed in the center of the chart

Question 13.
What is a 3-D chart?
Answer:
Charts can be prepared with three dimensional (3-D) effects. 3- D charts have a third axis. The third axis is called as Z-axis. So a 3-D chart has the fol¬lowing dimensions.

1. Horizontal axis – Indicate the category – known as X-axis
2. Vertical axis – Indicate the derived values – known as Y-axis
3. Depth axis – Indicate the series – known as Z-axis

Question 14
Differentiate between Data Marker and Data series.
Answer:
1. Data Marker:
Individual values plotted in a chart are called data marker or data point.

2. Data Series:
Data markers of the same colour or pattern is called data series.

Question 15.
Is there any difference between

1. A column chart and
2. A bar chart?

Substantiate your answer
Answer:
1. Column Chart:
It is the most commonly used chart type. It shows a bar chart or bar graph with vertical bars. The X-axis shows the categories and Y-axis shows the value for each category. Column chart are used to compare values across categories.

2. Bar Chart:
This type of chart shows a bar graph or column chart with horizontal bars. The Y-axis shows categories and the X-axis shows the value for each category. It is suitable for comparing multiple values.

Plus Two Accountancy Graphs and Charts for Business Data Three Mark Questions and Answers

Question 1.
Match the following

Answer:

Question 2.
What are the advantages of using Graph/ Chart?
Answer:
Advantages in using Graph/Chart:

1. It summarises a large data set in visual form
2. Charts or graphs can clarify trends better than do tables.
3. It helps to estimate key values at a glance
4. It shows each data category in a frequency distribution.
5. It permits a visual check of the accuracy and reasonableness of calculations
6. The charts and graphs allow the investigator to draw a valid conclusion.

Question 3.
What are the elements of a Chart/ Graph
Answer:

Question 4.
How to use word Art styles to format text.
Answer:

• Step 1: Click in the chart element that contains text to be changed.
• Step 2: Click on the format.
• Step 3: Click on word Art styles.
• Step 4: Choose suitable options related to text formating like text fill, text outlines, shadow, etc.

Plus Two Accountancy Graphs and Charts for Business Data Four Mark Questions and Answers

Question 1.
What are the difference between 2D charts and 3D charts
Answer:

Question 2.
List out the steps to Rotate a chart.
Answer:

• Step 1. Select the plot area of the chart.
• Step 2. Click on the format tab.
• Step 3. Click on format selection.
• Step 4. Click on 3D Rotation and type a value of angle between 0° to 360° and then click close
• Step 5. Click on the chart area of the chart and click on format tab.
• Step 6. Click on shape effects and then click on Bevel and select a bevel option.

Question 3.
What are the different types of charts?
Answer:

1. Column chart: column chart are used to compare values across categories
2. Line chart: Line charts are used to display trends over time
3. Pie chart: Pie charts display the contribution of each value to a total
4. Bar chart: Bar charts are best suited for comparing multiple values
5. Area chart: Area chart emphasis differences between several sets of data over a period of time.
6. Scatter chart: (XY chart) This chart compares pairs of values.
7. Radar chart: Display values relative to a centre point.
8. Doughnut chart: It shows the relationship of parts to a whole. This chart display data in rings, where each ring represents a data series.

1. Column Chart:
It is the most commonly used chart type. It shows a bar chart or bar graph with vertical bars. The X-axis shows the categories and Y-axis shows the value for each category. Column chart are used to compare values across categories.

2. Line Chart:
A line chart shows values in the Y-axis and categories in X-axis. The Y values of each data series is connected by a line. Line chart shows data changes for a certain period of time.

3. Pie chart:
A pie chart displays the contribution of each value to a total. It represents multiple subgroup of a single variable. It contains only one data series. A pie chart shows values as circular sectors of the total circle. Pie chart may be

• Normal Pie chart
• Exploded Pie chart
• Doughnut chart or Donut chart
• Exploded Doughnut chart

4. Bar Chart:
This type of chart shows a bar graph or column chart with horizontal bars. The Y-axis shows categories and the X-axis shows the value for each category. It is suitable for comparing multiple values.

5. Area chart:
The chart shows values as points on the Y-axis. The X-axis shows categories. The Y values of each data series are connected by a line. The area between each two lines is filled with a colour.

6. Scatter chart:
Scatter chart is also known as XY chart. In this type of chart, both axes display values. This chart is used to show the relationship among two variables.

7. Radar chart:
It is also known as Net chart or Star chart. A radar chart has a separate axis for each category and the axes extend outward from the center of the chart. The value of each data point is plotted on the corresponding axis.

8. Doughnut chart:
Chart display in rings, where each ring represents a data series. The first data series is displayed in the centre of the chart.

Question 4.
Identify and explain the type of chart given below.
Answer:

1. This is scatter chart or XY chart.
2. Features:
   • Both axes display values (No category)
   • This chart is used to show the relationship among two variables
   • Generally this chart is used for scientific, statistical and engineering data

Question 5.
Match the following.

Answer:

• (a) – (ii);
• (b) – (iii);
• (c) – (iv);
• (d) – (i)

Question 6.
How can we change the format of a selected chart element?
Answer:

• Step 1. Click anywhere in the chart.
• Step 2. Click format
• Step 3. Click format selection
• Step 4. Select a category (Fill border, style, etc)
• Step 5. Select formatting options

Question 7.
List down any four advantages of charts/ Graphs
Answer:
Advantages in using Graph/Chart:

1. It summarises a large data set in visual form
2. Charts or graphs can clarify trends better than do tables.
3. It helps to estimate key values at a glance
4. It shows each data category in a frequency distribution.
5. It permits a visual check of the accuracy and reasonableness of calculations
6. The charts and graphs allow the investigator to draw a valid conclusion.

Question 8.
What are the features of Charts/ Graphs in Libre Office Calc?
Answer:

1. Chart is a graphical representation of data
2. They are visual representation of numerical data
3. Charts can be read more quickly than the raw data
4. A chart has at least two axes – X and Y

Plus Two Accountancy Graphs and Charts for Business Data Five Mark Questions and Answers

Question 1.
What Pie Chart? What are the different types of Pie Chart?
Answer:
Pie chart:
A pie chart displays the contribution of each value to a total. It represents multiple subgroups of a single variable. It contains only one data series. A pie chart shows values as circular sectors of the total circle. Pie chart may be

1. Normal Pie chart
2. Exploded Pie chart
3. Doughnut chart or Donut chart
4. Exploded Doughnut chart

Question 2.
Name the different elements of given chart.

Answer:

• X-Axis Title
• Y-Axis Title
• Data label
• Main Title
• Legend
• X-Axis
• Y-Axis
• Data series

Question 3.
Write the steps of changing the chart type.
Answer:

1. First select the chart by double-clicking on it. The chart should now be surrounded by a gray bonder
2. Right-click on the chart and choose chart type.
3. Select the replacement chart type.
4. Click on [OK]

Question 4.
Write the steps for preparing a chart in Libre Office Calc.
Answer:

• Step 1: Enter the data in a worksheet with proper column and row titles
• Step 2: Select the range of data using the mouse
• Step 3: Click on Insert Tab → Object → Chart. Select a chart type from the “Choose a chart type” list in chart wizard window.
• Step 4: Naming chart, X-axis and Y-axis. Click on the chart → Right click → Insert titles (Names) → OK
• Step 5: Change the layout or styles of chart.
• Step 6: Show or hide a legend
• Step 7: Display or hide chart axes or gridlines
• Step 8: Move (resize) a chart
• Step 9: Save a chart

Plus Two Accountancy Graphs and Charts for Business Data Practical Lab Work Questions and Answers

Question 1.
Draw an Area Chart from the following

Procedure:
Step 1 – Open a new blanks worksheet in LibreOffice Calc

Step 2 – Enter the above data as follows.

Step 3 – Select the range A1: D6 which is to be shown in the chart.

Step 4 – Click on Insert menu → Click on Chart → Chart wizard → Select Area Chart → Finish
Output:

Question 2.
Quarterly sales of a product are given below. Draw a bar diagram/bar chart

Procedure:
Step 1 – Open a new blanks worksheet in LibreOffice Calc

Step 2 – Enter the above data as follows.

Step 3 – Select the range A1: B5 which is to be shown in the chart:

Step 4 – Click on Insert menu → Click on Chart → Chart wizard Click on Bar chart → Finish
Output:

Question 3.
Draw a 3D column chart from the following details.

Procedure:
Step 1 – Open a new blank worksheet in LibreOffice Calc.

Step 2 – Enter the following data in the respective cells.

Step 3-Select the range A1: B6, which is to be shown in the chart.

Step 4 – Click on Insert menu → Click on Chart → Chart wizard → Click on Column Chart → Tick 3D Look → Select Bar Charts → Finish.
Output:

Question 4.
The net profits of a firm for the last six years are given below. Draw a line chart.

Procedure:
Step 1 – Open a new blank worksheet in LibreOffice Calc

Step 2 – Enter the following data in the respective cells

Step 3 – Select the range A1: B7, which is to be shown in the chart

Step4- Click on Insert menu → Click on Chart → Chart Wizard → Click on Line Chart → Finish
Output:

Question 5.
Enter the following data into a LibreOffice Calc worksheet and draw a 3D Pie chart.

Procedure:
Step 1 – Open a new blank worksheet in LibreOffice Calc.

Step 2 – Enter the data in respective cells.

Step 3 – Select the range A2: B9, which is to be shown in the chart

Step 4 – Click on Insert menu → Click on Chart → Chart wizard → Click on Pie Chart Tick on 3D Look → Finish
Output:

Question 6.
Sales for the first six months in 2 years are given below. Draw a scatter chart in a LibreOffice Calc works sheet

Procedure:
Step 1 – Open a blank worksheet in LibreOffice Calc.

Step 2 – Enter the data in the following cells.

Step 3 – Select the range A1: C7, which is to be shown in the chart

Step 4 – Click on → Insert menu Click on → Chart → Chart Wizard → Scatter Chart→ Finish
Output:

Question 7.
The production of different items in Oct. 2015 is listed below. Draw a Radar Chart

Procedure:
Step 1 – Open a blank worksheet in LibreOffice Calc.

Step 2 – Enter the data in the following cells.

Step 3 – Select the range A1: C6, which is to be shown in the chart

Step 4 – Click on → Insert menu → Click on Chart → Chart Wizard → Click on Radar Chart → Finish
Output:

Question 8.
The following table shows the number of students passed in the higher secondary examination. Draw a doughnut chart.

Procedure:
Step 1 – Open a blank worksheet in LibreOffice Calc.

Step 2- Enter the data in the following cells.

Step 3 – Select the range A1: D6, which is to be shown in the chart.

Step 4 – Click on → Insert menu → Click on Chart → Chart Wizard → Click on doughnut Chart → Finish.
Output:

Students can Download Chapter 6 Application of Derivatives Questions and Answers, Plus Two Maths Chapter Wise Questions and Answers helps you to revise the complete Kerala State Syllabus and score more marks in your examinations.

Kerala Plus Two Maths Chapter Wise Questions and Answers Chapter 6 Application of Derivatives

Plus Two Maths Application of Derivatives Three Mark Questions and Answers

Question 1.
Find the equation of tangents and normals to the given curves x = cost, y = sin t at t = \(\frac{π}{4}\).
Answer:
Given; x = cost, y = sin t

Equation of tangent at t = \(\frac{π}{4}\) is;

Equation of normal at t = \(\frac{π}{4}\) is;

⇒ \(\sqrt{2}\)y + \(\sqrt{2}\)x = 0 ⇒ y + x = 0.

Question 2.
A ladder Sm long is leaning against a wall. The bottom of the ladder is pulled along the ground, away from the wall, at the rate of 2cm/s. How fast is its height on the decreasing when the foot of the ladder is 4m away from the wall?
Answer:
From the figure we have;
x² + y² = 25 ____(1)

Differentiating w.r.t t;

From (1) when x = 4 ⇒ 16 + y² = 25 ⇒ y = 3
Given; \(\frac{d x}{d t}\) = 2cm/s = 0.02 m/s
(2) ⇒ 4(0.02) + 3 \(\frac{d x}{d t}\) = 0

Question 3.
Find the points on the curve y = x³, the tangents at which are inclined at an angle of 60° to x-axis?
Answer:
\(\frac{d y}{d x}\) = 3x²
Slope of the tangent = tan60°
i.e. 3x² = \(\sqrt{3}\)

Question 4.
Find the equation of the tangent to the parabola y² = 4x + 5 which is parallel to y = 2x + 7.
Answer:
y² = 4x + 5 _____(1)
2y \(\frac{d y}{d x}\) = 4
\(\frac{d y}{d x}\) = \(\frac{4}{2y}\) = \(\frac{2}{y}\)
Given tangent is parallel to y = 2x + 7
ie. Slope of the tangent is 2 ⇒ \(\frac{2}{y}\) = 2 ⇒ y = 1
∴ from (1) ⇒ 1 = 4x+ 5 ⇒ 4x = -4 ⇒ x = -1
So the point of contact is (-1, 1).
∴ Equation of tangent is
y -1 = 2(x + 1) ⇒ y = 2x + 3.

Question 5.
Find the intervals in which the function f given f(x) = 2x² – 3x is

1. Strictly increasing.
2. Strictly decreasing.

Answer:
Given; f(x) = 2x² – 3x ⇒ f'(x) = 4x – 3
For turning points; f'(x) = 0
⇒ 4x – 3 = 0 ⇒ x = \(\frac{3}{4}\)
The intervals are \(\left(-\infty, \frac{3}{4}\right),\left(\frac{3}{4}, \infty\right)\)
f'(0) = – 3 < 0
∴ Strictly decreasing in \(\left(-\infty, \frac{3}{4}\right)\)
f'(1) = 1 > 0
∴ Strictly increasing in \(\left(\frac{3}{4}, \infty\right)\).

Question 6.
Find the intervals in which the function f(x) = (x + 1)³ (x – 3)³ strictly increasing or decreasing.
Answer:
Given; f(x) = (x + 1)³ (x – 3)³
⇒ f'(x) = (x + 1)³ 3(x – 3)² + (x – 3)³3(x + 1)²
= 3(x + 1)²(x – 3)²(x + 1 + x – 3)
= 3(x + 1)²(x – 3)²(2x – 2)
= 6(x +1)² (x – 3)² (x -1)
⇒ 6(x +1)² (x – 3)² (x – 1) = 0
⇒ x = -1, 1, 3
The intervals are
(-∞, -1), (-1, 1), (1, 3), (3, ∞)
f'(-2) = (-2 – 1) < 0
∴ Strictly decreasing in (-∞, -1)
f'(0) = (0 – 1) < 0
∴ Strictly decreasing in (-1, 1)
f'(2) = (2 – 1) > 0
∴ Strictly increasing in (1, 3)
f'(4) = (4 – 1) > 0
∴ Strictly increasing in (3, ∞).

Question 7.
Find the intervals in which the function f(x) = x + \(\frac{1}{x}\) strictly increasing or decreasing.
Answer:

⇒ x = ±1
The intervals are (-∞, -1), (-1, 1), (1, ∞)
f'(-2) > 0
∴ Strictly increasing in (-∞, -1)
f'(0) < 0
∴ Strictly decreasing in (-1, 1)
f'(2) > 0
∴ Strictly increasing in (1, ∞).

Question 8.
Determine whether the f(x) = x² function is strictly monotonic on the indicated interval.

1. (-1, 1)
2. (-1, 0)
3. (0, 1)

Answer:
f(x) = x²
⇒ f'(x) = 2x
⇒ f'(x) = 0 ⇒ 2x = 0 ⇒ x = 0
This turning point divides the domain into the intervals (-∞, 0); (0, ∞).

1. Interval (-1,1) f'(x) < 0 and f'(x) > 0. So f(x) is not monotonic.
2. Interval (-1,0), f'(x) < 0. ∴ f(x) is strictly monotonic.
3. Interval (0, 1) f'(x) > 0 and f(x) is strictly monotonic.

Question 9.
Determine whether the f(x) = x³ – x function is strictly monotonic on the indicated interval.

1. (-1, 0)
2. (-1, -1/2)
3. (-1, 1)

Answer:
(x) = x³ -x ⇒ f'(x) = 3x² – 1
⇒ f'(x) = 0 ⇒ 3x² – 1 = 0 ⇒ x = ±\(\frac{1}{\sqrt{3}}\)
This turning point divides the domain into the intervals (-∞, \(\frac{1}{\sqrt{3}}\)); (-\(\frac{1}{\sqrt{3}}\), \(\frac{1}{\sqrt{3}}\)); (\(\frac{1}{\sqrt{3}}\), ∞).

1. Interval (-1, 0), f'(x) changes sign. So not monotonic.
2. Interval (-1, -1/2), f'(x) > 0 strictly monotonic.
3. lnterval(-1, 1) not monotonic

Question 10.
Find the approximate change in the volume V of a cube of side x meters caused by increasing the side by 1%.
Answer:
We have; V = x³ and ∆x = 1% of x= 0.01x
dV = \(\frac{d V}{d x}\) ∆x = 3x²∆x
= 3x² × 0.01x = 0.03x³ = 0.03V
⇒ \(\frac{d V}{V}\) = 0.03
Therefore 3% is the approximate increase in volume.

Question 11.
If the radius of a sphere is measured as 7m with an error of 0.02m then find the approximate error in calculating its volume.
Answer:
Let r be the radius of the sphere and ∆r be the error in measuring the radius then r =7m and ∆r = 0.02 m
We have; V = \(\frac{4}{3}\) πr³
dV = \(\frac{d V}{dr}\) ∆r = \(\frac{4}{3}\) π3r² × ∆r
= 4π(7)² × 0.02 = 3.92 π m³.

Question 12.
The length of a rectangle is decreasing at the rate of 5 cm/min and the width is increasing at the rate of 4cm/min. When length is 8 cm and width is 6 cm, find the rate of change of its area.
Answer:
Let length = x and width = y

Question 13.
Find the equation of tangents and normals to the given curves y= x⁴ – 6x³ + 13x² – 10x + 5 at (0, 5)
Answer:
Given; y = x⁴ – 6x³ + 13x² – 10x + 5 at (0, 5)
⇒ \(\frac{d y}{d x}\) = 4x³ – 18x² + 26x – 10
Slope = \(\left(\frac{d y}{d x}\right)_{x=0}\) = -10
Equation of tangent at (0, 5) is;
y – 5 =(-10)(x – 0)
⇒ y – 5 = -10x ⇒ 10x + y – 5 = 0
Equation of normal at (0, 5) is;
y – 5 = \(\frac{1}{10}\)(x – 0)
⇒ 10y – 50 = x ⇒ x – 10y + 50 = 0.

Question 14.
Find the equation of tangents and normals to the given curves y = x³ at (1, 1)
Answer:
Given; y = x³
⇒ \(\frac{d y}{d x}\) = 3x²
Slope = \(\left(\frac{d y}{d x}\right)_{x=1}\) = 3
Equation of tangent at (1, 1) is; y -1 = (3)(x – 1)
⇒ y – 1 = 3x – 3 ⇒ 3x – y – 2 = 0
Equation of normal at (1, 1) is;
y – 1 = \(-\frac{1}{3}\)(x – 1)
⇒ 3y – 3 = -x + 1 ⇒ x+ 3y – 4 = 0.

Question 15.
The volume of a cube is increasing at the rate of 8cm³/s. How fast is the surface area increasing when the length of an edge is 12cm.
Answer:
Let V be the volume of the cube of side x.
We have volume = V = x³
Rate of change of volume with respect to time ‘t’ is;
ie; differentiating w.r.t t; \(\frac{d V}{d t}\) = 3x²\(\frac{d x}{d t}\)
Given; \(\frac{d V}{d t}\) = 8 and x = 12 ⇒ 8 = 3(12)²\(\frac{d x}{d t}\)

Now let Surface area = S = 6x²
Differentiating w.r.t t;

Question 16.
Find the intervals in which the function f(x) = -2x³ – 9x² – 12x + 1 strictly increasing or decreasing.
Answer:
Given; f(x) = -2x³ – 9x² – 12x + 1
⇒ f'(x) = -6x² – 18x – 12
= – 6(x² + 3x + 2)
= – 6(x + 2)(x +1)
⇒ f'(x) = 0 ⇒ -6(x + 2)(x +1) = 0
⇒ x = -2, -1
The intervals are (-∞, -2),(- 2, -1),(-1, ∞)
f'(-3) = -(-3 + 2)(-3 + 1) < 0
∴ Strictly decreasing in (-∞, -2)
f'(-1.5) = -(-1.5 + 2)(-1.5 + 1) > 0
∴ Strictly increasing in (- 2, -1)
f'(0) = -(0 + 2)(0 + 1) < 0
Strictly decreasing 1n(-1, ∞).

Question 17.
Find the local maxima and minima of the following functions. Also find the local maximum and minimum values. (each question carry 3 score)

1. f(x) = sin x + cosx, 0 < x < \(\frac{\pi}{2}\)
2. f(x) = x³ – 3x
3. f(x) = x³ – 6x² + 9x + 15
4. g(x) = \(\frac{x}{2}\) + \(\frac{2}{x}\), x > 0
5. g(x) = \(\frac{1}{x^{2}+2}\)

Answer:
1. Given; f(x) = sinx + cosx
⇒ f'(x) = cosx – sinx
For turning point f'(x) = 0
⇒ cosx – sinx = 0
⇒ cosx = sinx
⇒ x = \(\frac{\pi}{4}\)
f”(x) = -sin x – cosx
⇒ f (\(\frac{\pi}{4}\)) = -sin\(\frac{\pi}{4}\) – cos\(\frac{\pi}{4}\) < 0
Hence f(x) has a local maximum at x = \(\frac{\pi}{4}\) and local maximum value is

2. Given; f(x) = x³ – 3x
⇒ f'(x) = 3x² – 3
For turning point f'(x) = 0
⇒ 3x² – 3 = 0
⇒ x = ±1
f”(x) = 6x
When x = -1
⇒ f”(-1) = -6 < 0
Hence f(x) has a local maximum at x = -1 and local maximum value is
f(-1) = (-1)³ – 3(-1) = -1 + 3 = 2
When x = 1
⇒ f”(1) = 6 > 0
Hence f(x) has a local minimum at x = 1 and local minimum value is
f(1) = (1)³ – 3(1) = 1 – 3 = -2.

3. Given; f(x) = x³ – 6x² + 9x + 15
⇒ f'(x) = 3x² – 12x + 9
For turning point f'(x) = 0
⇒ 3x² – 12x + 9 = 0 ⇒ 3(x² – 4x + 3) = 0
⇒ 3(x – 1)(x – 3) = 0 ⇒ x = 1, 3
f”(x) = 6x – 12
When x = 1
⇒ f”( 1) = 6 – 12 < 0
Hence f(x) has a local maximum at x = 1 and local maximum value is
f(1) = (1)³ – 6(1)² + 9(1) + 15 = 19
When x = 3
⇒ f”(3) = 6(3) – 12 > 0
Hence f(x) has a local minimum at x = 3 and local minimum value is
f(3) = (3)³ – 6(3)² + 9(3) + 15 = 15.

4. Given; g(x) = \(\frac{x}{2}\) + \(\frac{2}{x}\)
⇒ g'(x) = \(\frac{1}{2}\) – \(\frac{2}{x^{2}}\)
For turning point g'(x) = 0

Since x > 0, the acceptable value of x = 2

Hence g(x) has a local maximum at x = 2 and local maximum value is g(2) = \(\frac{2}{2}\) + \(\frac{2}{2}\) = 2

5. Given; g(x) = \(\frac{1}{x^{2}+2}\)

For turning point g'(x) = 0


Hence g(x) has a local maximum at x = 2 and maximum value is g(2) = \(\frac{1}{0+2}=\frac{1}{2}\).

Question 18.
Find the absolute maximum value and minimum value of the following functions.

1. f(x) = x³, x ∈ [-2, 2]
2. f(x) = 4x – \(\frac{x^{2}}{2}\), x ∈ \(\left[-2, \frac{9}{2}\right]\)

Answer:
1. Given; f(x) = x³ ⇒ f'(x) = 3x²
For turning point f'(x) = 0 ⇒ 3x² = 0 ⇒ x = 0
f(- 2) = (-2 )³ = -8
f( 2) = (2)³ = 8
f(0) = (0)³ = 0
Absolute maximum = max{-8, 8, 0} = 8
Absolute minimum = min {-8, 8, 0} = – 8

2. Given; f(x) = 4x – \(\frac{x^{2}}{2}\) ⇒ f'(x) = 4 – x
For turning point f'(x) = 0 ⇒ 4 – x = 0
⇒ x = 4

Absolute maximum = max{-10, 8, 7.875} = 8
Absolute minimum = min {-10, 8, 7.87} = -10.

Question 19.
A television camera at ground level is filming the lift-off of a space shuttle that is rising vertically according to position equation S = 50t².
The camera is 2000 feet from the launch pad. Find the rate of change in the angle of elevation of the camera 10 seconds after lift-off.
Answer:

Question 20.
Determine whether the f(x) = sinx function is strictly monotonic on the indicated interval.

1. (0, 2π)
2. (0, π)
3. (-π/2, π/2)

Answer:
f(x) = sinx ⇒ f'(x) = cosx changes sign.

1. Interval (0, 2π). ∴ f(x) is not monotonic.
2. f'(x) changes sign in (0, π) not monotonic.
3. f'(x) > 0 in (-π/2, π/2), ie. f(x) is strictly monotonic.

Question 21.
Find the approximate change in the Surface Area of a cube of side x meters caused by decreasing the side by 1%.
Answer:
We have;
S = 6x² and ∆x = 1% of x = -0.01x
dS = \(\frac{d S}{d x}\) ∆x = 6 × 2x × ∆x
= 6 × 2x × -0.01x = -0.02 × 6x² = -0.02S
⇒ \(\frac{d S}{S}\) = -0.02
Therefore 2% is the approximate decrease in surface area.

Plus Two Maths Application of Derivatives Four Mark Questions and Answers

Question 1.
The length ‘x’ of a rectangle is decreasing at the rate of 2 cm/s and the width ‘y’ is increasing at the rate of 2 cm/s.

1. Find the rate of change of Perimeter.
2. Find \(\frac{d A}{dt}\) when x = 12 cm and y = 5 cm.

Answer:
Since the length ‘x’ is decreasing and the width ‘y’ is increasing, we have \(\frac{d x}{dt}\) = -2 cm/s and \(\frac{d y}{dt}\)
= 2 cm/sec.
1. The Perimeter ‘P’ of the rectangle is given by
P = 2 (x + y)

2. The area ‘A’ of the rectangle ‘A’ is given by
A = x.y

= 12(2) + 5(-2)
= 24 – 10 = 14 cm2/s.

Question 2.
Find the equation of all lines having slope -1. Which are tangents to the curve?
y = \(\frac{1}{x-1}\), x ≠ 1
Answer:

⇒ x² – 2x = 0 ⇒ x(x – 2) = 0 ⇒ x = 0, x = 2
At x = 0, y = -1
Equation of tangent at (0, -1) is;
At x = 2, y = \(\frac{1}{2-1}\) = 1
Equation of tangent at (2, 1) is; y – 1 = -1(x – 2)
⇒ y – 1 = -x + 2 ⇒ x + y – 3 = 0.

Question 3.
Find the points on the curve x² + y² – 2x – 3 = 0 at which the tangent are parallel to x-axis.
Answer:
Given; x² + y² – 2x – 3 = 0
Differentiating with respect to x;

Since the tangent is parallel to x-axis \(\frac{d y}{d x}\) = 0
\(\frac{1-x}{y}\) = 0 ⇒ x = 1
We have; (1)² + y² – 2(1) – 3 = 0
⇒ y² = 4 ⇒ y = ±2
Hence the points are (1, 2), (1, -2).

Question 4.
Find the equation of the tangent to the curve y = \(\sqrt{3 x-2}\) which is parallel to the line 4x – 2y + 5 = 0.
Answer:
Slope of the line 4x – 2y + 5 = 0 is 2.

acceptable since y is positive.
Hence the point is \(\left(\frac{41}{48}, \frac{3}{4}\right)\)
Equation of tangent is;


⇒ 6(4y – 3) = (48x – 41)
⇒ 24y – 18 = 48x – 41
⇒ 48x – 24y – 23 = 0.

Question 5.
Prove that the curve x = y² and xy = k cut at right angles, if 8k² = 1.
Answer:
x = y² ___(1)
⇒ 1 = 2y \(\frac{d y}{d x}\) ⇒ \(\frac{d y}{d x}\) = \(\frac{1}{2y}\)
xy = 2k ___(2)
⇒ x \(\frac{d y}{d x}\) + y.1 = 0 ⇒ \(\frac{d y}{d x}\) = \(-\frac{y}{x}\)
The product of the slopes will be – 1.

Question 6.
The gradient at any point (x, y) of a curve is 3x² – 12 and the curve through the point (2, -7).

1. Find the equation of the tangent at the point ( 2, -7 ). (2)
2. Find the equation to the curve. (2)

Answer:
1. Given gradient as 3x² – 12 ⇒ \(\frac{d y}{d x}\) = 3x² – 12
Slope at (2, -7) is given by
\(\left(\frac{d y}{d x}\right)_{x=2}\) = 3(2)² – 12 = 0
Since slope is zero, the tangent is parallel to x – axis.
Here y = – 7 is the equation of the tangent at (2, -7).

2. Given, \(\frac{d y}{d x}\) = 3x² – 12
⇒ ∫dy = ∫(3x² – 12 )dx
y = 3\(\frac{x^{3}}{3}\) – 12x + c ⇒ y = x³ – 12x + c ____(1)
Given (2, -7) is a point on the curve.
(1) ⇒ -7 = (2)³ – 12(2) + c ⇒ -7 = 8 – 24 + c ⇒ c = 9
∴ Curve is y = x³ – 12x + 9.

Question 7.
Consider the curve x^2/3 + y^2/3 = 2

1. Find the slope of the tangent to the curve at the point (1, 1). (2)
2. Find the equation of the normal at the point (1, 1). (2)

Answer:
1. Given, x^2/3 + y^2/3 = 2,
Differentiating w.r.t. x,

⇒ slope of tangent = – 1.

2. Slope of normal = \(-\frac{1}{-1}\) = 1.
Equation of the normal is
y – 1 = 1(x – 1) ⇒ y – x = 0.

Question 8.
Find the intervals in which the function f given by f(x) = 2x³ – 3x² – 36x + 7 is

1. Strictly increasing. (2)
2. Strictly decreasing. (2)

Answer:
Given; f(x) = 2x³ – 3x² – 36x + 7
⇒ f'(x) = 6x² – 6x – 36
f'(x) = 0 ⇒ 6x² – 6x – 36 = 0
⇒ 6(x² – x – 6) = 0
⇒ 6(x + 2)(x – 3) = 0 ⇒ x = -2, 3
The intervals are (-∞, -2),(- 2, 3), (3, ∞)
f'(-3) = 6(-3 + 2)(-3 – 3) > 0.
∴ Strictly increasing in (-∞, -2).
f'(0) = 6(2)(-3) < 0.
∴ Strictly decreasing in (- 2, 3).
f'(4) = 6(4 + 2)(4 – 3) > 0
∴ Strictly increasing in (3, ∞).

Question 9.
Use differentials to find the approximate value of \(\sqrt{0.6}\) up to 3 places of decimals.
Answer:
Take y = \(\sqrt{x}\), let x = 0.64 and ∆x = -0.04
Then; f(x) = y = \(\sqrt{x}\)
f(x + ∆x) = y + ∆y


(1) ⇒ \(\sqrt{0.6}\) = 0.8 – 0.025 = 0.775.

Question 10.
Use differentials to find the approximate value of (0.999)^{\(\frac{1}{10}\)} up to 3 places of decimals.
Answer:
Take = x^{\(\frac{1}{10}\)}, let x = 1 and ∆x = -0.001
Then; f(x) = y
f(x + ∆x) = y + ∆y
(0.999)^{\(\frac{1}{10}\)} = x^{\(\frac{1}{10}\)} + ∆y
(0.999)^{\(\frac{1}{10}\)} = (1)^{\(\frac{1}{10}\)} + ∆y
⇒ (0.999)^{\(\frac{1}{10}\)} = 1 + ∆y ______(1)

(1) ⇒ (0.999)^{\(\frac{1}{10}\)} = 1 – 0.0001 = 0.9999.

Question 11.
Use differentials to find the approximate value of (15)^{\(\frac{1}{4}\)} up to 3 places of decimals.
Answer:
Takey = x^{\(\frac{1}{4}\)}, let x = 16 and ∆x = -1
Then; f(x) = y
f(x + ∆x) = y + ∆y
(15)^{\(\frac{1}{4}\)} = x^{\(\frac{1}{4}\)} + ∆y
(15)^{\(\frac{1}{4}\)} = 16^{\(\frac{1}{4}\)} + ∆y
(15)^{\(\frac{1}{4}\)} = 2 + ∆y ____(1)
⇒ ∆y ≈ dy = \(\frac{d y}{d x}\) ∆x

Question 12.
Use differentials to find the approximate value of (26.57)^{\(\frac{1}{3}\)} up to 3 places of decimals.
Answer:
Take y = x^{\(\frac{1}{3}\)}, let x = 27 and ∆x = -0.43
Then; f(x) = y
f(x + ∆x) = y + ∆y
f(x + ∆x) = f(x) + ∆y
(26.57)^{\(\frac{1}{3}\)} = 27^{\(\frac{1}{3}\)} + ∆y .
⇒ (26.57)^{\(\frac{1}{3}\)} = 3 + ∆y ____(1)

(1) ⇒ (26.57)^{\(\frac{1}{3}\)} = 3 – 0.016 = 2.984.

Question 13.
Find the approximate value of f(5.001) where f(x) = x³ – 7x² + 15
Answer:
Let x = 5 and ∆x = 0.001
Then; f(x) = y
f(x + ∆x) = y + ∆y
f (5.001) = f(x) + ∆y
f(5.001) = f(5) + ∆y
f(5.001) = 5³ – 7(5)² + 15 + ∆y
⇒ f(5.001) = -35 + ∆y …
⇒ ∆y ≈ dy = \(\frac{d y}{d x}\) ∆x ⇒ dy = (3x² – 14x) × 0.001
= (3(5)² – 14(5)) × 0.001 = (75-70)0.001 = 0.005
(1) ⇒ f(5.001) = -35 + 0.005 = -34.995.

Question 14.
Find the approximate value of f(3.02) where f(x) = 3x² + 5x + 3
Answer:
Let x = 3 and ∆x = 0.02
Then; f(x) = y
f(x + ∆x) = y + ∆y
f(3.02) = f(x) + ∆y
f(3.02) = f(3) + ∆y
f(3.02) = 3(3)² + 5(2) + 3 + ∆y
⇒ f(3.02) = 45 + ∆y ____(1)
⇒ ∆y ≈ dy = \(\frac{d y}{d x}\) ∆x ⇒ dy = (6x + 5) × 0.02
= (6(3) + 5) × 0.02 = (18 + 5)0.02 = 0.46
(1) ⇒ f(3.02) = 45 + 0.46 = 45.46.

Question 15.
Consider the function y = f\(\sqrt{x}\)

1. If x = 0.0036 and ∆x = 0.0001 find ∆y. (3)
2. Hence approximate \(\sqrt{.0037}\) using differentials. (1)

Answer:
1. Let x = .0036, ∆x = 0.0001

2. (1) ⇒ \(\sqrt{.0037}\) = .000833 + .06 = .060833.

Question 16.
Find the approximate value of \(\sqrt[3]{124}\).
Answer:
f(x) = \(\sqrt[3]{x}\) = x^1/3 ⇒ f¹(x) = 1/3x^-2/3 = \(\frac{1}{3 x^{2 / 3}}\)
Let x = 125, ∆x = -1
Then; f(x) = y

Question 17.
Find two numbers x and y such that their sum is 35 and the product is x² y⁵ a maximum.
Answer:
Given; x + y = 35 ⇒ y = 35 – x
P = x² y⁵ ⇒ P = x²(35 – x)⁵
⇒ p’ = 2x(3 5 – x)⁵ + x² 5(35 – x)⁴(-1)
⇒ P’ = x(35 – x)⁴[2(35- x) – 5x]
⇒ p’ = x(35 – x)⁴[70 – 7x]
⇒ p’ = 7x(35 – x)⁴[10 – x]
⇒ p” = 7[x(3 5 – x)⁴ [-1] + x(10 – x)4(35 – x)³ (-1) + (35 – x)⁴(10 – x)]
For turning points P’ = 0
⇒ 7x(35 – x)⁴[10 – x] = 0
⇒ x = 0, 35, 10
x = 0, 35 can be rejected since correspondingly y will be y = 35, 0
⇒ P” = 7[10(35 – 10)⁴[-1]] < 0
Therefore maximum at x = 10
Thus the numbers are 10 and 35 – 10= 10.

Question 18.
Using differentials, find the approximate value of (63)^1/3.
Answer:
Take y = x^{\(\frac{1}{3}\)}, let x = 64 and ∆x = 1
Then; f(x) = y
f(x + ∆x) = y + ∆y

Question 19.

1. Find the point on the curve y = x³ – 10x + 8 at which the tangent is parallel to the line y = 2x + 1. (2)
2. Is the given line tangent to the curve? Why?

Answer:
1. \(\frac{d y}{d x}\) = 3x² – 10
Slope of the line y = 2x +1 is 2
⇒ 3x² – 10 = 2 ⇒ 3x² = 12 ⇒ x = ±2
When x = 2
y = 2³ – 10 × 2 + 8 = 8 – 20 + 8 = -4
When x = – 2
y = (-2)³ -10 × (-2) + 8 = -8 + 20 + 8 = 20
Therefore the points are (2, -4); (-2, 20)

2. No. Since (2, -4); (-2, 20) does not satisfies the equation y = 2x +1.

Question 20.
Suppose that a spherical balloon is inflated and it has volume ‘v’ and radius ‘r’ at time ‘t’.

1. If the balloon is inflated by pumping 900c.c. of gas per second. Find the rate a which the radius of the balloon is increasing when the radius is 15 cm. (2)
2. Find the rate of change of its surface at the instant when it radius is 15 cm. (2)

Answer:
1. Let V be the volume of the sphere of radius r.
V = \(\frac{4}{3}\) πr³, given; \(\frac{d V}{d t}\) = 900, r = 15
Differentiating w.r.t t,

2. Let ‘s’ denote the surface area of the balloon, then
S = 4πr²
Differentiating, \(\frac{d s}{d t}\) = 4π.2r.\(\frac{d r}{d t}\) =8.π r .\(\frac{d r}{d t}\)
= 8π × 15 × \(\frac{1}{\pi}\) = 120 cm²/sec.

Question 21.
Use differentials to find the approximate value of (0.009)^{\(\frac{1}{3}\)} up to 3 places of decimals.
Answer:
Take y = x^{\(\frac{1}{3}\)}, let x = 0.008 and ∆x = 0.001
Then; F(x) = Y
f(x + ∆x) = y + ∆y

Question 22.
Find the approximate value of \(\sqrt{401}\).
Answer:
f(x) = \(\sqrt{x}\) = x^1/2
f'(x) = \(\frac{1}{2 \sqrt{x}}\)
Let x = 400 ∆x = 1
f(x) = y = \(\sqrt{x}\)
f(x + ∆x) = y + ∆y

Question 23.
Consider y = \(\frac{\log x}{x}\), in (0, ∞)

1. Find the value of x at which \(\frac{d y}{d x}\) = 0 (2)
2. Find the maximum value.

Answer:
1.

2.

∴ y is maximum when x = e.
The maximum value is \(\frac{1}{e}\).

Question 24.
Find the point on the curve y = x³ – 11x + 5 at which the tangent is y = x – 11.
Answer:
Slope of the line y = x – 11 is 1.
Given; y = x³ – 11x + 5 ⇒ \(\frac{d y}{d x}\) = 3x² – 11 = 1
⇒ 3x² = 12 ⇒ x = ±2
At x = 2, ⇒ y = x – 11 = 2- 11 = -9
⇒ (2, -9)
At x = -2, ⇒ y = x – 11 = -2 – 11 = -13
⇒ (-2, -13)
But the point (-2, -13) do not lie on the curve, hence the point is (2, -9).

Question 25.
Consider the curve y = x² – 2x + 7

1. Find the slope of the tangent of the curve at x = 2. (2)
2. Write down the equation of the tangent at x =2. (2)

Answer:
1. Given, y = x² – 2x + 7 ⇒ y’ = 2x – 2
(y’)_x=2 = 2(2) – 2 = 2.

2. At x = 2 , y = 2² – 2(2) + 7 = 7.
Equation of the tangent at (2, 7) is
y – 7 = 2(x – 2) ⇒ 2x – y + 3 = 0.

Question 26.
Find the absolute maximum value and minimum value of the following functions.

1. f(x) = 2x³ – 15x² + 36x + 1, x ∈ [1, 5]
2. f(x) = 12x^{\(\frac{4}{3}\)} – 6x^{\(\frac{1}{3}\)}, x ∈ [-1, 1]

Answer:
1. Given; f(x) = 2x³ – 15x² + 36x + 1, x ∈ [1, 5]
⇒ f'(x) = 6x² – 30x + 36
For turning point f'(x) = 0 ⇒ 6x² – 30x + 36 = 0
⇒ x² – 5x + 6 = 0 ⇒ (x -3)(x – 2) = 0
⇒ x = 3, 2
f(1) = 2(1)³ – 15(1)² + 36(1) + 1 = 24
f(2) = 2(2)³ – 15(2)² + 36(2) + 1 = 29
f(3) = 2(3)³ – 15(3)² + 36(3) + 1 = 28
f(5) = 2(5)³ – 15(5)² + 36(5) + 1 = 56
Absolute maximum = max {24, 29, 28, 56} = 56
Absolute minimum = min {24, 29, 28, 56} = 24

2. Given;

f'(x) = 0 at x = \(\frac{1}{8}\) and f'(x) is not defined at x = 0. Therefore;

Absolute maximum = max {18, 0, 6, \(-\frac{9}{4}\)} = 18
Absolute minimum = min {18, 0, 6, \(-\frac{9}{4}\)} = \(-\frac{9}{4}\).

Question 27.
Consider the function y = x³ – 6x² + 3x – 1

1. Find the slope at x= -1. (1)
2. Find the minimum gradient of the above curve. (3)

Answer:
1. Given,
y = x³ – 6x² + 3x – 1 ⇒ y’ = 3x² – 12x + 3
Gradient at (x = -1) = (y’)_x=1 = 3(-1)² – 12(-1) + 3 = 18.

2. Now for minimum gradient we have to apply maxima – minima condition to the function y’ .ie, y” = 6x – 12 , for turning points of y’ is given by y” = 0.
Therefore, 6x – 12 = 0 ⇒ x = 2
Now, y”’ = 6 > 0
∴ y’ is maximum at x = 2.
Minimum gradient at (x = 2) is
= 12 – 24 + 3 = – 9.

Plus Two Maths Application of Derivatives Six Mark Questions and Answers

Question 1.
A curve passes through the origin, and its gradient function is 2x – \(\frac{x^{2}}{2}\)

1. Find its y coordinate when x= 2. (4)
2. Find the equation of the tangent at x= 2. (2)

Answer:
Given;

Integrating we have; ∫dy = ∫(2x – \(\frac{x^{2}}{2}\))dx
⇒ y = x² – \(\frac{x^{3}}{6}\) + c ___(1)
Since the curve passes through (0, 0)
(1) ⇒ 0 = 0 + c ⇒ c = 0
∴ Equation of the curve is y = x² – \(\frac{x^{3}}{6}\)
When x = 2 ⇒ y = 2² – \(\frac{2^{3}}{6}\) = \(\frac{8}{3}\)
∴ coordinate is (2, \(\frac{8}{3}\)).

2. Slope at (2, \(\frac{8}{3}\)) = 2 × 2 – \(\frac{2^{2}}{2}\) = 2
∴ Equation of the tangent at (2, \(\frac{8}{3}\)) is given by
y – \(\frac{8}{3}\) = 2(x – 2) ⇒ 3y – 8 = 6x – 12 ⇒ 3y = 6x – 4.

Question 2.
(i) Choose the correct answer from the bracket. The slope of the tangent to the curve y = x³ – 2x + 3 at x = 1 is ____(1)
(a) 0
(b) 1
(c) 2
(d) 3
(ii) Find points on the curve \(\frac{x^{2}}{25}+\frac{y^{2}}{9}\) = 1 at which the tangents are (2)
(a) Parallel to x-axis
(b) parallel to y – axis.
(iii) Use differential to approximate \(\sqrt{25.6}\). (3)
Answer:
(i) (b) 1, Since

(ii)

(a) \(\frac{d y}{d x}\) = 0, since tangents are parallel to x- axis.
\(\frac{-9x}{25}\) = 0, x = 0 ∴ y = ± 3;
The points are (0, 3) and (0, -3)

(b) \(\frac{-25 y}{9 x}\) = 0, since tangents are parallel to y-axis, slope of normal = 0; y = o
∴ x = ± 5
The points are (5, 0) and (-5, 0)

(iii) Take y = \(\sqrt{x}\) , let x = 25 and ∆x = 0.6
Then; f(x) = y = \(\sqrt{x}\)
f(x + ∆x) = y + ∆y

Question 3.
Let x and y be the length and breadth of the rectangle ABCD in a circle having radius r. Let ∠CAB = θ (Ref. figure). If ∆ represent area of the rectangle and r is a constant.

1. Write ∆ in terms of r and θ. (2)
2. Find \(\frac{d \Delta}{d \theta}\) and \(\frac{d^{2} \Delta}{d \theta^{2}}\). (1)
3. Hence find the maximum value of ∆. (2)
4. Show that the rectangle of maximum area that can be inscribed in a circle of radius r is a square of side \(\sqrt{2} r\). (1)

Answer:
1. Area of the rectangle is ∆ = xy
From the figure y = 2r sinθ, x = 2r cosθ
∆ = xy = 4r²sinθcosθ = 2r²sin2θ

2. \(\frac{d \Delta}{d \theta}\) = 4r² cos2θ ⇒ \(\frac{d^{2} \Delta}{d \theta^{2}}\) = -8r²sin2θ

3. For turning points

Therefore local maximum at θ = \(\frac{\pi}{4}\)

4. Then;

Hence the rectangle becomes a square.

Question 4.
The second derivative of the equation of a curve is given by the equation x \(\frac{d^{2} y}{d x^{2}}\) = 1, given y = 1, \(\frac{d y}{d x}\) = 0 when x= 1.

1. Find the slope at x = e. (2)
2. Find the equation of the curve. (2)
3. Find the equation of the normal at x= e. (2)

Answer:
1. Given;

Integrating we get,

∴ Slope of the curve at x = e is given by
\(\left(\frac{d y}{d x}\right)_{x=e}\) = loge = 1.

2. We have,
\(\frac{d y}{d x}\) = logx, ⇒ dy = logxdx
Integrating we get,
∫dy = ∫logx dx ⇒ y = logx.x – ∫\(\frac{1}{x}\).x dx + c₂
⇒ y = xlogx – x + c₂ ____(2)
Given; y = 1 when x = 1
(2) ⇒ 1 = 1log1 – 1 + c₂ ⇒ 1 = 0 – 1 + c₂ ⇒ c₂ = 2
Therefore the equation of the curve is
y = xlogx – x + 2

3. We have, y = xlogx – x + 2
When x = e
⇒ y = e log e – e + 2 ⇒ y = e – e + 2 = 2
So we have to find the slope at (e, 2),
We know; \(\left(\frac{d y}{d x}\right)_{x=e}\) = log e = 1
∴ Slope of the normal at (e, 2)= -1
∴ Equation of the normal at (e, 2) is.
y – 2 = (-1) (x – e)
y – 2 = – x + e ⇒ y + x = e + 2.

Question 5.
The given figure represents a cylinder Inscribed in a sphere.

1. Find an expression for the volume V of the cylinder. (2)
2. Find the height of the cylinder when its volume V is maximum. (2)
3. Find the volume and radius of the largest cylinder. (2)

Answer:
1. From the right triangle ∆OAB,
y² = R² – x² ⇒ y = \(\sqrt{R^{2}-x^{2}}\)
Which is the radius of the cylinder
Also height = 2 x
∴ Volume = V= π y² × 2x = 2π(R² – x²)x = 2π(R²x – x³).

2. Now,

For maximum or minimum,

3. Base radius =

Question 6.
If f(x) = x³ + 3x² – 9x + 4 is a real function

1. Find the intervals in which the function is increasing or decreasing. (3)
2. Find the points of local maxima or local minima of f(x) (2)
3. Graph of a function is given in the following figure:

Which among the following represents the graph of its derivative? (1)

Answer:
1. f'(x) = 3x² + 6x – 9
For turning points f'(x) = 3x² + 6x – 9 = 0
⇒ x = 1, -3
These turning point divide the domain of f(x) in the following intervals. (-∞, -3), (-3, 1), (1, ∞) in (-∞, -3)
⇒ f'(-4) = 3(-4)² + 6(-4) – 9 > 0
Hence increasing.
In (-3, 1) ⇒ f'(0) = 3(0)² + 6(0) – 9 < 0
Hence decreasing.
In (1, ∞) ⇒ f'(2) = 3(2)² + 6(2) – 9 > 0
Hence increasing.

2. x = -3 is a local maximum point and x = 1 is a local minimum point.

3. (a)

The function passes through origin and has a local maximum at x = 2.

Question 7.
Of all the Cylinders with given surface area, show that the volume is maximum when height is equal to the diameter of the base.
Answer:
Let r be the radius, h be the height, V be the volume and S be the surface area
S = 2πr² + 2 πrh

S – 6πr² = 0
2πr² + 2πrh – 6πr² = 0
So h = 2r
So volume is maximum when h = 2r.

Question 8.
Sand is pouring from a pipe. The falling sand forms a Cone on the ground in such a way that the height of the Cone is always one-sixth of the radius of the base.

1. Establish a relation between the volume ‘v’ and height ‘h’ of the Cone using the given condition. (2)
2. lf the sand is pouring at the rate of -12 cm/sec, Find the rate of change of height of the Cone. (2)
3. Find \(\frac{\mathrm{dh}}{\mathrm{dt}}\) when h = 4cm. (2)

Answer:
1. Given that the height of the Cone is one-sixth of the radius of the base, then h = \(\frac{r}{6}\) ⇒ r = 6h
Then Volume V = \(\frac{1}{3}\) πr²h = \(\frac{1}{3}\) π(6h)2.h
V = \(\frac{1}{3}\) π 36h².h = \(\frac{1}{3}\) π 36h³
V =12 πh³ ____(1)

2. Differentiating (1) we get

3. When h = 4 cm

Question 9.
(i) Choose the correct answer from the bracket. The rate of change of the area of a circle with respect to its radius r at r = 10cm is.
(a) 10π
(b) 20π
(c) 30π
(d) 40π (1)
(ii) Find the intervals in which the function f given by f(x) = x² – 6x + 5 is (2)
(a) Strictly increasing
(b) Strictly decreasing
(iii) Find the local minimum and local maximum value, if any, of the function f(x) = x³ – 6x² + 9x + 8 (3)
Answer:

(ii) f'(x) = 2x — 6; 2x – 6 = 0; x = 3
(-∞, 3 ) is strictly decreasing
(3, ∞) is strictly increasing.

(iii) f'(x) = 3x² – 12x + 9
f¹¹ = 6x — 12
For maxima, minima
f¹ = 0 → 3x² – 12x + 9 = 0
3(x – 3)(x — 1) = 0; x = 3, x = 1
At x = 3 f¹¹(x) = 6 × 3 – 12 = 18 – 12 = 6 > 0
f is minimum, the local minimum value of f = 8
At x = 1 f¹¹(x) = 6 × 1 – 12 = -6 < 0,
f is maximum, the local maximum value of f = 12.

Question 10.
A wire of length 28m is cut into two pieces. One of the pieces is be made into a square and the other into a circle. What should be the length of the two pieces so that combined area of the square and the circle is minimum using differentiation?
Answer:
Let the length of one piece be ‘x’ and other piece be ‘28 – x’. Let from the first piece we will make a circle of radius Y and from the second piece we will make a square of side y. Then,

Let A be the combined area of the circle and square, then

Question 11.
An open box of maximum volume is to be made from a square piece of tin sheet 24cm on a side by cutting equal squares from the corners and turning of the sides.
(i) Complete the following table. (2)

(ii) Using the above table, express V as a function of x and determine its domain. (1)
(iii) Find height (x. cm) of the box when volume V is maximum by differentiation. (3)
Answer:
(i)

(ii) Generalise the above table as a function.
V = x(24-2x)², 0 < x < 12.

(iii) \(\frac{d V}{d x}\) = x.2(24 – 2x)(-2) + (24 – 2x)²
= -4x(24 – 2x) + (24 – 2x)²
= -96x + 8x² + 576 + 4x² – 96x
= 12x² – 192x + 576
For maximum or minimum,

Therefore volume is maximum when x = 4 cm.

Question 12.
A square tank of capacity 250 m³ has to be dug out. The cost of land is Rs. 50 per m². The cost of digging increases with the depth and for the whole tank is Rs. 400 × (depth)².

1. Find an expression for the cost of digging the tank. (3)
2. Find the dimension of the tank when the total cost is least. (3)

Answer:
1. Let x, x and y be the length, breadth, and depth of the tank.
Then, V = x. x. y = 250 ⇒ y = \(\frac{250}{x^{2}}\).
Area of land = x²
⇒ Cost of land = 50 x²
(∵ cost of land is Rs.50/m²)
Cost of digging = 400 × (depth)² = 400 × (y)²
∴ Total cost = C = 50 x² + 400 × (y)²

2. We have, C = 50x² + \(\frac{400 \times(250)^{2}}{x^{4}}\).
Differentiating w.r.t.x, we get,


∴ Maximum at x = 10
m ⇒ when x = 10m and
y = \(\frac{250}{10^{2}}\) = 2.5m the total cost is least.

Question 13.
Show that the right circular cone of least curved surface and given volume has an altitude equal to \(\sqrt{2}\) times the radius of the base.
Answer:
Volume of the cone will be, V =\(\frac{1}{3}\)πr²h
h = \(\frac{3 V}{\pi r^{2}}\) ____(1)
Curved surface area will be, S = πrl
⇒ S² = π²r²l² = P
⇒ P = π²r²(h² + r²) ⇒ P = π²r²h² + π²r⁴)

⇒ 2r² = h² ⇒ h = \(\sqrt{2} r\).

Question 14.
Let ABC be an isosceles triangle inscribed in a circle having radius r. Then by figure, area of the triangle ABC is ∆

1. Find \(\frac{d \Delta}{d \theta}\) and \(\frac{d^{2} \Delta}{d \theta^{2}}\) (2)
2. Find the maximum value of ∆. (3)
3. Show that the isosceles triangle of maximum area that can be in scribed in a given circle is an equilateral triangle. (1)

Answer:
1. Area of the isosceles triangle is ∆ = \(\frac{1}{2}\)bh
From the figure b = r sin2θ, h = r + r cos2θ

2. For turning points

Therefore local maximum a θ = \(\frac{\pi}{6}\) which means the area of the isosceles triangle is maximum When θ = \(\frac{\pi}{6}\).

3. Then; ∠OCB = 30° ⇒ ∠ACB = 2∠OCB = 60°. Therefore the isosceles triangle is an equilateral triangle.

Question 15.
(i) Using the graph of the function f (x) in the interval [ a, h ] match the following.

(ii) Consider the function f(x) = 3x⁴ – 8x³ + 12x² – 48x + 25
(a) Find the turning points of f(x). (1)
(b) Explain the nature of the turning points (1)
(c) Find the absolute extreme values of f(x). (2)
Answer:
(i)

(ii) (a) f(x) = 12x³ – 24x² + 24x – 48
For turning points,
f'(x) = 0 ⇒ 12x³ – 24x² + 24x – 48 = 0
⇒ x³ – 2x² + 2x – 4 = 0
⇒ (x² + 2)(x – 2) = 0 ⇒ x = ± (\(\sqrt{-2}\), 2)
We admit only x = 2 as x = \(\sqrt{-2}\) is not a real number.
Therefore at x = 2 f (x) has a turning point.

(b) f”(x) = 36x² – 48x + 24
⇒ f”(2) = 36(2)² – 48 × 2 + 24 > 0
Therefore at x = 2 f(x) has a local minimum.

(c) f(0) = 25,
f(2) = 3(2)⁴ – 8(2)³ + 12(2)² – 48 × 2 + 25 = -39
f(3) = 3(3)⁴ – 8(3)³ + 12(3)² – 48 × 3 + 25 = 16
Consider the set { f (0), f{2), f (3)}
⇒ {25, -39, 16}
The maximum value of the above set is the absolute maximum and it is 25 at x = 0. The minimum value of the above set is the absolute minimum and it is -39 at x = 2.

Question 16.
An open box with a square base is to be made out of a given quantity of sheet of area a².

1. If the box has side x units, then show that volume V= \(\frac{a^{2} x-x^{3}}{4}\) (2)
2. Show that the maximum volume is \(\frac{a^{3}}{6 \sqrt{3}}\) (4)

Answer:
1. Area = a² = x² + 4xh,
h = height of the box.

2. We have,

Question 17.
For the function f(x) = sin2x, 0 < x < π
(i) Find the point between 0 and π that satisfies f'(x) = 0. (2)
(ii) Find the point of local maxima and local minima. (2)
(iii) Find the local maximum and local minimum value. (2)
Answer:

Question 18.
A cylindrical can with a volume of 125m3 (about 2 litres) is to be made by cutting its top and bottom from metal squares and forming its curved side by bending a rectangular sheet of metal to match its ends. What radius ‘r’ and height ‘h’ of the can will minimize the amount of material required.
Answer:

The circular top and bottom should be cut out from a square metal sheet of side 2r. Therefore the area of squares is 8r².
Area A = 8r² + 2πrh

∴ To minimize the amount of material, r = 2.5
\(h=\frac{125}{\pi(2.5)^{2}}=6.3\).

Question 19.
A rectangle sheet of tin with adjascent sides 45cm and 24cm is to be made into a box • without top, by cutting off equal squares from the comers and folding up the flaps

1. Taking the side of the square cut off as x, express the volume of the box as the function of x. (2)
2. For what value of x, the volume of the box will be maximum. (4)

Answer:
1. Length of the box = 45 – 2x
Breadth of the box = 24 – 2x
Height of the box = x
Volume; V = (45 – 2x)(24 – 2x)x
= (1080 – 138x + 4x²)x
= 4x³ – 138x² + 1080x.

2. \(\frac{d y}{d x}\) = 12x² – 276x + 1080

12x² – 276x + 1080 = 0
x² – 23x + 90 = 0
x = 18, 5
x = 18 is impossible
∴ x = 5 when x = 5, \(\frac{d^{2} y}{d x^{2}}\) < 0

The volume of the box is maximum at x = 5.

Students can Download Chapter 11 Advances in Computing Questions and Answers, Plus Two Computer Science Chapter Wise Questions and Answers helps you to revise the complete Kerala State Syllabus and score more marks in your examinations

Kerala Plus Two Computer Science Chapter Wise Questions and Answers Chapter 11 Advances in Computing

Plus Two Computer Science Advances in Computing One Mark Questions and Answers

Question 1.
Which among the following are true regarding distributed computing?
i) Different parts of a program are run simultaneously on two or more computers.
ii) Distributed systems fail even if one node fails to function.
iii) A lot of extra programming is required to set up a distributed system.
iv) All the different processors share memory.
(a) i & ii are correct
(b) iii & iv are correct
(c) i & iii are correct
(d) ii & iv are correct
Answer:
(c) i & iii are correct

Question 2.
______ computing provides users access to computational power just like electricity through wall sockets.
(a) Parallel
(b) Grid
(c) Cluster
(d) Serial
Answer:
(b) Grid

Question 3.
A pattern or a model in the study of any subject of complexity is called ______.
Answer:
paradigm

Question 4.
____ is a method of computing in which large problems can be divided into smaller ones and this smaller one are distributed among several computers.
Answer:
distributed computing.

Question 5.
_____ is the advantage of distributed computing where we can add computers according to the workload.
Answer:
Scalability.

Question 6.
Multiple processors are used in _____ computing
(a) serial
(b) parallel
(c) standalone
(d) none of these
Answer:
(b) parallel

Question 7.
Single processor is used in _____ computing.
(a) serial
(b) parallel
(c) standalone
(d) none of these
Answer:
(a) serial

Question 8.
One instruction is executed on a single processor at any moment in _____ computing.
Answer:
Serial.

Question 9.
More than one instruction is executed on multiple processors at any moment of time in _____ computing.
Answer:
Parallel.

Question 10.
_____ is the fastest supercomputer used by Indian Institute of Tropical meteorology
Answer:
ADITYA

Question 11.
______ computing uses millions of computers and in which computational power(resources, services, data) is readily available like electric power.
Answer:
Grid computing.

Question 12.
Here a group of Internet-connected computers, storage devices, etc are linked together and work like a single computer. Which is this computing
Answer:
Cluster computing

Question 13.
It is an emerging computing technology. Herewith the use of Internet and central remote servers to maintain data and applications. Name this computing
Answer:
Cloud computing.

Question 14.
From the following which is not the cloud service model
(a) SaaS
(b) PaaS
(c) laaS
(d) NaaS
Answer:
(d) NaaS

Question 15.
SaaS stands for _____.
Answer:
Software as a Service

Question 16.
PaaS stands for _____.
Answer:
Platform as a Service.

Question 17.
laaS stands for _____.
Answer:
Infrastructure as a Service.

Question 18.
Expand LAMP
Answer:
Linux, Apache Server, MySQL, and PHP.

Question 19.
Al stands for _____.
Answer:
Artificial Intelligence

Question 20.
The first definition of Artificial Intelligence was established by _______.
Answer:
Alan Turing.

Question 21.
Al was first coined by ______ in 1956.
Answer:
John MacCarthy

Question 22.
With the help of _____ computer can solve the tasks such as playing chess, proving mathematical theorems, natural language processing, medical diagnosis, etc.
Answer:
Artificial Intelligence.

Question 23.
____ is a test of a machine’s ability to exhibit intelligent behaviour equivalent to, or indistinguishable from, that of a human.
Answer:
Turing Test.

Question 24.
NLP stands for _____.
Answer:
Natural Language Processor.

Question 25.
ASR stands for _____.
Answer:
Automatic Speech Recognition

Question 26.
OCR stands for
Answer:
Optical Character Recognition

Question. 27
HCR stands for _____.
Answer:
Handwritten Character Recognition.

Question. 28
GIS stands for ______.
Answer:
Geographical Information System.

Question. 29
CAD stands for ______.
Answer:
Computer-Aided Design

Question. 30
Which of the following is not a distributed computing paradigm?
(a) grid
(b) cloud
(c) cluster
(d) serial
Answer:
(d) serial

Question. 31
The study of control and communication between man and machine is called _____.
Answer:
Cybernetics

Question. 32
In Artificial Intelligence, ANN stands for
(a) Artificial Network of Neural.
(b) Advanced Neural Network
(c) Artificial Neural Network
(d) Architectural Neural Network
Answer:
(c) Artificial Neural Network

Question 33.
Which among the following is the capability that is required by a computer to pass Turing Test?
i. Natural Language Processing (NLP)
ii. Knowledge representation
iii. Machine learning
iv. Computer Vision
(a) i & ii only
(b) i.ii & iii only
(c) iii & iv only
(d) All of the above
Answer:
(d) All of the above

Plus Two Computer Science Advances in Computing Two Mark Questions and Answers

Question 1.
Differentiate the terms intelligence and wisdom.
Answer:
The ability to draw useful inferences from the available knowledge is generally referred as intelligence. Wisdom is the maturity of mind that directs its intelligence to achieve desirable goals.

Question 2.
Find the suitable match.

Answer:
1 – c
2 – d
3 – b
4 – a

Question 3.
Find the suitable match.

Answer:
1 – b
2 – c
3 – d
4 – a

Question 4.
Classify the following as SaaS, PaaS, and laaS. Adobe Creative Cloud. Google App Engine, Microsoft Office 365, Amazon Web Services.
Answer:

• SaaS: Adobe Creative Cloud, Microsoft Office 365
• PaaS: Google App Engine
• laaS: Amazon Web Services

Question 5.
Question Text:
Pick the odd one out. The services of cloud computing include:
(a) Software as a Service
(b) Hardware as a Service
(c) Platform as a Service
(d) Infrastructure as a Service
Answer:
(b) Hardware as a Service. The others are cloud computing paradigm

Question 6.
Question Text:
State whether the following statements are true or false.

1. Clusters provide computational power through parallel processing.
2. Even if anyone of the computers fails, cluster computing as a whole will work.

Answer:

1. True
2. True

Question 7.
The following organisations plan to buy cloud computing service for their IT requirements. Suggest the cloud computing model that suits their need.

1. Hari & Co. requires spreadsheets and presentation software.
2. Tomy & Co. requires to install their own software for their accounting needs in a LAMP platform.
3. Raju & Co. requires to use MySQL for their database needs.
4. Joy & Co. requires 1 TB hard disk space, 2 GB RAM and processing power.

Answer:

1. SaaS
2. PaaS
3. SaaS
4. laaS

Question 8.
Consider the following statements about distributed computing and state True/False.
1. In distributed computing, parts of a program are run simultaneously from two or more computers which are communicating with each other.
2. WWW is an example for large distributed computing.
Answer:

1. True
2. True

Question 9.
Parallel computing is faster than serial computing. Mention the limitations in implementing parallel computing.
Answer:
Disadvantages:

• Implementing this is more complex than serial application
• Significant changes must be made to make the programs machine-independent

Question 10.
What do you mean by Distributed computing?
Answer:
Distributed computing is a method of computing in which large problems can be divided into smaller ones and these smaller ones are distributed among several computers. The solution for the smaller ones are computed separately and simultaneously. Finally, the results are assembled to get the desired overall solution.

Plus Two Computer Science Advances in Computing Three Mark Questions and Answers

Question 1.
Differentiate between Bioinformatics and Biometrics.
Answer:
1. Biometrics:
Biometrics refers to the unique characteristics of a human being to recognize an individual such as fingerprints, face recognition, iris, retina, etc. Biometrics are used to record attendance
Eg. In banks, employee login is restricted by using fingerprint reader

2. Bioinformatics:
It is a computer technology to the management of biological information. By the help of a computer analyse the fingerprints, DNA, iris, retina, etc and identifying the concerned person.

Question 2.
Briefly explain the Turing test.
Answer:
The Turing test is a test of a machine’s ability to exhibit intelligent behaviour equivalent to, or indistinguishable from, that of a human. The test involves a human judge engages in natural language conversations with a human and a machine designed to generate performance indistinguishable from that of a human being.

All participants are separated from one another. If the judge cannot reliably tell the machine from the human, the machine is said to have passed the test. The test does not check the ability to give the correct answer to questions; it checks how closely the answer resembles typical human answers. Turing predicted that by 2000 computer would pass the test.

Question 3.
Draw the knowledge pyramid and briefly explain the terms in it.
Answer:

Data is termed as a collection of mere symbols. While processing data we get information and knowledge is the organized information. It can be a piece of information that helps in decision making. The ability to draw useful inferences from the available knowledge is generally referred as intelligence. Wisdom is the maturity of mind that directs its intelligence to achieve desirable goals.

Question 4.
Compare grid computing and cloud computing paradigms of distributed computing.
Answer:
1. Grid computing:
It is a system in which millions of computers, smartphones, satellites, telescopes, cameras, sensors, etc. are connected each other as a cyber world in which computational power (resources, services, data) is readily available like electric power. Any information at any time at any place can be made available in our fingertips. This is used in disaster management, weather forecasting, market forecasting, bio information, etc.

2. Cloud computing:
It is an emerging computing technology. Herewith the use of Internet and central remote servers to maintain data and applications. Example for this is Email service, Office Software(word processor, spreadsheets, presentations, database, etc), graphics software, etc. The information is placed in a central remote server just like clouds in the sky hence the name cloud computing

Question 5.
What is cluster computing? Write its advantages and disadvantages.
Answer:
Cluster means groups. Here a group of Internet-connected computers, storage devices, etc are linked together and work like a single computer. It provides computational power through parallel processing. Its cost is less and used for scientific applications.

Advantages

• Price-performance ratio: The performance is high ‘ and the cost is less.
• Availability: If one group of system fails the other group will do the work.
• Scalability: Computers can be easily added according to the workload increases.

Disadvantages

• Programmability issues: Different computers uses different software and hardware hence the issues.
• Problem in finding fault: Fault detection is very difficult

Question 6.
The distributed computing method has some advantages and disadvantages. What are they?
Answer:
Advantages

• Economical: Reduces the computing cost hence it is economical
• Speed: The workload of the entire system is less hence the speed is high.
• Reliability: When one computer in the network fails the entire work will not be blocked, i.e. the other computers will do the work properly.
• Scalability: We can add computers according to the workload.

Disadvantages

• Complexities: The proper division of the problems and reassembling of the result is a major complex task.
• Security: Security measurements to be taken to keep track of the sent data packets otherwise it can be used for illegal purposes.
• Network reliance: Some occasions in case of network failure, the entire system may become unstable.

Question 7.
Most of the companies are opting for cloud computing for their IT requirement. Explain the advantages that they gain from this.
Answer:
Advantages

• Cost savings: Companies can reduce costs by using cloud computing
• scalability/ Flexibility: More resources are used when the workload increases.
• Reliability: It is reliable and helps in disaster recovery
• Maintenance: The service provider do system maintenance, then reducing maintenance requirements.
• Mobile accessible: Employees can do their job even when they are in move.

Question 8.
Match the following.

Answer:
i – b
ii – c
iii – d
iv – a

Question 9.
Explain the advantages and disadvantages of distributed computing.
Answer:
Advantages

• Economical: Reduces the computing cost hence it is economical
• Speed: The workload of the entire system is less hence the speed is high.
• Reliability: When one computer in the network fails the entire work will not be blocked, i.e. the other computers will do the work properly.
• Scalability: We can add computers according to the workload.

Disadvantages

• Complexities: The proper division of the problems and reassembling of the result is a major complex task.
• Security: Security measurements to be taken to keep track of the sent data packets otherwise it can be used for illegal purposes.
• Network reliance: Some occasions in case of network failure, the entire system may become unstable.

Question 10.
Write down the merits and demerits of parallel computing.
Answer:
Advantages

• If one or more node fails, the entire system will not failed instead it works with reduced performance. This method is called fault tolerance.
• Sharing computing power and storage resources with each other.
• Distributing tasks to different nodes hence reduce the load of entire system. It is called load sharing
• Scaling can be easily done.

Disadvantages

• Implementing this is more complex than serial application
• Significant changes must be made to make the programs machine-independent

Question 11.
Explain Grid computing with merits and demerits.
Answer:
It is a system in which millions of computers, smartphones, satellites, telescopes, cameras, sensors, etc. are connected each other as a cyber world in which computational power (resources, services, data) is readily available like electric power. Any information at any time at any place can be made available in our fingertips. This is used in disaster management, weather forecasting, market forecasting, bio information, etc.
Advantages

• It is used to solve more complex problems in a short time.
• Existing hardware used efficiently
• Scalable: The number of computers can be added according to the workload increases

Disadvantages

• Processing speed is less
• Different computers uses different software and the licensing issues may effect the working of application

Question 12.
Explain cluster computing with its merits.
Answer:
Cluster means groups. Here a group of Internet connected computers, storage devices, etc are linked together and work like a single computer. It provides Computational power through parallel processing. Its cost is less and used for scientific applications.
Advantages

• Price-performance ratio: The performance is high and the cost is less.
• Availability: If one group of system fails the other group will do the work.
• Scalability: Computers can be easily added according to the workload increases.

Question 13.
What is cloud computing?
Answer:
It is an emerging computing technology. Herewith the use of Internet and central remote servers to maintain data and applications. Example for this is Email service, Office Software(word processor, spreadsheets, presentations, database, etc), graphics software, etc. The information is placed in a central remote server just like clouds in the sky hence the name cloud computing.

Question 14.
Explain the Turing test
Answer:
The Turing test is a test of a machine’s ability to exhibit intelligent behaviour equivalent to, or indistinguishable from, that of a human. The test involves a human judge engages in natural language conversations with a human and a machine designed to generate performance indistinguishable from that of a human being.

All participants are separated from one another. If the judge cannot reliably tell the machine from the human, the machine is said to have passed the test. The test does not check the ability to give the correct answer to questions; it checks how closely the answer resembles typical human answers. Turing predicted that by 2000 computer would pass the test.

Question 15.
Compare parallel and serial computing.
Answer:
The difference between these two is given below.

Plus Two Computer Science Advances in Computing Five Mark Questions and Answers

Question 1.
Explain the three cloud service models.
Answer:
Cloud service models (3 major services):
1. Software as a Service (SaaS):
A SaaS provider company provides more services on demand such as they allow to access both resources and applications.
Examples are Google Docs, Adobe creative cloud, Microsoft Office 365, Facebook.com, etc.

2. Platform as a Service(PaaS):
A PaaS provider company provides subscribers access to the components that they, require to develop and operate applications over the Internet.
Example: LAMP platform(Linux, Apache Server, MySQL, and PHP), ASP.NET, PHP and Python, Google’s App Engine, Microsoft Azure, Force.com, etc.

3. Infrastructure as a Service(laaS):
It provides basic storage devices and computing capabilities as standardized services over the network.
Example: Amazon Web Services, Joyent, AT&T, GoGrid, etc.

Question 2.
What are the applications of Computational Intelligence? Explain?
Answer:
Application of Computational Intelligence
A. Biometrics:
Biometrics refers to the unique characteristics of a human being to recognize an individual such as fingerprints, face recognition, iris, retina, etc. Biometrics are used to record attendance
Eg. In banks employee login is restricted by using fingerprint readers.

B. Robotics:
It is a branch of scientific study associated with the design, manufacturing and controls the movements of the robots. Robotics are used in all areas. Some of them are discussed below.

1. Uses in vehicle manufacturing industry: Robots are used to do all tasks such as welding, cutting, lifting, sorting and bending. Since it is a machine, it can operate for long hours untiringly.

2. Exploration of outer space:
Robots are very much useful in this field such as they are used to do all the tasks related to launch a satellite.

3. In intelligent homes:
Robots are used in home segments to safe guard the home, automatically open the gate, doors and windows, etc.

4. Exploration in difficult environments:
Human beings are not ready to work situations like too hot and too cold. Since it is a machine robots are used instead of human beings. Robots are used in oil filed etc.

5. Uses in military:
Unmanned air crafts and vehicles are controlled by robots. Drones and computer controlled cameras are used in Military service.

6. Uses in agriculture:
Nowadays in India, the agriculture field is also in mechanization trend. Hence increase productivity.

C. Computer vision:
The world is changed from 2 dimensional images to 3 dimensional. 3D TVs are available in the market. Multiple cameras are used to capture the images and merge them to form 3D pictures. 3D scanners are used in the Medical filed to diagnose the diseases

D. Natural Language Processing:
It deals with how computers communicate just like a human being communicate naturally. Natural languages are languages spoken by the people. To achieve this ability to communicate like a human being is a laborious task. NLP is further be classified into two, Natural Language Understanding(NLU) and Natural Language Generation(NLG).

• NLU – The ability to understand languages like English, Malayalam, etc.
• NLG – It is deal with creation of output, i.e. generate words and giving reply.

E. Automatic Speech Recognition(ASR):
To login some computers, laptops .tabs, smartphones, etc, and to open some gates, doors, etc you have say the password orally. The computer recognizes the speech and opens the device to them.

Such devices are working based upon NLP technology and this system is called Automatic Speech Recognition(ASR) system. To implement this system the requirements, are mica or a telephone and convert the oral instruction into written text. Examples are Apple iOS, Google, etc.

F. Optical Character Recognition(OCR) and Handwritten Character Recognition Systems. (HCR):
It is used to read text from a paper as an image and translate this image into a form that computer can manipulate. For example, if we want to enter the text contents of a book by typing using a keyboard will take more time. Instead of this by using OCR and HCR we can easily do this. OCR is expensive. HCR system reads handwritten texts and converts it into computer-readable form

G. Bioinformatics:
It is a computer technology to the management of biological information. By the help of a computer analyse the fingerprints, DNA, iris, retina, etc and identifying the concerned person.
Three goals of bioinformatics.:

1. Organise: Huge amount of data organized to access information easily and to add new information when it is produced
2.  Develop tools: Develop new tools to analyse data efficiently.
3. Analysis: With thw help of these tools analyse the data and produce results.

H. Geographical Information System:
Geosynchronous satellite moves at the same Revolutions Per Minute(RPM) as that of the earth in the same direction. Thus both the earth and the satellite complete one revolution exactly in the same time and hence the relative position of the ground station with respect to the satellite never changes.

Geographic Information System(GIS) technology is developed from digital cartography and Computer-Aided Design(CAD) database management system. GIS as the name implies capturing, storing for future reference, checking and displaying data related to various positions on earth’s surface.

GIS can be applied in many areas such as soil mapping, agricultural mapping, forest mapping, e-Governance, etc. GIS is used in development planning like strategic rural and urban planning, infrastructure planning, precision agriculture planning, etc.

Question 3.
Explain cloud computing paradigm and its three models of services in detail.
Answer:
It is an emerging computing technology. Herewith the use of Internet and central remote servers to maintain data and applications. Example for this is Email service, Office Software (word processor, spreadsheets, presentations, database, etc), graphics software, etc. The information is placed in a central remote server just like clouds in the sky hence the name cloud computing.
Cloud service models (3 major services):
1. Software as a Service(SaaS)
A SaaS provider company provides more services on demand such as they allow to access both resources and applications.
Examples are Google Docs, Adobe creative cloud, Microsoft Office 365, Facebook.com, etc.

2. Platform as a Service(PaaS)
A PaaS provider company provides subscribers access to the components that they require to develop and operate applications over the Internet.
Example: LAMP platform(Linux, Apache Server, MySQL, and PHP), ASP.NET, PHP and Python, Google’s App Engine, Microsoft Azure, Force.com, etc.

3. Infrastructure as a Service(laaS)
It provides basic storage devices and computing capabilities as standardized services over the network.
Example: Amazon Web Services, Joyent, AT&T, GoGrid, etc.

Question 4.
List and explain any three biologically inspired algorithms/paradigms that simulate natural intelligence, which led to the development of intelligent systems.
Answer:
Computational Intelligence paradigms Computational Intelligence is the ability to make a computer to face and solve real-life problems just like a intelligent man do it. It includes Artificial Neural Networks(ANN), Evolutionary Computation(EC), Swarm Intelligence(SI) and Fuzzy Systems(FS).

A. Artificial Neural Networks (ANN):
The brain is a complex, nonlinear and parallel computer with ability to perform tasks such as recognise pattern, perception and motor control. ANN is the method of simulate biological neural systems to learn, memorise and generalize like human beings. A human brain cortex consists of 10-500 billion neurons with 60 trillion synapses(a synapse is a structure that permits a neuron to pass electrical)

B. Evolutionary Computation (EC):
It is the simulation of the natural evolution, i.e. survival of the fittest. In the surrounding, we can see that the stronger must win and others will lose. EC applied for data mining, fault diagnosis, classification, scheduling, etc.

C. Swarm Intelligence (SI):
Swarm Intelligence is the study of behaviour of colonies or groups of social animals, birds, insects, ants, etc. How they communicate and create and manage their own colonies beautifully.

D. Fuzzy Systems:
Human beings use common sense while facing a problem, just like human beings fuzzy systems can also use common sense and behave like human beings. Fuzzy systems is used to control gear transmission and raking systems, control lifts, home appliances, controlling traffic signals, etc.

Question 5.
One of the recent developments in Computer Science is the use of computational intelligence in different real life applications. Briefly explain any five areas of application of computational intelligence.
Answer:
A. Biometrics:
Biometrics refers to the unique characteristics of a human being to recognize an individual such as fingerprints, face recognition, iris, retina, etc. Biometrics are used to record attendance Eg. In banks employee login is restricted by using fingerprint readers.

B. Robotics:
It is a branch of scientific study associated with the design, manufacturing and control the movements of the robots. Robotics are used in all areas.

C. Computer vision:
The world is changed from 2-dimensional images to 3 dimensional. 3D TVs are available in the market. Multiple cameras are used to capture the images and merge them to form 3D pictures. 3D scanners are used in the Medical field to diagnose the diseases

D. Natural Language Processing:
It deals with how computers communicate just like a human being communicate naturally. Natural languages are languages spoken by the people. To achieve this ability to communicate like a human being is a laborious task. NLP is further be classified into two, Natural Language Understanding (NLU) and Natural Language Generation (NLG).

• NLU- The ability to understand the languages like English, Malayalam, etc.
• NLG- It is deal with creation of output, i.e. generate words and giving reply.

E. Automatic Speech Recognition(ASR):
To login some computers, laptops, tabs, smartphones, etc, and to open some gates, doors, etc you have say the password orally. The computer recognizes the speech and opens the device to them. Such devices are working based upon NLP technology and this system is called Automatic Speech Recognition(ASR) system.

To implement this system the requirements are a mica or a telephone and convert the oral instruction into written text. Examples are Apple iOS, Google, etc.

F. Optical Character Recognition(OCR) and Handwritten Character Recognition Systems. (HCR):
It is used to read text from a paper as an image and translate this image into a form that computer can manipulate. For example, if we want to enter the text contents of a book by typing using a keyboard will take more time. Instead of this by using OCR and HCR we can easily do this. OCR is expensive. HCR system reads handwritten texts and converts it into computer-readable form.

G. Bioinformatics:
It is a computer technology to the management of biological information. By the help of a computer analyse the fingerprints, DNA, iris, retina, etc and identifying the concerned person.
Three goals of bioinformatics.

1. Organise
2. Develop tools
3. Analysis

H. Geographical Information System:
Geosynchronous satellite moves at the same Revolutions Per Minute(RPM) as that of the earth in the same direction. Thus both the earth and the satellite complete one revolution exactly in the same time and hence the relative position of the ground station with respect to the satellite never changes.

Geographic Information System(GIS) technology is developed from digital cartography and Computer-Aided Design(CAD) database management system. GIS as the name implies capturing, storing for future reference, checking and displaying data related to various positions on earth’s surface. GIS can be applied in many areas such as soil mapping, agricultural mapping, forest mapping, e-Governance, etc.

GIS is used in development planning like strategic rural and urban planning, infrastructure planning, precision agriculture planning, etc.

Students can Download Chapter 3 Use of Spread Sheet in Business Application Questions and Answers, Plus Two Accountancy Chapter Wise Questions and Answers helps you to revise the complete Kerala State Syllabus and score more marks in your examinations.

Kerala Plus Two Chemistry Chapter Wise Questions and Answers Chapter 3 Use of Spread Sheet in Business Application

Plus Two Accountancy Use of Spread Sheet in Business One Mark Questions and Answers

Question 1.
Which of the following options in a financial function indicates the interest for a period?
(a) FV
(b) PV
(c) N per
(d) Rate
Answer:
(b) PV

Question 2.
Which of the following arguments in a financial function represents the total number of payments?
(a) FV
(b) PV
(c) N Per
(d) Rate
Answer:
(c) N-Per

Question 3.
What Category of functions is used in this formula: = PMT(C 10/12, C8, C9, 1)
(a) Logical
(b) Financial
(c) Payment
(d) Statistical
Answer:
(b) Financial

Question 4.
LibreOffice Calc is a program
(a) Word Processor
(b) Browser
(c) Spread Sheet
(d) Calculator
Answer:
(c) Spread Sheet

Question 5.
……………… is the statement prepared to show detailed salary calculation
(a) Employee Job Card
(b) Payroll
(c) Loan Repayment Schedule
(d) Worksheet Payroll
Answer:
(b) payroll

Question 6.
………………… calculates the monthly installment of loan amount
(a) Loan Repayment Schedule
(b) Loan analysis sheet
(c) Loan card
(d) Payroll statement
Answer:
(a) Loan Repayment schedule

Question 7.
Depreciation is provided on
(a) Current Assets
(b) Fixed Assets
(c) Current Liabilities
(d) Long term Liabilities
Answer:
(b) Fixqd Assets

Question 8.
Depreciation =
Answer:
\(\frac{\text { cost of the asset- Scrap Value }}{\text { Life of the asset }}\)

Question 9.
……………………. is the gradual & permanent diminution in the value of assets due to wear and tear, use or abuse or efflux of time.
Answer:
Depreciation

Question 10.
Under …………… method of depreciation, the asset account will be reduced to zero.
(a) Fixed Instalment method
(b) Reducing installment
(c) Depreciation Fund Method
(d) Revaluation method
Answer:
(a) Fixed Instalment Method

Question 11.
Decrease in the value of fixed assets is called ……………..
Answer:
Depreciation

Question 12.
If the cost of asset is 10000, Scrap value at the end of 10 years will be 2000, what will be the amount of annual depreciation?
Answer:
Depreciation = \(\frac{10000-2000}{10}\) i.e., 800

Question 13.
Depreciation = (Acquisition cost – ………………. ) ÷ Life time
(a) Salvage value
(b) Carriage expenses
(c) Sales price
(d) Installation charges
Answer:
(a) Salvage value

Question 14.
The ……… of an asset is the value, which is realisable at the end of its useful life
(a) Depreciation
(b) Scrap value
(c) Written down value
(d) Acquisition cost
Answer:
(b) Scrap value

Question 15.
Odd one out
(a) Basic Pay
(b) Grade Pay
(c) House Rent Allowance
(d) Provident Fund
Answer:
(d) Provident Fund (It is a deduction)

Question 16.
_________ is a statutory deduction deducted monthly towards income tax liability of an employee
Answer:
Tax Deducted at Source (TDS)

Question 17.
Gross Salary – Total Deduction = ______
Answer:
Net Salary

Question 18.
In PMT function, Type is, whether payment is made at the beginning of the month, the value = ……(a)…… or at the end of the month, the value = …….(b)……
Answer:
(a) 1
(b) 0

Question 19.
Rate of Depreciation under straight line Method = ………
Answer:
\(\frac{\text { Amount of Depreciation (Yearty Depreciation) }}{\text { Total Depreciable Amount (Cost) }} \times 100\)

Question 20.
The function PMT is used to prepare …………….
(a) Pay Roll statement
(b) Depreciation statement
(c) Loan repayment statement
(d) Interest on Investment statement
Answer:
(c) Loan repayment statement

Question 21.
Match the following

Answer:
1 → c; 2 → a; 3 → d; 4 → b

Question 22.
Which among the following is not a component of PayRoll statement
(a) Professional Tax
(b) Present Value
(c) HRA
(d) Dearness Allowance
Answer:
(b) Present Value

Plus Two Accountancy Use of Spread Sheet in Business Two Mark Questions and Answers

Question 1.
What are the different methods for calculating depreciation on fixed Assets?
Answer:
Methods of calculation of depreciation

1. Straight Line Method (SLM)
2. Written Down Value Method (WDV)

Question 2.
What commands are used to

1. Insert a column and
2. Delete a column in Libre Office Calc

Answer:

1. Insert a column
2. Delete a column

Question 3.
Develop the command to calculate the Group Insurance Premium and Tax Deducted at source (TDS) by using the ‘IF’ function.

1. Rate of GI Rs. 200/-. for BP below Rs. 10,000/- and for others Rs. 300/- assuming that BP of employee is given in cell F2
2. TDS 10% of Gross Pay for employees having Gross Pay below Rs, 25000/- and for others 20%, assuming that the gross pay of the employee is given in cell F2.

Answer:

1. = IF (B2 < 10000,200,300)
2. = IF (F2 < 25000, F2*10%, F2*20%)

Question 4.
Name the two basic method of depreciation functions used in LibreOffice Calc
Answer:

1. SLN
2. D8

Question 5.
Why is FV taken as Zero (0) in the PMT calculation?
Answer:
At the end of the loan period, the balance amount payable will be zero assuming that the repayments are made on regular basis. Therefore the future value FV is taken as zero.

Question 6.
Write the command to calculate the State Life Insurance (SLI) Premium of an Employee using the ‘IF’ function.
The condition is:- SLI Premium Rs. 250 for basic pay below Rs. 10,000/- for others Rs.500/- (Hint: Basic pay (BP) is given the cell B3)
Answer:
IF (B3 < 10000, 250, 500)

Plus Two Accountancy Use of Spread Sheet in Business Three Mark Questions and Answers

Question 1.
Give some examples for PayRoll components.
Answer:

1. Basic Pay
2. Dearness Allowance
3. House Rent Allowance
4. Provident Fund
5. Professional Tax
6. ESI

Question 2.
Basic Pay, Dearness Allowance, House Rent allowance, Professional Tax, Provident fund contribution are given to prepare the PayRoll statement. Give the equation to calculate Net Salary.

• Gross salary = Basic Pay + Dearness Allowance + House Rent Allowance
• Total Deduction = Professional Tax + Provident fund contribution
• Net Salary = Gross Salary – Total Deduction

Answer:
Net Salary Calculation:
Step 1 – Calculate Gross salary by using the given formula.
Gross salary /Gross Pay = Basic Pay + Grade Pay + Dearness Pay+ Dearness Allowance + House Rent Allowance + Any other Earnings.

Step 2 – Calculate Total Deduction by using the following formula.
Total Deduction = Professional Tax+ Provident Fund + Tax deducted at source + Loan Recovery + Any other deductions

Step 3- Calculate net salary by the given formula.
Net Salary = Gross salary – Total Deduction

Question 3.
What is the difference between WDV method and SLN method of depreciation?
Answer:
Written Down Value Method (WDV):
This method is also known as Diminishing balance method or Reducing balance method. Under this method, a fixed percentage is written off every year on the book value of the asset at the beginning of the year.

Here the amount of depreciation goes on decreasing and therefore, the book value of asset will not become zero after its working life.
Amount of depreciation = Written Down Value of asset x Rate of depreciation

Straight Line Method:
Under this method a fixed amount is deducted from the value of an asset year after year on account of depreciation and debited to profit and loss account. This method is also called Fixed Instalment method, or Original Cost method. Under this method value of asset will be reduced to zero.
Depreciation = \(\frac{\text { cost of the asset-Scrap Value }}{\text { Life of the asset }}\)

Question 4.
List down the Parameters of the function PMT
Answer:
LOAN REPAYMENT SCHEDULE:
Loan is a sum of borrowed money for a specified period at a pre-specified rate of interest. The loan is repaid through a number of periodic repayment instalments over the loan repayment period. LibreOffice Calc function PMT is used to calculate the loan repayment schedule. The parameters of the function PMT are as follows.

Parameter – Explanation

• Rate – Interest rate
• Nper – Total Number of payments for the loan
• PV – Present value(Loan amount)
• FV – Future value, which is taken a zero, is the balance at the end of the loan period
• Type – Whether payment is made at the beginning (value = 1) or at the end (value = 0) of the period.

Question 5.
Classify the assets under computerised asset accounting.
Answer:
Assets are classified into the following categories:

1. Goodwill
2. Land: Freehold and leasehold
3. Building: Factory, office & residential building
4. Plant & Machinery
5. Furniture and fixtures
6. Vehicles
7. Work in progress (Capital)
8. Other assets

Question 6.
List out common Payroll components regarding salary computation and its payment.
Answer:
Earnings:

1. Basic pay
2. DearnessAllowances
3. House Rent Allowances
4. Transport Allowances
5. Other allowances.

Deductions:

• Provident Fund
• Professional Tax
• Tax deducted at source
• E.S.I. Premium

Question 7.
What are the common accounting applications done with the help of Libre Office Calc?
Answer:

1. Payroll Accounting
2. Asset Management
3. Loan Repayment Schedule

Question 8.
Write the formula in Libre Office Calc to find the Professional Tax in cell B2 where annual income is given in cell A2. Profession Tax is 5% for income in between Rs. 100000 and Rs.200000 and 8% for income more than Rs. 2,00,000. No tax for income below Rs. 1,00,000.
Answer:
= IF(B2 > 200000, B2*8%, IF(B2>100000, B2*5%,))

Plus Two Accountancy Use of Spread Sheet in Business Four Mark Questions and Answers

Question 1.
Write command to calculate state life Insurance Premium (SLI) of employee using the ‘IF’ function.
Condition
Premium Rs. 350/- below Basic Pay of Rs. 25000 and for others Rs. 450/- (BP is given in cell A3)
Answer:
= IF(A3 < 25000, 350, 450)

Question 2.
Briefly explain the procedure of preparation of salary bill and disbursement of cash.
Answer:
Preparation of Salary Bill:
The preparation of salary bill should provide for the following:
1. Maintaining payroll related data such as Employee No., Name, attendance, Basic Pay, DA, and other allowances, deductions to be made etc.

2. Periodic Payroll Computations:
It includes the calculation of various earnings and deductions.

3. Preparation of salary statement and employee’s salary slip.

4. Generation of advice to bank:
It contains the net salary to be transferred to individual bank account of employees and other salary related statutory payments such as provident fund, tax, etc.

Question 3.
The column headings of payroll to be prepared through Libre Office Calc is given below.

1. Write the formula to calculate DA, HRA, Gross pay, TDS and Net pay of Jexin Jose the first employee, in the second row of the worksheet.
2. Give the command to fill the calculation automatically for the remaining ‘10’ employees in the firm.

Answer:
1. DA → C2 =B2 * 20%
HRA → D2 = B2 * 5%
GP → E2 = B2 + C2+ D2
TDS → F2 = E2 * 10%
NP → G2 = E2 – F2

2. Fill the calculation for the remaining ‘10’ employees in the firm.

Question 4.
Distinguish between straight line method and diminishing balance method of depreciation
Answer:

Question 5.
Mr. Jyothis, a Plus two commerce student, entered the following details in a worksheet of LibreOffice Calc.

Write the command to calculate Net Salary
Answer:

Fill down the calculation to remaining 4 employees

Question 6.
Develop the commands to calculate the group insurance premium (Gl) and Tax Deducted at source (TDS) by using the ‘IF’ function.

1. Rate of GI Rs. 200/- for BP below Rs: 8000/- and for others Rs. 300/-, assuming that BP of employee is given in B2.
2. TDS 10% of Gross pay, for employees having Gross pay below Rs. 15,000/- and for others, 20%, assuming that the gross pay of the employee is given in F2.

Answer:

1. IF (B2 < 8000, 200, 300)
2. IF (F2 < 15000, F2*10%, F2*20%)

Plus Two Accountancy Use of Spread Sheet in Business Five Mark Questions and Answers

Question 1.
How the assets are classified in computerised Asset Accounting? What are the different methods of calculating depreciation on such assets?
Answer:
In computerised Asset Accounting, Assets are classified into the following categories.

1. Goodwill
2. Land (Normally, depreciation is not provided on freehold land)
3. Building
4. Plant and Machinery
5. Furniture and Fixtures
6. Vehicles
7. Work in progress (Capital)
8. Others

The different methods of calculating depreciation are:

• Straight Line Method (SLM)
• Written Down Value Method (WDV)

Question 2.
Which built in function of LibreOffice Calc can be used to compute monthly instalments of repayment of loan? Give the parameters of this function.
Answer:
PMT function can be used to prepare Loan Repayment Schedule in LibreOffice Calc.
The parameters of PMT function are:-

Parameter – Explanation

• Rate – Interest on Loan
• Nper – Number of payments for the loan
• PV – Present value; (ie the loan amount)
• FV – Future value, which is taken a zero
• Type – If the payment is made at the beginning of the month, the value = 1 or at the end of the month, the value = 0

Question 3.
From the following particulars prepare a payroll of employees of a firm by using LibreOffice Calc

• DA – 40% of basic pay
• HRA – 8% of basic pay
• Contribution to PF – 10% of basic pay.

Answer:

• DA = Basic pay *40%
• HRA = Basic pay *8%
• PF = Basic pay *10%
• Gross Pay = Basic Pay + DA + HRA
• Net Pay = Gross pay – PF

Question 4.
From the following particulars, prepare a payroll of employees of a firm by using LibreOffice Calc.

• DA = 70% of Basic pay
• HRA = 10% of Basic pay
• Contributions to PF at 15% of Basic pay.

Answer:
Step 1 – Enter the following

Step 2

Step 3 – Copy this formula to the remaining cells

Plus Two Accountancy Use of Spread Sheet in Business Practical Lab Work Questions and Answers

Question 1.
Prepare a Pay Roll statement of Viswanath Enterprises from the table given below and additional information.

1. DA is provided at 90% of Basic Pay
2. HRA: Rs. 500 for manager, 400 for accountant and 200 for others.
3. PF is deducted @ 20% on Basic + DA

Procedure:
Step 1 – Open a blank worksheet in LibreOffice Calc.

Step 2 – Enter the following text/formula in respective cells

Step 3 – Enter the given details

Step 4 – Copy the formula down up to the last employee.
Output:

Question 2.
Mr. Shibu wants to take a housing loan of Rs. 2,00,000 repayable in 60 equal monthly installments over the next 5 years. Assuming that the installments are paid in the beginning of each month. Find out the amount of monthly installments. Use PMT Function.
Procedure:
Step 1 – Open blank work sheet in LibreOffice Calc.
Applications → Office → Libre Office Calc.

Step 2 – Enter the following data in appropriate cells

Output:

Question 3.
Riya took a industrial loan of Rs. 300000, repayable in 4 years (equal monthly installments). The annual rate of interest is 10%. Assuming that the installments are paid at the end of each month. Find out the amount of monthly installments. Use PMT Function.
Procedure:
Step 1 – Open a blank work sheet in LibreOffice Calc.
Application → Office → Libre Office Calc.

Step 2 – Enter the following data in appropriate cells.

Output:

Question 4.
From the following particulars of employees in Anu Traders, prepare the Pay Roll.

Additional information:

1. DA – 50% of BP
2. HRA – 10% of BP
3. A monthly subscription to PF – 15% of BP
4. Group insurance premium -120 from each employee.

Procedure:
Step 1 – Open a new worksheet in LibreOffice Calc

Step 2 – Enter the following details in the following cells.

Step 3 – Enter the following details in the respective cells

Step 4 – Copy the formula down up to the last employee.
Output:

Question 5.
The salary information of a company named Seasons India Ltd. is given below. Prepare Payroll.

DA – 50% of Basic pay, CCA – 5% of Basic pay, PF 8% of Basic pay.
Procedure:
Step 1 – Open a blank worksheet in LibreOffice Calc

Step 2 – Enter the following details in the following cells.

Step 3 – Enter the following formula in respective cells

Step 4 – Copy the formula down up to the last employee
Output:

Question 6.
Mr.Anil Kumar a plus two commerce student entered the following details in a worksheet of LibreOffice Calc.

But, he faces some difficulty in completing the task. Can you help him by giving necessary commands or formula for filling the bank columns in the given spread sheet.
Answer:
Give the Following Formula:

Copy these formula to the remaining cell. Edit – Fill – Down or use Drag option.
Output:

Question 7.
Prepare the payroll of Amal Bros, for the month of January 2016.

• DA – 36% of Basic Pay
• HRA – Rs 500
• CCA – 6% of Basic pay

Deduction:

1. PF subscription – 8% of BP.
2. Group insurance premium Rs. 200 below basic pay Rs. 6000 and for others Rs. 350.
3. Tax deducted at source 10% of Gross Pay for employees below gross pay of Rs. 10000 arid for others 20%. Also, find out the total salary payable to employees for the month.

Procedure:
Step 1 – Open a blank work sheet in LibreOffice Calc

Step 2 – Enter the following details in the following cells.

Step 3 – Enter the following formula in the respective cell

Step 4 – Copy the formula down up to the last employee.
Output:

Question 8.
Prepare a pay roll of Jayakumar Associates for the month of June 2016 from the following details

Additional Information’s

1. DA – 50% of Basic pay earned
2. HRA – Manager – 30%, Accountant – 20%, clerk 10%, no HRA for saleswoman/Salesman and driver.
3. Transport allowance – 1500 for saleswoman, 2500 for salesman and 1000 for driver
4. PF contribution – 6% of BP for all employees except the driver.

Procedure:
Step 1 – Open a blank worksheet in LibreOffice Calc

Step 2 – Enter the following text/formula in the following way

Step 3 – Enter the given formula in F2
F2 = 30 – E2
Copy the formula down to the last employee

Step 4 – Enter the given formula in G2
G2 = D2*F2 ÷ 30
Copy the formula down to the last employee.

Step 5 – Enter the text for formula in the following cells.

Step 6 – Copy the formula down to the last employee.
Output:

Question 9.
Megha Associates purchased a new Machinery on 1/1/2010 for Rs. 8000 and spent Rs. 2000 for its installation. The expected salvage value is Rs. 2000 at the end of its useful life of 10 years. Calculate the amount of depreciation under straight line method.
Procedure:
Step 1 – Open a new blank worksheet in LibreOffice Calc.

Step 2 – Enter the following details as follows

Output:

Question 10.
On 1.1.2010, Vahida Enterprises purchased a new machinery for Rs. 150000 and incurred Rs. 10000 for its installation. Preoperative expense amounted to Rs. 5000. The expected salvage value at the end of its useful life of 8 years is Rs. 2000. Calculate depreciation by straight line method by using spread sheet.
Step 1 – Open a new blank worksheet in LibreOffice Calc.

Step 2 – Enter the following details in respective cells.

Output:

Question 11.
On 1^st April 2000, a company purchased a Machinery for Rs. 20,00,000, The installation charge is 50,000, pre-operation expenses are 1,50,000 and its salvage value is calculated Rs. 1, 00,000. Life of machinery is estimated to 15 years. Calculate depreciation under straight line method.
Procedure:
Step 1 – Open a new blank worksheet in LibreOffice Calc.

Step 2 – Enter the following data/formula in the following way.

Output:

Question 12.
From the following details, calculate depreciation under written down value method by using spread sheet.

1. Purchase fo Machinery – 10-6-2012
2. Cost of the Machinery – 300000
3. Machinery installed on – 15-6-2012
4. Installation Expenses – 2000
5. Pre operating cost – 13000
6. Salvage value after 8 years – 18000
7. 1^st year end date – 31/3/2013

Procedure:
Step 1 – Open a new blank worksheet in LibreOffice Calc.

Step 2 – Enter the given data/ formula as follows.


Output:

Question 13.
From the following details, calculate depreciation of machinery under written down value method using spreadsheet.

Step 1 – Open a new blank worksheet in LibreOffice Calc.

Step 2 – Enter the given data in respective cells.

Output:

Question 14.
From the following details, calculate depreciation underwritten down value Method.

Procedure:
Step 1 – Open a new blank worksheet in LibreOffice Calc.

Step 2 – Enter the following data in the respective cells.

Output:

Question 15.
On 1-2-2015, Vikram borrowed Rs. 6,00,000 from Canara bank at 9.6% interest. The period of loan is 36 months. Calculate monthly installment assuming the installments are made at the beginning of each month.
procedure:
Step 1 – Open a new blank worksheet in LibreOffice Calc.

Step 2 – Enter data/formula as follows:

Output:

Question 16.
Mr. Chandramohan has taken a loan of Rs. 300,000 from a bank at an interest rate of 10% p.a. The loan is to be repaid in 36 monthly installments over the next 3 years. Assuming that the monthly installments are paid at the end of each month. Calculate the amount of interest paid by him in the 2^nd year only. Use CUMIPMT Function.
Procedure:
Step 1 – Open a new blank worksheet in LibreOffice Calc.

Step 2 – Enter the following details and formula in different cells as given below.

Output:

Students can Download Chapter 10 Server Side Scripting Using PHP Questions and Answers, Plus Two Computer Science Chapter Wise Questions and Answers helps you to revise the complete Kerala State Syllabus and score more marks in your examinations

Kerala Plus Two Computer Science Chapter Wise Questions and Answers Chapter 10 Server Side Scripting Using PHP

Plus Two Computer Science Server Side Scripting Using PHP One Mark Questions and Answers

Question 1.
PHP files have a default file extension of ______.
(a) .html
(b) .xml
(c) .php
(d) .ph
Answer:
(c) .php

Question 2.
A PHP script should start with.
(a) <php>
(b) <?php?>
(c) <?php>
(d) <?php?>
Answer:
(c) <?php>

Question 3.
We can use_ to provide multi line comments.
(a) /?
(b) //
(c) #
(d) /* */
Answer:
(d) /* */

Question 4.
Which of the following php statement/statements will store 111 in variable num?
i) int$num = 111;
ii) intnum = 111;
iii) $num = 111;
iv) 111 = $num;
(a) Both i) and ii)
(b) All of the mentioned.
(c) Only iii)
(d) Only i)
Answer:
(c) Only iii)

Question 5.
What will be the output of the following PHP code?
<?php
$num = 1;
$num1 = 2;.
print $num . “+”. $num1;
?>
(a) 3
(b) 1 + 2
(c) 1. + .2
(d) Error
Answer:
(b) 1 + 2

Question 6.
Which of the following PHP statements will output Hello World on the screen?
i) echo (“Hello World”);
ii) print (“Hello World”);
iii) cout(“Hello World”);
iv) sprintf (“Hello World”);
(a) i) and ii)
(b) i), ii) and iii)
(c) All of the mentioned.
(d) i), ii) and iv)
Answer:
(a) i) and ii)

Question 7.
What will be the output of the following PHP code?
<?php
$total=25;
$more=10;
$total=$total + $more; .
echo “$total”;
?>
(a) Error
(b) 35 students
(c) 35
(d) 25 students
Answer:
(c) 35

Question 8.
Which statement will output $x on the screen?
(a) echo “\$x”;
(b) echo “$$x”;
(c) echo“/$x”;
(d) echo“$x;”;
Answer:
(a) echo “\$x”;

Question 9.
What will be the output of the following PHP code?
<?php
$a = “clue”;
$a = “get”;
echo “$a”;
?>
(a) get
(b) true
(c) false
(d) clueget
Answer:
(d) clueget

Question 10.
PHP’s numerically indexed array begin with position ______.
(a) 1
(b) 2
(c) 0
(d) -1
Answer:
(c) 0

Question 11.
What will be the output of the following PHP code?
<?php
echo $x— != ++$x;
?>
(a) 1
(b) 0
(c) error
(d) no output
Answer:
(d) no output

Question 12.
List Superglobals used in PHP.
Answer:
superglobals used in PHP is given below.
$_REQUEST, S_POST, S_GET, and S_COOKIE.

Plus Two Computer Science Server Side Scripting Using PHP Two Mark Questions and Answers

Question 1.
Name the PHP functions we use

1. to find the length of a string
2. for comparing two strings

Answer:

1. strlen()
2. strcmp()

Question 2.
What is the main difference between JavaScript and PHP?
Answer:
JavaScript is a client side scripting language whereas PHP is a server side scripting language.

Question 3.
What will be the output of the following PHP code?
<?php
$a = 10;
echo ++$a;
echo $a++;
echo $a;
echo ++$a;
?>
(a) 11111213
(b) 11121213
(c) 11111212
(d) 11111112
Answer:
(a) 11111213
It works as follows
<?php
$a = 10;
echo ++$a; → Here pre increment first add 1 to
10 then it prints 11
echo $a++; → Here it prints 11 and then add 1 to
11 and stores in the variable $a, i.e. $a=12. echo$a; → Here it prints 12.
echo ++$a; → Here pre increment first add 1 to
12 then it prints 13 ?>

Question 4.
What will be the output of the following PHP code?
<?php
$x=”test”;
$y=”this”;
$z=”also”;
$x.=$y.=$z; echo $x; echo $y;
?>
(a) testthisthisalso
(b) testthis
(c) testthisalsothisalso
(d) error at line 4
Answer:
(c) testthisalsothisalso

Question 5.
What will be the output of the following PHP code?
<?php
$y = 2;
if ($y— == ++$y)
{
echo $y;
}
?>
(a) 2
(b) 1
(c) 3
(d) no output
Answer:
(a) 2
It works as follows $y=2;
Here $y – – (LHS of the condition) , it first use the value of $y i.e. 2 hence LHS becomes 2, then its values decremented by 1 so $y now becomes 1. ++$y(RHS of the condition) first it changes the value
i. e. incremented by 1 now $y=2 hence RHS becomes 2
Here LHS and RHS are same then the condition $y— == ++$y returns true.
So it prints the value of $y, i.e. 2.

Plus Two Computer Science Server Side Scripting Using PHP Three Mark Questions and Answers

Question 1.
A special type of array which is not supported by C++ is used in PHP. Can you describe the features of that array with example?
Answer:
Associative arrays
Arrays with named keys and string indices are called associative arrays.
Syntax: $varibale_name=array(key1 =>value1, key2=>value2,etc);
Eg:
<!DOCTYPE HTML>
<html lang=”en”>
<head>
<title>
We are learning PHP </title>
</head>
<body bgcolor=”cyan”>
<?php
$course = array (“Computer Science”=>”05″, “Commerce”=>”39″,”Science”=> “01” ); echo”The code of Computer Science is “.Scourse[“Computer Science”];
?>
</body>
</html>

Question 2.
Compare echo and print statements used in PHP.
Answer:
Output statements in PHP:
1. echo and print are used to display all types of data but echo is used to produce multiple outputs. Parenthesis is optional. Print returns true or false based on success or failure whereas echo doesn’t return true or false.
eg:
echo “ first output”, “second output”; or
echo (“ first output”, “second output”);
print “only one output”; .
or
print (“only one output”);
Eg.
<!DOCTYPE HTML> <head> <meta charset=”UTF-8″> <title>
This is a php page </title>
</head>
<body>
<?php
echo “This is first output”,” This is second output<br>”;
print “Only support single output”;
?>
</body>
</html>

Question 3.
List the main differences between GET and POST methods in form submitting?
Answer:
The main differences are given below.

Plus Two Computer Science Server Side Scripting Using PHP Five Mark Questions and Answers

Question 1.
What are the additional steps involved to run PHP in your computer?
Answer:
Basics of PHP
A. Setting up the development environment

• Step 1: Install a PHP compatible web Server(Eg. Abyss Web Server For Windows)
• Step 2: Install PHP interpreter.
  After installing the webserver type http:// localhost in the address bar the following screen will be available.

B. Writing and running the script
Take a note pad and type the code , PHP code should begin with <?php and end with ?>. Save this file in the root directory of the web server with extension .php.
Step 1
Take a notepad and type the following and save it as first.php on C:\Abyss Web Server\htdocs.
<?php
echo” My first PHP web page”;
?>
Step 2
Start the webserver if it is off
Step 3
Type as “http://localhost/first.php” in the address bar.

Students can Download Chapter 9 Structured Query Language Questions and Answers, Plus Two Computer Science Chapter Wise Questions and Answers helps you to revise the complete Kerala State Syllabus and score more marks in your examinations

Kerala Plus Two Computer Science Chapter Wise Questions and Answers Chapter 9 Structured Query Language

Plus Two Computer Science Structured Query Language One Mark Questions and Answers

Question 1.
………………. form of SQL is designed for use within general purpose programming languages such as COBOL, C, etc.
Answer:
Embedded SQL.

Question 2.
What is TCL?
Answer:
Transaction Control Language- component of SQL includes commands for specifying transactions.

Question 3.
Data dictionary is a special file in DBMS. What is it used for?
Answer:
Table details are stored in this file.

Question 4.
What does the following statement mean?
Name VARCHAR(30)
Answer:
Field Name can store up to 30 characters. It is a column definition.

Question 5.
Is there any data type available in SQL to store your date of birth information?
Answer:
Yes. DATE data type

Question 6.
Pick the odd one out.
(DEC, NUMBER, INT, DATE)
Answer:
DATE.

Question 7.
How do you ensure that the field ‘name’ will have some value always?
Answer:
using the constraint NOT NULL.

Question 8.
How to set the default value of column District in a table to Thrissur?
Answer:
District VARCHAR(30) DEFAULT ‘Thrissur’

Question 9.
…………… symbol is used as substitution operator in SQL.
Answer:
&

Question 10.
Is there any method to find the strings starting with letter ‘a’ from a field in SQL?
Answer:
Use LIKE operator, LIKE ‘a%’

Question 11.
How to check whether a particular field contains null values or not?
Answer:
Use operator IS NULL

Question 12.
‘ORDER BY’ clause is used for …………
Answer:
Sorting the results of a query by ascending(Asc) or Descending (Desc)

Question 13.
The built-in functions in SQL that return just a single value for a group of rows in a table are called ………..
Answer:
Summary functions or aggregate functions

Question 14.
How to find the number of values in a column in the table?
Answer:
Using the function COUNT()

Question 15.
………………. is the clause in SQL used for categorization.
Answer:
GROUP BY

Question 16.
Thomas wants to remove a table that he were using. How could you help him doing this?
Answer:
Using DROP TABLE command.

Question 17.
Pick the odd one out.
(SELECT, UPDATE, DELETE, DROP TABLE)
Answer:
DROP TABLE

Question 18.
Name the aggregate function that can be used to find the total number of records.
Answer:
COUNT()

Question 19.
Which of the following is an essential clause used with SELECT command?
(GROUP BY, ORDER BY, WHERE, FROM)
Answer:
FROM

Question 20.
Which of the following is not a column constraint?
(CHECK, DISTINCT, UNIQUE, DEFAULT)
Answer:
DISTINCT

Question 21.
Which of the following is a DDL command?
(SELECT, UPDATE, CREATE TABLE, INSERT INTO)
Answer:
CREATE TABLE

Question 22.
What are the logical operators used in SQL?
Answer:
And, Or, Not.

Question 23.
The …………. operator pf SQL is used to match a pattern with the help of %. February 2009
(a) BETWEEN
(b) AND
(c) LIKE
(d) OR
Answer:
(c) LIKE

Question 24.
The structure of a table Book is given below.

Write SQL query to Insert an additional column Purchase date of date type to the Books table.
Answer:
Alter table Book add(PurchaseDate Date);

Question 25.
Suppose we want to include a column in a table in which serial numbers are to be stored automatically on adding new records. Which constraint is to be used for that column during table creation?
Answer:
The constraint Autojncrement is used.

Question 26.
Which of the following cannot be used to name a table in SQL? Give the reason.
Answer:
(a) Studnt50
(b) Table
(c) $Employee
(d) Stock_123
Answer:
(b) Table. This is a keyword hence it cannot be used.

Question 27.
Which of the following commands is used to view the structure of a table?
(a) SHOW TABLES
(b) DESC
(C) SELECT
(d) DISPLAY
Answer:
(b) DESC

Question 28.
The command to eliminate the table CUSTOMER from a database is:
(a) REMOVE TABLE CUSTOMER
(b) DROP TABLE CUSTOMER
(c) DELETE TABLE CUSTOMER
(d) UPDATE TABLE CUSTOMER
Answer:
(b) DROP TABLE CUSTOMER

Question 29.
Which SQL command is used to open a database?
(a) OPEN
(b) SHOW
(c) USE
(d) CREATE
Answer:
(c) USE

Question 30.
Which is the keyword used with SELECT command to avoid duplication of rows in the selection?
Answer:
DISTINCT

Question 31.
Pick odd one out and write reason:
(a) WHERE
(b) ORDER BY
(c) UPDATE
(d) GROUP BY
Answer:
UPDATE. It is a command and others are clauses.

Question 32.
Which of the following clause is not used with SELECT command in SQL?
(a) GROUP BY
(b) WHERE
(c) SET
(d) ORDER BY
Answer:
(c) SET. This clause is used with UPDATE.

Question 33.
……………… operator in SQL is used with wild card characters for selection of records.
(a) LIKE
(b) IN
(c) NOT IN
(d) IN and NOT IN
Answer:
(a) LIKE

Plus Two Computer Science Structured Query Language Two Mark Questions and Answers

Question 1.
How is SQL different from other computer high-level languages?
Answer:
SQL means Structured Query Language. It is a relational database language, not a programming language like other high-level languages. It provides facilities to create a table, insert data into a table, retrieve information from a table, modify data in the table, etc.

Question 2.
Distinguish the SQL keywords UNIQUE and DISTINCT.
Answer:
1. Unique – It ensures that no two rows have the same value in a column while storing data. It is used with create command.

2. Distinct – This keyword is used to avoid duplicate values in a column of a table while retrieving data. It is used with select command.

Question 3.
Identify errors in the following SQL statement and rewrite it correctly. Underline the corrections.
CREATE student TABLE (admno PRIMARY KEY, roll no INT, name CHAR);
Answer:
The correct SQL statement is as follows.
CREATE TABLE student( admno INT PRIMARY KEY, roll_no INT, name CHAR(3));

Question 4.
Suppose a column named Fee does not contain any value for some records in the table named STUDENT. Write SQL statements to fill these blanks with 1000.
Answer:
UPDATE STUDENT SET Fee = 1000 WHERE Fee IS NULL;

Question 5.
Identify the errors in the following SQL statement and give reason for the error.
SELECT FROM STUDENT ORDER BY Group WHERE Marks above 50;
Answer:
In this query Group is the keyword hence it cannot be used. The correct query is as follows.
SELECT * FROM STUDENT WHERE Marks > 50 ORDER BY Marks;

Question 6.
Differentiate CHAR and VARCHAR data types of SQL.
Answer:

1. Char – It is used to store fixed number of characters. It is declared as char(size).
2. Varchar – It is used to store characters but it uses only enough memory.

Question 7.
Assume that CUSTOMER is a table with columns Cust_code, Cust_name, Mob_No and Email. Write an SQL statement to add the details of a customer who has no e-mail id.
Answer:
INSERT INTO CUSTOMER VALUES(1001, ‘ALVIS’, 9447024365, NULL);

Question 8.
Find the correct clause from the 2nd column for each SQL command in the 1_st column.

Answer:

Question 9.
Is ALL a keyword in SQL? Explain
Answer:
Yes, ALL retains all the duplicate values of a field

Question 10.
Differentiate LIKE ‘a%’ and LiKE ‘a_’
Answer:
%, it replaces a string but _ replaces only one character at a time.LIKE ‘a%’ retrieve all strings of any length that start with letter ‘a’ while LIKE ‘a_’ retrieve all two letter strings that start with letter ‘a’.

Question 11.
Is multiple sorting possible using ORDER BY clause? Explain
Answer:
Yes, by giving multiple field names separated by comma in the ORDER BY clause.

Question 12.
While inserting records into a table, Raju finds it is not possible to give more than 20 characters in the ‘name’ field. How can you help Raju solve this problem?
Answer:
Using ALTER TABLE command he can modify the width of field so that it can accommodate more than 20 characters.

Question 13.
After executing a query Mohan gets a message like ‘Table Altered’. What would have he done? Give the syntax.
Answer:
He would have used the ALTER TABLE command.
Syntax: ALTER TABLE ADD/MODIFY ();

Question 14.
During discussion one student said that DELETE and DROP TABLE commands are same. Do you agree with that? Justify.
Answer:
No, DROP TABLE removes a table entirely from the database whereas DELETE command deletes only records from an existing table.

Question 15.
1. Pick odd one out.
DROP TABLE, DELETE, ALTER TABLE, CREATE VIEW
2. Justify your answer
Answer:

1. DELETE
2. All others are DDL commands

Question 16.

1. Pick odd one out from the following.
2. Justify your answer.

Answer:

1. Group By
2. Group By is not a Constraint.

Question 17.
Consider the following SQL statements.
DELETE Name.
From Student
Where name = ‘Raju”
Find the error in the SQL if any and correct it.
Answer:
Delete from student where name = ‘Raju’

Question 18.
Consider the following Query in SQL.
From Employee Where branch = ‘Kannur’ Group By Department Having avg (salary) > 7000, Compare the ‘where’ clause and ‘Having’ Clause using the above query.
Answer:
‘where’ clause applies on single rows but Having clause applies on a group.

Question 19.
Some constraints in SQL are called column constraints. Some constraints are called table constraints. How do they differ?
Answer:
Column constraints are specified while defining each column, table constraints are specified once for the entire table at the end of table definition

Question 20.
1. Choose the odd one from the following.
Primary key, Unique, Distinct, Default, Check
2. Justify your choice
Answer:

1. Distinct
2. Distinct is used with select command while others are column constraints of create table command.

Question 21.
Name the most appropriate SQL data type required to store the following data.

1. Name of a student
2. Date of Birth of a student.
3. RollNo. of a student (in the range 1 to 50)
4. Percentage of marks obtained

Answer:

1. Varchar(70)
2. Date
3. Smallint OR Integer Or decimal
4. Dec(5, 2)

Question 22.
1. From the list given below select the names that cannot be used as a table name.
Adm_No, Date, Salary2006, Table, Column_Name, Address.
2. Justify your selection.
Answer:

1. Date, Table
2. There is a data type Date and Table is a keyword used to create a table. So these two are not used.

Question 23.
Classify the following SQL elements into two and give proper title for each category.
NOT NULL, AVG, COUNT, CHECK, SUM, DEFAULT
Answer:

Plus Two Computer Science Structured Query Language Three Mark Questions and Answers

Question 1.
As a part of your school project, you are asked to create a table Student with the fields RollNo, Name, Date of Birth and Score in IT. The constraints required are RollNo. is the primary key. Name cannot be empty.
Answer:
Create table student(RollNo decimal(2) not null primary key, Name varchar(20) not null, DOB date, Score number(2));

Question 2.
A table Employee consists of fields EmployeeNo, Name, Designation and Salary.
Consider that you are forced to give access to this table for an engineer from another company. But for security reasons you need to hide Salary from him. Employee No, Name, Designation, Salary.

1. Name the concept that provides this engineer, a facility to work on this table without viewing salary. Salary view
2. Write SQL query for implementing this SQL query

Answer:

1. Views
2. Create view Empview as select employeeno, Name, Designation from Employee.

Question 3.
Explain the keywords in the following query.
Answer:
SELECT allows to retrieve a subset of rows from the table, DISTINCT avoids duplication of courses from the table STUDENT, FROM is a keyword used to specify the name of the table

Question 4.
A table named student is given below.

Write answers for the questions based on the above table.

1. SQL statement to display the different courses available without duplication.
2. SQL statement to display the Name and Batch of the students whose percentage has a null value.
3. Output of the query select count (percentage) from Student.

Answer:

1. Select distinct batch from Student;
2. Select name, batch from Student where percent is null
3. 5

Question 5.
Once the creation of a table is over, one can perform two changes in the schema of the table. What are they? Give syntax.
Answer:
We can alter the table in two ways.
1. We can add a new column to the existing table using the following
syntax: ALTER TABLE ADD( );

2. We can also change or modify the existing column in terms of type or size using the following
syntax: ALTER TABLEMODIFY( );

Question 6.
Explain how pattern matching can be done in SQL with an example.
Answer:
pattern matching can be done using the operator LIKE while setting the condition with pattern matching. for eg., to display the names of all students whose name begins with letters ‘ma’, we can write the following query, SELECT name FROM STUDENT WHERE name LIKE ‘ma%’; here the character ‘%’ – substitutes any number of characters in the value of the specified column. Another character substitutes only one character of the specified column.

Question 7.
During the discussion of study your friend say that table and view are the same. How can you correct him?
Answer:
Tables and views are different. A view is a single virtual table that is derived from other physically existing tables. When we access a view we actually access the base tables.

We can use all the DML commands with the views but care should be taken as operation actually reflects in the base tables. The advantage of view is that without sparing extra storage space, we can use same table as different virtual tables. It also implements sharing along with privacy.

Question 8.
Find the errors if any of the following code.
Create table emp (name char, RolINo int(20));
Answer:
Here the argument size of data type char of field name is missing. So we can store a character only. The second error is the data type int has no argument. The correct statement is as follows Create table emp (name char(20), RolINo int);

Question 9.
Consider the following variable Declaration in SQL.
a. name char (25)
b. name Varchar (25)

1. Considering the utilisation of memory, which variable declaration is more suitable.
2. Justify your answer

Answer:
1. name varchar (25)
2. Because char data type is fixed length. It allocates maximum memory i.e, here it allocates memory for 25 characters maybe there is a chance of memory wastage. But Varchar allocates only enough memory to store the actual size.

Question 10.
Mr. Dilip wants to construct a table and implement some restrictions on the table.

1. Column can never have empty values.
2. One of the columns must be a key to identify the rows etc.

Can you help him to create that table satisfying the above restrictions with an example
Answer:

1. Use of create table, Not NULL.
2. Primary key Eg: Create table employee(RollNo decimal(3) not null primary key,Name Varchar(70) not null, Design Varchar(30), DOB Date,Salary Dec(7,2));

Question 11.
Write SQL query to construct a table student with fields Reg No, Stud Name, Sex, Course, grade, etc. As per the following conditions

1. Reg No should not be empty and using this column any rows in that table can be identified. Reg. No.
2. Student name should have some value.
3. Default value of sex be Female.
4. Grade should be any of the values: A+, A, B+, B, C+, C, D+, D, E

Answer:
Create table Student(RollNo decimal(3) not null primary key, Name Varchar(70) not null, sex char default ‘Female’,Grade char(2));

Question 12.
Ramu create Table employee with fields empId, empname, Designation, salary using SQL statements. Later he found that data type of emPId is typed as Integer instead of character and missed a field ‘Department’. Can you help him to solve this problem without recreating ‘employee’ table?
Answer:
Alter Table Employee Modify(Empld char(4)); AlterTable Employee Add(Dept char(15));

Question 13.
While creating a table Alvis give “Emp Details” for table name. Is it Possible? Write down the rules for naming a Table.
Answer:
It is not possible because there is a space between Emp and Details. The rules are given below:

1. It must not be a keyword(Keywords are reserved words and have predefined meaning)
2. It must begin with alphabets
3. Digits can be used followed by alphabets
4. Special characters cannot be used except underscore
5. We cannot give the name of another table

Plus Two Computer Science Structured Query Language Five Mark Questions and Answers

Question 1.
Consider the table ITEMS.

a) SELECT ITEMCODE, NAME FROM ITEMS WHERE CATEGORY = ‘Stationery’;
b) SELECT * FROM ITEMS WHERE SALES_ PRICE < UNIT_PRICE;
c) SELECT CATEGORY, COUNT(*) FROM ITEMS GROUP BY CATEGORY;
Answer:

Question 2.
Write SQL queries to SQL Query to
1. Create a table Employee with the fields given below.

2. List the name of all employees whose name’s second letter is ‘a’.
3. List the Name and Designation of employees whose Designation is not ‘Manager’
4. Increase the salary of ail employees by 10 percent.
5. Remove all managers whose salary is less than Rs. 10,000 from the table.
Answer:

1. Create table employee(Name Varchar(70), Desgn Varchar(30), DOB Date, Salary Dec(7,2));
2. Select Name from Employee where Name like
3. Select Name, Desgn from Employee where Desg no’Manager’;
4. Update Employee set Salary = Salary + Salary * .01;
5. Delete from Employee where Desgn = ‘Manager’ and Salary < 10000;

Question 3.
A table Student consists of fields Roll No, Name, Batch and Percent. Write SQL statements to

1. Display RolINo and Name of students whose percentage is Iessthan90 and greater than 70.
2. Display RolINo and Name of all students in science batch whose percentage is more than 90.
3. Display Names of all students in commerce and science batches.
4. Display the average Percent of students in each batch.
5. Display RolINo and Name in the ascending order of Batch and descending order of Percent.

Answer:

1. Select RollNo, Name from Student where percent < 90 and percent > 70;
2. Select RollNo, Name from Student where Batch = ’Science’ and percent > 90;
3. Select Name from Student where batch = ’Science’ Or ’batchCommerce’;
4. Select batch, Avg(percent) from Student group by batch;
5. Select RollNo, Name from Student order by batch, percent desc;

Question 4.
1. Classify the following SQL commands.
Create table, Insert Into, AlterTable, Delete, Up-date, Drop Table, Select.
2. List the features of each category.
Answer:
1. DDL – Create Table, Alter Table, Drop Table.
DML- Insert Into, Delete, Update, Select.

2. DDL – DDL means Data Definition Language. It is used to create the structure of a table, modify the structure of a table and delete the structure of a table. DML -DML means Data Manipulation Language. It is used to insert records into a table, modify the records of a table, delete the records of a table and retrieve the records from a table.

Question 5.
Explain the available database integrity constraints.
Answer:
1. NOT NULL: it specifies that a column can never have null values, i.e., not empty

2. UNIQUE: it ensures that no two rows have same value in the specified column.

3. PRIMARY KEY: it declares a column or a set of columns as the primary key of the table. This constraint makes a column NOT NULL and UNIQUE.

4. DEFAULT: it sets a default value for a column when the user does not enter a value for that column.

5. Auto_increment: This constraint is used to perform auto increment the values in a column. That automatically generates serial numbers. Only one auto-increment column per table is allowed.

Question 6.
Consider a table student with fields Reg No, Stud Name, Sex, Course, total score.
Write SQL queries for the following:
RegNo, Studname, Sex, Course, Total score.

1. Enter a Record
2. List the Detail’s of all students
3. Display Details of the student whose name ends with ‘Kumar’.
4. List all Female students who got more than 50 marks.
5. List all students who are studying either science or in Commerce group.
6. List details of those students who are studying Humanities in the Descending order of their names.

Answer:

1. Insert into Student values (52, ‘JOSE’, ‘Male’, ‘Science’, 500);
2. Select*from Student;
3. Select* from Student where name like ’%Kumar’;
4. Select * from Student where sex=’Female’ and Total >50;
5. Select * from Student where course = ‘science’ or course =‘commerce’;
6. Select* from Student where course-‘Humanities’ order by name desc;

Question 7.
Construct a Table Product with the following fields using SQL.
Product code – Consist of Alphanumeric code.
Product name – Consist of maximum of 30 Alphabets
Unit price – Numeric values
Quantity – Numeric values
Product price – Numeric Values
Write Query for the following:

1. Enter 5 records in the table (not give values for product prices)
2. Calculate product price (unit price × quantity)
3. List all product whose unit price ranging from 10 to 20
4. Calculate total price of all products.

Answer:
Create table Product(ProdCode Varchar(20) not null primary key, ProdName char(30), UPrice decimal(7,2), Qty decimal(6), ProdPrice decimal(7,2));

1. Insert into Product(Product Code,Product Name, Unit Price, Quantity) values (‘101 ’, ‘LUX’, 29.50,500); Similarly insert four more records
2. Update Product set ProdPrice=Qty * UPrice;
3. Select ProdName from Product where UPrice be-tween 10 and 20;
4. Select sum(ProdPrice) from Product;

Question 8.
Mr. Wilson wants to store the details of students. The details consist of different types of data. Explain different data types used in SQL to store data.
Answer:
The different data types are
1. Char (Fixed):
It is declared as char (size). This data type is used to store alphanumeric characters. We have to specify the size. If no size is specified, by default we can store only one character. Eg: name char(20)

2. Variable Character:
It is declared as varchar (size). This data type is also used to store alphanumeric characters. But there is a slight difference. lt allocates only enough memory to store the actual size.
Eg: name varchar(20)

3. Decimal:
It is declared as Dec(size, scale), where size is the number of digits and scale is the maximum number of digits to the right of the decimal point.
Eg: weight dec(3, 2)

4. Integer:
It is declared as int. It does not have any arguments. It takes more memory. Eg: ROllNO int.

5. Small Integer:
It is declared as smallint. It takes less memory ROllNO int.

6. Date:
It is used to store date. Eg: DOB date.

7. Time:
It is used to store time. Eg: Joining_Time Time.

Question 9.
A company wants to create a table to store its employees details. Write SQL Commands for the following :

1. Create a table with EMP table having fields EMPNO primary key varchar(10), Name varchar(20), Salary number(6), Department varchar(3)
2. Insert values to table
3. List all employees whose salary > 10,000 Salary 10,000
4. Display name and salary in the order of name.

Answer:

1. Create table EMP (EMPNO varchar(10) not null primary key, Name varchar(20), Salary decimal(6), Deptvarchar(3));
2. Insert into EMP values (‘1001 ’, ‘ALVIS’, 50000, ‘Sales’);
3. Select * from EMP where salary > 10000;
4. Select name, salary from EMP order by name;

Question 10.
Create a table ‘Savings’ with the following fields. Acc No (Integer), Name (char), age (Integer) and balance (Number) where Acc No is the primary key. Write SQL commands for the following.

1. Insert data in all the fields for 3 records inserted
2. Display the list of account holders in the ascending order Of their names.
3. Display the list of all account holders having age between 20 and 30
4. Display the name and Acc No of customers having a balance > 10 lakhs

Answer:
Create table Savings(Accno decimal(4) not null primary key, name char(2), age decimal(3), Balance decimal(8, 2));

1. Insert into savings values (501, ‘Andrea’, 18,45000)
2. Select * from Savings order by name
3. Select * from Savings where age between 20 and 30
4. Select name.accno from Savings where balance >100000

Question 11.
Which are the components of SQL? How do they help to manage database?
Answer:
The components of SQL are given below.
a. DDL commands ( 3 commands):

1. Create table – Used to create a table.
2. Alter table – Used to modify existing column or add new column to an existing table. There are 2 keywords used ADD and MODIFY.
3. Drop table – Used to remove a table from the memory.

b. DML commands ( 4 commands):

1. Select – Used to select rows from a table. The keyword From is used with this. Where clause is used to specify the condition.
2. Insert – Used to insert new records into a table. So the keyword used is INTO.
3. Delete – Used to delete records in a table.
4. Update – Used to modify the records in a table the keyword used is set.

c. DCL (Data Control Language) commands:

1. Grant – It grants permission to the users to the database
2. Revoke – It withdraws user’s rights given by using Grant command

Students can Download Chapter 5 Continuity and Differentiability Questions and Answers, Plus Two Maths Chapter Wise Questions and Answers helps you to revise the complete Kerala State Syllabus and score more marks in your examinations.

Kerala Plus Two Maths Chapter Wise Questions and Answers Chapter 5 Continuity and Differentiability

Plus Two Maths Continuity and Differentiability Three Mark Questions and Answers

Question 1.
Consider the function g(x) = \(\frac{|x-2|}{x-2}\)

1. Find the domain and range of the function g(x). (2)
2. Check whether the g(x) is continuous at x = 2. (1)

Answer:
1. The function is not defined at points where denominator is zero.
i.e., x – 2 = 0 ⇒ x = 2.
∴ domain is R – {2}.
g(x) = \(\frac{|x-2|}{x-2}\) = \(\left\{\begin{array}{c}{\frac{x-2}{x-2}, \quad x-2>0} \\{\frac{-(x-2)}{x-2}, \quad x-2<0}\end{array}=\left\{\begin{array}{ll}{1,} & {x>2} \\{-1,} & {x<2}\end{array}\right.\right.\)
∴ range is {-1, 1}

2. The function g(x) is not defined at x = 2. Therefore discontinuous.

Question 2.
(i) If f(x) = x+|x| + 1, then which of the follow represents f (x) (1)


(ii) Test whether f (x) is continuous at x=0. Explain. (2)
Answer:
(i) (b) Since, f(x) = \(\left\{\begin{array}{c}{x+x+1, x \geq 0} \\{x-x+1, \quad x<0}
\end{array}=\left\{\begin{array}{c}{2 x+1, x \geq 0} \\{1, x<0}\end{array}\right.\right.\)

(ii) We have ,f (0) = 1,

Continuous at x = 0.

Question 3.
Consider the function f(x) = \(\left\{\begin{array}{ll}{\frac{\sin x}{x}} & {, x<0} \\{x+1} & {, x \geq 0}\end{array}\right.\)

1. Find \(\lim _{x \rightarrow 0} f(x)\) (2)
2. Is f (x) continuous at x= 0? (1)

Answer:
1. To find \(\lim _{x \rightarrow 0} f(x)\) we have to find f(0^– )and f(0⁺)
f(0^–) = \(\lim _{x \rightarrow 0} \frac{\sin x}{x}=1\),
f(0⁺) = \(\lim _{x \rightarrow 0}\) + 1 = 0 + 1 = 1
f(0^–) = f(0⁺) = 1 .Therefore \(\lim _{x \rightarrow 0} f(x)\) = 1

2. Here, f (0) = 0 + 1 = 1 = f(0^–) = f(0⁺) = 1
Therefore continuous at x = 0.

Question 4.
Consider the figure and answer the following questions.

(i) Identify the graphed function. (1)


(ii) Discuss the continuity of the above function at x = 2. (2)
Answer:
(i) (b) f(x) = \(\left\{\begin{array}{ll}{\frac{|x-2|}{x-2},} & {x \neq 2} \\{0,} & {x=2}\end{array}\right.\)

(ii) From the figure we can see that
f(2^–) = 1, f(2⁺) = -1 and f(2) = 0
Therefore, f(2^–) = 1 ≠ f(2⁺) = -1 ≠ f(2) = 0. Discontinuous.

Question 5.
Consider f(x) = \(\left\{\begin{array}{ll}{2 x} & {\text { if } x<2} \\{2} & {\text { if } x=2} \\ {x^{2}} & {\text { if } x>2}\end{array}\right.\)
(a) Find \(\lim _{x \rightarrow 2^{-}} f(x)\) and \(\lim _{x \rightarrow 2^{+}} f(x)\) (2)
(b) f(x) is continuous. If not so, how can you make it continuous. (1)
Answer:


Therefore f(x) is not continuous at x = 2.
If f(2) = 4, then f(x) becomes continuous.

Question 6.
If y = log₁₀x + log_x10 + log_xx + log₁₀10. Find \(.
Answer:
y = log_e x log₁₀e + log_e10 log_xe + 1 + 1

Question 7.
Examine the continuity of the function

Answer:
In both the intervals x = 1 and x < 1 the function f(x) is a polynomial so continuous. So we have to check the continuity at x = 1.

f(1) = 2
Since

f(x) is continuous at x = 1.

Question 8.
Find [latex]\frac{d y}{d x}\) of the following (3 score each)

1. 2x + 3y = sinx
2. xy + y² = tanx + y
3. x³ + x²y + xy² + y³ = 81
4. sin²x + cos²y = 1
5. \(\sqrt{x}\) + \(\sqrt{y}\) = 1
6. x² + xy + y² = 7
7. x²(x – y) = y²(x + y)
8. xy² + x²y = 2
9. sin y = xcos (a + y)

Answer:
1. Given; 2x + 3y = sinx
Differentiating with respect to x;

2. Given; xy + y² = tanx + y
Differentiating with respect to x;

3. Given; x³ + x²y + xy² + y³ = 81
Differentiating with respect to x;

4. Given; sin²x + cos²y = 1
Differentiating with respect to x;

5. \(\sqrt{x}\) + \(\sqrt{y}\) = 1
Differentiating with respect to x;

6. x² + xy + y² = 7
Differentiating with respect to x;

7. x²(x – y) = y²(x + y)
Differentiating with respect to x;

8. xy² + x²y = 2
Differentiating with respect to x;

9. sin y = xcos (a + y)
⇒ x = \(\frac{\sin y}{\cos (a+y)}\)
Diff. with respect to y.

Question 9.
Find \(\frac{d y}{d x}\) of the following (3 score each)

(viii) x = a(t – sint), y = a(1 – cost)
(ix) y = e^t cost, x = e^t sint.
Answer:
(i) We know; y = sin^-1\(\left(\frac{2 x}{1+x^{2}}\right)\)
⇒ y = = 2 tan^-1(x)
Differentiating with respect to x;

(ii) We know; y = tan^-1\(\left(\frac{3 x-x^{3}}{1-3 x^{2}}\right)\)
Put x = tanθ ⇒ θ = tan^-1x

⇒ y = tan^-1(tan3θ)
⇒ y = 3 tan^-1(x)
Differentiating with respect to x;

(iii) We know; y = sin^-1\(\left(\frac{1-x^{2}}{1+x^{2}}\right)\)
Put x = tanθ ⇒ θ = tan^-1x

(iv) We know; y = sec^-1 = \(\left(\frac{1}{2 x^{2}-1}\right)\)
Put x = cosθ ⇒ θ = cos^-1x

⇒ y = sec^-1 sec2θ = 2θ
⇒ y = 2cos^-1(x)
Differentiating with respect to x;

(v) ∴ y = tan^-1\(\sqrt{\tan ^{2} x / 2}\) = tan^-1 tanx/2 = x/2
\(\frac{d y}{d x}=\frac{1}{2}\).

= π – 2tan^-1x
\(\frac{d y}{d x}=\frac{-2}{1+x^{2}}\).

(vii) Let x = sinθ and \(\sqrt{x}\) = sinφ

= sin^-1 (sinθcosφ + cosφsinφ)
= sin^-1 (sin(θ + φ)) = θ + φ
= sin^-1x + sin^-1\(\sqrt{x}\)
\(\frac{d y}{d x}=\frac{1}{\sqrt{1-x^{2}}}+\frac{1}{\sqrt{1-x}} \times \frac{1}{2 \sqrt{x}}\).

(ix) y = e^tcost ⇒ \(\frac{d y}{d t}\) = – e^t sin t + e^t
x = e^t sint ⇒ \(\frac{d x}{d t}\) = e^t cos t + e^t sin t

Question 10.
If y = log\(\left(\frac{1}{x}\right)\), Show that \(\frac{d y}{d x}\) + e^y = 0.
Answer:
Given, y = log\(\left(\frac{1}{x}\right)\) ? \(\left(\frac{1}{x}\right)\) = e^y …….(1)

Question 11.
If e^y (x+1) = 1. Show that

1. \(\frac{d y}{d x}\) = -e^y (2)
2. \(\frac{d^{2} y}{d x^{2}}=\left(\frac{d y}{d x}\right)^{2}\) (1)

Answer:
1. e^y (x+1) = 1
Differentiating e^y +e^y(x +1) \(\frac{d y}{d x}\) = 0

2.

Question 12.
(i) Evaluate \(\lim _{x \rightarrow 0} \frac{k \cos x}{\pi-2 x}\) (2)
(Hint: Put π – 2x = y , where Iris a constant)
(ii) Find the value of k if f (x) is a continuous function given by (1)

Answer:
(i) \(\lim _{x \rightarrow \pi / 2} \frac{k \cos x}{\pi-2 x}=k \lim _{x \rightarrow \pi / 2} \frac{\cos x}{\pi-2 x}\),
Put π – 2x = y when Put x → π/2, y → 0

(ii) Since f (x) is continuous

Question 13.
If f(x) \(f(x)=\left\{\begin{array}{cc}{x-[x]} & {, x<.2} \\{0} & {; x=2} \\{3 x-5} & {, x>2}
\end{array}\right.\)

1. Find \(\lim _{x \rightarrow 2} f(x)\) (2)
2. Is f(x) continuous at x = 2? (1)

Answer:
1. To find \(\lim _{x \rightarrow 2} f(x)\)
we have to find f(2^–) and f(2⁺)
f(2^–) = \(\lim _{x \rightarrow 2} x-[x]\) = 2 -1 = 1,
f(2⁺) = \(\lim _{x \rightarrow 2}\) 3x – 5 = 6 -5 = 1
f(2^–) = f(2⁺) = 1.
Therefore \(\lim _{x \rightarrow 2}\) f(x) = 1

2. Here, f(2) = 0 ≠ f(2^–) = f(2⁺) = 1.
Therefore discontinuity at x = 2.

Plus Two Maths Continuity and Differentiability Four Mark Questions and Answers

Question 1.
If x = 2cosθ; y = 3sinθ

1. Find \(\frac{d y}{d x}\).
2. Find \(\frac{d^{2} y}{d x^{2}}\)

Answer:
1. x = 2cosθ ⇒ \(\frac{d x}{d θ}\) = -2sinθ
y = 3sinθ ⇒ \(\frac{d x}{d θ}\) = 3cosθ

2.

Question 2.
If y = (tan^-1 x)², show that (x² +1)² y₂ + 2x(x² +1) y₁ = 2.
Answer:
y = (tan^-1 x)²
⇒ y₁ = 2(tan^-1 x) \(\frac{1}{1+x^{2}}\)
⇒ (1 + x²)y₁ = 2(tan^-1 x)
⇒ (1 + x²)y₂ + y₁2x = 2 \(\frac{1}{1+x^{2}}\)
⇒ (1 + x²)² y₂ + x(1 + x²)y₁ = 2.

Question 3.
Find \(\frac{d y}{d x}\) if y = sin^-1 \(\left(\frac{1-x^{2}}{1+x^{2}}\right)\), 0 < x < 1.
Answer:
Put x = tanθ

Question 4.
Let f(x) = \(\left\{\begin{array}{ll}{\cos x,} & {0 \leq x \leq c} \\{\sin x,} & {c<x \leq \pi}\end{array}\right.\)

1. Find the value of c if / is continuous on [0, π].
2. Show that is f not differentiable at the point c.

Answer:
1. Since f is continuous on [0, π], we have;
\(\lim _{x \rightarrow c^{+}}\) f(x) = \(\lim _{x \rightarrow c^{-}}\) f(x) = f(c)
⇒ \(\lim _{x \rightarrow c^{+}}\) sinx = \(\lim _{x \rightarrow c^{-}}\) cosx = cosc
⇒ sinc = cosc ⇒ c = \(\frac{π}{4}\).

2. \(f^{\prime}(x)=\left\{\begin{array}{ll}{-\sin x,} & {0 \leq x \leq c} \\{\cos x,} & {c<x \leq \pi}\end{array}\right. \)
Left derivative at \(\frac{\pi}{4}\) = – sin \(\frac{\pi}{4}\) = –\(\frac{1}{\sqrt{2}}\)
Right derivative at \(\frac{\pi}{4}\) = cos \(\frac{\pi}{4}\) = \(\frac{1}{\sqrt{2}}\)
Left derivative at \(\frac{\pi}{4}\) ≠ Right derivative at \(\frac{\pi}{4}\)
Therefore is not differentiable at the point c.

Question 5.

1. Find \(\frac{d y}{d x}\) if x = 2sinθ; y = 3cosθ
2. Which among the following functions is differentiable on R?

(a) |sinx|
(b) |cosx|
(c) cos|x|
(d) sin|x|
Answer:
1. \(\frac{d x}{d θ}\) = 2cosθ; \(\frac{d y}{d θ}\) = -3 sinθ ⇒ \(\frac{d y}{d x}\) = \(-\frac{3}{2}\)tanθ

2. (c) cos|x|
(Since cos x is an even function, it treats x and -x in the same way).

Question 6.
(i) Examine whether the function defined by \(f(x)=\left\{\begin{array}{ll}{x+5,} & {x \leq 1} \\{x-5,} & {x>1}\end{array}\right.\) is continuous or not. (2)
(ii) If x = ^sin-1t, y = ^cos-1t, a > 0, show that \(\frac{d y}{d x}=-\frac{y}{x}\)
Answer:

f(x) is not continuous.

Question 7.
(i) If \(f(x)=\left\{\begin{array}{ll}{1-x,} & {0 \leq x \leq 1} \\{1+x,} & {1<x \leq 2}\end{array}\right.\) then which of the following is not true (1)
(a) f is continuous in ( 0, 1 )
(b) f is continuous in (1, 2 )
(c) f is continuous in [ 0, 2 ]
(d) f is continuous in [ 0,1 ]
if \(\left\{\begin{array}{cc}{1,} & {x \leq 3} \\{a x+b} & {, \quad 3<x<5} \\{7,} & {5 \leq x}\end{array}\right.\)
(ii) Find f(3⁺) and f(5^–) (1)
(iii) Hence find the value of ‘a’ and ‘b’ so that f(x) is continuous. (2)
Answer:
(i) (c) Since f is not continuous at x = 1.

(iii) Since f (x) is continuous, it is continuous at x = 3 and x = 5
∴ f(3⁺) = f(3) ⇒ 3a + b = 1 ____(1)
and f(5^–) = f(5) ⇒ 5a + b = 7 ____(2)
(2) – (1) ⇒ 2a = 6, a = 3
(1) ⇒ b = 1 – 3 a ⇒ b = -8
∴ a = 3, b = – 8.

Question 8.
Consider f(x) = \(\left\{\begin{array}{ll}{2 x+3,} & {x \leq 2} \\{x+2 k,} & {x>2}\end{array}\right.\)

1. Find f(2) (1)
2. Evaluate \(\lim _{x \rightarrow 2^{+}}\)f(x) (1)
3. Find the value of k, if is continuous at x = 2. (2)

Answer:
1. f(2) = 2(2) + 3 = 7

2. Here, f(x) = x + 2k for x > 2.
\(\lim _{x \rightarrow 2^{+}}\)f(x) = \(\lim _{x \rightarrow 2}\)(x + 2k) = 2 + 2k.

3. Since f (x) is continuous at x = 2
We have, f(2) = \(\lim _{x \rightarrow 2^{+}}\)f(x)
⇒ 7 = 2 + 2k ⇒ k = \(\frac{5}{2}\)

Question 9.
Find \(\frac{d y}{d x}\) of the following (4 score each)

1. y = (logx)^cosx
2. x = 2at², y = at⁴
3. x = a(cosθ + θsinθ), y = a(sinθ – θcosθ)
4. y=x^x
5. y =(x log x)^log(logx)
6. y = \(\sqrt{\sin x \sqrt{\sin x+\sqrt{\sin x+\ldots .}}}\)
7. y^x = x^siny
8. y =(log x)^x + x^logx
9. y = (sinx)^x + sin^-1 \(\sqrt{x}\)

Answer:
1. Given; y = (logx)^cosx, taking log on both sides;
log y = cosxlog(logx),
Differentiating with respect to x;

2. Given; x = 2at² ⇒ \(\frac{d x}{d t}\) = 4at

3. Given; x = a(cosθ + θsinθ)
\(\frac{d x}{d \theta}\) = a(-sinθ + θcosθ + sinθ) = aθcosθ
y = a(sinθ – θcosθ)
\(\frac{d x}{d \theta}\) = a(cosθ – θ(-sinθ) – cosθ) = aθ sinθ
\(\frac{d y}{d x}=\frac{a \theta \sin \theta}{a \theta \cos \theta}=\tan \theta\)

4. y= x^x; Taking log on both sides;
log y = x log x

5. y = (x log x)^{log logx}
Taking log on both sides;
log y = (log log x) [log (xlogx)]

6. y = \(\sqrt{\sin x+y}\) ⇒ y² = sinx + y
⇒ y² – y = sinx

7. y^x = x^{sin y};
Taking log on both sides;
xlogy = siny log x

8. y = (log x)^x + x^logx = u + v

9. y = (sinx)^x + sin^-1\(\sqrt{x}\)
Let u = (sinx)^x ⇒ log u = x log sinx

Question 10.
Find \(\frac{d^{2} y}{d x^{2}}\) of the following

1. y = x² + 3x + 2 (2)
2. y = tan^-1x (2)

Answer:
1. Given; y = x² + 3x + 2
Differentiating with respect to x;
\(\frac{d y}{d x}\) = 2x + 3
Differentiating again with respect to x;
\(\frac{d^{2} y}{d x^{2}}\) = 2.

2. Given; y = tan^-1x
Differentiating with respect to x; \(\frac{d y}{d x}\) = \(\frac{1}{1+x^{2}}\)
Differentiating again with respect to x;
\(\frac{d^{2} y}{d x^{2}}\) = \(-\frac{1}{\left(1+x^{2}\right)^{2}} \cdot 2 x\).

Question 11.
Match the following. (4)

Answer:

Question 12.
If x – sint and y = sinmt show that
(i) y = sin(m sin^-1x) (1)
(ii) \(\frac{d y}{d x}\) (1)
(iii) (1 – x²) y₂ – xy₁ + m²y = 0 (2)
Answer:
(i) x = sint, y = sinmt
t = sin^-1x ⇒ y = sin(msin^-1x).


multiplying with \(\sqrt{1-x^{2}}\)
(1 – x²) y₂ – xy₁ = -m²y
(1 – x²) y₂ – xy₁ + m²y = 0.

Question 13.
Consider the function f(x) = x(x – 2), x ∈ [1, 3]. Verify mean value theorem for the function in[1, 3].
Answer:
f(x) = x(x – 2) = x² – 2x ⇒ f'(x) = 2x – 2.
As f is a polynomial, it is continuous in the interval [1, 3] and differentiable in the interval (1, 3).
Therefore two conditions of MVT are satisfied and so there exists c ∈ (1,3)such that.

Hence MVT is verified.

Question 14.
Verify Lagranges’ Mean value theorem for the function f(x) = 2x² – 10x + 29 in [2, 9]
Answer:
f(x) = 2x² – 10x + 29; f'(x) = 4x – 10.
As f is a polynomial, it is continuous in the interval [2, 9] and differentiable in the interval (2, 9).
Therefore two conditions of MVT are satisfied and so there exists c ∈ (2, 9) such that.

Hence MVT is verified.

Question 15.
Let f(x) = x(x – 1)(x – 2), x ∈ [0, 2]

1. Find f(0) and f(2) (1)
2. Find f'(x) (1)
3. Find the values of x when f'(x) = 0 verify Rolle’s theorem. (2)

Answer:
1. f(0) = 0, f(2) = 2(2 – 1)(2 – 2) = 0

2. We have, f(x) = x³ – 3x² + 2x
⇒ f'(x) = 3x² – 6x + 2.

3. f'(x) = 3x² – 6x + 2 = 0

Clearly all the three conditions of Rolle’s theorem are satisfied and 1 ± \(\frac{1}{\sqrt{3}}\) ∈ (0, 2).

Question 16.
Verify Rolle’s Theorem for the function
f(x) = x² + 2x – 8, x ∈ [-4, 2]
Answer:
f(x) = x² + 2x – 8, f'(x) = 2x + 2.
As f is a polynomial, it is continuous in the interval [-4, 2] and differentiable in the interval (-4, 2).
f(-4) = 16 – 8 – 8 = 0
f(2) = 4 + 4 – 8 = 0
f'(c) = 0 ⇒ 2c + 2 = 0 ⇒ c = -1 ∈ (-4, 2) Hence Rolle’s Theorem is verified.

Question 17.
Examine that Rolle’s Theorem is applicable to the following function in the given intervals, justify your answer.

1. f(x) = [x], x ∈ [5, 9]
2. f(x) = x² – 1, x ∈ [1, 2]

Answer:
1. The function f(x) = [x] is not differentiable and continuous at integral values. So in the given interval [5, 9] the function is neither differentiable nor continuous at x = 6, 7 ,8. Therefore Rolle’s Theorem is not applicable.

2. The function f(x) = x² – 1 is a polynomial function so differentiable and continuous.
f(1) = 1 – 1 = 0, f(2) = 4 – 1 = 3
f(1) ≠ f(2) . Therefore Rolle’s Theorem is not applicable.

Question 18.
Examine the continuity of the function
\(f(x)=\left\{\begin{array}{cc}{|x|+3,} & {x \leq-3} \\{-2 x,} & {-3<x<3} \\{6 x+2,} & {x \geq 3}\end{array}\right.\)
Answer:
In the intervals x ≤ -3, f(x) is the sum of a constant function and modulus function so continuous. In the intervals -3 < x < 3 and x ≥ 3the function f(x) is a polynomial so continuous. Hence we have to check the continuity at x = -3, x = 3.
At x = -3
f(-3) = 6

f(x) is continuous at x = -3.
At x = 3
f(3) = 6(3) + 2 = 20

Since \(\lim _{x \rightarrow 3^{-}}\)f(x) = f(3), f(x) is not continuous at x = 3.

Question 19.
Test continuity for the following functions.

Answer:

= 0 × a finite quantity between -1 and 1 = 0 Also f(0) = 0
Therefore f(x) is continuous at x = 0.

Therefore f(x) is discontinuous at x = 0

But f(1) = 2
∴ f(x) is discontinuous at x = 1.

Question 20.
If y = \(\frac{\sin ^{-1} x}{\sqrt{1-x^{2}}}\) prove that
(i) (1 – x²) y² = (sin^-1x)² (1)
(ii) (1 – x²)y₁ – xy = 1 (1)
(iii) (1 – x²) y₂ – 3xy₁ – y = 0 (2)
Answer:

(ii) Differentiating
(1 – x²) 2y.y₁ + y²x – 2x = \(\frac{2 \sin ^{-1} x}{\sqrt{1-x^{2}}}\)
(1 – x²)2yy₁ – 2xy² = 2y
(1 – x²) y₁ – xy = 1.

(iii) Again differentiating
(1 – x²) y₂ + y₁ x – 2x – xy₁ – y = 0
(1 – x²) y₂ – 3xy₁ – y = 0.

Question 21.
At what point on the curve y = x², x ∈ [-2, 2] at which the tangent is parallel to x-axis?
Answer:
Y = x², a continuous function on [-2, 2] and differentiable on [-2, 2] f(2) = 4 = f(-2). All conditions of Rolles theorem is satisfied. Given the tangent is parallel to x-axis.
f¹ (x) = 2x
f¹(c) = 2c
f¹(c) = 0 ⇒ 2c = 0 ⇒ c = 0 ∈ [-2, 2]
where c = 0, y = 0
Therefore (0, 0) is the required point.

Question 22.

is continuous in the interval [-1 1].
(a) Find \(\lim _{x \rightarrow 0}\)f(x) (2)
(b) Find f(0). (1)
(c) Find P. (1)
Answer:


(c) Since f is continuous in [-1 1] it is continuous at 0.
Therefore P = \(-\frac{1}{2}\).

Question 23.
If ax² + 2hxy + by² = 1

1. Find \(\frac{d y}{d x}\) (1)
2. Find \(\frac{d^{2} y}{d x^{2}}\) (3)

Answer:
1. We have, ax² + 2hxy + by² = 1 ___(1)
Differentiating w.r.t.x, we get,

2. Differentiating (2) w.r.tx, we get,

Question 24.
Consider the function y = x^x \(\sqrt{x}\)

1. Express the above function as logy = \(\left(x+\frac{1}{2}\right)\) logx (2)
2. Find \(\frac{d y}{d x}\) (2)

Answer:
1. Given, y = x^x \(\sqrt{x}\). Take log on both sides,

2. We have, logy = \(\left(x+\frac{1}{2}\right)\) logx
Differentiating w.r.t x, we get,

Plus Two Maths Continuity and Differentiability Six Mark Questions and Answers

Question 1.

1. Verify mean value theorem for the function f(x) = (x – 2)² in [1, 4].
2. Find a point on the curve y = (x – 2)² at which the tangent is parallel to the chord joining the points (1, 1) and (4, 2)
3. Find a point on the above curve at which the tangent is parallel to the x-axis.

Answer:
1. f(x) = (x – 1)², x ∈ [1, 4]
f(x) is continuous in [1, 4]
f'(x) = 2(x – 2) is differentiable in [1, 4]
Then there exists c ∈ [1, 4] so that

Hence Mean Value Theorem is verified.

2. c = \(\frac{5}{2}\) will be the x-coordinate to the point of contact of tangent and the curve, then y = (x – 2)² ⇒ y = (\(\frac{5}{2}\) – 2)² = \(\frac{1}{4}\)
Therefore the point is (\(\frac{5}{2}\), \(\frac{1}{4}\)).

3. The tangent parallel to x- axis will have
f'(c) = 0 ⇒ 2(c – 2) = 0 ⇒ c = 2
Then; x = 2 ⇒ y = (2 – 2)² = 0
Therefore the point is (2, 0).

Question 2.

1. Differentiate x^sinx w.r.t.x (2)
2. If x = at², y = 2at, then find \(\frac{d y}{d x}\) (2)
3. If y = sin^-1(cosx) + cos^-1(sinx), then find \(\frac{d y}{d x}\). (2)

Answer:
1. Let y = x^sinx, take log on both sides,
log y = sinx logx differentiate w. r.t.x, we get

2.

3. Given, y = sin^-1(cosx) + cos^-1(sinx)

Differentiate w.r.t. x, we get \(\frac{d y}{d x}\) = -2.

Question 3.

1. Differentiate \(\frac{x-1}{x-3}\) with respect to x.(2)
2. Differentiate \(\sqrt{\frac{(x-1)(x-2)}{(x-3)(x-4)(x-5)}}\) with respect to x. (4)

Answer:
1. Let y = \(\frac{x-1}{x-3}\) Differentiate w.r.t. x, we get;

2. Given, y = \(\sqrt{\frac{(x-1)(x-2)}{(x-3)(x-4)(x-5)}}\)
Take log on both sides;

Differentiate w.r.t. x, we get;

Question 4.
(i) Define |x|
(a) |x| = \(\sqrt{x^{2}}\)
(b) |x| = x
(c) |x| = -x
(d) |x| = x²
(ii) At which point \(\frac{d}{d x}\)|x| does not exist?
Find \(\frac{d}{d x}\) |x|. (2)
(iii) Find \(\frac{d}{d x}\)|x³ – 7x| . Also, find the point at which the derivative exists. (3)
Answer:
(i) (a) |x| = \(\sqrt{x^{2}}\).

(ii) At x = 0, \(\frac{d}{d x}\) |x| does not exist.


Does not exist at
x³ – 7x = 0 ⇒ x(x² – 7) = 0
⇒ x = 0, x² – 7 = 0 ⇒ x = ±\(\sqrt{7}\).

Question 5.
(i) Match the following (4)

(ii) If log (x² + y²) = 2 tan^-1\(\left(\frac{y}{x}\right)\), then, show that \(\frac{d y}{d x}=\frac{x+y}{x-y}\) (2)
Answer:
(i)

(ii) Given, log (x² + y²) = 2 tan^-1\(\left(\frac{y}{x}\right)\).
Differentiate w.r.to x, we get;

Question 6.
If x = a sec³θ and y = a tan³θ

Answer:
(i) Given, x = a sec³θ
Differentiate w.r.to θ, we get;
\(\frac{d x}{d \theta}\) = 3a sec²θ. secθ. tanθ = 3a sec³ θ. tan θ
Given, y = a tan³θ .
Differentiating w.r.to θ, we get
\(\frac{d x}{d \theta}\) = 3a tan² θ. sec²θ.

(iii) We have, \(\frac{d y}{d x}\) = sinθ
Differentiating w.r.to x, we get

(iv) We have,

Question 7.
Consider the function \(f(x)=\left\{\begin{array}{cc}{1-x} & {, \quad x<0} \\{1} & {x=0} \\ {1+x} & {, \quad x>0}\end{array}\right.\)
(i) Compete the following table. (2)

(ii) Draw a rough sketch of f (x). (2)
(iii) What is your inference from the graph about Its continuity. Verify your answer using limits. (2)
Answer:

Since, f (- 2) = 1 – (- 2) = 3, f (-1) = 1 – (-1) = 2,
f(1) = 1 + (1) = 2, f (2) = 1 + (2) = 3.

(ii)

(iii) From the graph we can see that there is no break or jump at x = 0. Therefore continuous.
From the figure we can see that
f(0^–) = 1 f(0⁺) = 1 and f(0) = 1
Hence, f(0^–) = f(0⁺) = f(0) = 1.
Therefore continuous.

Question 8.
Consider the equation \(\sqrt{1-x^{2}}+\sqrt{1-y^{2}}=a(x-y)\)
(i) Simplify the above equation to sin^-1x – sin^-1y = 2cot^-1 a by giving suitable substitution.
(ii) Prove that \(\frac{d y}{d x}=\sqrt{\frac{1-y^{2}}{1-x^{2}}}\)
Answer:

(ii) We have; sin^-1 x – cos^-1y = 2cot^-1a.
Differentiating w.r.t x, we get,

Question 9.
(i) Match the following. (4)

(ii) If y = e^{a cos-1x}, then show that (1 – x²)y₂ – xy₁ – a²y = 0 (2)
Answer:
(i)

(ii) Given, y = e^{a cos-1x} ____(1)
Differentiating w.r.to x,

Again differentiating w. r.to x

⇒ (1 – x²)y₂ – xy₁ = a². e^{a cos-1x}
⇒ (1 – x²)y₂ – xy₁ = a²y
⇒ (1 – x²)y₂ – xy₁ – a²y = 0.

Question 10.
(i) Match the following (3)

Differentiate the following
(ii) y =\(\frac{1}{5 x^{2}+3 x+7}\) (1)
(iii) y = 3cosec⁴(7x) (1)
(iv) y = e^{2log tan 5x} (1)
Answer:
(i)

(iii) Given,

(iv) Given,

Students can Download Chapter 8 Database Management System Questions and Answers, Plus Two Computer Science Chapter Wise Questions and Answers helps you to revise the complete Kerala State Syllabus and score more marks in your examinations

Kerala Plus Two Computer Science Chapter Wise Questions and Answers Chapter 8 Database Management System

Plus Two Computer Science Database Management System One Mark Questions and Answers

Question 1.
Select the property which is desirable for a database.
(a) Redundancy
(b) Inconsistency
(c) Integrity
(d) Complexity
Answer:
(c) Integrity

Question 2.
Pick the odd man out.
Answer:
(a) Create
(b) Select
(c) Update
(d) Insert
Answer:
(a) Create

Question 3.
______ is the ability to modify a schema definition in one level without affecting the schema definition in the next higher level.
Answer:
Data Independence

Question 4.
For accessing data from a database, provides an interface with programming languages.
Answer:
SQL(orDML)

Question 5.
Give an example for RDBMS package.
Answer:
Packages such as Oracle, My SQL, etc.

Question 6.
Name the key that acts as a candidate key but not a primary key.
Answer:
Alternate key

Question 7.
With the help of ______ the process of storing, retrieving and modifying data are greatly simplified.
Answer:
DBMS

Question 8.
If _____ is controlled , DBMS can guarantee that database is never inconsistent.
Answer:
Redundancy.

Question 9.
The property of a DBMS that guarantees that the database is never inconsistent.
Answer:
Redundancy.

Question 10.
_____ and ______ are the two types of integrity checks.
Answer:
Range checks, Value checks.

Question 11.
Which component of DBMS provides interfaces with programming Languages ________.
Answer:
DML

Question 12.
The level of database abstraction that describes how the data is actually stored in the storage medium.
Answer:
Physical level.

Question 13.
The level of database abstraction that describes what data are stored in the database.
Answer:
Logical level.

Question 14.
Database Administrators (DBA) are more concerned with level ____ of Abstraction.
Answer:
Logical level

Question 15.
The programmers are connected with ______ .level of abstraction.
Answer:
Logical level.

Question 16.
The teller at a bank sees only that part of the database that has information on customer accounts. Which level of Database abstraction he is at?
Answer:
View level.

Question 17.
As part of project work, Ashish defines the type of data and the relationship among them. He is at _____ level of database abstraction.
Answer:
Logical.

Question 18.
_____ is the other name for logical level
Answer:
Conceptual level

Question 19.
if the modifications made on storage format does not affect the structure of data, then we achieve ___ data independence.
Answer:
Physical data independence.

Question 20.
Pick the odd one out.
(a) network model
(b) hybrid model
(c) relational model
(d) hierarchical model
Answer:
(b) hybrid model

Question 21.
“I am a data model. My records can have more than one parent record” Who am I?
Answer:
Network model.

Question 22.
Name the language that enables user to access or manipulate data as organized by RDBMS.
Answer:
DBML

Question 23.
A Database Administrator is able to modify the structure a programmer changes data types and length of a database without affecting certain fields in a database of a bank and the program. Identify the data independence associated in it.
Answer:
Logical data Independence

Question 24.
Name the language that used to define a database scheme.
Answer:
DDL

Question 25.
Name the person who has central control over the database and programs in DBMS
(a) Naive user
(b) Programmer
(c) Database Administrator
(d) System Analyst
Answer:
(c) Database Administrator

Question 26.
Oracle DBMS package is based on _____ model.
Answer:
Relational

Question 27.
Match the following.

Answer:
a – ii
b – iii
c – i

Question 28.
Name the Relational operation which selects certain columns from the table while discarding others.
Answer:
Project.

Question 29.
How to define the Domain of a column ‘subject 1’of MARKS relation.
Answer:
Range of values from 0 to 100

Question 30.
State whether true or False.
A view is a kind of table whose contents are taken from other tables.
Answer:
True.

Question 31.
State True or False.
A view can be queried, inserted into, updated and deleted from.
Answer:
True.

Question 32.
Name an efficient way to provide only required data to users hiding other data from the database.
Answer:
View.

Question 33.
Pick the key which can not be used to uniquely identify a tuple on a relation:
(Candidate Key, Primary Key, Alternate Key, Super Key, None of these)
Answer:
None of these.

Question 34.
π (pi) Greek letter is used to denote ______ operation in relational algebra.
Answer:
Project.

Question 35.
Which relational Algebra operation returns all possible combinations of tuples from two relations.
Answer:
Cartesian product.

Question 36.
Pick the odd one out.
(Select, Cartesian product, Union, intersection)
Answer:
Select – unary operator.

Question 37.
What will be the cardinality of the resultant table if after the following operation if the cardinality of STUDENT is 5 and INSTRUCTOR is 3?
Student × Instructor
Answer:
15.

Question 38.
Consider two relations FOOTBALL AND CRICKET, How to get the names of players play only cricket not also FOOTBALL.
Answer:
CRICKET – FOOTBALL.

Question 39.
Why we call a Foreign Key so?
Answer:
it is a candidate Key in another table, A foreigner.

Question 40.
______ is range of values from which actual values are appearing in a given column are drawn.
Answer:
Domain

Question 41.
Name the table that does not contain data of its own, but is derived from a base table.
Answer:
View

Question 42.
Name a way to uniquely identify a tuple in a relation.
Answer:
By using primary key.

Question 43.
Give two Unary operations performed on a relation in Relational Algebra.
Answer:
Select, Project.

Question 44.
Data redundancy is not a desirable property. But All redundancy can not or should not be eliminated. Do you agree with this statement? Justify.
Answer:
Yes. Because sometimes there can be technical or business reasons for maintaining several distinct copies of same data.

Question 45.
Anju is able to do all the internal operations in a DBMS. What type of user is she? What are the other type of users?
Answer:
DBA, Other type users are Appl Programmer and Naive users.

Question 46.
Which of the following statements are true?
(1) DBMS facilitates storage, retrieval, and management of databases.
(2) We must keep more copies of the same data in databases.
(3) Data inconsistency is eliminated in DBMS.
(4) DBMS allows sharing of data but does not ensure security.
Choose the correct option from the following:
(a) Both (1) and (3) are true
(b) Statements (1), (3) and (4) are true
(c) Statements (1), (2) and (4) are true
(d) All statements are true
Answer:
(a) Both (1) and (3) are true

Question 47.
Which of the following refers to duplication of data in files?
(a) Data redundancy
(b) Data inconsistency
(c) Data integrity
(d) Data security
Answer:
(a) Data redundancy

Question 48.
The following are some responsibilities of database users. Which of them belongs to Database Administrator?
(1) Design the conceptual schema of the database.
(2) Develops programs to interact with the database.
(3) Interacts with the database through queries.
(4) Ensures authorised and secured access of data
Choose the correct option from the following:
(a) Both (1) and (3)
(b) Except (2) and (3)
(c) (1), (2) and (4)
(d) All four
Answer:
(b) Except (2) and (3)

Question 49.
Which of the keys in a relation do not allow null values? Choose the most appropriate option from the following.
(a) Primary key
(b) Candidate key
(c) Both primary key and candidate key
(d) Either primary key or candidate key
Answer:
(c) Both primary key and candidate key

Question 50.
Choose the level of database abstraction that describes what data is stored in the database and what relationships exist among them,
(a) External
(b) Logical
(c) Physical
(d) View
Answer:
(b) Logical

Question 51.
Which of the following operations can extract the specified columns of a table?
(a) Selection
(b) Projection
(c) Intersection
(d) Set Difference
Answer:
(b) Projection

Plus Two Computer Science Database Management System Two Mark Questions and Answers

Question 1.
The schema of a table is EMPLOYEE (emp_code, emp_name, designation, salary). Write down the relational expressions for the following:
a) To get the name and designation of all employees.
b) To get the details of employees whose salary is above 25000.
c) To get the names of employees who designation is Manager.
d) To get the details of Managers with salary less than 25000.
Answer:

Question 2.
Data sharing is an essential feature of DBMS. How data sharing reduces the data inconsistency in a database? Data sharing is an essential feature of DBMS. How data sharing reduces the data inconsistency in a database?
Answer:
Instead of storing more than one copy of the same data, it stores only one copy. This can be shared by several users. If redundancy occurs there is a chance to inconsistency. If redundancy is removed then in-consistency cannot occur.

Question 3.
Pick the odd one out and justify your answer:
(a) Column
(b) Attribute
(c) Field
(d) Tuple
Answer:
(d) Tuple. The other three terminologies indicate the same characteristic of a table.

Question 4.
Suppose a table (relation) contains the details of customers in a bank. Which attribute of the customer will be set as primary key for the table? Give reason for your opinion.
Answer:
Account number can be set as primary key since account number is different. different customers. That is it is unique hence it can be set as primary key.

Question 5.
How many distinct tuples and attributes are there in relation with cardinality 22 and degree 7.
Answer:

• Cardinality is the number of rows (tuples)
• Hence number Of tuples is 22
• Degree is the number of columns (attributes)
• Hence number of attributes 7

Question 6.
Distinguish primary key and alternate key.
Answer:

• Primary key: It is a set of one or more attributes used to uniquely identify a row.
• Alternate key: A candidate key other than the primary key.

Question 7.
Write an example for relational data model.
Answer:

Question 8.
Observe the following table and choose the correct match from the following options.

(a) 1 → B, 2 → D, 3 → E, 4 → C
(b) 1 → C, 2 → D, 3 → E, 4 → A
(c) 1 → C, 2 → D, 3 → B, 4 → A
(d) 1 → D, 2 → C, 3 → B, 4 → E
Answer:
(c) 1 → C, 2 → D, 3 → B, 4 → A

Question 9.
Consider the table with the following fields Name, RollNumberand Mark for a set of students. Suggest a field among them, which is suitable for primary key. Justify your answer.
Answer:
field RollNOmber is suitable for the primary key. The name and mark can have same values so they are not suitable for the primary key.

Question 10.
Raju is confused with the statement ‘logical data independence is more difficult to achieve than physical data independence. How can you help Raju to understand the statement?
Answer:
Because Appl. Programs heavily dependent on the logical structure of data. So any change in structure means chance of rewriting Appl. Programs.

Question 11.
Match the following.

Answer:
a – ii
b – iii
c – i.

Question 12
Match the following.

Answer:
a – iv
b – iii
c – i.

Question 13.
Your friend tells you that only relational model is used nowadays as DBMS. Will you agree with that? Justify.
Answer:
Yes. Other two models are complex. In.RDMS, no redundancy, and relationships can be formed easily.

Question 14.
The telephone number of Gokul is entered in Library file as 802111 and in admission register file as 802171.

1. Can you correlate this problem with a concept in DBMS?
2. Can you propose a solution to avoid this?

Answer:
Consistency problem, Remove data redundancy

Question 15.
What is DBMS?
Answer:
A DBMS is used to store large volumes of data and it is used to retrieve data whenever needed, edit the existing data, update the data and it is possible to delete also.

Question 16.
“View provides an excellent way to access data from data.” Do you agree with this statement? Justify your answer.
Answer:
Yes. Views can have data from more than one table, view can be queried, inserted into, deleted from and updated like a normal table.

Question 17.
A relation is given below
STUDENT

Mark the following:
Tuple, Attributes, Cardinality, Degree
Answer:

• Tuple – It is the Rows
• Attributes – It is the columns
• Cardinality – 3 (Number of Rows)
• Degree – 4 (Number of Columns)

Question 18.
State whether true or False.

1. Primary key cannot be composite key.
2. Only a candidate key can become a Primary Key.
3. Foreign key of a table js a candidate key in another table.
4. A super key uniquely identifies a row in a relation.

Answer:

1. False
2. True
3. True
4. True

Question 19.
Explain the meaning of following operations.
Answer:
select the tuples whose department is sales and who have salary > 5000.

Question 20.

Is it possible to find the players who play both FOOTBALL AND CRICKET by applying any of the Relational Algebra Operations? Explain.
Answer:
Intersection operation.
FOOTBALL ∩ CRICKET

Question 21.
How will you differentiate Primary key and Super Key?
Answer:

• primary key – one of the candidate keys chosen to uniquely identify the rows of a table.
• Super key – Combination of a Primary key with any other attribute or group of attributes.

Question 22.
Cardinality of a table T1 is 10 and of table, T2 is 8 and the two relations are union compatible. If the cardinality of result T1 ∪ T2 is 13, then what is the cardinality of T1 ∩ T2? Justify your answer.
Answer:
Cardinality of table T1 is 10 means it has 10 rows Cardinalty of table T2 is 8 means it has 8 rows Normally T1 ∪ T2 is 10 + 8 = 18 But Here T1 ∪ T2 is 13 means after eliminating duplication of 5 rows this happened. This means 5 rows are common That is T1 ∩ T2 is 5.

Question 23.
Cardinality of a table T1 is 10 and of table, T2 is 8 and the two relations are union compatible.

1. What will be the maximum possible cardinality of T1 ∪ T2?
2. What will be the minimum possible cardinality of T1 ∩ T2?

Answer:
1. Degree(CD) – The number of Columns is the Degree
Cardinality (RC) – the number of Rows is the Cardinality
T1 ∪ T2 = Sum of cardinalities of Table1 and Table2.
i. e.T1 ∪ T2 = 10 + 8 = 18

2. T1 ∩ T2 is the common rows(tuples) in T1 and T2 If there is no common tuples then T1 ∩ T2is o hence the cardinality is 0.

Plus Two Computer Science Database Management System Three Mark Questions and Answers

Question 1.
For catering to the needs of users, a database is implemented through three general levels. Name the three levels and discuss them.
Answer:
1. Physical Level is the lowest level. it describes how the data is actually stored in the storage medium. At physical level complex, low-level data structures are described in detail.

2. Logical level describes what data are stored in the database and what relationships exist among data. Here database is described in terms of simple structures. Records are defined in this level. Programmers work at this level.

3. View level is the highest level of data abstraction. It is concerned with the way in which the users view the database. It describes only part of the database.

Question 2.
Consider the following table arid write relational algebra operations for the following DEPOSIT.

1. To display those tuples from DEPOSIT relation where amount is greater than 25,000.
2. To display only AccNo and Amount of all depositors.

Answer:

Question 3.

Show the output of the following relational operations.
a) R1 – R2
b) R1 ∩ R2
c) R1 ∪ R2
Answer:

Question 4.
Developers hide the complexity of Database system three several levels of abstraction. What are they?
Answer:
Physical – logical – view level.
(how data) (what data) (view data)

Physical Level is the lowest level. It describes how the data is actually stored in the storage medium. At physical level complex, low-level data structures are described in detail.

Logical level describes what data are stored in the database and what relationships exist among data. Here database is described in terms of simple structure. Records are defined in this level. Programmers work at this level.

View level is the highest level of data abstraction. It is concerned with the way in which the users view the database. It describes only part of the database.

Question 5.
How data are organized in a database.
Answer:

• Field: Smallest unit of data. Eg: RolINo, Name
• Record: Collection of related fields. Eg: The information of a particular student.
• File: Collection of related records. Eg: The information of 10 students.

Question 6.
Salih checks his account details using an ATM machine.

1. Identify the levels of abstraction associated with this?
2. Specify other levels.

Answer:

1. View level
2. Logical level Physical level

Question 7.
Match the following.

Answer:
1 – b
2 – c
3 – a.

Question 8.
Match the following.

Answer:

Question 9.
Explain the major components of DBMS.
Answer:
Components of DBMS

1. Databases – It is the main component.
2. Data Definition Language (DDL) – It is used to define the structure of a table.
3. Data Manipulation Language (DML) – It is used to add, retrieve, modify and delete records in a database.
4. Users- With the help of programs users interact with the DBMS.

Question 10.
Categorise the users of DBMS and write their functions.
Answer:
Users of Database

1. Database Administrator – It is a person who has central control over the DBMS.
2. Application Programmer – These are computer professionals who interact with the DBMS through programs.
3. Naive users – He is an end user. He does not know the details of DBMS.

Question 11.
A table with three columns is given below. For each relational operation given in the 1st column find the best matches from 2^nd and 3^rd columns.

Answer:
1. Select → c) o → (ii)
2. Union → d) ∪ → (iv)
3. Set difference → b) – → (i)

Question 12.
Observe the given table BOOK and write down the outputs of the following relational expressions:

Answer:
a. This query returns all the tuples(rows) that contain BPB in column Publisher.

b. This query returns the column Book_Title with price < 200.
Book Title
Computer Fundamentals C++ Programming Mystery of Chemistry.

Plus Two Computer Science Database Management System Five Mark Questions and Answers

Question 1.
Cardinality of table A is 10 and of table, B is 8 and the two relations are union compatible.
What will be the maximum possible cardinality of (A ∪ B) and (A ∩ B)?
What will be the minimum possible cardinality of (A ∪ B) and (A ∩ B)?
Give justifications for your answers.
Answer:
1. Both relations contain different tuples (rows).
2. The 8 tuples (rows) of table B are same as that of table A.
Case 1.
If both relations contain different tuples then the maximum possible cardinality of A ∪ B is 10 + 8 = 18
Case 2.
If 8 tuples of table B are same as that of table A then the maximum possible cardinality of A C B is 8.
Case 3
If 8 tuples of table B are same as that of table A then the minimum possible cardinality of A ∪ B is 10.
Case 4.
If both relations contain different tuples then the mini-mum possible cardinality of A ∩ B is 0.

Question 2.
There are different data models of which one is currently used in all business transactions. Specify it and discuss in detail.
Answer:
Relational data model is currently used in all business transactions. It is based on the concept introduced by E F Codd. It is composed of one or more tables. Tables are made up of rows and columns. Here tables are called relations, rows are called tuples and the columns are called attributes. The advantages of this model is neither data redundancy nor complexity.
Eg:

Question 3.
You have to present a seminar on the topic “Keys in RDBMS”. Prepare the seminar report.
Answer:

1. Candidate Key: It is a set of attributes that uniquely identifies a row. There may be more than candidate key and maybe a combination of more than one attribute.
2. Primary Key: A primary key is one of the Candidate Keys. It is a set of one or more attributes that can uniquely identify tuples in a relation.
3. Alternate Key: The Candidate key that is not the. primary key is called the alternate key.
4. Super Key: A combination of a primary key with any other attribute or group of attributes is called a super key.
5. Foreign Key: A single attribute or a set of attributes, which is a candidate key in another table, is called foreign key.

Question 4.

Consider the relations STUDENT and GRADE given above and predict the output of the following relational operations in table format.

Answer:

Question 5.
Explain any 4 Relational Algebra Operations.
Answer:
1. SELECT operation:
SELECT operation is used to select tuples in a relation that satisfies a selection condition. Greek letter a (sigma) is used to denote the operation. Syntax – σ _condition(relation)
eg. σ_{salary < 10000} (EMPLOYEE) – selects tuple whose salary is less than 10000 from EMPLOYEE relation.

2. PROJECT operation:
PROJECT operation selects certain columns from the table and discards the other columns. Greek letter7i(pi) is used to denote PROJECT operation. Syntax – π_condition(relation)
eg. π_{name, salary} (EMPLOYEE) displays only the name and salary of all employees

3. UNION operation:
This operation returns a relation consisting of all tuples appearing in either or both of the two specified relations. It is denoted by ∪. duplicate tuples are eliminated. Union operation can take place between compatible relations only, i.e., the number and type of attributes in both the relations should be the same and also their order.
e.g. SCIENCE ∪ COMMERCE gives all the tuples in both COMMERCE and SCIENCE.

4. INTERSECTION operation:
This operation returns a relation consisting of all the tuples appearing in both of the specified relations. It is denoted by ∩. It can takes place only on compatible relations.
e.g. FOOTBALL ∩ CRICKET returns the players who are in both football and cricket teams.

Question 6.
Why should you choose a database system instead of simply storing data in conventional files?
Answer:
Advantages of DBMS over conventional files:

1. Data Redundancy – It means duplication of data. DBMS eliminates redundancy. DBMS does not store more than one copy of the same data.

2. Inconsistency can be avoided – If redundancy occurs there is a chance to inconsistency. If redundancy is removed then inconsistency cannot occur.

3. Efficient data access – It stored huge amount of data efficiently and can be retrieved whenever a need arise.

4. Data can be shared – The data stored in the database can be shared by the users or programs.

5. Standards can be enforced – The data in the database follows some standards.
Eg: a field ‘Name’ should have 40 characters long. Some standards are ANSI, ISO, etc.

6. Security restrictions can be applied – The data is of great value so it must be kept secure and private. Data security means the protection of data against accidental or intentional disclosure or unauthorized destruction or modification by unauthorized person.

7. Integrity can be maintained – It ensures that the data is to be entered in the database is correct.

8. Crash recovery – Some times all or a portion of the data is lost when a system crashes A good DBMS helps to recover data after the system crashed.

Question 7.
We have admission register, attendance register, marks register, etc. in our school to keep various details of students. Briefly describe how DBMS can replace these registers by stating any five merits.
Answer:
Advantages of DBMS
1. Data Redundancy – It means duplication of data. DBMS eliminates redundancy. DBMS does not store more than one copy of the same data.

2. Inconsistency can be avoided – If redundancy occurs there is a chance to inconsistency. If redundancy is removed then inconsistency cannot occur.

3. Data can be shared – The data stored in the database can be shared by the users or programs.

4. Standards can be enforced – The data in the database follows some standards.
Eg: a field ‘Name’ should have 40 characters long. Some standards are ANSI, ISO, etc.

5. Security restrictions can be applied – The data is of great value so it must be kept secure and private. Data security means the protection of data against accidental or intentional disclosure or unauthorized destruction or modification by unauthorized persons.

6. Integrity can be maintained – It ensures that the data is to be entered in the database is correct.

7. Efficient data access – It stored huge amount of data efficiently and can be retrieved whenever a need arise.

8. Crash recovery – Some times all or a portion of the data is lost when a system crashes. A good DBMS helps to recover data after the system crashed.

Students can Download Chapter 7 Web Hosting Questions and Answers, Plus Two Computer Science Chapter Wise Questions and Answers helps you to revise the complete Kerala State Syllabus and score more marks in your examinations

Kerala Plus Two Computer Science Chapter Wise Questions and Answers Chapter 7 Web Hosting

Plus Two Computer Science Web Hosting One Mark Questions and Answers

Question 1.
The companies that provide web hosting services are called ______.
Answer:
Web Hosts

Question 2.
The service of providing storage space in a web server to make a website available on Internet is called
Answer:
web hosting

Question 3.
Which of the following is true in the case of dedicated hosting?
(a) It shares server with other websites.
(b) It is usually inexpensive.
(c) It does not guarantee performance.
(d) It offers freedom for the clients to choose the hardware and the software.
Answer:
(d) only

Question 4.
Choose the odd one out, and justify your answer.
(a) Shared hosting
(b) Dedicated hosting
(c) DNS
(d) Virtual Private Server
Answer:
(c) DNS others are types of web hosting.

Question 5.
______ is the service of providing storage space in a Webserver.

OR

Storing the web pages of a website in a server is popularly known as _____.
Answer:
Web hosting

Question 6.
The companies that provide web hosting services are called _______.
Answer:
Web hosts

Question 7.
Odd one out.
(a) Shared
(b) Dedicated
(c) VPS
(d) DNS
Answer:
(d) DNS means Domain Name System. The others are types of web hosting

Question 8.
VPS stands for _____ .
Answer:
Virtual Private Server.

Question 9.
From the following select the most commonly used web hosting.
(a) Shared
(b) Dedicated
(c) VPS
(d) DNS
Answer:
(a) Shared hosting

Question 10.
DNS stands for ____.
Answer:
Domain Name System

Question 11.
‘A record’ means ______ .
Answer:
Address record

Question 12.
FTP stands for _____ .
Answer:
File Transfer Protocol.

Question 13.
Odd one out.
(a) Mozilla Firefox
(b) FileZilla
(c) CuteFTP
(d) SmartFTP
Answer:
(a) Mozilla Firefox, it is a web browser, the others are popular FTP client software

Question 14.
______ hosting provides web hosting services free of charge.
Answer:
Free hosting

Question 15.
Give an example for Free web hosting services with sub-domain website address.
Answer:
www.bvmhsskalparamba.facebook.com

Question 16.
Give an example for Free web hosting services with directory service website address.
Answer:
www.facebook.com/bvmhsSkalparamba

Question 17.
CMS stands for ____.
Answer:
Content Management System

Question 18.
The term ‘responsive web designing’ was introduced by _____.
Answer:
Ethan Marcotte

Question 19.
The method of Flexible designing of web pages to suit the various types of screens is called _____.
Answer:
Responsive web design method

Question 20.
In dedicated hosting, if the client is allowed to place his own purchased web server in the service provider’s facility, then it is called _______.
Answer:
Co-location

Question 21.
What are the information contained in a ICANN database?
Answer:
Registered domain names/name, address, telephone number and e-mail address of the registrants.

Question 22.
What is‘A record’?
Answer:
‘A record’ is used to store the IP address and the corresponding domain name

Question 23.
Joomla is an example for ______ .
(a) CMS
(b) ISP
(c) DNS
(d) None of the above
Answer:
(a) CMS

Question 24.
The responsive web design feature that converts horizontal menu to a drop-down menu in mobile phones is called ______.
Answer:
Media queries

Question 25.
The organization that maintains the WHOIS database of domain names is ______.
Answer:
ICANN

Plus Two Computer Science Web Hosting Two Mark Questions and Answers

Question 1.
Consider that your school is planning to host a website. What are the factors that you will consider while choosing the type of web hosting?
Answer:
Following factors to be considered

1. Buying sufficient amount of memory space for storing our website files
2. If the web pages contain programming contents supporting technology must be considered
3. Based upon the programs select Windows hosting or Linux hosting

Question 2.
Emmanuel wishes to buy a suitable domain for his company. Unfortunately, the domain name he chose is already registered by someone else. Name the feature that will help him to find the current owner. List the details will he get.
Answer:
WHOIS
Name, address, telephone number and e-mail address of the registrant

Question 3.
What is the use of FTP client software? Give an example.
Answer:
FTP (File Transfer Protocol) client software:
When a client requests a website by entering website address. Then FTP client software helps to establish a connection between client computer and remote server computer. Unauthorised access is denied by using user name and password hence secure our website files for that SSH(Secure Shell) FTP simply SFTP is used.

Instead of http://, it uses ftp://. By using FTP client s/w we can transfer(upload) the files from our computer to the web server by using the ‘drag and drop’ method. The popular FTP client software are FileZilla, CuteFTP, SmartFTP, etc.

Question 4.
Haseena has decided to host her new website using free hosting facility; her friend Rinisha is against this move. Can you guess her argument against the utilization of free hosting facility?
Answer:
In free web hosting service, the expense is meet by the advertisements. Some service providers allow limited facilities such as limited storage space, do not allow multimedia (audio and video) files.

Plus Two Computer Science Web Hosting Three Mark Questions and Answers

Question 1.
Priya has developed a website for her shop. She has purchased a domain name and hosting space.

1. Name the software that will help her to transfer her files from her computer to the webserver.
2. List the requirements in that software that are necessary to connect to the webserver.

Answer:

1. FTP software such as FileZilla, Cute FTP, Smart FTP
2. Following are the requirements to connect to the Webserver
   • Domain name /IP address
   • User name.
   • Password

Question 2.
Explain the advantages of using SFTP protocol in FTP client software.
Answer:
Unauthorized access is denied by using username and password hence secure our website files, for this SSH (Secure Shell) FTP simply SFTP is used. It encrypts and sends usernames, passwords, and data to the webserver.

Question 3.
Merin plans to create a website for their family without spending money.

1. List some of the limitations that Merin will face regarding the hosting space for website.
2. How will she provide a domain name for the website?

Answer:
1. In free web hosting service, the expense is meet by the advertisements. Some service providers allow limited facilities such as limited storage space, do not allow multimedia (audio and video) files.

2. Usually, two types of free web hosting services as follows.

• As a directory service: service provider’s website address/ our website address
  eg: www.facebook.com/bvmhsskalparamba
• As a subdomain: Our website address. service providers website address
  eg: www.bvmhsskalparamba.facebook.com

Question 4.
Recently more and more people are using Content Management Systems (CMS) for developing professional websites. What can be the reasons for this?
Answer:
CMS means Content Management System. Do you heard about Data Base Management System (DBMS). DBMS is a software (collection of programs) used to create, alter, modify, delete and retrieve records of a DataBase. Similarly CMS is a collection of programs that is used to create, modify, update and publish website contents.

CMS can be downloaded freely and is useful to design and manage attractive and interactive websites with the help of templates that are available in CMS. WordPress, Joomla, etc. are the examples of CMS.

Question 5.
Suggest a hosting type for the following websites given below. Justify.

1. Website for a medical shop in your city.
2. Website for Public Service Commission (PSC) of Kerala.
3. Website for an online shopping facility.

Answer:

1. Shared hosting
2. Dedicated/VPS
3. Dedicated/VPS

Question 6.
Consider that a college in your locality plans to shift its website from shared type of hosting to VPS hosting. List the advantages that the website will gain from this change.
Answer:
Virtual Private Server (VPS):
A VPS is a virtual machine sold as a service by an Internet hosting Service. A VPS runs its own copy of an OS(Operating System) and customers have super level access to that OS instance, so they can install almost any s/ w that runs on that OS.

This type is suitable for websites that require more features than shared hosting but less features than dedicated hosting.
Eg: It is similar to owning a Condo

Question 7.
Mr. Mohan wants to host a personal website with minimal cost. Which type of web hosting would you advise for him? Justify your answer.
Answer:
Shared Hosting:
This type of hosting sharing re-sources, like memory, disk space, and CPU hence the name shared. Several websites share the same server. This is suitable for small websites that have less traffic and it is not suitable for large websites that have large bandwidth, large storage space and have large volume of traffic.

Eg: Shared hosting is very similar to living in an Apartment(Villas) complex. All residents are in the same location and must share the available resources(Car parking area, Swimming pool, Gymnasium, playground, etc) with everyone.

Question 8.
A supermarket in a city wishes to take its business online. It plans to accept orders for its products through a website and receive payments online.

1. Which type of hosting is suitable for this website?
2. Explain the reason for your choice.

Answer:
1. Dedicated Hosting

2. A web server and its resources are exclusively for one website that have large volume of traffic means large volume of requests by the visitors. Some Govt, departments or large organizations require uninterrupted services for that round the clock power supply is needed. It is too expensive but it is more reliable and provides good service to the public.

Eg: It is similar to living in an Our own house. All the resources in your house is only for you. No one else’s account resides on the computer and would not be capable of tapping into your resourses

Question 9.
Emil wishes to purchase the web hosting space required to host a website for his medical shop. List the features to be taken into consideration while buying hosting space on a web server.
Answer:
Following factors to be considered:

1. Buying sufficient amount of memory space for storing our website files
2. If the web pages contain programming contents supporting technology must be considered
3. Based upon the programs select Windows hosting or Linux hosting

Question 10.
How can we connect a website hosted in a Web server to a domain name?
Answer:
Millions of websites are available over Internet so that our website must be registered with a suitable name. Domain Name registration is used to identify a website over Internet. A domain name must be unique(i.e. no two websites with same name is available).

So you have to check the availability of domain name before you register it, for this www.whois.net website will help. If the domain name entered is available then we can register it by paying the Annual registration fees online. Consider a Post Office, it has two addresses one string address (Irinjalakuda) and one numeric(pin) code (680121).

Just like this the website has also two addresses a string address, for example, www.agker.cag.gov.in and a numeric address (http:/ /210.212.239.70/). We are following string address, hence this domain name has to be connected to the corresponding IP address of the webserver. This is done by using ‘A record’(Address record) of the domain. ‘A record’ is used to store the IP address and the corresponding domain name.

Question 11.
What is the advantage of using SFTP protocol in FTP software?
Answer:
FTP(File Transfer Protocol) client software:
When a client requests a website by entering website address. Then FTP client software helps to establish a connection between client computer and remote server computer. Unauthorised access is denied by using username and password hence secure our website files for that SSH(Secure Shell) FTP simply SFTP is used.

Instead of http://, it uses ftp://. By using FTP client s/w we can transfer(upload) the files from our computer to the web server by using the ‘drag and drop’ method. The popular FTP client software are FileZilla, CuteFTP, SmartFTP, etc.

Question 12.
Raju wishes to host a website for his family. What are the advantages that free web hosting companies provide?
Answer:
The name implies it is free of cost service and the expense is meet by the advertisements. Some service providers allow limited facilities such as limited storage space, do not allow multimedia(audio and video) files. A paid service website’s address is as follows:
Eg: www.bvmhsskalparamba.com

Usually two types of free web hosting services as follows:
1. As a directory service:
Service provider’s website address/ our website address.
eg: www.facebook.com / bvm hss kalparambu.

2. As a Sub domain:
Our website address.service providers website address.
eg: www.bvmhsskalparamba.facebook.com Earlier web hosting services are expensive but nowadays it is cheaper hence reduced the need for free web hosting.

Question 13.
What is CMS? What are the features of CMS? Give Examples.
Answer:
CMS means Content Management System. Do you heard about Data Base Management System (DBMS)? DBMS is a software(collection of programs) used to create, alter, modify, delete and retrieve records of a DataBase. Similarly, CMS is a collection of programs that is used to create, modify, update and publish website contents.

CMS can be downloaded freely and is useful to design and manage attractive and interactive websites with the help of templates that are available in CMS. WordPress, Joomla, etc. are examples of CMS.

Plus Two Computer Science Web Hosting Five Mark Questions and Answers

Question 1.
Explain different types of web hosting?
Answer:
Types of web hosting:
Various types of web hosting services are available. We can choose the web hosting services according to our needs depends upon the storage space needed for hosting, the number of visitors expected to visit, etc.

1. Shared Hosting:
This type of hosting sharing resources, like memory, disk space, and CPU hence the name shared. Several websites share the same server. This is suitable for small websites that have less traffic and it is not suitable for large websites that have large bandwidth, large storage space and have large volume of traffic.

Eg: Shared hosting is very similar to living in an Apartment(Villas) complex. All residents are in the same location and must share the available resources(Car parking area, Swimming pool, Gymnasium, playground, etc) with everyone.

2. Dedicated Hosting:
A web server and its resources are exclusively for one website that have large volume of traffic means large volume of requests by the visitors. Some Govt, departments or large organizations require uninterrupted services for that round the clock power supply is needed. It is too expensive but it is more reliable and provides good service to the public.

Eg: It is similar to living in an Our own house. All the resources in your house is only for you. No one else’s account resides on the computer and would not be capable, of tapping into your resources.

3. Virtual Private Server (VPS):
A VPS is a virtual machine sold as a service by an Internet hosting Service. A VPS runs its own copy of an OS (Operating System) and customers have super level access to that OS instance, so they can install almost any s/what runs on that OS. This type is suitable for websites that require more features than shared hosting but less features than dedicated hosting.
Eg: It is similar to owning a Condo

Question 2.

1. What is responsive web design?
2. Why is it gaining importance recently?

Answer:
1. The home page is displayed differently according to the screen size of the browser window (different screen sized devices mobile phone, palmtop, tablet, laptop, and desktop) we used. The website is designed dynamically (flexibly) that suit the screen size of different device introduced by Ethan Marcotte.

Before this, companies have to design different websites for different screen sized devices. By responsive web design, companies have to design only one website that suitably displayed according to the screen size of the devices. It is implemented by using flexible grid layout, images, and media queries.

• Flexible grid layouts: It helps to set the size of the web page to fit the screen size of the device.
• Flexible image and video: It helps to set the image or video dimension to fit the screen size of the device.
• Media queries: There is an option (settings) to select the size of the web page to match our device, this can be done by using media queries inside the CSS file.

A well known Malayalam daily Malaysia Manorama launched their responsive website.

2. Instead of using desktops or laptops many people nowadays visit websites using tablets and mobile phones. Portability is the main reason for this.

Question 3.
Today, we visit websites using tablets and mobile phones also. You might have noticed that the same website is displayed in a different layout in different devices.

1. Name the concept used for this.
2. List and explain the technologies used for implementing this concept

Answer:
1. Responsive web design.

2. It is implemented by using flexible grid layout, images, and media queries:

• Flexible grid layouts: It helps to set the size of the web page to fit the screen size of the device.
• Flexible image and video: It helps to set the image or video dimension to fit the screen size of the device.
• Media queries: There is an option (settings) to select the size of the web page to match our device, this can be done by using media queries inside the CSS file.

A well known Malayalam daily Malayala Manorama launched their responsive website.

Question 4.

1. What is responsive web design?
2. How is responsive web design implemented?

Answer:
1. The home page is displayed differently according to the screen size of the browser window (different screen sized devices mobile phone, palm top, tablet, laptop and desktop) we used. The website is designed dynamically (flexibly) that suit the screen size of different device introduced by Ethan Marcotte.

Before this, companies have to design different websites for different screen sized devices. By responsive web design, companies have to design only one website that suitably displayed according to the screen size of the devices.

2. It is implemented by using flexible grid layout, images, and media queries:

• Flexible grid layouts: It helps to set the size of the web page to fit the screen size of the device.
• Flexible image and video: It helps to set the image or video dimension to fit the screen size of the device.
• Media queries: There is an option (settings) to select the size of the web page to match our device, this can be done by using media queries inside the CSS file.

A well known Malayalam daily Malayala Manorama launched their responsive website.

Students can Download Chapter 2 Spread Sheet Questions and Answers, Plus Two Accountancy Chapter Wise Questions and Answers helps you to revise the complete Kerala State Syllabus and score more marks in your examinations.

Kerala Plus Two Accountancy Chapter Wise Questions and Answers Chapter 2 Spread Sheet

Plus Two Accountancy Spread Sheet One Mark Questions and Answers

Question 1.
The best way to get started in Libre Office calc is _____
Answer:
Application → Office → LibreOffice Calc

Question 2.
___________ is a configuration of rows and columns
Answer:
Spread sheet

Question 3.
A spread sheet is also known as ____________
(a) Work book
(b) Work area
(c) Work sheet
(d) Spread book
Answer:
(c) Work sheet

Question 4.
____________ in spread sheet are horizontal vectors while ______ are vertical vectors
Answer:
Rows, columns

Question 5.
Spread sheet is used to
(a) Record data
(b) Calculate data
(c) Compare data
(d) All the above
Answer:
(d) All of the above

Question 6.
Each cell value can either be an independent (basic) value or it may be derived on the basis of ____________.
Answer:
Arithmetic expression or a function.

Question 7.
A file in LibreOffice Calc is known as a ______
(a) Work sheet
(b) Page
(c) Work book
(d) All the above
Answer:
(c) Work book

Question 8.
A work book is a collection of a number of ______
Answer:
Work Sheets

Question 9.
Where is the address of the active cell displayed?
(a) Row heading
(b) Status Bar
(c) Name Box
(d) Formula Bar
Answer:
(c) Name Box

Question 10.
Which command reverses the last action performed in the worksheet?
(a) Cut
(b) Undo
(c) Redo
(d) Paste
Answer:
(b) Undo

Question 11.
__________ is a text or special character or descriptive information for rows or columns.
Answer:
Label

Question 12.
A formula must starts with a ___________ sign
(a) =
(b) >
(c) *
(d) {}
Answer:
(a) =

Question 13.
_______ Function is commonly used to get the addition of various numbers orthe contents of various cells.
Answer:
Autosum (Σ)

Question 14.
The cell A5 indicate Column _______ and Row _____
Answer:
Column A & Row 5

Question 15.
The dark box which distinguishes the active cell is called _______
Answer:
Cell Pointer

Question 16.
One or more cells selected is called ______
Answer:
a range

Question 17.
Without the equal sign, the entry in a cell is treated as _________
(a) Text
(b) Label
(c) TextorLabel
(d) None of the above
Answer:
(c) Text or Label

Question 18.
Libre Office calc has three type of cell entries, they are _______ , ______and _______
Answer:
Value, Label and Formula.

Question 19.
Which command allows you to reverse an undo command?
(a) Redo
(b) Repeat
(c) Reset
(d) Reverse
Answer:
(a) Redo

Question 20.
Which cell alignment is assigned to most values by default?
(a) Right
(b) Left
(c) Centre
(d) None of the above
Answer:
(b) Left

Question 21.
Which function automatically totals a column or row of Values?
(a) TOTAL
(b) ADD
(c) SUM
(d) AVG
Answer:
(c) SUM

Question 22.
Which Mathematical Operator is represented by an asterisk (*)
(a) Exponentiation (square)
(b) Addition
(c) Subtraction
(d) Multiplication
Answer:
(d) Multiplication

Question 23.
How many blank work sheets are shown when a new workbook is created?
(a) One
(b) Two
(c) Three
(d) Four
Answer:
(c) Three

Question 24.
The cell co-ordinate in the formula are known as ………….
Answer:
cell references

Question 25.
IF function is …………….
Answer:
Logical function

Question 26.
The cell references for cell range of G2to M12 is …………….
(a) G2.M12
(b) G2: M12
(c) G2; M12
(d) G2 – M12
Answer:
(c) G2: M12

Question 27.
If 4/6 entered in a cell without applying any format, LibreOffice Calc will treat this as
(a) Fraction
(b) Number
(c) Text
(d) Date
Answer:
(d) Date

Question 28.
The cell labelled F5 refers to …………….
(a) Row F column 5
(b) Column F row 5
(c) Function available in cells
(d) Function key F5
Answer:
(b) Column F row 5

Question 29.
LibreOffice Calc is a FOSS. What is FOSS?
Answer:
Free and Open Source Software.

Question 30.
Which among the following is not a spreadsheet software.
(a) MS Office Excel
(b) Open Office Spredsheet
(c) Libre Office Calc
(d) MS Office Word
Answer:
(d) M S Office Word

Question 31.
How many worksheets can be made as active worksheet at a time?
(a) 1
(b) 2
(c) 3
(d) 4
Answer:
(a) 1

Question 32.
The name of the worksheet will be shown in the ______ at the bottom left of the windows.
Answer:
Sheet Tab

Question 33.
To add column in a worksheet, click __________, there we get an option to add column.
Answer:
Column Header

Question 34.
A ………… is identified by a combination of a column header (letter) and a row header (number)
Answer:
cell

Question 35.
_______ is a group of adjacent cells that forms a rectangular area.
Answer:
Range

Question 36.
Which among the following is used as the range operator
(a) ;
(b) :
(c) /
(d) #
Answer:
(b) :

Question 37.
One ENTER key stroke means
(a) One cell down
(b) One cell up
(c) One cell right
(d) One cell left
Answer:
(a) One cell down

Question 38.
………………. Function counts the number of cells which contain any value.
(COUNT, COUNTA, COUNT BLANK, COUNTIF)
Answer:
COUNTA

Plus Two Accountancy Spread Sheet Two Mark Questions and Answers

Question 1.
Match the following

Answer:

Question 2.
What do you mean by spreadsheet?
Answer:
Spreadsheet:
Spreadsheet application is a computer program that allows to record, calculate and compare numerical or financial data. Using a spreadsheet program. We can store a lot of data in the worksheet and also arrange and analyse the data by using different functions and formulae for the meaningful object.

It is used to establish relationship between two or more sets of data. Libre Office Calc, MS Office Excel, Open Office Spreadsheet etc. are examples of spreadsheet software.

Question 3.
Give a short note on

1. Work book
2. Work sheet

Answer:
1. Workbook:
A file in spread sheet is known as a workbook. A work book is a collection of a number of work sheets.

2. Work sheets:
The work area which consists of rows and columns in a spreadsheet is called a worksheet. By default three work sheets-sheet 1, sheet -2, sheet -3 are available in work book.

Question 4.
Explain about rows and columns in Libre Office Calc?
Answer:
1. Rows:
Rows are the horizontal vectors in the worksheet. These are numbered numerically from Top to Bottom.

2. Columns:
Columns are vertical vectors in the worksheet. These are referred by alpha characters from left to right such as A, B, C, …, AA, AB, AC …etc.

Question 5.
What do you mean be Relative cell Reference?
Answer:
1. Relative Cell references:
By default cell reference is relative; which means that as a formula or function is copied and pasted to other cells, the cell references in the formula or function change to reflect the new location.

Question 6.
Define the following

1. Label
2. Formula

Answer:
1. Labels:
Descriptive information for rows or columns in the form of a text or a special character is called Label.
Eg: Name, Roll No, Address.

2. Formula:
The formula means a mathematical calculation on a set of cells. The formula must start with an = (equal to) sign. When a cell contains a formula, it often contains reference to other cells. Eg:= Basic pay + DA + HRA

Question 7.
List down any two features fo Spreadsheet.
Answer:

• A spreadsheet is a configuration of rows and columns.
• A spreadsheet is also known as worksheet.

Question 8.
Name the different spreadsheet software available.
Answer:
LibreOffice Calc, MS Office Excel, Open Office Spreadsheet.

Question 9.
Briefly explain any two Date and Time functions availabe in LibreOffice Calc
Answer:
1. TODAY():
It is the function for today’s date in the worksheet. This helps to update the date value when we reopen the spreadsheet or modify the values of the document
Syntax: =TODAY()

2. NOW ():
It is the function for today’s date and present time. This helps to update the date and the time value when the cell value is modified.
Syntax: =NOW()

Question 10.
Give the Syntax for

1. YEAR()
2. DATE()

Answer:
1. YEAR()
Syntax: = YEAR (Date value) OR = YEAR (“Date”)

2. DATE()
Syntax: = DATE (Year, Month, Day)

Question 11.
Complete the table by using ROUNDUP()

Answer:

1. 1880
2. 1900

Question 12.
What are the Text Manipulation Function in LibreOffice Calc
Answer:

• TEXT
• CONCATENATE

Question 13.
Give the explanation of the following errors
Error Message

1. # DIV/o!
2. VALUE!

Answer:

1. # DIV/0! → When a number is divided by zero
2. VALUE! → When a wrong argument is given in a fromula

Question 14.
Spot the correct pairs by observing the nature of software, and give justification
(a) Microsoft Excel and LibreOffice Calc
(b) Linux and Tata Ex.
(c) Windows and MS Office
(d) GINUGhata and Microsoft Access
Answer:
(a) Microsoft Excel and LibreOffice Calc. Both are spread sheet packages.

Plus Two Accountancy Spread Sheet Three Mark Questions and Answers

Question 1.
What are the advantage of Libre Office Calc?
Answer:

1. It is both free software and open source software.
2. It can be used to calculate, analyse and manage data.
3. Libre Office Calc is available for a variety of platforms including Linux, OSX, Microsoft windows and Free BSD.

Question 2.
Give the cell address or range reference in the following situations.

1. Cell at 10^th column and 6^th row.
2. Cell at 27th column and 15^th row.
3. Range starting from 5^th column, 9^throw and spread till 12^th column and 15^th row.

Answer:

1. Cell at 10^th column and 6^th row = J6.
2. Cell at 27^th column and 15^th row = AA15.
3. Range starting from 5^th column, 9^th row and spread till 12^th column and 15^th row = E9: L15.

Question 3.

1. What is FOSS?
2. What are the benefits of using FOSS?

Answer:

1. FOSS means Free and Open Source Software
2. The benefits of using FOSS:
   • Decreased software costs.
   • Increased Security and stability.
   • Any one can use, copy, study and change the software in any manner.
   • Source code is openly shared.

Question 4.
How can we save Libre Office Calc file?
Answer:
Step 1: Go to the File menu
File menu

Step 2: Click on Save
Save

OR

Step 1: & Step 2 – Press Ctrl + S
Ctrl + S

Step 3: Type the file in the name field instead of default name Untitled 1
Name field

Step 4: Choose the place where we want to save the new file.

Step 5: Click on Save

Question 5.
Write the steps to be followed to

1. Rename a worksheet
2. Delete a worksheet
3. Copy a worksheet

Answer:
1. Rename a worksheet:
Step – 1 Select the work sheet in the Sheet Tab which we want to Rename.

Step – 2 Right click and select Rename sheet from the drop up menu

Step – 3 Type new name in the Name field and press OK button

2. Delete a worksheet:
Step – 1 Select the worksheet in the Sheet Tab which we want to delete

Step – 2 Right click and select Delete sheet from the drop up menu

Step – 3 Click on Yes to the conformation question.

3. Copy a worksheet:
Step – 1 Click on blank rectangle Top left corner of the worksheet (Range Adress A1: AM J1048576)

Step – 2 Move the curser inside the worksheet and Right click the mouse.

Step – 3 Click on Copy from the dropdown menu.

Step – 4 Open the worksheet where we want to copy the sheet

Step – 5 Right click on cell A1. Click on Paste.

Question 6.
Give the cell address or range reference in the following situations.

1. Cell of 10th column and 9^th row
2. Range starting from 2^nd column 4^th row and spread till 8^th column 12^th row
3. Range starting from 4^th column 5^th row and spread till 10^thcolumn 15^th row

Answer:

1. J9
2. B4: H12
3. D5: J15

Question 7.
What is the purpose of the COUNTIF function?
Answer:
COUNTIF():
This function counts the number of cells within a given that meet the criteria or condition.
Syntax: = COUNTIF (Range, Criteria)

Question 8.
Write the command to calculate the State Life Insurance Premium (SLI) of an employee using IF Function. The condition is SLI Premium Rs. 500/-below Basic Pay (BP) of Rs. 15000/- and for others Rs. 800/- (BP is given in cell C3)
Answer:
= IF(C3 < 15000, 500, 800)

Question 9.
4 numbers are entered in Libre Office Calc spreadsheet starting from cell A1 to A4. Write any two formulae for getting total of those numbers in the cell A5

Answer:

1. A5 = A1 + A2 + A3 + A4
2. A5 = Σ(A1 : A4)

Question 10.
For preparation of Payslip of an employee, Govind entered Basic Pay in cell B2 of a worksheet in LibreOffice calc. The D.A. is 76% of Basic Pay and Gross Salary is the sum of Basic Pay and DA. In order to calculate the amount of DA in cell C2 and Gross salary in cell D2, what entries are to be made?
Answer:
Basic Pay → B2
DA → C2
Gross salary → D2
C2 = B2 * 76%
D2 = B2 + C2

Question 11.
Consider the following features of a software tool. Identify the software.

1. It can be used as a text editor
2. List out the important uses of this software

Answer:

1. LibreOffice calc has the above mentioned features.
2. Importance of LibreOffice calc.
   • It can be used for the preparation of statement of depreciation.
   • It can be used for preparation of Payroll of employees.
   • It can be used for the preparation of the loan re-payment schedule.

Question 12.
Complete the following.

1. One cell down → arrow key
2. One cell up → …………………………
3. One cell left → …………………………
4. One cell right → ………………………

Answer:

2. Up arrow key
3. Left arrow key
4. Right arrow key

Question 13.
Can you give some key navigations and short cut in LibreOffice calc?
Answer:
Spreadsheet navigation:
We can move around a worksheet through four arrow keys

1. Left-arrow key
2. Right arrow key
3. Up arrow key
4. Down arrow key

The mouse can also be used for navigation in a spreadsheet except for data entry. Some common operations/navigations are listed below:

Question 14.
What commands are used to insert a column and delete a column in LibreOffice Calc?
Answer:
1. To insert a column:
To insert a column click a cell in the column immediately to the right of where you want to insert the new column. Then on the Insert menu, click Columns.

2. To delete a column:
Select the column you want to delete. On the Edit menu, click Delete.

Question 15.
Give the procedure to insert a new worksheet and to delete a worksheet.
Answer:
To insert a new worksheet, right click the worksheet, select ‘insert’. To delete a worksheet, select the sheet you want to delete and ‘click delete sheet’ on the edit menu.

Question 16.
Give the cell address or range reference in the following situations.

1. Cell at 12^th Column and 8^th row.
2. Range starting from 6^th Column 10^th row and spread till 12^th Column and 16^th row.

Answer:

1. L8.
2. F10: L16

Question 17.
Name the appropriate Statistical functions.

1. Number of cells contain numbers.
2. Number of cells contain any value.
3. Number of empty cell.
4. Number of cells that meet the given criteria.

Answer:

1. COUNT
2. COUNTA
3. COUNTBLANK
4. COUNTIF

Question 18.
What is the use of financial function ACCRINT in LibreOffice Calc
Answer:
ACCRINT ():
This function returns the accrued interest for a security that pays periodic interest.
Syntax: = ACCRINT(Issue, First_Interest, settlement, rate, Par, frequency, basis, calc_method)

Question 19.
Explain the difference between relative cell reference and absolute cell reference?
Answer:
1. Relative Cell references:
By default cell reference is relative; which means that as a formula or function is copied and pasted to other cells, the cell references in the formula or function change to reflect the new location.

2. Absolute Cell reference:
The absolute cell reference consists of the column letter and row number surrounded by dollar ($) signs. Eg $A$5. An absolute cell reference is used when we want a cell reference to stay fixed on a specific cell.

Question 20.
What is the use of PIVOT TABLE?
Answer:
Preparation of reports using Pivot Tables:
A Pivot Table is a way to present information in a report format. A Pivot Table report provides enhanced layout, attractive and formatted report with improved readability. There are two types of data table.

1. One-Variable Data Table (One – Variable )
2. Two-Variable Data Table (Two-Variable)
   • The one variable Data Table allows us to identify a single decision variable in our model and see how changing the values for that variable affects the values calculated by one or more formulas in our model.
   • The two variable Data table allows us to specify two decision variables and a variety of inputs and only a single formula.

Plus Two Accountancy Spread Sheet Five Mark Questions and Answers

Question 1.
Define the following

1. Cell
2. Range
3. Worksheet
4. Workbook

Answer:
1. Cell:
The intersection of a row and a column is called a cell. A cell is identified by a combination of an alpha – numeric character eg: A1, B6, C10, etc. This alpha numeric character is called cell address. Hence each cell has a unique address.

2. Ranges:
Range is a group of adjacent cells that forms a rectangular area. A range is specified by giving the address for first cell in range and the last cell in the rage, eg: range starting from A10 to A20 is written as A10: A20 where colon (:) is the range operator.

3. Work sheets:
The work area which consists of rows and columns in a spreadsheet is called worksheet. By default three worksheets-sheet 1, sheet -2, sheet -3 are available in work book.

4. Workbook:
A file in spread sheet is known as a workbook. A work book is a collection of a number of work sheets.

Question 2.
What are the different spreadsheet reference functions in Libre Office Calc?
Answer:
Spreadsheet Reference Functions:
The important spreadsheet reference functions are

1. LOOKUP () functions:
The LOOKUP function returns a value either from a one-row or one-column range or from an array. The lookup function has two syntax forms: Vector form and Array form.

The vector form of LOOUP looks in a one-row or one column range (known as a vector) for a value, and then returns a value from the same position in a second one-row or one-column range.

The array form of LOOKUP looks in the first row or column of an array for the specified value, and then returns a value from the same position in the last row or column of the array.

LOOKUP (Vector from)
Syntax: = LOOKUP (search criterion, Search vector, Result vector)
LOOKUP (Array form)
Syntax: =(LOOKUP (lookup_value, array)

2. VLOOK UP ():
VLOOK UP is the vertical LOOKUP function. Use VLOOK UP to search the first column (columns are vertical) of a block of data and return the value from another column in the same row.
Syntax: = VLOOKUP (Search criterion; Array; Index; Sort Order)

3. HLOOKUP ( ):
It is the Horizontal LOOKUP function, searches for a value in the first row of a table array and returns the corresponding value in the same column from another row of the same table array.
Syntax: HLOOKUP (search criteria; index; sorted)

Question 3.
Give the cell address or range reference in the following situations.

1. Cell at 10^th Column and 9^th row.
2. Range starting from 2^nd Column 4^th row and spread till 8^th Column and 12^th row.

Answer:

1. J9.
2. B4: H12

Question 4.
What are the logical functions in LibreOffice Calc
Answer:
Logical Functions:
Logical functions are used for comparison and checking a test condition. The major logical functions are IF, AND and OR.

Question 5.
Explain the steps involved to insert a new work sheet in LibreOffice Calc
Answer:
Steps involved to insert a new work sheet in LibreOffice Calc.
Step 1 – Click on the [+] button in the sheet Tab

OR

Step 1 – Click on the work sheet in the sheet Tab Sheet Tab

Step 2 – Right click the mouse

Step – 3 Select insert sheet from the Drop up menu box
Drop up

Step 4- Add number of sheets and give name, press
OK

Question 6.
You are required to prepare a rank list for admission to the B.Com course. The Index mark is calculated as follows.
Sum of mark secured in Plus 2, Mark obtained in Accountancy and -25% of Mark obtained in Business studies. Give the entries in Libre Office Calc to get the index mark.
Answer:

• A1 → Total Mark
• B1 → Mark in Accountancy
• C1 → Mark in Business Studies
• D1 → Index Mark
• A2 → Enter the Marks
• B2 → Enter the Marks
• C2 → Enter the Marks
• D2 → =A2 + B2 + (C2 * 25%)

Question 7.
Match the following:

Answer:

Question 8.
The monthly sales of a company for the first six months are given below:

7. Find the total sales for the six months
8. Find the average sales of the six months
9. Find the lowest sales of the six months
10. Find the highest sales of the six months

Answer:

Question 9.
Give the range reference in the following cases.

1. Range beginning from 1^st column, 1^st row and ending 16^th column, 8^th row
2. Range beginning from 5^th column, 7^th Row and ending 27^th column, 37^th row

Answer:

1. A1: P8
2. E7: AA37

Question 10.
Match the following: