Home
Current Affairs January 2024

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

Correct Answer :

A. One student can have many classes


Related Questions

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

A composite key is

A. Required when a table does not have any unique fields in it

B. The primary key with AutoNumber as the field type

C. Made up of two or more fields to uniquely identify records

D. Is a foreign key that uniquely identifies records

What is the correct answer?

4

The third stage in designing a database is when we analyze our tables more closely and create a ___________ between tables

A. relationship

B. Join

C. Query

D. None of these

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

A database can be best described as

A. Organized collection of data

B. Useful presentation of data

C. Graphical representation of data

D. All of above

What is the correct answer?

4

Microsoft Access is a

A. RDBMS

B. OODBMS

C. ORDBMS

D. Network database model

What is the correct answer?

4

A search value can be an exact value or it can be

A. Logical Operator

B. Relationship

C. Wild card character

D. Comparison operation

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

It is used to calculate and restructure data for easier analysis of your data. It calculates the sum,

A. Parameter

B. Select

C. crosstab

D. Append

What is the correct answer?

4

Queries in Access can be used as

A. view, change and analyze data in different ways

B. a source of records for forms and reports

C. Only a

D. Both a and b

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

Which of the following is not a database object?

A. Tables

B. Queries

C. Relationships

D. Reports

What is the correct answer?

4

If I create Student field in Fees table to store student_id of Students table, then this Student field in Fees table is called:

A. Foreign key

B. Native key

C. Composite key

D. Primary key

What is the correct answer?

4

To create queries in Access

A. You can drag and drop fields on query builders

B. you can type the SQL command in SQL view

C. You can use query wizard or design view

D. All of above

What is the correct answer?

4

Query design window has two parts. The upper part shows

A. Name of fields, field type and size

B. Tables with fields and relationships between tables

C. Criteria

D. Sorting check boxes

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

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

When a picture or other graphic image is placed in the report header section it will appear____

A. Once in the beginning of the report

B. At the top of every page

C. Every after record break

D. On the 1st and last pages of the report

What is the correct answer?

4

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

A. datasheet view

B. design view

C. link table

D. None of the above

What is the correct answer?

4

It is an association established between common fields of two tables.

A. line

B. relationship

C. primary key

D. records

What is the correct answer?

4

A database object in MS Access that stores a question about the data in database?

A. Table

B. Form

C. Query

D. Report

What is the correct answer?

4

It is a query that when run displays its own dialog box prompting you for information, such as

A. Select

B. crosstab

C. Parameter

D. Append

What is the correct answer?

4

An Access database object that is used to enter, view or edit records

A. Table

B. Form

C. Query

D. Report

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

A __________ enables you to view data from a table based on a specific criterion

A. Form

B. Query

C. Macro

D. Report

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

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

What are the columns in a Microsoft Access table called?

A. Rows

B. Records

C. Fields

D. Columns

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