PPSC Computer Science Chapter 6 Microsoft Access Online Test With Answers

PPSC Computer Science Chapter 6 Microsoft Access Online Test

Sr. # Questions Answers Choice
1 When creating a new able which method can be used to choose field from standard data bases and tables. Create table in design view Create table using wizard Create table by entering data None
2 To create a new table in which method you don't need to specify the field type and size. Create table in design view Create table using wizard Create table by entering data All of above
3 Which of the following is method is create a new table in MS Access. Create table in design view Create table using wizard Create table by entering data All of above
4 Which of the following data base object produce the final result to present. forms Reports Queries Tables
5 Which of the following data base object hold data. Forms Report Queries Tables
6 Which of the following is Not A type of Microsoft access Data base object. Table Form Worksheets Modules
7 What is the columns n Microsoft access table called. Rows Record Fields Columns
8 A__ enables you to view Data Base A table based on a specific criterion Form Query Macro Report
9 Which of the following is Not A Data Base object. Tables Queries Relationships Reports
10 What is the maximum length A text field Can be. 120 255 265 75
11 The Data base language that allow you to access or maintain data in Data base. DCL DML DDL None
12 DCL provides commands to perform actions like Change the structure of tables Insert update or delete records and data values Authorizing access and other control over data base None
13 Microsoft Access is A RDBMS OODBMS ORDBMS Network Data base Model
14 Following is not A data base model Network Data base model Relational Data base model Object oriented data base model None
15 Which of the following statement is true. Foreign key field don't allow duplicate values. In primary key field you can enter duplicate value In an indexed field you may or may not enter duplicate value depending upon setting. All statements are true
16 Which of the field has width 8 bytes. Memo Number Date/time Hyper link
17 The Data base language concerned with the definition of the whole Data base structure and scheme is DCL DDL DML All above
18 This is the stage in Data base design where one Gathers and list all the necessary field for the data base project. Data definition Data refinement Establishing Relationship None of the above
19 It is an association established between common Line Relationship Primary key Record
20 This key Uniquely identifies each record. Primary key Key Record Unique key Field name
Download This Set

Is this page helpful?