Computer Awareness - SPLessons

TS CAB Recruitment Computer Aptitude Quiz 7

Home > > Tutorial
SPLessons 5 Steps, 3 Clicks
5 Steps - 3 Clicks

TS CAB Recruitment Computer Aptitude Quiz 7

shape Introduction

What is Computer Awareness? Computer Awareness, also known as Computer Aptitude is one of the prominent sections in various recruitment related competitive exams in India. TS CAB Recruitment Computer Aptitude Quiz 7 lists some of the important questions for the preparation of Computer Awareness module. The most significant topics to be learnt for Computer Awareness module are as follows:
  1. History of Computers
  2. Computer Fundamentals
  3. Parts of a Computer System
  4. Data Processing Cycle of a Computer
  5. Computer Languages
  6. Input Devices & Output Devices
  7. Operating Systems
  8. Database Management Systems
  9. Microsoft Office
  10. Keyboard Shortcuts
  11. File Extensions
  12. Networking and Internet
  13. Computer Viruses
  14. Important Abbreviations

shape Quiz

1. 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. All of the above

Answer: Option A
2. 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 communication package

Answer: Option B
3. A _____ DBMS distributes data processing tasks between the workstation and a network server.
    A. Network B. Relational C. Client Server D. Hierarchical

Answer: Option C
4. Information can be transferred between the DBMS and a
    A. spreadsheet program B. word processor program C. graphics program D. All of the above

Answer: Option D
5. 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. All of the above

Answer: Option C
1. 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. both (a) and (b)

Answer: Option D
2. In SQL, which command(s) is(are) used to recompile a stored function?
    A. SET FUNCTION B. SET STORED FUNCTION C. ALTER FUNCTION D. All of the above

Answer: Option C
3. In SQL, which command(s) is(are) used to recompile a stored function?
    A. SET FUNCTION B. SET STORED FUNCTION C. ALTER FUNCTION D. All of the above

Answer: Option C
4. Report generators are used to
    A. store data input by a user B. retrieve information from files C. answer queries D. both (B) and (V)

Answer: Option D
5. Administrate supervision of database activities is the responsibility of the
    A. Database administrator B. DP Manager C. DB Manager D. DP administration

Answer: Option A
1. 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. All of the above

Answer: Option D
2. In SQL, which command(s) is(are) used to change a table's storage characteristics?
    A. ALTER TABLE B. MODIFY TABLE C. CHANGE TABLE D. All of the above

Answer: Option A
3. In SQL, which of the following is not a data definition language commands?
    A. RENAME B. REVOKE C. GRANT D. UPDATE

Answer: Option D
4. Subschema can be used to
    A. create very different, personalized views of the same data B. present information in different formats C. hide sensitive information by omitting fields from the sub¬schema's description D. All of the above

Answer: Option D
5. Database management systems are intended to:
    A. eliminate data redundancy B. establish relationships among records in different files C. manage file access & maintain data integrity D. All of the above

Answer: Option D

Computer Awareness - Related Information
IBPS RRB Clerk Computer Awareness Quiz 1
IBPS RRB Clerk Computer Awareness Quiz 2
IBPS RRB Clerk Computer Awareness Quiz 3
Computer Awareness Book for Bank Exams