PPSC Computer Science Full Book test With Answers

PPSC Computer Science Full Book test

Sr. # Questions Answers Choice
1 The size of the field with number data type can not be. 2 4 8 16
2 Which of the following is not a field type in access Memo Hyper link Oie object Look up Wizard
3 The size of yes no field is always 1 bit 1 byte 1 GB 1 Character
4 The default and maximum size of text field in access. 50 and 255 characters 8 and 1 GB 266 Characters and 64000 characters. None
5 In table design view what are the first column of buttons used for Indicate primary key Indicate current row Both of above None
6 In table design view which key can be used to switch between the field names and properties panels. F3 F4 F5 F6
7 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
8 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
9 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
10 Which of the following data base object produce the final result to present. forms Reports Queries Tables
11 Which of the following data base object hold data. Forms Report Queries Tables
12 Which of the following is Not A type of Microsoft access Data base object. Table Form Worksheets Modules
13 What is the columns n Microsoft access table called. Rows Record Fields Columns
14 A__ enables you to view Data Base A table based on a specific criterion Form Query Macro Report
15 Which of the following is Not A Data Base object. Tables Queries Relationships Reports
16 What is the maximum length A text field Can be. 120 255 265 75
17 The Data base language that allow you to access or maintain data in Data base. DCL DML DDL None
18 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
19 Microsoft Access is A RDBMS OODBMS ORDBMS Network Data base Model
20 Following is not A data base model Network Data base model Relational Data base model Object oriented data base model None
21 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
22 Which of the field has width 8 bytes. Memo Number Date/time Hyper link
23 The Data base language concerned with the definition of the whole Data base structure and scheme is DCL DDL DML All above
24 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
25 It is an association established between common Line Relationship Primary key Record
26 This key Uniquely identifies each record. Primary key Key Record Unique key Field name
27 In A data base table The category of information is called _______ Tuple Field Record All above
28 The third stage in Designing A database is when We analyze our tables more closely and create a _________ between tables. Relationship Join Query None
29 The command center of access file that appears when you create or open the MS access database file. Database window Query Window Design view window Switch board
30 Which of the following creates A drop down list of values to choose from. Ole object Hyper link Memo Lockup Wizard
Download This Set

Is this page helpful?