Computer interview questions – page 19

What is a motion path?

1. A type of animation entrance effect
2. A method of advancing slides
3. A method moving items on a slide
4. All of the above

______ are lines that have connection points at the end and stay connected to the shapes that you attach them to.

1. Connectors
2. Headers
3. Footers
4. Separators

In certain browsers, which button is clicked by the user to reload a page?

1. Reload
2. Refresh
3. History
4. Both A and B

Press _____ to cyle between open windows.

1. Ctrl + F4
2. Ctrl + F6
3. Ctrl + F7
4. Ctrl + F12

You can automatically include all of the field in a table in a query by _____ a strike that appear list box in query design view.

1. Double clicking
2. Right clicking
3. Clicking
4. All the above

What is a database?

1. It is a collection of data arranged in rows
2. It is a collection of data arranged in columns
3. It is a collection of data arranged in rows and columns
4. All of the above

To open an existing database, press

1. Ctrl + O
2. Ctrl + P
3. Ctrl + E
4. Ctrl + X

The option allows you to build a new table by entering data directly into the datasheet.

1. Datasheet view
2. Design view
3. Link table
4. All of the above

Queries in Access can be used as

1. View, change and analyze data in different ways
2. A source of records for forms and reports
3. Both a and b
4. None of these

To sort records in a table

1. Open table, click on the field on which the sorting is to be done, then click sort button on database toolbar
2. Click the field heading to sort it ascending or descending
3. Open table, click sort button on database toolbar, choose field based on which to sort, click ok
4. All of the above

In MS Access “Lookup Wizard” is used to

1. to select value from another table
2. to select values from Excel Sheet
3. to select from previous values
4. not a valid data type

The command center of access file that appears when you create or open the ms access database file.

1. Switchboard
2. Design view Window
3. Database Window
4. Query Window

In MS Access, Text data type may contain maximum character of

1. 255 character
2. 256 character
3. 1064 character
4. No limit

To rename a selected object, press

1. F2
2. F3
3. F4
4. F5

In a relational model, relations are termed as

1. Rows
2. Tables
3. Attributes
4. Tuples

DBMS helps to achieve

1. Data independence
2. More redundancy
3. Centralised manner to control of data
4. Both a and c

_____ key is uniquely identifies each record.

1. Field Name
2. Unique key
3. Primary key
4. Key record

Which of the following is a method to create a new table in MS access?

1. Create table by entering data
2. Create table using wizard
3. Create table in design view
4. All of above

The expression builder is an access tool that controls an expression _____ for entering an expression.

1. Palette
2. Box
3. Cell
4. Table

Which of the following is a method to create a new table in MS-Access?

1. Create table using wizard
2. Create table in design view
3. Create table in data sheet view
4. All of the above

Which of the following database objects asks a question of information in a database and then displays the result?

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

Which of the following Data Type is used to store picture in MS Access?

1. Picture cannot be stored
2. Memo
3. OLE object
4. Picture

A _____ name must be unique within a database.

1. Character
2. Table
3. Record
4. Field

Which control does access use to link data access page components to access data?

1. Microsoft Default Connection Control
2. Microsoft Data Connection Control
3. Microsoft Dynamic Data Control
4. Microsoft Office Data Source Control

Which of the following database object is created first before any other created?

1. Query
2. Table
3. Report
4. Form

1 MB is equal to _____ bytes.

1. 210
2. 220
3. 230
4. 240

A ____ is approximately one billion bytes.

1. Gigabyte
2. Megabyte
3. Bit
4. Kilobyte

The most popular commercial DBMS is

1. Oracle
2. MySQL
3. Microsoft Access
4. Microsoft SQL Server

Which of the following is a set of one or more attributes taken collectively to uniquely identify a record?

1. Foreign key
2. Super key
3. Sub key
4. Candidate key

A _____ consists of a collection of interrelated data and a collection of programs to access that data.

1. DBA
2. DBMS
3. Schema
4. Database