Computer Knowledge MCQs (Challenging - 1)

1-  Which of the following is a reason for creating a list instead of creating a database?

A.     to prevent data inconsistency

B.     to prevent data redundancy

C.     to make it easier to share data in a central location

D.     to organize data for simple tasks

2- Which of the following is NOT an effect of data redundancy in a database?

A.       increased loss of data

B.       wasted time entering data

C.       increased likelihood of a mistake

D.      inconsistent data

3- When data changes in multiple lists and all lists are not updated, this causes:

A.       data redundancy.

B.       information overload.

C.       duplicate data.

D.      data inconsistency.

  4-  ____________ means that the data contained in a database is accurate and reliable.

A.       Data redundancy

B.       Data integrity

C.       Data reliability

D.      Data consistency

5-  All of the following are advantages of using a database, EXCEPT:

A.       data redundancy.

B.       data integrity.

C.       flexible use of data.

D.      information sharing.

6-  In a database, a field is a:

A.      label.

B.      table of information.

C.      group of related records.

D.      category of information.

7.  Each field in a database is identified by a:

A.       field name.

B.       key name.

C.       field type.

D.      field code.

8- . In a database, ____________ fields store numbers used to perform calculations.

A.    next

B.    numeric

C.    key

D.    alphanumeric

9- . A telephone number would be stored in a____________ field in a database.

A.    text

B.    memo

C.    computed

D.    date

10- .  A picture would be stored in a(n)____________ field in a database.

A.    text

B.    memo

C.    object

D.    hyperlink

11- . To store text data that may be very long, use a ____________ field in a database.

A.       memo

B.       text

C.       data

D.      long

12- A group of related fields in a database is called a(n):

A.       record.

B.       object.

C.       memo.

D.      table.

13- .The purpose of the primary key in a database is to:

A.      unlock the database.

B.      uniquely identify a record.

C.      provide a map of the data.

D.      establish constraints on database operations

14- . A good candidate for a primary key in a database would be a(n):

A.       last name.

B.       birthdate.

C.       employee position title.

D.      student identification number.

15-  In a relational database, tables are logically linked to each other by a:

A.       key.

B.       hyperlink.

C.       field type.

D.      field size.

16- Which of the following would NOT ordinarily be considered unstructured data?

A.       text

B.       video

C.       audio clips

D.      MP3 files

17- Oracle 10g is an example of a(n):

A.       relational database.

B.       object-oriented database.

C.       multidimensional database.

D.      Web-based database.

18- Which of the following is NOT one of the four main functions of a database management system(DBMS)?

A.       creating databases and entering data

B.       viewing and indexing data

C.       querying data

D.      programming data

19- . The ____________ contains data descriptions and defines the name, data type, and length of each field in the database.

A.       data dictionary

B.       data table

C.       data record

D.      data field

20- Another name for the data dictionary in a database is the:

A.        validation data.

B.        relational data.

C.        database management system.

D.        database schema.

21- Field attributes (such as data type and field size) in a database are also known as:

A.       metadata.

B.       default values.

C.       field names.

D.      primary keys.

22- .         ____________ are the values the database will automatically use for the field unless the user enters another value.

A.       Data types

B.       Default values

C.       Validated data

D.      Metadata

23- In addition to keying data directly into the database, data entry can be done from a(n):

A.       input form.

B.       table.

C.       field.

D.       data dictionary.

24- .         ____________ is the process within the database design of ensuring that data entered into a database meets validation rules.

A.       Proofreading

B.       Authorization

C.       Validation

D.      Computation

25- .The phrase “>5.50 And <20” is an example of a(n) ____________ check to validate data in a database.

A.       requirements

B.       completeness

C.       range

D.      insurance

26- You can use a function to combine text from two cells into one cell. But you can use an operator to dothe same thing. Which operator is that?

A.       & (ampersand)

B.       = (equal sign)

C.        (space)

D.      All of the above

27- The divide symbol is

A.       /

B.       D

C.       \

D.      )

