12th Class ICS Computer Science Chapter Wise Online MCQ Test With Answers PDF

ICS Part 2 Computer Science Online Test

Sr. #	Questions	Answers Choice
1	Which of the following are objects in an MS Access database?	Tables,forms,queries, and reports Database, Datasheet, And forms views Folders and Tools All of these
2	Which object is used to store data and define structure for the data in a database?	Table Macro Form Query
3	Which of the following is NOT a database object?	Table Query Report MS word
4	Which is displayed in title bar of an open database?	Program name Database name Object type All of these
5	Which option in MS Access is used to create a new database form scratch?	Access template Blank database Existing databse New folder
6	An MS Access table contains:	Fields Records Characters All
7	A report is a complete set of _______ field:	Distinct Related Designed All
8	Microsoft access saves the database with the extension:	.mdb .msdb .madb .mxls
9	Which object is used to retrieve data from database and present in formatted way?	Report Form Table Query
10	The output of the query is in the form of a :	Table Form Report Query
11	Which of the following database object is used to retrieve data form database ?	Queries Forms Reports Tables
12	A data base consists of various components called:	Tools Properties Entities Objects
13	The 1NF describes the tabular format in which:	All the key attributes are defined No repeating groups in the table All attributes are dependent on primary key All
14	A relation is in third normal form if it is in second normal form and:	Dependent on part of the key Dependent on the whole key Independent of the key Has no transitive dependencies
15	Which of the following anomalies result from a transitive dependency ?	Insertion Modification Deletion All
16	A functional dependency between two or more non-key attributes is called:	Partial functional dependency Partial non-key dependency Transitive dependency None
17	Which of the following are anomalies that can be caused by redundancy in tables?	Insertion Deletion Modification All

Download This Set