125876 + Interview Questions in General QA

1.	1. Data Definition Language is the standard language for Relational Database Management System.2. The full form of DDL is Data Definition Language.
Answer» 1. False 2. True

1.

1. Data Definition Language is the standard language for Relational Database Management System.2. The full form of DDL is Data Definition Language.

Answer»

1. False

2. True

2.	How to dene the Domain of a column ‘subject 1’of MARKS relation.
Answer» Range of values from 0 to 100

Discussion

3.	1. A ___________ in the context of databases, is a situation that exists between two relational database tables.2. In a ___________ relationship, one record in a table is associated with one and only one record in another table.
Answer» 1. Relationship 2. One-to-One

3.

1. A _ in the context of databases, is a situation that exists between two relational database tables.2. In a _ relationship, one record in a table is associated with one and only one record in another table.

Answer»

1. Relationship

2. One-to-One

Discussion

4.	Name the person who has central control over the database and programs in DBMS(a) Naive user (b) Programmer (c) Database Administrator (d) System Analyst
Answer» (c) Database Administrator

Discussion

5.	Name the language that used to dene a database scheme.
Answer» DDL language that used to dene a database scheme.

Discussion

6.	___________ relationships can also be viewed as Many-to-One relationships, depending on which way you look at it.
Answer» Correct Answer is One-to-Many

Discussion

7.	1. Record is also called a Tuple.2. A column or a combination of columns that can be used to identify one or more rows (tuples) in a table is called a Key of the table.
Answer» 1. True 2. True

7.

1. Record is also called a Tuple.2. A column or a combination of columns that can be used to identify one or more rows (tuples) in a table is called a Key of the table.

Answer»

1. True

2. True

Discussion

8.	Name the person who has central control over the database and programs in DBMS (a) Naive user (b) Programmer (c) Database Administrator(d) System Analyst
Answer» (c) Database Administrator

Discussion

9.	1. Record is also called as a ___________2. A column or a combination of columns that can be used to identify one or more rows (tuples) in a table is called a ___________ of the table.
Answer» 1. Tuple 2. Key

9.

1. Record is also called as a _2. A column or a combination of columns that can be used to identify one or more rows (tuples) in a table is called a _ of the table.

Answer»

1. Tuple

2. Key

Discussion

10.	1. A ___________ relationship occurs when multiple records in a table are associated with multiple records in another table.2. Full form of SQL is ___________
Answer» 1. Many-to-Many 2. Structured Query Language

10.

1. A _ relationship occurs when multiple records in a table are associated with multiple records in another table.2. Full form of SQL is _

Answer»

1. Many-to-Many

2. Structured Query Language

Discussion

11.	1. A One-to-One relationship occurs when multiple records in a table are associated with multiple records in another table.2.The full form of SQL is Structured Query Language.
Answer» 1. False 2. True

11.

1. A One-to-One relationship occurs when multiple records in a table are associated with multiple records in another table.2.The full form of SQL is Structured Query Language.

Answer»

1. False

2. True

Discussion

12.	1. In a Many-to-Many relationship, one record in a table is associated with one and only one record in another table.2. One-to-Many relationships can also be viewed as Many-to-One relationships, depending on which way you look at them.
Answer» 1. False 2. True

12.

1. In a Many-to-Many relationship, one record in a table is associated with one and only one record in another table.2. One-to-Many relationships can also be viewed as Many-to-One relationships, depending on which way you look at them.

Answer»

1. False

2. True

Discussion

13.

Observe the field names of a database given below in ‘Column A’ related to Bus reservation. Write suitable data types for each field in front of the respective field in ‘Column B’.Column A (Field Name)Column B (Data Type)Passenger NameAgeGenderMobile Number

Answer»

Column A (Field Name)	Column B (Data Type)
Passenger Name	Varchar
Age	Int
Gender	Char
Mobile Number	Int

Discussion

14.	In a ___________ relationship, one record in a table is associated with one and only one record in another table. (A) One-to-One (B) One-to-Many (C) Many-to-Many(D) Database
Answer» (A) One-to-One

Discussion

15.	The student wants to create a field Pincode in a table, which data type he will choose?
Answer» Answer is: Int

Discussion

16.	Tick the appropriate circle.
Answer» Answer is: One or Many Tables

Discussion

17.	Tick the appropriate box.
Answer» Uniquely identifies a record.

