Home
Current Affairs January 2024

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

Correct Answer :

C. DDL


Related Questions

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

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

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

In table design view what are the first column of buttons used for

A. Indicate Primary Key

B. Indicate Current Row

C. Both of above

D. None of above

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

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 term is least related to database?

A. Attributes

B. Tuples

C. Relationship

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

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

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

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

The task of arranging data in order is called

A. Searching

B. Sorting

C. Ordering

D. Shorting

What is the correct answer?

4

Which of the following is not a type of relationship that can be applied in Access database

A. One to One

B. One to Many

C. Many to Many

D. All of above can be applied

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

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

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

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

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

Collection of related records in a database is known as

A. File

B. Bench

C. Table

D. Relationship

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

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

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

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

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

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

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

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

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

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

A. tuple

B. field

C. record

D. All of above