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 - 160
Hassan
1.If a calculation is embedded in a form
A. the result of the calculations are stored with the form
B. the calculations are stored with the form
C. the result of the calculations are printed in report
D. the result of the calculations are stored with the form
2.Data security threats include
A. hardware failure
B. privacy invasion
C. fraudulent manipulation of data
D. hardware failure
3.An operation that will increase the length of a list is
A. Insert
B. Look-up
C. Modify
D. Insert
4.In SQL, which command is used to add a column/integrity constraint to a table
A. ADD COLUMN
B. INSERT COLUMN
C. MODIFY TABLE
D. ADD COLUMN
5.In SQL, which command(s) is(are) used to enable/disable a database trigger?
A. ALTER TRIGGER
B. ALTER DATABASE
C. ALTER TABLE
D. ALTER TRIGGER
6.In a relational schema, each tuple is divided into fields called
A. Relations
B. Domains
C. Queries
D. Relations
7.In SQL, which command is used to changes data in a table?
A. UPDATE
B. INSERT
C. BROWSE
D. UPDATE
8.What name is given to the collection of facts, items of information or data which are related in some way?
A. Database
B. Directory information
C. Information tree
D. Database
9.In a large DBMS
A. each user can "see" only a small part of the entire database
B. each user can access every sub¬schema
C. each subschema contains every field in the logical schema
D. each user can "see" only a small part of the entire database
10.Which of the following command(s) is(are) used to recompile a stored procedure in SQL?
A. COMPILE PROCEDURE
B. ALTER PROCEDURE
C. MODIFY PROCEDURE id) All of the above
D. COMPILE PROCEDURE
11.Internal auditors should review data system design before they are
A. developed
B. implemented
C. modified
D. developed
12.A _____ means that one record in a particular record type may be related to more than 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
13.Which command(s) is(are) used to redefine a column of the table in SQL ?
A. ALTER TABLE
B. DEFINE TABLE
C. MODIFY TABLE
D. ALTER TABLE
14.Which command(s) is(are) used to enable/disable/drop an integrity constraint in SQL?
A. DEFINE TABLE
B. MODIFY TABLE
C. ALTER TABLE
D. DEFINE TABLE
15.In SQL, the ALTER TABLESPACE command is used
A. to add/rename data files
B. to change storage characteristics
C. to take a tablespace online/offline
D. to add/rename data files
16.The language used in application programs to request data from the DBMS is referred to as the
A. DML
B. DDL
C. query language
D. DML
17.A database management system might consist of application programs and a software package called
A. FORTRAN
B. AUTOFLOW
C. BPL
D. FORTRAN
18.An audit trail
A. is used to make back-up copies
B. is the recorded history of operations performed on a file
C. can be used to restore lost information
D. is used to make back-up copies
19.A race condition occurs when
A. Two concurrent activities interact to cause a processing error
B. two users of the DBMS are interacting with different files at the same time
C. both (a) and (b)
D. Two concurrent activities interact to cause a processing error
20.An indexing operation
A. sorts a file using a single key
B. sorts file using two keys
C. establishes an index for a file
D. sorts a file using a single key
21.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
22.If you want your database to include methods, you should use a _____ database.
A. Network
B. Distributed
C. Hierarchical
D. Network
23.In SQL, which of the following is not a data Manipulation Language Commands?
A. DELETE
B. SELECT
C. UPDATE
D. DELETE
24.Which of the following is not characteristic of a relational database model?
A. tables
B. treelike structure
C. complex logical relationships
D. tables
25.A computer file contains several records. What does each record contain?
A. Bytes
B. Words
C. Fields
D. Bytes
26.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
27.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
28.In the DBM approach, application programs perform the
A. storage function
B. processing functions
C. access control
D. storage function
29.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
30.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
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]