Home
Current Affairs January 2024

What is the correct answer?

4

In one-to-many relationship the table in one side is called _______ and on many side is called _______

A. Child , Parent

B. Parent , Child

C. Brother , Sister

D. Father , Son

Correct Answer :

B. Parent , Child


Related Questions

What is the correct answer?

4

The default and maximum size of text field in Access

A. 50 and 255 Characters

B. 8 and 1 GB

C. 266 characters & 64000 characters

D. None 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

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

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 of the following may not be a database?

A. Data presented in table in MS Word document

B. Data entered in Excel spreadsheet

C. A presentation created in PowerPoint

D. A telephone diary

What is the correct answer?

4

To create a new table, in which method you dont need to specify the field type and size?

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

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

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

A database language concerned with the definition of the whole database structure and schema is ________

A. DCL

B. DML

C. DDL

D. All of above

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

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

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

What is the maximum length a text field can be?

A. 120

B. 255

C. 265

D. 75

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

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

The key uniquely identifies each record in a table.

A. primary key

B. key word

C. filed name

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

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

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

To duplicate a controls formatting you can use___

A. Manager

B. Wizard

C. Painter

D. Control

What is the correct answer?

4

Which field type can store photos?

A. Hyperlink

B. OLE

C. Both of these can be used

D. Access tables cant store photos

What is the correct answer?

4

Which of the following is not a field type in Access

A. Memo

B. Hyperlink

C. OLE Object

D. Lookup Wizard

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

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

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

To create primary key for a table when in design view

A. Type PRIMARY in field type box when creating required field

B. Mark the Primary check box in field name of required field

C. Click the Primary Key button in Design ribbon when the cursor is in required field

D. None of the 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

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 store command to retrieve data from database?

A. Forms

B. Reports

C. Queries

D. Tables