ICS Part 2 Computer Science Online Test With Answers

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

Is this page helpful?

Share your comments & questions here

Guest

  • No comments yet. Be the first to comment!