Join Us ::

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

Computer Science :: All Aptitude Test ::

Home » GAT Subject » Computer Science » Aptitude Test - 33
1.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
2.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
3.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
4.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
5.The modify operation is likely to be done after
A. Delete
B. Look-up
C. Insert
D. Delete
6.One data dictionary software package is called
A. DB/DC dictionary
B. TOTAL
C. ACCESS
D. DB/DC dictionary
7.One approach to standardizing storing of data
A. MIS
B. structured programming
C. CODASYL specifications
D. MIS
8.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
9.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
10.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
11.A _____ Contains fields of data about one entity.
A. Record
B. File
C. Fields
D. Record
12.A condition that led to the development of databases was
A. a demand for more data to support information needs
B. an increase in the amount of data handled by organizations
C. the proliferation of data files
D. a demand for more data to support information needs
13.The _____ command is used to allocates an extent for the table in SQL
A. MODIFY ALLOCATES
B. MODIFY TABLE
C. ALTER TABLE
D. MODIFY ALLOCATES
14.Embedded pointer provide
A. a secondary access path
B. a physical record key
C. an inverted index
D. a secondary access path
15.Which of the following is a type of DBMS software?
A. database manipulation language
B. query language
C. utilities
D. database manipulation language
16.Data items grouped together for storage purposes are called a
A. record
B. title
C. list
D. record
17.The activity of a file
A. is a low percentages of number of records added or deleted from a file
B. if high, reduces processing efficiency for sequential and nonsequential files
C. is a measure of the percentage of existing records updated during a run
D. is a low percentages of number of records added or deleted from a file
18.Versatile report generators can provide
A. Columnar totals
B. Subtotals
C. Calculations
D. Columnar totals
19.Related fields in a data base are grouped to form
A. data file
B. data record
C. menu
D. data file
20.A _____ means that one record in a particular record type can be related to many records in another record type and vice-versa.
A. One-to-one relationship
B. One-to-many relationship
C. Many-to-one relationship
D. One-to-one relationship
21.In SQL, the _____ command is used to recompile a view
A. COMPILE VIEW
B. DEFINE VIEW
C. CREATE VIEW
D. COMPILE VIEW
22.A list in alphabetical order
A. is in descending order
B. is in ascending order
C. is the result of a sort operation
D. is in descending order
23.If a piece of data is stored in two places in the database, then
A. storage space is wasted
B. changing the data is one spot will cause data inconsistency
C. it can be more easily accessed
D. storage space is wasted
24.A data dictionary is a special file that contains
A. the names of all fields in all files
B. the data types of all fields in all files
C. the widths of all fields in all files
D. the names of all fields in all files
25.A file that is organized in uniform format is formally referred to as a _____ or a database file.
A. Document
B. Database
C. Record
D. Document
26.A form can be used to
A. modify records
B. delete records
C. format printed output
D. modify records
27.Which language has recently become the de-facto standard for interfacing application programs with relational database system?
A. Oracle
B. SQL
C. dBASE
D. Oracle
28.Which of the following is not true of the traditional approach to information processing?
A. There is common sharing of data among the various applications
B. It is file-oriented
C. Programs are dependent on the files
D. There is common sharing of data among the various applications
29.Batch processing is appropriate if
A. a large computer system is available
B. only a small computer system is available
C. only a few transactions are involved
D. a large computer system is available
30.What is the abbreviation used for a software package that permits the users to create, retrieve and maintain records in a database?
A. DASD
B. FMS
C. EMMS
D. DASD
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-2025 by Pak-MCQs.net All Rights Reserved.

Email: [email protected]