Computer Science -II

CONTENTS COMPUTER-II SYLLABUS

1: Data Basics

2: Basic concepts and terminology

3: Data Base Design Process

4. Data integrity and normalization

5. Introduction to Microsoft Access

6. Table and query

7. Microsoft access – Forms and reports

8. Getting started with C

9. Elements of C

10. Input/ Output

11. Decision Construction

12. Loop Construction

13. Functions in C

14. File Handling in C

1|Page
Copyright © Roots International Schools and colleges, All right reserved BISE LHR |Computer Science XII, 2020
Chapter 1 Data Basics
Multiple Choice Questions (MCQs):

1) A collection of related fields is;

a) File b) Record c) Database d) None
2) A logical grouping of characters is a;
a) Field b) Record c) File d) All
3) Which of the following is also known as data set?
a) Record b) Field c) File d) All
4) Which of the following is an image file extension?
a) .tif b) .jpg c) .bmp d) All
5) A database is an organized collection of _______ related data.
a) Logically b) Physically c) Loosely d) Badly
6) Traditional file system stores data in
a) Different file b) not more than 4 file c) temporary file d) none of the above
7) When operation is applied on Master file then temporary processed data stored in
a) master file b) primary file c) transaction file d) secondary file
8) Microsoft SQL Server is an example of:
a) database management system b) MS Office c) application data d)
database
9) Name the option that makes information from data
a) input b) Output c) action d) process
10) Identify data in given options
a) processed information b) collection of raw facts c) binary data d)
organized information

2|Page
Copyright © Roots International Schools and colleges, All right reserved BISE LHR |Computer Science XII, 2020
Chapter 2 -Basic Concept and
Terminology
Multiple Choice Questions (MCQs)
1) The columns of a table correspond to;

a) Table b) Record c) Field d) Cell

2) A row of a relation is called a (n);

a) Attribute b) Entity c) Tuple d) a & c

3) A table must have;

a) Primary key b) Secondary key c) Composite key d) Sort key

4) Insert command is used to insert;

a) New table b) New record c) View d) Dependencies

5) Which of the following is also known as control key?

a) Sort key b) Composite key c) Candidate key d) Primary key

6) SQL is used for

a) Data definition b) data manipulation c) data definition and manipulation

d) Searching records

7) CREATE command is used to create a

a) Table b) view c) report d) query

8) A foreign key is found in

a) Parent table b) dependent table c) pivot table d) index table

3|Page
Copyright © Roots International Schools and colleges, All right reserved BISE LHR |Computer Science XII, 2020
Chapter 3 – Data base Design Process
Multiple choice questions (MCQs)

1) Which of the following is used to define objects and describe their characteristics?

a) Attribute b) Relationship c) a & b d) None

2) Which is not included in the definition of an entity?

a) Person b) Object c) Concept d) Action

3) Which of the following are ingredients of data modeling?

a) Entities/Objects b) Attribute c) Relationship d) All

4) Organizing the database in computer hard disk storage is done in;

a) Logical design b) Physical design c) Analysis d) Implementation

5) DFD stands for

a) Data flow diagram b) data build diagram c) data forward data d) none of the above

6) In hybrid distribution which kind of fragments are stored at only one site

a) Critical fragment b) non-critical fragments c) critical and non- critical fragments d)

only large fragments

7) In ERD model, a relationship between two entities is represented by a:

a) Diamond symbol b) rectangular box c) oval symbol d) line’

8) Which of the following keys does not hold the uniqueness property

a) Candidate key b) foreign key c) primary key d) secondary key

4|Page
Copyright © Roots International Schools and colleges, All right reserved BISE LHR |Computer Science XII, 2020
9) ERD stands for

a) Entity return diagram b) entity relation diagram c) entity round diagram

d) Both c and b

10) Data modeling is the process of

a) Identifying the data objects b) relationship between the objects c) identifying

requirement d) both a and b

