Home
Current Affairs January 2024

What is the correct answer?

4

Collection of related records in a database is known as

A. File

B. Bench

C. Table

D. Relationship

Correct Answer :

C. Table


Related Questions

What is the correct answer?

4

How can you link a table with another so that a field in current table will display values in drop down box from another table while entering data:

A. Query Wizard

B. Look up Wizard

C. Form Wizard

D. Report Wizard

What is the correct answer?

4

Which field type will you select when creating a new table if you require to enter long text in that field?

A. Text

B. Memo

C. Currency

D. Hyperlink

What is the correct answer?

4

The database language that allows you to access or maintain data in a database

A. DCL

B. DML

C. DDL

D. None of above

What is the correct answer?

4

The size of Yes No field is always

A. 1 bit

B. 1 byte

C. 1 character

D. 1 GB

What is the correct answer?

4

What happens when you release mouse pointer after you drop the primary key of a table into foreign key of another table?

A. A relationship is created

B. Edit relationship dialog box appears

C. Error occurs

D. Nothing happens

What is the correct answer?

4

Which of the following can be an example of a database?

A. Address book of all the suppliers of a company

B. Salary sheet of all the employees of a company

C. Records of daily sales transactions of a company

D. All of above

What is the correct answer?

4

When entering field name, how many characters you can type in maximum?

A. 60

B. 64

C. 68

D. Any number of character

What is the correct answer?

4

Which of the following statement is true?

A. Foreign key fields dont allow duplicate values

B. In primary key field you can enter duplicate value

C. In an indexed field you may or may not enter duplicate value depending upon setting

D. All statements are true

What is the correct answer?

4

Which of the following statement is true

A. Reports can be used to retrieve data from tables and calculate

B. Queries can be printed in well formatted manner and presented as the information

C. Queries can include calculated fields that do not exist in table

D. Reports and forms are similar but forms are use to print but reports to display on screen only

What is the correct answer?

4

Which of the following expresses correct order?

A. Characters, Fields, Records, Tables, Files, Databases

B. Characters, Fields, Records, Tables, Database, Files

C. Databases, Tables, Files, Records, Field, Character

D. Files, Databases, Tables, Records, Fields, Characters

What is the correct answer?

4

Which of the following database object hold data?

A. Forms

B. Reports

C. Queries

D. Tables

What is the correct answer?

4

Unlike text data type, this can store up to maximum of 65, 535 characters.

A. memo

B. data/time

C. number

D. All of above

What is the correct answer?

4

A small button with three dots usually displayed at the right of field properties box

A. Make button

B. Expression button

C. Build button

D. None of above

What is the correct answer?

4

Referential integrity means

A. Do not enter a value in the foreign key field of a child table if that value does not exist in the primary key of the parent table

B. Do not enter a value in the primary key field of child table if that value does not exist in the primary key of the parent table

C. Do not enter a value in the foreign key field of a parent table if that value does not exist in the primary key of the child table

D. All of above

What is the correct answer?

4

After entering all fields required for a table, if you realize that the third field is not needed, how will you remove?

A. You need to delete the whole tablThere is no method to remove a particular field only.

B. Delete all the fields from third downwards and reenter the required fields again.

C. Select the third column in datasheet view then Delete

D. Select the third row in table design view then Delete

What is the correct answer?

4

Collection of related records in a database is known as

A. File

B. Bench

C. Table

D. Relationship

What is the correct answer?

4

Which of the following is NOT a type of Microsoft Access database object?

A. Table

B. Form

C. Worksheets

D. Modules

What is the correct answer?

4

Which of the following is not a database object in MS Access?

A. Tables

B. Query

C. Report

D. Relationship

What is the correct answer?

4

While creating relationship, when you drag a field of a field to drop into another table the mouse pointer changes into

A. a doctors sign

B. thin + sign

C. outline rectangle

D. None of above

What is the correct answer?

4

Which is not a view to display a table in Access?

A. Datasheet View

B. Design View

C. Pivot Table & Pivot Chart View

D. None of above

What is the correct answer?

4

It is most common type of query. It retrieves records from one or more tables and then displays the

A. Parameter

B. Select

C. crosstab

D. All of above

What is the correct answer?

4

The size of a field with Number data type can not be

A. 2

B. 4

C. 8

D. 16

What is the correct answer?

4

In table design view, which key can be used to switch between the field names and properties panels?

A. F3

B. F4

C. F5

D. F6

What is the correct answer?

4

To achieve AND effect when you are entering criteria in a query design window

A. write criteria values vertically one in a row

B. write criteria values horizontally

C. Write criteria values in same field separated with AND

D. Write criteria values in same field separated with &

What is the correct answer?

4

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

A. Create table in Design View

B. Create Table using wizard

C. Create Table by Entering data

D. All of above

What is the correct answer?

4

Each record is constituted by a number of individual data items which are called

A. Fields

B. Data Types

C. Relations

D. Tables

What is the correct answer?

4

Following is not a database model

A. network database model

B. relational database model

C. Object Oriented database model

D. None

What is the correct answer?

4

You can set a controls border type to make the border invisible.

A. Transparent

B. Invisible

C. Do not display

D. No border

What is the correct answer?

4

Every table in relational database contain a field or combination of fields that can uniquely identify each records, it is called

A. Foreign key

B. Native key

C. Composite key

D. Primary key

What is the correct answer?

4

The key uniquely identifies each record in a table.

A. primary key

B. key word

C. filed name

D. All of above