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 - 162
Hassan
1.A _____ Contains fields of data about one entity.
A. Record
B. File
C. Fields
D. Record
2.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
3.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
4.Embedded pointer provide
A. a secondary access path
B. a physical record key
C. an inverted index
D. a secondary access path
5.Which of the following is a type of DBMS software?
A. database manipulation language
B. query language
C. utilities
D. database manipulation language
6.Data items grouped together for storage purposes are called a
A. record
B. title
C. list
D. record
7.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
8.Versatile report generators can provide
A. Columnar totals
B. Subtotals
C. Calculations
D. Columnar totals
9.Related fields in a data base are grouped to form
A. data file
B. data record
C. menu
D. data file
10.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
11.In SQL, the _____ command is used to recompile a view
A. COMPILE VIEW
B. DEFINE VIEW
C. CREATE VIEW
D. COMPILE VIEW
12.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
13.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
14.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
15.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
16.A form can be used to
A. modify records
B. delete records
C. format printed output
D. modify records
17.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
18.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
19.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
20.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
21.Which of the following is not an advantage of the data-base approach?
A. elimination of the data redundancy
B. ability to associate related data
C. increased security
D. elimination of the data redundancy
22.Data encryption techniques are particularly useful for
A. reducing storage space requirements
B. improving data integrity
C. protecting data in data communication systems
D. reducing storage space requirements
23.It is more accurate to define a _____ as a variety of different record types that are treated as a single unit
A. Database
B. Table
C. Record
D. Database
24.A logical schema
A. is the entire database
B. is a standard way of organizing information into accessible parts
C. describes how data is actually stored on disk
D. is the entire database
25.Queries to a database
A. are written in English
B. can use aggregate functions like SUM and COUNT
C. both (a) and (b)
D. are written in English
26.In order to use a record management system
A. You need to understand the low-level details of how information in stored
B. You need to understand the model the record management system uses.
C. Both (a) and (b)
D. You need to understand the low-level details of how information in stored
27.In SQL, which command is used to select only one copy of each set of duplicable rows
A. SELECT DISTINCT
B. SELECT UNIQUE
C. SELECT DIFFERENT
D. SELECT DISTINCT
28.The physical location of a record is determined by a mathematical formula that transforms a file key into a record location in
A. a tree file
B. an indexed file
C. a hashed file
D. a tree file
29.Which command is used to select distinct subject (SUB) from the table (BOOK)?
A. SELECT ALL FROM BOOK
B. SELECT DISTINCT SUB FROM BOOK
C. SELECT SUB FROM BOOK
D. SELECT ALL FROM BOOK
30.The master list of an indexed file
A. is sorted in ascending order
B. contains only a list of keys and record numbers
C. has a number assigned to each record
D. is sorted in ascending order
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]