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 - 163
Hassan
1.Which of the following is not the responsibility of the utilities component of DBMS software?
A. creating the physical and logical designs
B. removing flagged records for deletion
C. creating and maintaining the data dictionary
D. creating the physical and logical designs
2.In SQL, the CREATE TABLESPACE is used
A. to create a place in the database for storage of scheme objects, rollback segments, and naming the data files to comprise the tablespace
B. to create a database trigger
C. to add/rename data files, to change storage
D. to create a place in the database for storage of scheme objects, rollback segments, and naming the data files to comprise the tablespace
3.In SQL, which command is used to remove a stored function from the database?
A. REMOVE FUNCTION
B. DELETE FUNCTION
C. DROP FUNCTION
D. REMOVE FUNCTION
4.The database administration function includes
A. application programming
B. computer operations management
C. database access planning
D. application programming
5.A relational database management (RDBM) package manages data in more than one file at once. How does it organize these file? As
A. tables
B. relations
C. tuple
D. tables
6.A command that lets you change one or more fields in a record is
A. Insert
B. Modify
C. Look-up
D. Insert
7.In SQL, the command(s) is(are) used to create an index for a table or cluster
A. CREATE INDEX
B. MODIFY INDEX
C. SET INDEX TO FILE
D. CREATE INDEX
8.There are certain packages that allow people to define data items, place these items in particular records, combine the records into designated files and then manipulate and retrieve the stored data. What are they called?
A. Data storage system
B. Database management system (DBMS)
C. Batch processing system
D. Data storage system
9.A _____ DBMS distributes data processing tasks between the workstation and a network server.
A. Network
B. Relational
C. Client Server
D. Network
10.Information can be transferred between the DBMS and a
A. spreadsheet program
B. word processor program
C. graphics program
D. spreadsheet program
11.Data integrity control
A. is used to set upper and lower limits on numeric data
B. requires the use of passwords to prohibit unauthorized access to the file
C. has the data dictionary keep the date and time of last access last back-up, and most recent modification for all files
D. is used to set upper and lower limits on numeric data
12.In order to use a DBMS, it is important to understand
A. the physical schema
B. all sub-schemas that the system supports
C. one subschema
D. the physical schema
13.In SQL, which command(s) is(are) used to recompile a stored function?
A. SET FUNCTION
B. SET STORED FUNCTION
C. ALTER FUNCTION
D. SET FUNCTION
14.Report generators are used to
A. store data input by a user
B. retrieve information from files
C. answer queries
D. store data input by a user
15.Administrate supervision of database activities is the responsibility of the
A. Database administrator
B. DP Manager
C. DB Manager
D. Database administrator
16.Goals for the design of the logical schema include
A. avoiding data inconsistency
B. being able to construct queries easily
C. being able to access data efficiently
D. avoiding data inconsistency
17.In SQL, which of the following is not a data definition language commands?
A. RENAME
B. REVOKE
C. GRANT
D. RENAME
18.Database management systems are intended to:
A. eliminate data redundancy
B. establish relationships among records in different files
C. manage file access
D. eliminate data redundancy
19.In SQL, which command(s) is(are) used to issue multiple CREATE TABLE, CREATE VIEW, and GRANT statements in a single transaction?
A. CREATE PACKAGE
B. CREATE SCHEMA
C. CREATE CLUSTER
D. CREATE PACKAGE
20.An OR gate can be imagined as
A. switches connected in series
B. switches connected in parallel
C. MOS transistors connected in series
D. switches connected in series
21.Address 200H contains the byte 3FH. What is the decimal equivalent of 3FH
A. 63
B. 32
C. 16
D. 63
22.Conversion of an octal number 1128 to hexadecimal number is
A. 4A16
B. 5A16
C. 1516
D. 4A16
23.The functional difference between SR flip-flop and JK flip-flop is that
A. JK flip-flop is faster than SR flip-flop
B. JK flip-flop has a feed back path
C. JK flip-flop accepts both inputs 1
D. JK flip-flop is faster than SR flip-flop
24.The inverter OR gate and AND gate are called decision-making elements because they can recognize some input _____ while disregarding others. A gate recognizes a word when its output is _____
A. words, high
B. bytes, low
C. bytes, high
D. words, high
25.A positive AND gate is also a negative
A. NAND gate
B. NOR gate
C. AND gate
D. NAND gate
26.In which code the successive code characters differ in only one bit position?
A. gray code
B. excess 3 code
C. 8421 code
D. gray code
27.Conversion of binary number 1011012 to hexadecimal is
A. 3716
B. 2D16
C. 2E16
D. 3716
28.ASCII and EBCDIC differ in
A. their efficiency in storing data
B. the random and sequential access method
C. the number of bytes used to store characters
D. their efficiency in storing data
29.A p- channel enhancement type MOSFET performs much the same function as a PNP transistor, except that
A. it operates much faster
B. it is considerably larger
C. it is controlled by voltage rather than by current, so that it requires very little current at the control terminal
D. it operates much faster
30.What logic function is produced by adding an inverter to each input and the output of an AND gate?
A. NAND
B. NOR
C. OR
D. NAND
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]