DBMS Multiple Choice Questions

This section of interview questions and answers focuses on "Database Management System". One shall practice these interview questions to improve their concepts for various interviews such as campus interviews, walk-in interviews, company interviews, placements, entrance exams and other competitive exams.

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

DML(Data Manipulation Language)

Query

Relational Schema

DDL(Data Definition Language)

Answer: D

Explanation: The term "DDL" stands for Data Definition Language, used to perform all other essential tasks such as deleting relation and related schemas in defining the structure relation.

2) Which of the following provides the ability to query information from the database and insert tuples into, delete tuples from, and modify tuples in the database?

DML(Data Manipulation Language)

DDL(Data Definition Language)

Query

Relational Schema

Answer: A

Explanation: The term "DML" stands for the Data Manipulation Language used to perform the required changes in the relation's values.

3) The given Query can also be replaced with_______:

SELECT name, course_id

FROM instructor, teaches

WHERE instructor_ID= teaches_ID; SELECT name, course_id FROM instructor, teaches WHERE instructor_ID= teaches_ID;

Select name,course_id from teaches,instructor where instructor_id=course_id;

Select name, course_id from instructor natural join teaches;

Select name, course_id from instructor;

Select course_id from instructor join teaches;

Answer: B

Explanation: Join clause joins two tables by matching the common column

4) Which one of the following given statements possibly contains the error?

select * from emp where empid = 10003;

select empid from emp where empid = 10006;

select empid from emp;

select empid where empid = 1009 and Lastname = 'GELLER';

Answer: D

Explanation: The Query given in option D does not contain the "from" clause, which specifies the relation from which the values have to be selected or fetched. Therefore the correct answer is D.

5) Ready the Query carefully:

SELECT emp_name

FROM department

WHERE dept_name LIKE ' _____ Computer Science'; SELECT emp_name FROM department WHERE dept_name LIKE ' _____ Computer Science';

In the above-given Query, which of the following can be placed in the Query's blank portion to select the "dept_name" that also contains Computer Science as its ending string?

Answer: C

Explanation: In the above-given Query, the "%" (like) operator will be used, which is generally used while searching for a certain pattern in the strings. It represents the single and multiple characters. In this case, it used with "Where "louse to select the "dept_name" that contains the Computer Since as its ending string. To understand it more clearly, consider the following syntax:

Syntax SELECT column1, column2, ... FROM table_name WHERE columnN LIKE pattern;

6) What do you mean by one to many relationships?

One class may have many teachers

One teacher can have many classes

Many classes may have many teachers

Many teachers may have many classes

Answer: B

Explanation: We can understand the "one to many" relationship as a teacher who may have more than one class to attend.

7) In the following Query, which of the following can be placed in the Query's blank portion to display the salary from highest to lowest amount, and sorting the employs name alphabetically?

SELECT *

FROM instructor

ORDER BY salary ____, name ___; SELECT * FROM instructor ORDER BY salary ____, name ___;

Ascending, Descending

Asc, Desc

Desc, Asc

All of the above

Answer: C

Explanation: To sort the salary from highest to lowest amount and display the employee's name alphabetically, one can use the "Desc and Asc" in the above-given Query.

8) The given Query can be replaced with ____________:

SELECT name

FROM instructor1

WHERE salary <= 100000 AND salary >= 90000; SELECT name FROM instructor1 WHERE salary <= 100000 AND salary >= 90000;

SELECT name

FROM instructor1

WHERE salary BETWEEN 100000 AND 90000 SELECT name FROM instructor1 WHERE salary BETWEEN 100000 AND 90000

SELECT name

FROM instructor|

WHERE salary BETWEEN 90000 AND 100000; SELECT name FROM instructor| WHERE salary BETWEEN 90000 AND 100000;

SELECT name

FROM instructor1

WHERE salary BETWEEN 90000 AND 100000; SELECT name FROM instructor1 WHERE salary BETWEEN 90000 AND 100000;

