Trivia Quiz On Database Management System
Welcome to the trivia quiz on database management system. Over the past few days we have been able to dive deeper into the data base. A data base is made of different components and each of them has a specific responsibility in order to meet a user’s responsibility. Take up the quiz and get to see just how much you got to understand. All the best!
Questions and Answers
- 1.
Which of the following is not the responsibility of the utilities component of DBMS software?
- A.
Creating the physical and logical designs
- B.
Removing flagged records for deletion
- C.
Creating and maintaining the data dictionary
- D.
Monitoring performance
Correct Answer
A. Creating the physical and logical designsExplanation
The utilities component of DBMS software is responsible for various tasks, such as removing flagged records for deletion, creating and maintaining the data dictionary, and monitoring performance. However, creating the physical and logical designs is not one of its responsibilities. This task typically falls under the responsibility of the database administrator or the database designer, who are in charge of designing the structure and organization of the database.Rate this question:
-
- 2.
A report generator is used to
- A.
Update files.
- B.
Print files on paper.
- C.
Data entry.
- D.
Delete files.
Correct Answer
B. Print files on paper.Explanation
A report generator is a tool or software that is specifically designed to generate reports. These reports can be in various formats, such as PDF, Excel, or HTML, but one of the common outputs is printing the reports on paper. Therefore, the correct answer is "print files on paper."Rate this question:
-
- 3.
Count function in SQL returns the number of
- A.
Values.
- B.
Distinct values.
- C.
groups.
- D.
Columns.
Correct Answer
A. Values.Explanation
The count function in SQL returns the number of values. It is used to count the number of rows or records in a table or the number of values in a specific column. It does not take into account the distinct values, groups, or columns, but simply returns the total count of values.Rate this question:
-
- 4.
The statement in SQL which allows to change the definition of a table is
- A.
Alter.
- B.
Update.
- C.
Create.
- D.
Select.
Correct Answer
A. Alter.Explanation
The correct answer is "Alter" because the ALTER statement in SQL is used to modify the structure or definition of an existing table. It allows you to add, delete, or modify columns, constraints, and other table attributes. The UPDATE statement is used to modify the data within the table, not the table structure. The CREATE statement is used to create a new table, not change an existing one. The SELECT statement is used to retrieve data from the table, not modify its definition.Rate this question:
-
- 5.
DBMS helps achieve
- A.
Data independence
- B.
Centralized control of data
- C.
Neither (A) nor (B)
- D.
Both (A) and (B)
Correct Answer
D. Both (A) and (B)Explanation
DBMS (Database Management System) helps achieve both data independence and centralized control of data. Data independence refers to the ability to make changes to the database structure without affecting the applications that use the data. DBMS provides a layer of abstraction between the physical storage and the logical representation of data, allowing for easier modifications. Centralized control of data means that the DBMS provides a centralized location for storing and managing data, ensuring consistency, security, and efficient access. Therefore, both options (A) and (B) are correct.Rate this question:
-
- 6.
Which of the following are the properties of entities?
- A.
Groups
- B.
Table
- C.
Attributes
- D.
Switchboards
Correct Answer
C. AttributesExplanation
Entities are the objects or things that we want to store information about in a database. They can be people, places, things, or events. Properties of entities are the characteristics or attributes that describe them. These attributes provide information about the entities and help in organizing and categorizing the data. Therefore, "Attributes" is the correct answer as it correctly identifies one of the properties of entities.Rate this question:
-
- 7.
The RDBMS terminology for a row is
- A.
Tuple.
- B.
Relation.
- C.
Attribute.
- D.
Degree.
Correct Answer
A. Tuple.Explanation
In the context of relational database management systems (RDBMS), a row is referred to as a tuple. A tuple represents a single record or instance of data within a table. It consists of a collection of attributes or fields that describe the characteristics or properties of that particular record. Therefore, the term "tuple" accurately describes the RDBMS terminology for a row in a database table.Rate this question:
-
- 8.
The full form of DDL is
- A.
Dynamic Data Language
- B.
Detailed Data Language
- C.
Data Definition Language
- D.
Data Derivation Language
Correct Answer
C. Data Definition LanguageExplanation
DDL stands for Data Definition Language. It is a subset of SQL (Structured Query Language) that is used to define and manage the structure of a database. DDL statements are used to create, modify, and delete database objects such as tables, indexes, and views. Examples of DDL statements include CREATE, ALTER, and DROP. DDL is different from DML (Data Manipulation Language) which is used to retrieve, insert, update, and delete data in a database. Therefore, the correct answer is Data Definition Language.Rate this question:
-
- 9.
Which of the following is a legal expression in SQL?
- A.
SELECT NULL FROM EMPLOYEE;
- B.
SELECT NAME FROM EMPLOYEE;
- C.
SELECT NAME FROM EMPLOYEE WHERE SALARY = NULL;
- D.
None of the above
Correct Answer
B. SELECT NAME FROM EMPLOYEE;Explanation
The correct answer is "SELECT NAME FROM EMPLOYEE;". This is a legal expression in SQL because it follows the syntax of the SELECT statement, which is used to retrieve data from a database. The statement selects the "NAME" column from the "EMPLOYEE" table, indicating that the desired data is the names of employees.Rate this question:
-
- 10.
The result of the UNION operation between R1 and R2 is a relation that includes
- A.
All the tuples of R1
- B.
All the tuples of R2
- C.
All the tuples of R1 and R2
- D.
All the tuples of R1 and R2 which have common columns
Correct Answer
D. All the tuples of R1 and R2 which have common columnsExplanation
The result of the UNION operation between R1 and R2 is a relation that includes all the tuples of R1 and R2 which have common columns. The UNION operation combines the tuples from both relations and eliminates any duplicates. In this case, only the tuples that have common columns in R1 and R2 will be included in the result. Tuples that do not have common columns will not be included.Rate this question:
-
Quiz Review Timeline +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
-
Current Version
-
Mar 21, 2023Quiz Edited by
ProProfs Editorial Team -
Nov 26, 2012Quiz Created by
Ashishdoorwar96
- Binary Code Quizzes
- Computer Concept Quizzes
- Computer Essential Quizzes
- Computer Forensics Quizzes
- Computer Hardware Quizzes
- Computer Networking Quizzes
- Computer Parts Quizzes
- Computer Programming Quizzes
- Computer Science Quizzes
- Computer Security Quizzes
- Computer Shortcut Key Quizzes
- Computer Skills Quizzes
- Computer Virus Quizzes
- Cyber Security Quizzes
- Data Quizzes
- Data Security Quizzes
- Hacking Quizzes
- HCI Quizzes
- Internet Quizzes
- IT SecurITy Quizzes
- Malware Quizzes
- Microprocessor Quizzes
- Network Quizzes
- Operating System Quizzes
- Phishing Quizzes
- Programming Language Quizzes
- Server Quizzes
- Software Quizzes
Back to top