Discussion

18.	RDBMS stands for ___________
Answer» Relational Database Management System

Discussion

19.	___________ ensures that the database properly changes states upon a successfully committed transaction.
Answer» Correct Answer is Consistency

Discussion

20.	___________ ensures that the result or effect of a committed transaction persists in case of a system failure.
Answer» Correct Answer is Durability

Discussion

21.	___________ ensures that the database properly changes states upon a successfully committed transaction. (A) Atomicity (B) Consistency (C) Isolation (D) Durability
Answer» Correct option is (B) Consistency

Discussion

22.	Which of the following cannot be used to name a table in SQL? Give the reason. (a) Studnt50 (b) Table (c) $Employee (d) Stock_123
Answer» (b) Table. This is a keyword hence it cannot be used.

22.

Which of the following cannot be used to name a table in SQL? Give the reason. (a) Studnt50 (b) Table (c) $Employee (d) Stock_123

Answer»

(b) Table.

This is a keyword hence it cannot be used.

Discussion

23.	1. From the list given below select the names that cannot be used as a table name. Adm_No, Date, Salary 2006, Table, Column_Name, Address. 2. Justify your selection.
Answer» 1. Date, Table 2. There is a data type Date and Table is a key word used to create a table. So these two are not used.

23.

1. From the list given below select the names that cannot be used as a table name. Adm_No, Date, Salary 2006, Table, Column_Name, Address. 2. Justify your selection.

Answer»

1. Date, Table

2. There is a data type Date and Table is a key word used to create a table. So these two are not used.

Discussion

24.	Classify the following SQL elements into two and give proper title for each category.NOT NULL. AVG. COUNT. CHECK. SUM. DEFAULT
Answer» 1. Aggregate functions: AVG COUNT SUM 2. Column Constraints: NOT NULL CHECK DEFAULT

24.

Classify the following SQL elements into two and give proper title for each category.NOT NULL. AVG. COUNT. CHECK. SUM. DEFAULT

Answer»

1. Aggregate functions:

AVG

COUNT

SUM

2. Column Constraints:

NOT NULL

CHECK

DEFAULT

Discussion

25.	______ is the ability to modify a schema definition in one level without affecting the schema definition in the next higher level.
Answer» Data Independence is the ability to modify a schema definition in one level without affecting the schema definition in the next higher level.

Discussion

26.	A table Employee consists of fields Employee No, Name, Designation and Salary. Consider that you are forced to give access to this table for an engineer from another company. But for security reasons you need to hide Salary from him.1. Name the concept that provides this engineer, a facility to work on this table without viewing salary. 2. Write SQL query for implementing this
Answer» 1. Views 2. Create view Empview as select employee no, Name, Designation from Employee.

26.

A table Employee consists of fields Employee No, Name, Designation and Salary. Consider that you are forced to give access to this table for an engineer from another company. But for security reasons you need to hide Salary from him.1. Name the concept that provides this engineer, a facility to work on this table without viewing salary. 2. Write SQL query for implementing this

Answer»

1. Views

2. Create view Empview as select employee no, Name, Designation from Employee.

Discussion

27.	1. Atomicity ensures that the database properly changes states upon a successfully committed transaction.2. Isolation enables transactions to operate independently of and be transparent to each other.
Answer» 1. False 2. True

27.

1. Atomicity ensures that the database properly changes states upon a successfully committed transaction.2. Isolation enables transactions to operate independently of and be transparent to each other.

Answer»

1. False

2. True

Discussion

