MCQ | Database Management System (DBMS)

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

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

This key that uniquely identifies each record is called:

The extension of the database file  in MS Access is

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

The UPDATE SQL clause can______

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

The term ________ is used to refer to a row

A relational database consists of a collection of

In a distributed Database reduction of redundancy is obtained by_____

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

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

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

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

Date/Time occupies . . . bytes of memory.

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

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

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

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

Which SQL keyword is used to retrieve a maximum value?

object of access is used to print formatted data.

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

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

The term "SQL" stands for

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

_____is not the data type of MS-Access.

….. query changes the value in the main table

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

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

The term attributes refers to a________ of a table.

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

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

A Detail Management System is a type of _______ software.

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

The term "Data" refers to:

In MS Access data are stored In . . ….

Which of the following is not a DDL command?

Which of the following is not a database application?

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

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

The server process that implements lock Manages functionality, is called

A data dictionary is repository that manages _________

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

The data type appropriate to store salary is. .

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

A relationship is considered a:

The primary key does not accept . . .

The columns in a database table are called. ..

Which is not a type of query?

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

Functional Dependencies are the types of constraints that are based on_____

Tables in second normal form (2NF):

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

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