QUIZ ON : ms-office - MS ACCESS

MS ACCESS

00:00:00

Question No# : 01 out of 50

Which protocol provides e-mail facility among different hosts

A. FTP

B. SMTP

C. TELNET

D. SNMP

Question No# : 02 out of 50

Which software would you use to teach students in Computer classes?

A. Spreadsheet

B. Database

C. Word processing

D. Power point

Question No# : 03 out of 50

Which is the valid data type in Access?

A. Number

B. Text

C. Currency

D. All of the above

Question No# : 04 out of 50

SQL stands for

A. Standard Query Language

B. Structured Query Language

C. Shortest Query Language

D. System Query Language

Question No# : 05 out of 50

In the relationships window, what does the appearance of symbols, such as 1 and the infinity symbol, at the endpoints of a relationship line mean?

A. Referential integrity is enforced

B. Referential integrity isn’t enforced

C. An inner join is set

D. An outer join is set

Question No# : 06 out of 50

Data isolation can be avoided easily by

A. File processing system

B. Database management system

C. Hardware system

D. Software system

Question No# : 07 out of 50

The term DBMS stands for

A. Digital Bar Management Software

B. Data Base Management System

C. Domain Based Management Software

D. Data Base Management Software

Question No# : 08 out of 50

________ Memory is used to store BIOS on Motherboard.

A. ROM

B. RAM

C. CACHE

D. None of the Above

Question No# : 09 out of 50

What determines a table’s sort order?

A. AutoNumber field

B. Index field

C. Field order

D. Primary key

Question No# : 10 out of 50

While sending a file or message on the net, it is divided into very small parts known as

A. Point

B. Box

C. Pin

D. Packet

Question No# : 11 out of 50

____________ is the illusion of movement created by a succession of still graphics that are shown rapidly to the eye.

A. Animation

B. Graphics

C. Web graphics

D. All of the above

Question No# : 12 out of 50

Which one of the following binary number s is divisible by 4?

A. 101010

B. 100101100

C. 1110001

D. 100011

Question No# : 13 out of 50

The formula in cell A2 is =B2+C3 on copying this formula in cell C2 the formula will be

A. =D3+E4

B. =D2+E3

C. =D2+E4

D. =D3+E3

Question No# : 14 out of 50

A File which contains readymade styles that can be used for a presentation is called

A. AutoStyle

B. Wizard

C. Template

D. Preformatting

Question No# : 15 out of 50

A transparent DBMS

A. hides sensitive information from users

B. keeps its logical structure hidden from users

C. keeps its physical structure hidden from users

D. provides physical map of underlying hardware to users

Question No# : 16 out of 50

A table is a grid of rows and columns containing boxes of

A. text or graphics

B. only text

C. only graphics

D. none of the above

Question No# : 17 out of 50

An area of memory or disk that is assigned to store e-mail messages sent by other users

A. Post-email

B. Postbox

C. Emailbox

D. Mailbox

Question No# : 18 out of 50

MIS stands for

A. Maintenance Information System

B. Model Information System

C. Management Information System

D. Media Information Source

Question No# : 19 out of 50

Decimal equivalent of the binary number 110111 is

A. 55

B. 56

C. 57

D. 58

Question No# : 20 out of 50

Which of the following is not a view for interacting with a form object?

A. Datasheet view

B. Design view

C. Form view

D. Layout view

Question No# : 21 out of 50

How many relations may exist between two tables in databases?

A. 3

B. 4

C. 2

D. 1

Question No# : 22 out of 50

This command lets you view the contents of a file in DOS.

A. CAT

B. SHOW

C. TYPE

D. DISP

Question No# : 23 out of 50

Operating System can be installed from following resources.

A. Disk

B. Network

C. Remote Installation

D. All of the above

Question No# : 24 out of 50

Which of the following is not a type of Microsoft access database object?

A. Table

B. Form

C. Worksheets

D. Modules

Question No# : 25 out of 50

Which of the following are components of Central Processing Unit (CPU)

A. Arithmetic logic unit, Mouse

