DBMS

Question 1

When data is accessed by multiple systems/programs simultaneously. So database manager should ensure that there is no flaw in the data during this concurrent access of data. This management system is termed as _______________________, whose job is to manage the concurrent access to the data.

Answer 1

Transaction and Concurrency control system

Question 2

Language which is used to work on the database data is _________

Answer 2

Structured Query Language [SQL]

Question 3

We represent databases pictorially using ____________

Answer 3

E-R diagram [Entity-Relationship diagram]

Question 4

The retrieving of data stored or recording of data should be fast and therefore, the database is stored in the form of _____

Answer 4

B-Trees and B+ Trees

Question 5

The Mathmatical model which talks about how to store data in tables is called ___________

Answer 5

Relational Model

Question 6

SQL is a query lanuage based on ____________ and is used to add,delete,modify,search,retrieve data from the atabase.

Answer 6

relational model

Question 7

What is a relation?

Answer 7

Reation refers to a table.Table is a set of rows and columns

Question 8

What are attributes?

Answer 8

Attributes are nothing but the columns in relational database. Attribues are also called as fields.

Question 9

Attributes are also called as _____________ in table

Answer 9

Fields

Question 10

Tuples

Answer 10

Rows in a table[relational databse] are called as tuples. They are also known as records.

Question 11

Tuples are also called as?

Answer 11

Record

Question 12

In a relation there should not be two same tuples True or False

Answer 12

True

Question 13

What is an instance in DBMS?

Answer 13

It is a set of tuples/rows along with the table structure

Question 14

Key

Answer 14

it is he minimum number/set of attributes/columns to uniquely identify a row/tuple.

Question 15

Simple key

Answer 15

Key with only one attribute/column.

Question 16

Compound key

Answer 16

Key with multiple attributes/columns

Question 17

Candidate key

Answer 17

Set of all unique keys is called as Candidate key

Question 18

Primary key

Answer 18

PRIMARY KEY in DBMS is a column or group of columns in a table that uniquely identify every row in that table. The Primary Key can’t be a duplicate meaning the same value can’t appear more than once in the table. A table cannot have more than one primary key.