28- To add two cells (A1 and A2) together you use the following formula

A.       =A1 + A2

B.       =Add(A1+A2)

C.       =together(A1:A2)

D.      A1 plus A2

29- On an excel sheet the active cell in indicated by …

A.      A dark wide boarder

B.      A dotted border

C.      A blinking border

D.      None of above

30- You can print

A.    A range of cells by range name

B.    An entire worksheet

C.    A single worksheet

D.    All of the above

31- You can create hyperlinks from the Excel workbook to

a.   A webpage on company internet

b.   A web page on the internet

c.   Other Office 97 application documents

d.   All

32- . The cell reference fro a range of cells that starts in cell B1 and goes over to column G and down to row10 is……

a.   B1-G10

b.   B1.G10

c.   B1;G10

d.   B1:G10

33- The advantage of using a spreadsheet is:

a.   calculations can be done automatically.

b.   changing data automatically updates calculations

c.   more flexibility

d.   all of the above

34- . The intersection of a row and column is called :

a.   data

b.   a field.

c.   a cell

d.   an equation.

35- . If you press ……, the cell accepts your typing as its contents.

a.   Enter

b.   Ctrl+Enter

c.   Tab

d.   Insert

36- . which of the following special function keys allow the content in cell

a.   esc

b.   shift

c.   return

d.   Tab

37- . Excel uses the …. Function when creating a data table

a.   Average

b.   Count

c.   Sum

d.   Table

38- You can copy cell formats from one cell to another by using the

a.   Backspace key

b.   Default font

c.   Format painter

d.   Formatting toolbar

39- You can use drag and drop to embed excel worksheet data in a word document

a.   By dragging a range of excel data to the word button on the taskbar while pressing the Ctrl key

b.   By dragging a range of excel data to the Word    button on the taskbar while pressing Shift key

c.   By displaying both applications side-by-side and dragging a selected range of Excel data into the word application window while pressing the Ctrl key

d.   a and c

40- A ….. is a group of cells that form a rectangle on the screen.

a.   Calculation

b.   Formula

c.   Range

d.   Range address

41- . The drag and drop method of copying or moving

a.   Can be used between worksheets but not workbooks

b.   Can be used between workbooks and worksheets also

c.   Can be used between workbooks but not worksheets

d.   None

42- . The auto calculate feature

a.   Can only add values in a range of cells

b.   Provides a quick way to view the results of an arithmetic operation on a range of cells

c.   Automatically creates formulas and adds them to a worksheet

d.   a and c

43- A value used in a formula that does not change is called a

a.   Cell address

b.   Constant

c.   Function

d.   Range

44- Say that you want to paste a formula result – but not the underlying formula – to another cell. In excel 2002,you would copy the cell with the formula, then place the insertion point in the cell you want to copy to whatnext?

a.   Click the Paste button on the standard toolbar

b.   Click the arrow on the paste button on the standard toolbar, hen click formulas

c.   Click the arrow on the paste button on the standard toolbar, then click values.

d.   All of above

45- . The default style for new data keyed in a new workbook is

a.   Comma

b.   Currency

c.   Normal

d.   Percent

46- Which formula can add the all the numeric values in a range of cells, ignoring those which are notnumeric, and place the resulting a differene cell

a.   Count

b.   Average

c.   Sum

d.   None of above

47- . To access the Go To Special feature, you can press

a.   Ctrl + G

b.   Ctrl + O

c.   Ctrl + Shift + G

d.   Ctrl + 1

48- . which do you press to enter the current date in a cell?

a.   Ctrl + Shift + :

b.   Ctrl + ;

c.   Ctrl + F10

d.   All of above

49- . Which of the following is not an underline option in the format cells dialog box?

a.   Double

b.   Single Engineering

c.   Single Accounting

d.   Double Accounting

50- You can convert existing Excel worksheet data and charts to HTML document by using thej

a.   FTP Wizard
b.   Internet Assistant Wizard
c.   Intranet Wizard
d.   Import Wizard

 BY - AKASH SHRIVASTAVA