Computer interview questions – page 20

The ____ provides a set of operations that take one or more relations as input and return a relation as an output.

1. Relation flow
2. Scheme diagram
3. Relational algebra
4. Schematic representation

The feature that database allows to access only certain records in database is

1. Tables
2. Reports
3. Forms
4. Query

The most commonly used operation in relational algebra for projecting a set of tuple from a relation is

1. Union
2. Select
3. Projection
4. Join

In E-R diagram, relationship is represented by

1. Diamond shaped
2. Dashed shaped
3. Ellipse shaped
4. Rectangle shaped

The _____ operation allows the combining of two relations by merging pairs of tubles, one from each relation, into a single tuple.

1. Intersection
2. Union
3. Join
4. Select

A _____ is an abstract model that describes how the data are organised and represented.

1. Database
2. Schema
3. Instances
4. Data model

_____ describe what is in database fields.

1. Field names
2. Field definitions
3. Field markers
4. Structures

In an E-R diagrams, ellipses represents

1. Attributes
2. Link between attributes and entity sets
3. Relation among entity set
4. Entity set

A _____ is a property of the entire relation rather than of the individual tuples in which each tuple is unique.

1. Key
2. Rows
3. Attribute
4. Fields

In a relational modes, a cardinality is termed as

1. Number of constraints
2. Number of tables
3. Number of attributes
4. Number of tubles

Which of the following is not a type of database?

1. Relational
2. Hierarchical
3. Network
4. Transition

One megabyte equals approximately _______

1. 500 bytes
2. 1024 bytes
3. 1 billion bytes
4. 1 million bytes

To displays the Find and Replace dialog box, with the Find tab selected press

1. Alt + F
2. Tab + F
3. Esc + F
4. Ctrl + F

Press ______ to displays the format cell dialog box in MS Excel.

1. Ctrl + 1
2. Ctrl + 2
3. Ctrl + 3
4. Ctrl + 4

Pre-defined and built in formulas in Excel are known as

1. Autosheets
2. Charts
3. Functions
4. Tables

Press ______ to saves the active file with its current file name, location, and file format.

1. Ctrl + S
2. Alt + S
3. Ctrl + Alt + Esc
4. Alt + Tab + Esc

Use the _____ to join, or concatenate, one or more text strings to produce a single piece of text.

1. Ampersand
2. Comma
3. Colon
4. Space

______ inserts a new worksheet.

1. Alt + Shift + F1
2. Alt + Shift + F2
3. Alt + Shift + F3
4. Alt + Shift + F4

_____ creates a chart of the data in the current range.

1. Alt + F1
2. Ctrl + F1
3. Ctrl + Alt + F1
4. Esc + F1

Which sign is used for absolute addressing?

1. @
2. $
3. &
4. *

Press ______ to open the Excel formula window.

1. Shift + F3
2. Shift + F4
3. Shift + F5
4. Shift + F6

A spreadsheet is a sheet which is spread in such a way that it divides itself into the various _____ and ______

1. Horizontal columns, vertical row
2. Horizontal table, vertical cell
3. Horizontal cell, vertical table
4. Horizontal row, vertical columns

1 GB is equal to _____ bytes.

1. 256
2. 512
3. 1024
4. 1046

RAM consists of binary numbers 0s and

1. 1s
2. 2s
3. 3s
4. 4s

1 TB is equal to _____ GB.

1. 256
2. 512
3. 1000
4. 1024

Which of the following number system has a base of 16?

1. Decimal number system
2. Hexadecimal number system
3. Octal number system
4. Binary number system

GB stands for

1. Gigabit
2. Gilobyte
3. Gigabyte
4. Gilobit

Which of the following is the largest unit of storage?

1. GB
2. KB
3. MB
4. TB

To convert a decimal number into its octal equivalent

1. the decimal number is divided by 8
2. the decimal number is multiplied by 8
3. the decimal number is divided by 16
4. the decimal number is multiplied by 16

What is the base or radix of the decimal number system?

1. 2
2. 4
3. 8
4. 10