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 - 159
Hassan
1.An-owner-member set in the CODASYL specifications may have
A. only one owner but many owner occurrences
B. only one member but many member occurrence
C. more than one member but only one occurrence per member
D. only one owner but many owner occurrences
2.What is the name given to the database management system which is able to handle full text data, image data, audio and video?
A. Full media
B. Graphics media
C. Multimedia
D. Full media
3.A top-to-bottom relationship among the items in a database is established by a
A. Hierarchical schema
B. Network schema
C. Relational schema
D. Hierarchical schema
4.A database management system
A. allows simultaneous access to multiple files
B. can do more than a record management system
C. is a collection of programs for managing data in a single file
D. allows simultaneous access to multiple files
5.Which of the following hardware components is the most important to the operation of a database management system?
A. high-resolution video display
B. printer
C. high speed, large-capacity disk
D. high-resolution video display
6.The PROJECT command will create new table that has
A. more fields than the original table
B. more rows than the original table
C. both (a) and (b)
D. more fields than the original table
7.To have a file hold a list, it is necessary to
A. identify the records in the list
B. identify the name, width and type of the fields of each record.
C. decide which fields will be used as sort or index keys
D. identify the records in the list
8.Sophisticated report generators can
A. print row-oriented reports
B. perform arithmetic operations
C. selectively retrieve and print portions of a list
D. print row-oriented reports
9.In a _____ a parent record type can be linked to one or more "child" record types, but a child record type can have only one parent.
A. Network database
B. Relational database
C. Distributed database
D. Network database
10.Which two files are used during operation of the DBMS?
A. query language and utilities
B. data manipulation language and query language
C. data dictionary and transaction log
D. query language and utilities
11.When using a database management system, the first thing that you must do is to
A. create a database file
B. activate file editor
C. load the software into your micro¬computer
D. create a database file
12.A network schema
A. restricts the structure to a one-to-many relationship
B. permits many-to-many relation¬ships
C. stores data in tables
D. restricts the structure to a one-to-many relationship
13.Which of the following is not a relational database?
A. dBASE IV
B. 4th Dimension
C. FoxPro
D. dBASE IV
14.Which command is used to remove a table from the database in SQL?
A. DELETE TABLE
B. DROP TABLE
C. ERASE TABLE
D. DELETE TABLE
15.A large computer information system maintains many different computer files. Which amongst them is called a perpetual file?
A. Specialized file
B. Log file
C. Master file
D. Specialized file
16.A file produced by a spreadsheet
A. is generally stored on disk in an ASCII text format
B. can be used as it by the DBMS
C. can be used for graphic
D. is generally stored on disk in an ASCII text format
17.A form defines
A. where data is placed on the screen
B. the width of each field
C. both (a) and (b)
D. where data is placed on the screen
18.Which of the following is true of a network structure?
A. It is a physical representation of the data
B. It allows a many-to-many relationship
C. It is conceptually simple
D. It is a physical representation of the data
19.In SQL, GRANT command is used to
A. allow user to access databases
B. allow user to create databases
C. grant system privileges, roles, and object privileges to uses and roles
D. allow user to access databases
20.The highest level in the hierarchy of data organization is called
A. data bank
B. database
C. data file
D. data bank
21.The logical data structure with a one-to-many relationship is a :
A. network
B. tree
C. chain
D. network
22.Updating a database means
A. revising the file structure
B. reorganizing the database
C. modifying or adding record occurrences
D. revising the file structure
23.In SQL, which command(s) is(are) used to enable/disable all triggers on a table?
A. ALTER TRIGGERS
B. ALTER TABLE
C. MODIFY TRIGGERS IN TABLE
D. ALTER TRIGGERS
24.When you have finished entering information into a form
A. the template is written to the data file
B. the contents of the form are written to the data file
C. the contents of the form can be printed
D. the template is written to the data file
25.The main idea behind computer files is that it is convenient to
A. arrange them
B. store information together
C. create them
D. arrange them
26.A list consists of last names, first names, addresses, and pin codes if all people in the list have the same last and the same pin code, a useful key would be
A. the pin code
B. the last name
C. a compound key consisting of the first name and the last name
D. the pin code
27.In SQL, which command is used to add new rows to a table?
A. ALTER TABLE
B. ADD ROW
C. INSERT
D. ALTER TABLE
28.A number of related records that are treated as a unit is called
A. file
B. field
C. data
D. file
29.If you want to group the records in the abc database, you could use the Jobcode as the _____.
A. Delete
B. Update
C. Sort Key
D. Delete
30.The Management Information system (MIS) structure with one main computer system is called a
A. hierarchical MIS structure
B. distributed MIS structure
C. centralized MIS structure
D. hierarchical MIS structure
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]