28.	The schema of a table is EMPLOYEE(emp_code, emp_name, designation, salary).Write down the relational expressions for the following: 1. To get the name and designation of all employees. 2. To get the details of employees whose salary is above 25000. 3. To get the names of employees who designation is Manager. 4. To get the details of Managers with salary less than 25000.
Answer» 1. π_{name, designation}(EMPLOYEE) 2. σ_salary>25000 (EMLOYEE) 3. π_name(σ_{designation=”Manager"} (EMPLOYEE)) 4. σ_{designation = “Manager” and salary < 25000}(EMLOYEE).

28.

The schema of a table is EMPLOYEE(emp_code, emp_name, designation, salary).Write down the relational expressions for the following: 1. To get the name and designation of all employees. 2. To get the details of employees whose salary is above 25000. 3. To get the names of employees who designation is Manager. 4. To get the details of Managers with salary less than 25000.

Answer»

1. π_{name, designation}(EMPLOYEE)

2. σ_salary>25000 (EMLOYEE)

3. π_name(σ_{designation=”Manager"} (EMPLOYEE))

4. σ_{designation = “Manager” and salary < 25000}(EMLOYEE).

Discussion

29.	A table Employee consists of fields EmployeeNo, Name, Designation and Salary. Consider that you are forced to give access to this table for an engineer from another company. But for security reasons you need to hide Salary from him. Employee No, Name, Designation, Salary. 1. Name the concept that provides this engineer, a facility to work on this table without viewing salary. Salary view 2. Write SQL query for implementing this SQL query
Answer» 1. Views 2. Create view Empview as select employeeno, Name, Designation from Employee.

29.

A table Employee consists of fields EmployeeNo, Name, Designation and Salary. Consider that you are forced to give access to this table for an engineer from another company. But for security reasons you need to hide Salary from him. Employee No, Name, Designation, Salary. 1. Name the concept that provides this engineer, a facility to work on this table without viewing salary. Salary view 2. Write SQL query for implementing this SQL query

Answer»

1. Views

2. Create view Empview as select employeeno, Name, Designation from Employee.

Discussion

30.	___________ ensures that the result or effect of a committed transaction persists in case of a system failure. (A) Atomicity(B) Consistency (C) Isolation (D) Durability
Answer» Correct option is (D) Durability

Discussion

31.

In a company the data is stored in a table under the following fields Employee number, Last name, Date of birth, Address. Which data type will you use for the above field?

Answer»

Field Name	Data Type
Employee Name	Char
Last Name	Char
Address	Varchar
Date of Birth	Date

Discussion

32.	___________ enables transactions to operate independently of and transparent to each other. (A) Atomicity(B) Consistency (C) Isolation (D) Durability
Answer» Correct option is (C) Isolation

Discussion

33.	___________ enables transactions to operate independently of and transparent to each other.
Answer» Correct Answer is Isolation

Discussion

34.	___________ is simple and has all the properties and capabilities required to process data with storage efficiency. (A) Model (B) Data model (C) Storage and Processing (D) Relational data model
Answer» (D) Relational data model

Discussion

35.	What is DDL (Data Definition Language)
Answer» DDL statements or commands are used to define and modify the database structure of your tables or schema. When you execute a DDL statement, it takes effect immediately. Some examples of DDL commands are CREATE, ALTER, and DROP.

Discussion

36.	Discuss the various Data types.
Answer» 1. CHAR holds a fixed-length string (can contain letters, numbers, and special characters). 2. VARCHAR holds a variable-length string (can contain letters, numbers, and special characters). 3. DECIMAL can represent numbers with or without the fractional part. 4. INT is used for storing integer values. 5. DATE holds the date including day, month, and year. 6. TIME() holds time. Format: HH:MM:SS.

36.

Discuss the various Data types.

Answer»

1. CHAR holds a fixed-length string (can contain letters, numbers, and special characters).

2. VARCHAR holds a variable-length string (can contain letters, numbers, and special characters).

3. DECIMAL can represent numbers with or without the fractional part.

4. INT is used for storing integer values.

5. DATE holds the date including day, month, and year.

6. TIME() holds time. Format: HH:MM:SS.

Discussion

37.	Write down the Properties of Transactions.
Answer» 1. Atomicity ensures that all operations within the work unit are completed successfully. 2. Consistency ensures that the database properly changes states upon a successfully committed transaction. 3. Isolation enables transactions to operate independently of and be transparent to each other. 4. Durability ensures that the result or effect of a committed transaction persists in case of a system failure.

37.

Write down the Properties of Transactions.

Answer»

1. Atomicity ensures that all operations within the work unit are completed successfully.

2. Consistency ensures that the database properly changes states upon a successfully committed transaction.

3. Isolation enables transactions to operate independently of and be transparent to each other.

4. Durability ensures that the result or effect of a committed transaction persists in case of a system failure.

Discussion

38.	Explain Data Model and Relational Model.
Answer» 1. This logical structure of the database is known as a Model. 2. The data model defines how the data is connected to each other and how they are processed and stored inside the system. 3. The data model describes the method of storing and retrieving the data. 4. The relational data model is the primary data model, which is used widely around the world for data storage and processing. 5. The relational data model is simple and has all the properties and capabilities required to process data with storage efficiency.

38.

Explain Data Model and Relational Model.

Answer»

1. This logical structure of the database is known as a Model.

2. The data model defines how the data is connected to each other and how they are processed and stored inside the system.

3. The data model describes the method of storing and retrieving the data.

4. The relational data model is the primary data model, which is used widely around the world for data storage and processing.

5. The relational data model is simple and has all the properties and capabilities required to process data with storage efficiency.

Discussion

39.	Full form of DML is ___________
Answer» Data Manipulation Language

Discussion

40.	Relational data model is the primary data model, which is used widely around the world for ___________ and ___________ (A) Creating(B) Storing (C) Retrieving(D) Data storage (E) Processing
Answer» (D) Data storage, (E) Processing

Discussion

41.	Full form of DML is ___________ (A) Data Manipulation Language(B) Data Machine Language (C) Data Management Language (D) Device Manipulation Language
Answer» (A) Data Manipulation Language

Discussion

42.	1. In Relational Database Management System a database is considered as a collection of interrelated data.2. The Table is the basic data storage unit in a Relational database.
Answer» 1. True 2. True

42.

1. In Relational Database Management System a database is considered as a collection of interrelated data.2. The Table is the basic data storage unit in a Relational database.

Answer»

1. True

2. True

Discussion

43.	Record is also called as a ___________ (A) Table (B) Database(C) Record(D) Tuple
Answer» Correct option is (D) Tuple

Discussion

44.	A column or a combination of columns that can be used to identify one or more rows (tuples) in a table is called a ___________ of the table. (A) Key (B) Primary Key (C) Foreign Key (D) Table
Answer» Correct option is (A) Key

Discussion

45.	1. The table consists of columns and rows.2. A record consists of one or more tables according to which data is stored in a table.
Answer» 1. True 2. False

45.

1. The table consists of columns and rows.2. A record consists of one or more tables according to which data is stored in a table.

Answer»

1. True

2. False

Discussion

46.	Database designer decides the name of the ___________ and ___________ of columns. (A) Schema (B) Table (C) Fields (D) Titles (E) Capabilities
Answer» (B) Table, (D) Titles

Discussion

47.	1. ___________ consists of columns and rows.2. A ___________ consists of one or more tables according to which data is stored in a table.
Answer» 1. Table 2. Database

47.

1. _ consists of columns and rows.2. A _ consists of one or more tables according to which data is stored in a table.

Answer»

1. Table

2. Database

Discussion

48.	___________ is collection of interrelated data.
Answer» Correct option is Database

Discussion

49.	The ___________ is the basic data storage unit in a Relational database. (A) Table (B) Database (C) Record (D) Tuple
Answer» Correct option is (A) Table

Discussion

50.	The ___________ is the basic data storage unit in a Relational database.
Answer» Correct Answer is Table

Discussion

Explore topic-wise InterviewSolutions in Current Affairs.

1. Data Definition Language is the standard language for Relational Database Management System.2. The full form of DDL is Data Definition Language.

How to dene the Domain of a column ‘subject 1’of MARKS relation.

1. A ___________ in the context of databases, is a situation that exists between two relational database tables.2. In a ___________ relationship, one record in a table is associated with one and only one record in another table.

Name the person who has central control over the database and programs in DBMS(a) Naive user (b) Programmer (c) Database Administrator (d) System Analyst

Name the language that used to dene a database scheme.

___________ relationships can also be viewed as Many-to-One relationships, depending on which way you look at it.

1. Record is also called a Tuple.2. A column or a combination of columns that can be used to identify one or more rows (tuples) in a table is called a Key of the table.

Name the person who has central control over the database and programs in DBMS (a) Naive user (b) Programmer (c) Database Administrator(d) System Analyst

1. Record is also called as a ___________2. A column or a combination of columns that can be used to identify one or more rows (tuples) in a table is called a ___________ of the table.

1. A ___________ relationship occurs when multiple records in a table are associated with multiple records in another table.2. Full form of SQL is ___________

1. A One-to-One relationship occurs when multiple records in a table are associated with multiple records in another table.2.The full form of SQL is Structured Query Language.

1. In a Many-to-Many relationship, one record in a table is associated with one and only one record in another table.2. One-to-Many relationships can also be viewed as Many-to-One relationships, depending on which way you look at them.

Observe the field names of a database given below in ‘Column A’ related to Bus reservation. Write suitable data types for each field in front of the respective field in ‘Column B’.Column A (Field Name)Column B (Data Type)Passenger NameAgeGenderMobile Number

In a ___________ relationship, one record in a table is associated with one and only one record in another table. (A) One-to-One (B) One-to-Many (C) Many-to-Many(D) Database

The student wants to create a field Pincode in a table, which data type he will choose?

Tick the appropriate circle.

Tick the appropriate box.

RDBMS stands for ___________

___________ ensures that the database properly changes states upon a successfully committed transaction.

___________ ensures that the result or effect of a committed transaction persists in case of a system failure.

___________ ensures that the database properly changes states upon a successfully committed transaction. (A) Atomicity (B) Consistency (C) Isolation (D) Durability

Which of the following cannot be used to name a table in SQL? Give the reason. (a) Studnt50 (b) Table (c) $Employee (d) Stock_123

1. From the list given below select the names that cannot be used as a table name. Adm_No, Date, Salary 2006, Table, Column_Name, Address. 2. Justify your selection.

Classify the following SQL elements into two and give proper title for each category.NOT NULL. AVG. COUNT. CHECK. SUM. DEFAULT

______ is the ability to modify a schema definition in one level without affecting the schema definition in the next higher level.

1. Atomicity ensures that the database properly changes states upon a successfully committed transaction.2. Isolation enables transactions to operate independently of and be transparent to each other.

___________ ensures that the result or effect of a committed transaction persists in case of a system failure. (A) Atomicity(B) Consistency (C) Isolation (D) Durability

In a company the data is stored in a table under the following fields Employee number, Last name, Date of birth, Address. Which data type will you use for the above field?

___________ enables transactions to operate independently of and transparent to each other. (A) Atomicity(B) Consistency (C) Isolation (D) Durability

___________ enables transactions to operate independently of and transparent to each other.

___________ is simple and has all the properties and capabilities required to process data with storage efficiency. (A) Model (B) Data model (C) Storage and Processing (D) Relational data model

What is DDL (Data Definition Language)

Discuss the various Data types.

Write down the Properties of Transactions.

Explain Data Model and Relational Model.

Full form of DML is ___________

Relational data model is the primary data model, which is used widely around the world for ___________ and ___________ (A) Creating(B) Storing (C) Retrieving(D) Data storage (E) Processing

Full form of DML is ___________ (A) Data Manipulation Language(B) Data Machine Language (C) Data Management Language (D) Device Manipulation Language

1. In Relational Database Management System a database is considered as a collection of interrelated data.2. The Table is the basic data storage unit in a Relational database.

Record is also called as a ___________ (A) Table (B) Database(C) Record(D) Tuple

A column or a combination of columns that can be used to identify one or more rows (tuples) in a table is called a ___________ of the table. (A) Key (B) Primary Key (C) Foreign Key (D) Table

1. The table consists of columns and rows.2. A record consists of one or more tables according to which data is stored in a table.

Database designer decides the name of the ___________ and ___________ of columns. (A) Schema (B) Table (C) Fields (D) Titles (E) Capabilities

1. ___________ consists of columns and rows.2. A ___________ consists of one or more tables according to which data is stored in a table.

___________ is collection of interrelated data.

The ___________ is the basic data storage unit in a Relational database. (A) Table (B) Database (C) Record (D) Tuple

The ___________ is the basic data storage unit in a Relational database.

1. A _ in the context of databases, is a situation that exists between two relational database tables.2. In a _ relationship, one record in a table is associated with one and only one record in another table.

1. Record is also called as a _2. A column or a combination of columns that can be used to identify one or more rows (tuples) in a table is called a _ of the table.

1. A _ relationship occurs when multiple records in a table are associated with multiple records in another table.2. Full form of SQL is _

Relational data model is the primary data model, which is used widely around the world for _ and _ (A) Creating(B) Storing (C) Retrieving(D) Data storage (E) Processing

Database designer decides the name of the _ and _ of columns. (A) Schema (B) Table (C) Fields (D) Titles (E) Capabilities

1. _ consists of columns and rows.2. A _ consists of one or more tables according to which data is stored in a table.