Join Us ::

Menu Home Classes GK Engineering Past Papers Current Affairs Technical GAT Subject Programming Medical Papers

GAT Subject :: All Aptitude Test ::

Home » GAT Subject » Aptitude Test - 161
Hassan
1.A _____ means that one record in a particular record type is related to only one record of another record type.
A. One-to-one relationship
B. One-to-many relationship
C. Many-to-one relationship
D. One-to-one relationship
2.A _____ database does not use pointers or physical links, but instead finds related records by examining the contents of fields.
A. Network
B. Hierarchical
C. Relational
D. Network
3.Which of the following is a serious problem of file management systems?
A. difficult to update
B. lack of data independence
C. data redundancy
D. difficult to update
4.With respect to data input, the most accurate description of batch control is
A. dividing documents to be entered into batches
B. controlling the input of each input clerk
C. comparing to a pre-calculated figure the total of a data item summed across a batch records put into the system
D. dividing documents to be entered into batches
5.The model for a _____ resembles the hierarchical model in many respects.
A. Network database
B. Relational database
C. Distributed database
D. Network database
6.In any hierarchy of data organization, the smallest entity to be processed as a single unit is called
A. data field
B. data record
C. data file
D. data field
7.Long-range planning report produced in an MIS are primarily designed for
A. top management
B. middle management
C. lower management
D. top management
8.The model for a record management system might be
A. handwritten list
B. a Rolodex card file
C. a business form
D. handwritten list
9.The designer of a form includes
A. filed designators
B. prompts
C. data
D. filed designators
10.Which of the following contains a complete record of all activity that affected the contents of a database during a certain period of time?
A. report writer
B. query language
C. data manipulation language
D. report writer
11.Two files may be joined into a third file if
A. they have a row in common
B. they have a field in common
C. they have no records with the same value in the common field
D. they have a row in common
12.Characteristic(s) of a distributed MIS structure is
A. interactive sharing of the workload
B. a multiprocessing environment
C. computers supporting local DP operations
D. interactive sharing of the workload
13.The data-base environment has all of the following components except:
A. users
B. separate files
C. data base
D. users
14.The way a particular application views the data from the data base that the application uses is a :
A. module
B. relational model
C. schema
D. module
15.A compound key
A. is made up a several pieces of information
B. uniquely identifies an item in a list
C. both (a) and (b)
D. is made up a several pieces of information
16.The distinguishable parts of a record are called
A. files
B. data
C. fields
D. files
17.Large collections of files are called
A. fields
B. records
C. databases
D. fields
18.The index consists of
A. a list of keys
B. pointers to the master list
C. both (a) and (b)
D. a list of keys
19.In SQL, which command is used to select data in rows and column from one or more tables?
A. CHOOSE
B. SELECT
C. LIST
D. CHOOSE
20.A scheme describes
A. data elements
B. records and files
C. record relationships
D. data elements
21.A report form
A. appears on the computer monitor during data entry
B. is used during report generation to format data
C. both (a) and (b)
D. appears on the computer monitor during data entry
22.A computer file can be best described as
A. a single data item
B. a general collection of data items
C. an orderly collection of data items
D. a single data item
23.A good query system
A. can accept English language commands
B. allows non-programmers to access information stored in a database
C. can be accessed only by data processing professionals
D. can accept English language commands
24.If you want to organize a file in multiple ways, it is better to _____ the data rather than to sort it.
A. Delete
B. Update
C. Sort Key
D. Delete
25.The modify operation is likely to be done after
A. Delete
B. Look-up
C. Insert
D. Delete
26.One data dictionary software package is called
A. DB/DC dictionary
B. TOTAL
C. ACCESS
D. DB/DC dictionary
27.One approach to standardizing storing of data
A. MIS
B. structured programming
C. CODASYL specifications
D. MIS
28.What software packages are commonly used for businesses that have to track extensive lists of clients and inventory?
A. Special purpose packages
B. Custom made programs
C. Single function application packages
D. Special purpose packages
29.A multiple-form file management system
A. lets you define different forms for different operations
B. lets you create a look-up form with an associated read-only password to prevent access by unauthorized users
C. both (a) and (b)
D. lets you define different forms for different operations
30.The term _____ is sometimes used to refer to a data file in which all the records have the same record format, that is, the same field names, field lengths, and data types.
A. Database
B. Table
C. Flat file
D. Database
Related Subjects

Date to Date Current Affairs 2022

PakMCQs.net

Quick Links

GAT Subject



   Computer Science    English Mcqs    Agriculture    

Engineering



   Computer Science    Civil Engineering    

Technical



   Networking    Electronics    Database    

Past Papers



   Model Papers    FPSC Papers    
Our Team | Career | Contact | JoinUs | Privacy Policy | DMC

© 2020-2024 by Pak-MCQs.net All Rights Reserved.

Email: [email protected]