SELECT name

FROM instructor!

WHERE salary <= 90000 AND salary>=100000; SELECT name FROM instructor! WHERE salary <= 90000 AND salary>=100000;

Answer: C

Explanation: The "SQL" contains a comparison known as the "BETWEEN," which is also used in one of the given queries, as you can see. The "BETWEEN" operator is generally used to simplify the "WHERE" clause that is used to specify that the value is greater than one value or greater than some values, less than one or more values.

9) A Database Management System is a type of _________software.

It is a type of system software

It is a kind of application software

It is a kind of general software

Both A and C

Answer: A

Explanation: The DBMS (or Database Management System) is a kind of system software used for several operations such as creating tables/databases, storing data, managing databases. It also allows modifying the data stored in the database as well.

10) The term "FAT" is stands for_____

File Allocation Tree

File Allocation Table

File Allocation Graph

All of the above

Answer: B

Explanation: The term "FAT" can be described as a file structure (or file architecture). In which all the information about the files where they are stored and where all these files need to be stored or in which directory, all that information generally stored in the file structure. Therefore the Operating system creates a table in which all the files and clusters are stored, known as the file allocation table.

11) Which of the following can be considered as the maximum size that is supported by FAT?

8GB

4GB

4TB

None of the above

Answer: B

Explanation: The files with a size of less than 4 GB or equal to 4GB are easily supported by the FAT. All files with a size greater than the maximum size (or is 4Gb) are not supported by the FAT.

12) The term "NTFS" refers to which one of the following?

New Technology File System

New Tree File System

New Table type File System

Both A and C

Answer: A

Explanation: In the old operating systems, the file structure used to store and manage files is called the FAT 32 ( or File Allocation Table). Later, when the technology evolves with time, a new type of file system is introduced, known as the New Technology File System. It overcomes all the drawbacks, issues that exist in FAT file architecture and has many other new features such as it is fast, it can handle files whose size is even greater than 4 GB.

13) Which of the following can be considered as the maximum size that is supported by NTFS?

4GB

16TB

64TB

8TB

Answer: A

Explanation: The New Technology File System was introduced in 1993 for the very first time as a part of new Windows operating systems (Windows NT 3.1).

You may be surprised to know that windows are still using it because of its fast speed and can support files whose size is up to 16TB (16 terabytes), which is much more than that file size supported by the old system.

14) A huge collection of the information or data accumulated form several different sources is known as ________:

Data Management

Data Mining

Data Warehouse

Both B and C

Answer: C

Explanation: A huge collection of different types of data/information which collected from many different sources stored in one place is called a data warehouse. It works just like the standard warehouse, which is generally a type of holding area/building to store the different types of different goods in huge quantities until they are further distributed. Therefore the correct answer is Data Warehouse.

15) Which of the following can be used to extract or filter the data & information from the data warehouse?

Data redundancy

Data recovery tool

Data mining

Both B and C

Answer: C

Explanation: The tools used to obtain meaningful information or Data from the large collection of data (or from the Data Warehouses) are known as the Data mining tools. Through data mining, one can easily filter the useful information or data from the massive collection of the data. Therefore the correct answer is Data Mining.

16) Which one of the following refers to the copies of the same data (or information) occupying the memory space at multiple places.

Data Repository

Data Inconsistency

Data Mining

Data Redundancy

Answer: D

Explanation: The data redundancy generally occurs whenever more than one copy of the exact same data exists in several different places. Sometimes it may cause data inconsistency, which can result in an unreliable source of data or information that is not good for anyone.

17) Which one of the following refers to the "data about data"?

Search This Blog

AtoZExams

DBMS Multiple Choice Questions

Comments

Post a Comment

Popular posts from this blog

Mini-Max Algorithm in Artificial Intelligence

Alpha-Beta Pruning

SQL Multiple Choice Questions