TOP STAR ACADEMY
TEST FOR 2nd YEAR CLASS
Computer Science
Subject: _____________________________ Total Time: 30 Mints
Student Name: _________________________ Roll No. ____________________
40
Total Marks: __________________________ Obtain Marks _______________
Objective Type
1. Encircle the Correct Option. (1 x 40 = 40)
1) The concept of database evolved from .
a) Computers b) Traditional File management system c) Software d) Hardware
2) The number of characters in fixed - length field is .
a) Constant b) 5 c) 255 d) Variable
3) The number of characters in variable - length field is .
a) Constant b) 5 c) 255 d) Variable
4) Insert command is used to insert .
a) A new record b) A new column c) A view d) A new table
5) The row of table is also called .
a) Entity b) Attributes c) Cell d) Record
6) An attribute is also known as .
a) Relation b) Row c) Field d) Tuple
7) Atomicity means .
a) Individual value in a cell b) Individual value in a table c) Individual value in a row d) Individual value in a tuple
8) Another name for file is called .
a) Collection records b) Row c) Dataset d) Tuple
9) The column(s) of a relation correspond to .
a) Table b) Cell(s) c) Field(s) d) Records
10) The columns of a table correspond to .
a) Table b) Record c) Field d) Cell
11) Following represents an entity .
a) Car b) Student c) House d) All of these
12) Teachers , students and cars are example of .
a) Relationships b) Entity c) Attributes d) Identifiers
13) A table is also called .
a) Two dimensional array b) Relation c) Both A & B d) Key
14) A table is a two - dimensional array that consists of .
a) Matrix elements b) x and y coordinates c) Intersection of data d) Columns and rows
15) Following two objects cannot have the same name in a database .
a) Tables b) Rows c) Database d) Records
16) CREAT TABLE command is used to create a .
a) Table b) View c) Report d) Query
17) In the Relation , following is insignificant .
a) Name of relation b) Number of records c) Order of rows d) Size of relation
Page 1 of 2
18) The following is / are the property / properties of relation .
a) Each attribute has a b) No multivalued c) No two rows are same d) All of these
different name attributes
19) SQL is used for .
a) Data manipulation b) Data definition c) Data deletion d) All of these
20) Views are used to .
a) Hide SQL statements b) Hide columns c) Hide rows d) All of these
21) Views are also called .
a) Complex tables b) Simple tables c) Virtual tables d) Actual tables
22) A virtual table that is constructed from other tables is called .
a) Tuple b) Table c) View d) Report
23) Following helps the database system to run smooth and fast .
a) Computer b) Software c) Table d) Index
24) A key is .
a) A unique field that b) The first field of a table c) The most important field in a d) The last field of a table
identifies a record table
25) A table must have a .
a) Primary key b) Secondary key c) Composite key d) Sort key
26) The following is the most suitable example of primary key .
a) Name b) Birth date c) Address d) NIC number
27) How many primary keys can exists in a relation ?
a) Al least two b) Only one c) No limit d) More than one
28) Following key consists of two or more than two attributes of a table .
a) Composite key b) Foreign key c) Primary key d) Sort key
29) Which of the following is also known as control key ?
a) Foreign key b) Composite key c) Primary key d) Sort key
30) Foreign key is found in .
a) Parent Table b) Dependent Table c) Pivot Table d) Index table
31) Following serves as a bridge between end users and database administrator .
a) Data administrator b) Application programmer c) System analyst d) None of these
32) A person who is responsible for the organization of entire data of an organization is called .
a) DBA b) DA c) Administrator d) System administrator
33) DBA stands for .
a) Database application b) Database administrator c) Database access d) Dual base administrator
34) A person who is responsible for the security and maintenance of database is called .
a) DBA b) DA c) User d) System administrator
35) Insert command is used to insert .
a) A new table b) A new record c) A view d) Dependencies
36) CREATE command is used to create a .
a) Table b) View c) Report d) Query
37) SQL is used for .
a) Data definition b) Data definition and manipulation c) Data manipulation d) Searching records
38) The foreign key is found in .
a) Parent table b) Dependent table c) Pivot table d) Index table
39) A table must have .
a) Primary key b) Secondary key c) Composite key d) Sort key
40) Views are also called.
a) Complex Tables b) Simple Tables c) Virtual Tables d) Actual Tables
Page 2 of 2