5|Page
Copyright © Roots International Schools and colleges, All right reserved BISE LHR |Computer Science XII, 2020
Chapter 4 – Data integrity &
normalization

Multiple choice questions (MCQs)

1) In 3NF, which form of dependency is removed?

a) Functional b) Non-functional c) Associative d) Transitive

2) Two or more attributes having different names but same meaning are called;

a) Homonyms b) Aliases c) Synonyms d) Alternate attributes

3) The attribute on the left hand side of the arrow in a functional dependency is;

a) Candidate key b) Determinant c) Foreign key d) Primary key

4) In 2NF, which form of dependency is removed?

a) Functional b) Partial c) Associative d) Transitive

5) Which of the following anomalies result from a transitive dependency?

a) Insertion b) Modification c) Deletion d) All

6) In relational database, a table is also called

a) Tuple b) relation c) file d) schema

7) Different attributes in two different tables having same name are referred to as
a) Synonyms b) homonym c) acronym d) mutually exclusive

8) Every relation must have a

a) Primary key b) candidate key c) secondary key d) composite key

6|Page
Copyright © Roots International Schools and colleges, All right reserved BISE LHR |Computer Science XII, 2020
Chapter 5 – Introduction to MS Access
Multiple choice questions (MCQs)

1) A Database consists of various components called: -

a) Tools b) Properties c) Entities d) Objects
2) An MS Access table Contains: -
a) Fields b) Records c) Characters d) All
3) A report may be based on a :
a) Table b) Query c) Both a & b d) None
4) It is very simple to create database using:
a) Query b) Wizard c) Common Standard d) Easier
Programming
5) The columns of a table correspond to
a) Table b) Record c) Field d) Cell
6) The maximum number of table in a database can be:
a) 1 b) 2 c) 3 d) 4
7) Which of the following is the correct association?
a) File=Col b) Record=row c) Field=row d) Record=table
8) Which of the following is not a database object?
a) Table b) Query c) Report d) MS Word
9) The output of the Query is in the form of a:-
a) Table b) Form c) Reports d) Query
10) Each set of related items in a table is called:-
a) Table b) Record c) Field d) Query

7|Page
Copyright © Roots International Schools and colleges, All right reserved BISE LHR |Computer Science XII, 2020
Chapter 6 – Table and Query
Multiple choice questions (MCQs)

1) The data in tables is entered in: -

a) Design View b) Normal View c) Datasheet view d) Layout View
2) How many table views are available in Microsoft Access?
b) 4 b) 3 c) 2 d) 1
3) How many types of relationship can be used?
b) 2 b) 3 c) 4 d) 5
4) In a relational database, a single piece of information is called
b) Table b) Record c) Entity d)
Attribute
5) Which field type can be indexed?
b) Memo b) Number c) Hyperlink d) OLE
6) Field Properties are shown in
b) Design View b) Datasheet View c) abs d) None
7) What is the default field size of a text data type field?
b) 2 b) 5 c) 20 d) 50
8) Field properties determine: -
b) Field size b) Input mask c) Default view d) All
9) Which does not improve data entry?
b) Input masks b) Validation rules c) indexing d) Required Fields
10) Which symbol is placed around dates in a criterion?
b) [] b) * c) () d) #

8|Page
Copyright © Roots International Schools and colleges, All right reserved BISE LHR |Computer Science XII, 2020
Chapter -7 MS Access forms & Reports

Multiple choice questions (MCQs)

1) Forms are designed to:

b) Input Data b) Manipulate data c) Accept Change d) All
2) How many are layout of report?
c) 2 b) 3 c) 4 d) 5
3) How many form layouts are provided by MS Access?
c) 2 b) 4 c) 6 d) 8
4) A sub form can be created using
c) Drag and drop b) form wizard c) sub-form wizard d) All
5) A report may be based on
c) Memo b) Number c) Hyperlink d) OLE
6) Field Properties are shown in
c) A table but not a query b) A query but not a table c) Both a& b d)
None
7) Which of the following is used to display yes/No values?
c) Checkbox b) option button c) Both a& b d)
None
8) Which auto form displays one record at a time?
c) Tabular Report b) Columnar c) Datasheet d) Justified
9) Which of the following is used to create and modify a form?
c) Form view b) Table Design c) form design d) New form design
10) Which of the following is used to display a list of items in forms?
c) List box b) combo box c) Both a&b d) None

