Home
Current Affairs January 2024

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

Correct Answer :

D. Primary key


Related Questions

What is the correct answer?

4

What does the show check box in query design window indicate

A. It indicates whether the field is to be used or not

B. It indicates whether the field is to be displayed in query result or not

C. It indicates whether the field names to be displayed in query result or not

D. None of above

What is the correct answer?

4

It is a database object to view, change, and analyze data in different ways

A. query

B. form

C. report

D. None of the above

What is the correct answer?

4

When creating a new table which method can be used to choose fields from standard databases and tables

A. Create table in Design View

B. Create Table using wizard

C. Create Table by Entering data

D. None of above

What is the correct answer?

4

The expression builder is an access tool that controls an expression___ for entering an expression

A. Table

B. Box

C. Cell

D. Palette

What is the correct answer?

4

Both conditions display on the same row in the design grid when ___operator is in use

A. OR

B. IN

C. AND

D. LIKE

What is the correct answer?

4

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

A. Database Window

B. Query Window

C. Design View Window

D. Switchboard

What is the correct answer?

4

Which of the following database object produces the final result to present?

A. Forms

B. Reports

C. Queries

D. Tables

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

What is the maximum length a text field can be?

A. 120

B. 255

C. 265

D. 75

What is the correct answer?

4

What do you mean by one to many relationship between Student and Class table?

A. One student can have many classes

B. One class may have many student

C. Many classes may have many students

D. Many students may have many classes

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

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

To sort records in a table

A. Open table, click on the field on which the sorting is to be done, then click Sort button on database toolbar

B. Open table, click Sort button on database toolbar, choose field based on which to sort, click OK

C. Click the field heading to sort it ascending or descending

D. All of above

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

This data type allows alphanumeric characters and special symbols.

A. text

B. memo

C. auto number

D. None of the above

What is the correct answer?

4

Which of the following store command to retrieve data from database?

A. Forms

B. Reports

C. Queries

D. Tables

What is the correct answer?

4

A part of database that stores only one type of data is

A. Report

B. Field

C. Query

D. Record

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

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 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

To create relationship between two tables

A. drag the primary key of a table into foreign key of another table

B. drag the foreign key of a table into the primary key of another table

C. drag any field from parent table and drop on child table

D. Any of above can be done to create relationship

What is the correct answer?

4

What is a form in MS Access

A. It is a printed page where users will write their data to fill it up

B. It is an input screen designed to make the viewing and entering data easier

C. This is an important part of database used by analysts to draw conclusions

D. All of above

What is the correct answer?

4

The two form layout types will display multiple records at one time are tabular and___

A. columnar

B. justified

C. date sheet

D. pivot table

What is the correct answer?

4

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

A. Clicking

B. Right clicking

C. Double clicking

D. None of the above

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

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

What are the columns in a Microsoft Access table called?

A. Rows

B. Records

C. Fields

D. Columns

What is the correct answer?

4

A __ name must be unique within a database

A. Table

B. Field

C. Record

D. Character

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

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

A. Transparent

B. Invisible

C. Do not display

D. No border