Database Systems MCQs with Answers | Computer Science

@T-Bone

A database is an organized collection of structured information, or data, typically stored electronically in a computer system. Together, the data and the DBMS, along with the applications that are associated with them, are referred to as a database system, often shortened to just database

A database is an organized collection of structured information, or data, typically stored electronically in a computer system. Together, the data and the DBMS, along with the applications that are associated with them, are referred to as a database system, often shortened to just database

Questions

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

Mark the correct option

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?

Mark the correct option

3. Which one of the following given statements possibly contains the error?

Mark the correct option

4. Ready the Query carefully: 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?

Mark the correct option

5. What do you mean by one to many relationships?

Mark the correct option

6. 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 ___;

Mark the correct option

7. A Database Management System is a type of _________software.

Mark the correct option

8. The term "FAT" is stands for_____

Mark the correct option

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

Mark the correct option

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

Mark the correct option

11. A huge collection of the information or data accumulated from several different sources is known as ________:

Mark the correct option

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

Mark the correct option

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

Mark the correct option

14. Which one of the following refers to the "data about data"?

Mark the correct option

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

Mark the correct option

16. To which of the following the term "DBA" referred?

Mark the correct option

17. In general, a file is basically a collection of all related______.

Mark the correct option

18. The term "Data" refers to:

Mark the correct option

19. Rows of a relation are known as the _______.

Mark the correct option

20. Which of the following refers to the number of tuples in a relation?

Mark the correct option

Index of Questions