9|Page
Copyright © Roots International Schools and colleges, All right reserved BISE LHR |Computer Science XII, 2020
Chapter -8 Getting Started with C

Multiple Choice Questions (MCQs)

1) Which of the following key is used to save a file?

a) F2 b) F3 c) F5 d) F9
2) The extension of object file is;
a) .c b) .txt c) .obj d) .h
3) The “.exe” file is produced by;
a) Linker b) Loader c) Compiler d) Interpreter
4) The extension of header file is;
a). CPP b) .txt c) .c d) .h
5) Void occupies how many bytes in memory?
a) 0 b) 1 c) 2 d) 4
6) C is a
a) High level language b) low level language c) machine language d) assembly language

7) Debug is the process of

a) creating bugs in program b) identifying and removing errors c) identifying errors
d) removing errors

8) Which of the following language requires no translator to the execute the program
a) C b) C++ c) Machine language d) Assembly Language

9) Turbo C++ can compile

a) C++ program only b) C and C++ programs c) Turbo C programs d) Turbo C++ program

10) Preprocessor directives are command for

10 | P a g e
Copyright © Roots International Schools and colleges, All right reserved BISE LHR |Computer Science XII, 2020
a) Microprocessor b) language processor c) C preprocessor d) Loader

Chapter # 9 – Elements of C

Multiple Choice Questions (MCQs)

1) Which of the following operators has lowest precedence?

a) ! b) + c) = d) = =
2) Variables and constants names cannot contain;
a) Number b) Underscore c) Letter d) Period
3) Number of bytes used by a double data type in C is;
a) 2 b) 8 c) 12 d) 16
4) An expression consists of;

a) Operators b) Operand c) a & b d) None

5) A relation expression produces results as;

a) True b) False c) a or b d) any value

6) Variables are created in
a) RAM b) ROM c) Hard Disk d) Cache
7) Which of the following is a valid character constant
a) a b) “b” c) ‘6’ d) =

8) Which of the following data types offers the highest precisions

a) float b) long int c) long double d) unsigned long it

9) A+= B is equivalent to
a) b+=a b) a=+b c) a=a+b d) b=b+a

11 | P a g e
Copyright © Roots International Schools and colleges, All right reserved BISE LHR |Computer Science XII, 2020
10) The symbol ‘=’, represents
a) Comparison operator b) assignment operator c) equal to operator
d) None of these

Chapter -10 Input/ Output

Multiple choice questions

1. How many variables can be used in one printf function?

a) One b) Two c) Three d) Many
2. _____ format specifier is used for float type data;
a) %d b) %s c) %c d) %f
3. The function that is used to display output on the screen is called;
a) printf b) scanf c) pow d) None
4. The general form of format specifier for floating point value is;
a) %m.nf b) m.n% c) m%.nf d) m.n%f
5. The escape sequence for backslash is;
a) \ b) \b c) \\ d) \t
6. Which of the following is not a valid escape code?
a) \t b) \r c) \y d) \f

7. The function getche () is defined in

a) stdio.h b) string.h c) math.h d) conio.h

8. The format specifier %u is used for

a) Integer b) unsigned short c) unsigned float d) unsigned long int

9. In statement scanf (“%f”, & kilometer); kilometer is a (n)

a) integer variable b) float variable c) string variable d) double variable

10. ASCII code for a character is displayed using format specifier

a) %d b) %f c) %c d) % x

12 | P a g e
Copyright © Roots International Schools and colleges, All right reserved BISE LHR |Computer Science XII, 2020
Chapter -11 Decision Construction

Multiple Choice Questions (MCQs)

