MCQ | Database Management System (DBMS)

A Detail Management System is a type of _______ software.

In the given query which of the keyword has to be inserted?

INSERT INTO employee ___ (4,Alok,2000);

The columns in a database table are called. ..

In the __________ normal form, a composite attribute is converted to individual attributes.

Which of the following is/are the main goals of a distributed database?

The report can be generated by using data from...

Functional Dependencies are the types of constraints that are based on_____

Which of the following gives a logical structure of the database graphically?

Which-one ofthe following statements about normal forms is FALSE?

Which of the following is generally used for performing tasks like creating the structure of the relations, deleting Relations?

The extension of the database file  in MS Access is

A relational database consists of a collection of

Which of the following SQL statement is used to DELETE rows from a database table? .

The maximum size of the text field in MS. Access is .

Which of the following is a group of one or more attributes that uniquely identifies a row?

In MS Access data are stored In . . ….

This key that uniquely identifies each record is called:

A data dictionary is repository that manages _________

Which of the following is not a database application?

Date/Time occupies . . . bytes of memory.

The primary key does not accept . . .

In the __________ normal form, a composite attribute is converted to individual attributes.

Which SQL keyword is used to retrieve a maximum value?

A........ key uniquely identifies a record.

Which forms simplifies and ensures that there are minimal data aggregates and repetitive groups:

Which of the following refers to the level of data abstraction that describes exactly how the data actually stored?

The term attributes refers to a________ of a table.

Which is a bottom-up approach to database design that design by examining the relationship between attributes:

The term ________ is used to refer to a row

CREATE TABLE employee (name VARCHAR, id INTEGER ) What type of statement is this?

Storing a separate copy of the database at multiple locations is which of the following?

In a distributed Database reduction of redundancy is obtained by_____

The term "Data" refers to:

Which is not a type of query?

A table on the many side of a one to many or many to many relationship must:

object of access is used to print formatted data.

_____is not the data type of MS-Access.

Which of the following is not a DDL command?

In general, a file is basically a collection of all related_____

Tables in second normal form (2NF):

A relationship is considered a:

The data type appropriate to store salary is. .

With SQL, how do you select all the records from a table named "Persons" where the value of the column “FirstName” ends with an “a” ?

The default data type in MS-Access if . . .

The  entity relationship set is represented in E-R diagram as

The server process that implements lock Manages functionality, is called

An _______ is a set of entities of the same type that share the same properties, of attributes.

A distributed database is a collection of data which belong to the same system but are spread over the of the network.

….. query changes the value in the main table

The UPDATE SQL clause can______

A field that is used to uniquely define particular record in a table is called:

The term "SQL" stands for

Which data type provides storage for variable length and arbitrary format data?