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 - 32
1.In SQL, which command(s) is(are) used to create a synonym for a schema object?
A. CREATE SCHEMA
B. CREATE SYNONYM
C. CREATE SAME
D. CREATE SCHEMA
2.If you want your database to include methods, you should use a _____ database.
A. Network
B. Distributed
C. Hierarchical
D. Network
3.In SQL, which of the following is not a data Manipulation Language Commands?
A. DELETE
B. SELECT
C. UPDATE
D. DELETE
4.Which of the following is not characteristic of a relational database model?
A. tables
B. treelike structure
C. complex logical relationships
D. tables
5.A computer file contains several records. What does each record contain?
A. Bytes
B. Words
C. Fields
D. Bytes
6.In SQL, the CREATE VIEW command is used
A. to recompile view
B. to define a view of one or more tables or views
C. to recompile a table
D. to recompile view
7.A ____ Contains the smallest unit of meaningful data, so you might call it the basic building block for a data file.
A. File structure
B. Records
C. Fields
D. File structure
8.In the DBM approach, application programs perform the
A. storage function
B. processing functions
C. access control
D. storage function
9.In SQL, which command is used to create a database user?
A. ADD USER TO DATABASE
B. MK USER
C. CREATE USER
D. ADD USER TO DATABASE
10.When performing a look-up operation using a form
A. you enter the search value into the form
B. you look at each form sequentially until you see the one you want
C. you type the key in an entry line, and the correct form is displayed
D. you enter the search value into the form
11.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
12.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
13.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
14.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
15.The model for a _____ resembles the hierarchical model in many respects.
A. Network database
B. Relational database
C. Distributed database
D. Network database
16.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
17.Long-range planning report produced in an MIS are primarily designed for
A. top management
B. middle management
C. lower management
D. top management
18.The model for a record management system might be
A. handwritten list
B. a Rolodex card file
C. a business form
D. handwritten list
19.The designer of a form includes
A. filed designators
B. prompts
C. data
D. filed designators
20.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
21.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
22.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
23.The data-base environment has all of the following components except:
A. users
B. separate files
C. data base
D. users
24.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
25.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
26.The distinguishable parts of a record are called
A. files
B. data
C. fields
D. files
27.Large collections of files are called
A. fields
B. records
C. databases
D. fields
28.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
29.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
30.A scheme describes
A. data elements
B. records and files
C. record relationships
D. data elements
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]