Home
Current Affairs January 2024

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

Correct Answer :

D. All of above


Related Questions

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

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

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

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

How can you define a field so that when entering data for that field it will display ****** instead of actual typed text

A. Input mask

B. Validation Rule

C. Indexed

D. IME Mode

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

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

DCL provides commands to perform actions like

A. Change the structure of tables

B. insert, update or delete records and data values

C. authorizing access and other control over database

D. None of above

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

This is the stage in database design where one gathers and lists all the necessary fields for the database project.

A. data definition

B. data refinement

C. establishing relationship

D. none of the above

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

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

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 is not a database object?

A. Tables

B. Queries

C. Relationships

D. Reports

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

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

If you write criteria values vertically (one in a row) it will mean

A. OR conditions

B. AND conditions

C. NOT condition

D. None of above

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

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

Which of the following term is least related to database?

A. Attributes

B. Tuples

C. Relationship

D. Columns

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

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

In a database table, the category of information is called ____________

A. tuple

B. field

C. record

D. All of above

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

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

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

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

Microsoft Access is a

A. RDBMS

B. OODBMS

C. ORDBMS

D. Network database model