B. Arithmetic logic unit, Control unit

C. Arithmetic logic unit, Integrated Circuits

D. Control Unit, Monitor

Question No# : 26 out of 50

Which of the following translates a program written in high-level language into machine code

A. Assembler

B. Compiler

C. Convertor

D. Translator

Question No# : 27 out of 50

Numbers in base 10 are called as

A. Octal System

B. Hexadecimal System

C. Decimal System

D. Binary Numbering System

Question No# : 28 out of 50

To paste text from the clipboard in the document being edited, press the keys

A. Ctrl and V

B. Ctrl and X

C. Ctrl and A

D. Ins

Question No# : 29 out of 50

There are how many types of integrity in database systems.

A. One

B. Two

C. Three

D. Four

Question No# : 30 out of 50

To create a copy of files in the event of system failure, you create a

A. restore file

B. backup

C. firewall

D. refundancy

Question No# : 31 out of 50

The value of Primary key

A. cannot be null

B. can be null

C. can be duplicate

D. None of these

Question No# : 32 out of 50

What are the columns in a Microsoft access table called?

A. Rows

B. Fields

C. Records

D. Columns

Question No# : 33 out of 50

What is the purpose of indexing?

A. To reduce table size

B. To speedup data search

C. both A and B

D. none of the above

Question No# : 34 out of 50

___________ operation of file or folder is required to move location of file or folder.

A. Copy followed by Paste

B. Cut followed by Paste

C. Move followed by Paste

D. Change location

Question No# : 35 out of 50

The background screen and main area of Windows where you can open and manage files and programs is known as

A. background

B. desktop

C. wall paper

D. none of the above

Question No# : 36 out of 50

Which of the following translates a program written in Assembly language into machine code?

A. A compiler

B. An assembler

C. An operating system

D. An editor

Question No# : 37 out of 50

Which of the following is not an action query?

A. add

B. delete

C. make-table

D. update

Question No# : 38 out of 50

Which of the following file extensions does not indicate graphic files?

A. BMP

B. JPEG

C. DOC

D. GIF

Question No# : 39 out of 50

Which of the following is the lowest data model?

A. Physical data model

B. Logical data model

C. External data model

D. None of the above

Question No# : 40 out of 50

What type of computers are client computers (most of the time) in a client server system?

A. Main frame

B. Mini-Computer

C. Microcomputer

D. PDA

Question No# : 41 out of 50

The Start menu is a feature of the Windows Operating System that provides quick access to programs, folders and system settings.

A. Start menu

B. Control menu

C. Taskbar

D. Title bar

Question No# : 42 out of 50

The cost of storing a bit is minimum in

A. Cache

B. Register

C. RAM

D. Magnetic Disc

Question No# : 43 out of 50

Which Characteristic of computer distinguish it from electronic Calculators?

A. Accuracy

B. Versatility

C. Storage

D. Automatic

Question No# : 44 out of 50

What happens when ctrl+a shortcut key is pressed?

A. Selects the whole document

B. Select single line

C. Selects a single paragraph

D. None of the above

Question No# : 45 out of 50

In which generation, operating system was introduced?.

A. First

B. Second

C. Third

D. Fourth

Question No# : 46 out of 50

In the datasheet formatting dialogue box, which is not an option in the border and line styles dropdown list box?

A. datasheet border

B. datasheet underline

C. Column Header underline

D. vertical gridline

Question No# : 47 out of 50

Which of the following describes a relational database?

A. It provides a relationship between databases.

B. It consists of separate tables of related data.

C. It retrieves data related to its queries.

D. It provides a relationship between fields

Question No# : 48 out of 50

The running applications can be managed using the

A. Task manager

B. Taskbar

C. Start menu

D. Control menu

Question No# : 49 out of 50

is a mathematical scheme for demonstrating the authenticity of a digital message or document

A. Scanned Signature

B. Digital Signature

C. User Photo

D. Compressed File

Question No# : 50 out of 50

Common elements of application windows include the control menu, ___________ and border.

A. Taskbar

B. Dialog box

C. Menu bar

D. Icons