Home
Current Affairs January 2024

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

Correct Answer :

A. relationship


Related Questions

What is the correct answer?

4

The__ button on the tool box display data from a related table

A. Sub form sub report

B. Relationships

C. Select objects

D. More controls

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

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

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

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

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

We can remove a relationship defined between two tables by

A. From Edit menu choose Delete Relationship

B. Select the relationship line and press Delete

C. Choose Delete option from Relationship menu

D. All of above

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___ operator will cause a record to be selected only if two or more conditions are satisfied

A. Or

B. If or

C. Range

D. And

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

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 is the difference between Open and Open Exclusively?

A. Open statement opens access database files and Open Exclusively opens database files of other program like Oracle

B. Open Exclusive locks whole database so that no one can access it whereas Open locks only the record that is being accessed

C. Both Open and Open Exclusively are same

D. Open Exclusive command does not exist in MS Access

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

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

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

If you need to edit a relationship

A. Right click the relationship line and choose Edit Relationship

B. Double click the relationship line

C. Both of above

D. None of above

What is the correct answer?

4

A primary key in any table has the properties

A. Not Null

B. No Duplicates

C. Both of above

D. None of above

What is the correct answer?

4

The complete information about an entity in a database is called

A. Data

B. Information

C. Field

D. Record

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

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

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

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

Database Management Systems are featured with:

A. The facility to easy editing, spelling check, auto pagination, lay out and printing reports

B. The ability to store large amount of data to facilitate easy update, sort and retrieval

C. The ability to calculate efficiently with the help of built-in functions and analyze

D. All of above

What is the correct answer?

4

Which of the following term is least related to database?

A. Attributes

B. Tuples

C. Relationship

D. Columns

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

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

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

Which field type can store photos?

A. Hyperlink

B. OLE

C. Both of these can be used

D. Access tables cant store photos