Home
Current Affairs January 2024

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

Correct Answer :

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


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

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

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

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

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

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

Two tables can be linked with relationship so that the data integrity can be enforced. Where can you find Relationship Command?

A. Home Tab

B. Create Tab

C. External Data Tab

D. Database Tab

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

Microsoft Access is a

A. RDBMS

B. OODBMS

C. ORDBMS

D. Network database model

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

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

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

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

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

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

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

Which of the following database object hold data?

A. Forms

B. Reports

C. Queries

D. Tables

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

Cascade update option

A. means do not change the value in the primary key field if that record has related records in another table

B. means change all the related records in child tables if the record in parent table is changed

C. Both of above

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

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

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

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

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

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

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

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

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