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 - 30
1.Data item characteristics that are important in data management include
A. punctuation
B. language
C. spelling
D. punctuation
2.In SQL, which command is used to make permanent changes made by statements issue since the beginning of a transaction?
A. ZIP
B. PACK
C. COMMIT
D. ZIP
3.Periodically adding, changing and deleting file records is called file
A. Updating
B. upgrading
C. restructuring
D. Updating
4.Sort/report generators
A. are faster than index/report generators
B. require more disk space than index/report generators
C. do not need to sort before generating a report
D. are faster than index/report generators
5.The data dictionary tells the DBMS
A. what files are in the database
B. what attribute are possessed by the data
C. what these files contain
D. what files are in the database
6.In SQL, which command(s) is(are) used to enable/disable a database trigger?
A. MODIFY USER
B. CHANGE USER
C. ALTER TRIGGER
D. MODIFY USER
7.If the record management system allows you to edit values before they are recorded on disk, you can
A. correct spelling changes before they are recorded
B. change the name of a field
C. change the width of a field
D. correct spelling changes before they are recorded
8.The relational model uses some unfamiliar terminology. A tuple is equivalent to a:
A. record
B. field
C. file
D. record
9.The files stored on a secondary stage device are composed of a hierarchy of data. What does a record in a file contain?
A. Bits
B. Characters
C. Data field
D. Bits
10.Which command is used to remove an index from the database in SQL?
A. DELETE INDEX
B. DROP INDEX
C. REMOVE INDEX
D. DELETE INDEX
11.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
12.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
13.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
14.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
15.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
16.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
17.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
18.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
19.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
20.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
21.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
22.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
23.Which of the following is not a relational database?
A. dBASE IV
B. 4th Dimension
C. FoxPro
D. dBASE IV
24.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
25.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
26.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
27.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
28.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
29.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
30.The highest level in the hierarchy of data organization is called
A. data bank
B. database
C. data file
D. data bank
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]