COMPUTER SCIENCE
CLASS-11th
Time Allowed : 1:30 Hours Maximum Marks : 25
Section-A
(Objective Type Questions)
Q1.DBMS is a computerized record keeping system. (True/False)
Ans.True
Q2.Database management system is Hardware.(True/False)
Ans.Flase
Q3.The Collection of Files or Tables is known as?
Ans: Database
Q4.D.B.M.S stands for?
Ans: Database Management System
Q5.What is the Full Form of Opcode?
Ans.Operation Code
Q6.Set of instructions is called _________________.
a. Group
b. Software
c. Program
d. None of these
Ans.c. Program
Q7.Which language is directly understood by computer without any translation?
a. Procedure Oriented Language
b. Machine Language
c. Assembly Language
d. High Level Language
Ans.b. Machine Language
SECTION-B
(Short Answer type Questions)
Q8.Explain the Application Areas of DBMS?
Ans: Some of the DBMS application areas are listed below:
1.DBMS is used to store student records in educational institutions.
2.DBMS is used to store bank customer information.
3.DBMS is used to store call records, monthly bills etc. information in the telecommunications sector.
4.DBMS is used to track the production and supply of goods in the manufacturing sector.
5.DBMS is used to store reservations and schedule information in the Tours and travel industry.
Q9.What do you mean by End User?
Ans: A DBMS has many different types of users and each user can have different rights to perform different types operations on the database. END USERS is a type of DBMS user. It includes those users who actually benefit from DBMS. End users can range from general audiences to intelligent users like business analysts.
OR
Q.What is Cloud database?
Ans: A cloud database is a database that typically runs on a cloud computing platform. Internet is used to access cloud databases. Cloud Database Services can be accessed in two ways:
1.In the first method, an organization purchases virtual machine space from a cloud service provider, and stores the database on the cloud. IT staff is used by the organization to control the database. In this system, the organization is responsible for monitoring and managing the database.
2.In the second method, the organization makes a subscription-based agreement with the cloud service provider. The database is stored on the cloud server, but the cloud service provider allows the database to be used as a service (Database as a service-DBaaS).
Q10.Write the names of different symbols used in flowcharts.
Ans: Following are the different symbols used in the flow chart:
Terminal (Oval symbol)
Input / Output (parallelogram)
Processing (rectangle)
Diamond (rhombus)
Flow lines (arrows)
Connectors (circles)
SECTION-C
(Long Answer Type Questions)
Q11.What are low level programming languages? Explain their advantages and disadvantages.
Ans: Machine and assembly languages are called low-level languages. These are explained below:
Machine language: Machine language is also called binary language. It is the fundamental language of computer systems because it is understood directly by the computer system. The computer does not require any translation to understand this language. This language is made up of only two binary digits 0 and 1.
Assembly Language: This language is also called Symbolic Language because it uses the symbolic names of the instructions instead of the binary code. The symbolic names of the assembly language instructions can be easily remembered.
Advantages of Low-Level Languages:
These languages can communicate / interact directly with computer hardware These languages work faster than computers.
Disadvantages of Machine Language:
For programming in low level languages, the programmer needs to know the internal structure of the hardware.Programs created in low level languages are machine dependent.
Q12.What is algorithm? Explain the different features that an algorithm should have.
Ans: Creating algorithms is a basic requirement in computer programming. This is a step-by-step description of how to solve a given problem. An algorithm has limited steps and it should always produce some (right or wrong) result. Before creating a program, a programmer first sets the algorithm.
An algorithm should have the following features:
Every step must be accurate.Every step should be clear, which means it should not be ambiguous.Input and output should be carefully determined.Steps should not be repeated indefinitely.After implementing the steps, the required output should be obtained in any case.
Some more Important Questions Which can come in paper:-
Q1.What are Language Translators? Explain any one translator in detail.
Ans: Language translators are also called language processors. These are system-programs. The purpose of developing language translators is to accomplish two main tasks: first, to translate source programs into Object Code, and second, to detect syntax errors in the source program. Each language has its own translator program that can only translate programs written in that particular language. Examples of language translators are: assemblers, compilers and interpreter.
Assembler: This is a language translator that converts programs written in assembly language into machine language. A program written in assembly language is called a source program. This source program cannot be directly understood by the computer. Therefore, it is necessary to translate it into a machine-understandable format. It is the assembler that converts the source program of the assembly language into a machine-understandable program. The code generated after translation is called the object program, which is used to execute the program.
Q2.What are Syntax Errors?
Ans: These are the errors that occur when we develop programs that do not follow the rules or syntax of programming language. These types of errors are automatically detected by compilers during the compilation process. A program cannot be successfully compiled until all syntax errors in the program have been corrected. Some examples of syntax errors in C language are: Missing Semicolon,Variable not declared, etc.
Q3.Explain different types of errors found in the computer programs.
Ans: There are two common types of errors in programs:
• Syntax Errors: These are the errors that occur when we develop programs that do not follow the rules or syntax of programming language. These types of errors are automatically detected by compilers during the compilation process. A program cannot be successfully compiled until all syntax errors in the program have been corrected. Some examples of syntax errors in C language are: Missing Semicolon, Variable not declared, etc.
• Logical Errors: These errors occur when there are the errors in the logic of the program. If there are logical errors in our program, it will be successfully compiled but it will produce incorrect results / output. Such errors cannot be detected by the compiler. These can be easily found with the help of debugging tools.