Computer Awareness - SPLessons
boy2

Computer Awareness Practice Set 7

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

Computer Awareness Practice Set 7

shape Introduction

What is Computer Aptitude? Computer Aptitude Test is a scientifically validated test designed to measure the aptitude for working with computers. Basically, it measures the ability to solve problems quickly that is essential to truly succeed in every field using computers.
Computers are an integral part of everyday life. Computer aptitude is an important section in many competitive exams primarily related to recruitment. Candidates preparing for banking exams like IBPS PO, SBI PO, and the RBI, must be prepared with Computer Aptitude syllabus.
"A Computer is a device that can be instructed to carry out sequences of arithmetic or logical operations automatically via computer programming". Computers follow a generalized set of operations termed as programs. The programs enable computers to perform an extremely wide range of tasks. Computers are now ubiquitous and are being used in every field of work. Thus, basic knowledge of computers and the ability to operate a computer is now crucial for all job aspirants.
Computer Awareness, also known as Computer Aptitude is one of the prominent sections in various recruitment related competitive exams in India. Computer Awareness Practice Set 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

Directions(1-5): Relational Database Questions 1. A relational database consists of a collection of
    A. Tables B. Fields C. Records D. Keys

Answer: Option A
2. A ________ in a table represents a relationship among a set of values.
    A. Column B. Key C. Row D. Entry

Answer: Option C
3. The term _______ is used to refer to a row.
    A. Attribute B. Tuple C. Field D. Instance

Answer: Option B
4. The term attribute refers to a ___________ of a table.
    A. Record B. Column C. Tuple D. Key

Answer: Option B
5. For each attribute of a relation, there is a set of permitted values, called the ________ of that attribute.
    A. Domain B. Relation C. Set D. Schema

Answer: Option A
Directions(1-5): SQL Basic Questions 1. Which one of the following is used to define the structure of the relation, deleting relations and relating schemas?
    A. DML(Data Manipulation Langauge) B. DDL(Data Definition Langauge) C. Query D. Relational Schema

Answer: Option B
2. The basic data type char(n) is a _____ length character string and varchar(n) is _____ length character.
    A. Fixed, equal B. Equal, variable C. Fixed, variable D. Variable, equal

Answer: Option C
3. An attribute A of datatype varchar(20) has the value “Avi”. The attribute B of datatype char(20) has value ”Reed”. Here attribute A has ____ spaces and attribute B has ____ spaces.
    A. 3, 20 B. 20, 4 C. 20, 20 D. 3, 4

Answer: Option A
4. To remove a relation from an SQL database, we use the ______ command.
    A. Delete B. Purge C. Remove D. Drop table

Answer: Option D
5. The ________ clause is used to list the attributes desired in the result of a query.
    A. Where B. Select C. From D. Distinct

Answer: Option B
Directions: Database Modification Questions 1. A Delete command operates on ______ relation.
    A. One B. Two C. Several D. Null

Answer: Option A
Directions(2-5): Database Redesign Questions 2. Which of the following SQL statements are helpful in database redesign?
    A. Correlated subqueries only B. EXISTS/NOT EXISTS expressions only C. Both of the above are helpful D. None of the above are helpful.

Answer: Option C
3. Database redesign is not terribly difficult if the:
    A. database is structured B. database is well-designed C. database has no data D. database is relatively small

Answer: Option C
4. Which SQL-92 standard SQL command can be used to change a table name?
    A. RENAME TABLE B. CHANGE TABLE C. ALTER TABLE D. None of the above is correct.

Answer: Option C
5. The process of reading a database schema and producing a data model from that schema is known as:
    A. data modeling B. database design C. reverse engineering D. None of the above is correct

Answer: Option C

Other Articles

shape Exams

Competitive Exams - College Entrance Exams
Category Notification
Diploma NITC New Delhi
Click Here For – All India Entrance Exam Notifications


shape Job-Alerts

Competitive Exams - Recent Job Notifications
Category
Banking SSC Railway
Defence Police Insurance
Click Here For – All India Latest Jobs

shape SP Quiz

Competitive Exams - Practice Sets
Category Quiz
Quant Aptitude Permutation and Combination
Spotting Errors
Reasoning Ability Puzzles
Insurance Awareness Insurance Awareness
Hide Index Show Index