1. Which programming structure executes program statements in order?

a) Relation b) Decision c) Sequence d) Repetition
2. Relational operators allow you to _______ numbers;
a) Compare b) Add c) Multiply d) Divide
3. In if statement, true is represented by;
a) 0 b) 1 c) 2 d) 3
4. Which of the following are valid case statements in a switch?
a) Case 1: b) case x<4: c) case ‘ab’: d) case
1.5:
5. The case block ends with;
a) End Select b) End Case c) Break; d) Case else

13 | P a g e
Copyright © Roots International Schools and colleges, All right reserved BISE LHR |Computer Science XII, 2020
Chapter- 12 Loops Construct

Multiple Choice Questions (MCQs)

1) A counter can be defined as:

a) Final Value of a loop b) variable that counts loop iterations c) initial
value of a loop d) all
2) Which loop structure always executes at least once?
a) Do-while b) For c) While d) All
3) The loop which never ends is called?
a) Infinite loop b) running loop c) continuous loop d) nested loop
4) One execution of a loop is known as?
a) cycle b) duration c) iteration d) test
5) How many types of loop structure are available in C?
a) 4 b) 3 c) 2 d) 6
6) What is the final value of x after executing the following code: for(Int x=0;x<10;x++)
a) 10 b) 9 c) 0 d) 1
7) The keyword break cannot be used within?
a) Do-while b) IF-ELSE c) for d) while
8) Which of the following is a loop statement?
a) IF b) IF-else c) Switch d) None
9) This means to increase a value by one?
a) Modulus b) Increment c) Decrement d) Inc
10) In which loop the condition comes after the body of the loop?
a) While loop b) Do-while Loop c) for loop d) b&c

14 | P a g e
Copyright © Roots International Schools and colleges, All right reserved BISE LHR |Computer Science XII, 2020
Chapter – 13 Functions In C

Multiple Choice questions (MCQs)

1) The printf is a
a) Built in function b) User defined function c) Local function d) None
2) Multiple arguments to a function are separated by
a) Comments b) Semicolons c) Colons d) Commas
3) A built-in function
a) Cannot be redefine b) Can be redefined c) cannot return a value d) Should be
redefined
4) Local Variable are also called
a) Automatic variable b) Normal variable c) Global variables d) Basic Variable
5) The Scope of a variable refers to its
a) Length b) Name c) Accessibility d) Data type
6) Function prototypes for built -in functions are specified in
a) source files b) header file c) object file d) image files
7) Memory is allocated to a local variable at the time of its
a) declaration b) destruction c) definition d) first reference

8) Formal arguments are also called

a) Actual arguments b) dummy arguments c) original arguments d) referenced
arguments
9) In a C program two functions can have
a) same name b) same parameters c) same name and same parameters d) same
name but different parameters
10) Global variables are created in ?
a) RAM b) ROM c) Hard disk c) Cache

15 | P a g e
Copyright © Roots International Schools and colleges, All right reserved BISE LHR |Computer Science XII, 2020
Chapter 14- File Handling in C

Multiple choice questions (MCQs)

1) A file is stored in?

a) Ram b) Hard disk c) Rom d) Cache
2) Which of the following function is used to write a string to a file?
a) Puts () b) Putc () c) fputs () d) fgets ()
3) Which of the following character is used to mark the end of the string?
a) \0 b) /0 c) \a d) \n
4) A stream is a _______interface to a file
a) Logical b) Serial c) Parallel d) Graphical
5) A ______________ can store text only
a) Binary File b) Text file c) Exe file d) Object File
6) Which of the following mode open only an existing file for both reading and writing
a) “w” b) “w+” c) “r+” d) “a+”
7) On successful closing of a file , the fclose () returns
a) NULL b) 0 c) 1 d) FILE pointer
8) An array subscript should be
a) int b) float c) double d) an array

16 | P a g e
Copyright © Roots International Schools and colleges, All right reserved BISE LHR |Computer Science XII, 2020