Introduction To DBMS
This quiz is for BBA-2C of PCTE, Ludhiana.
Questions and Answers
- 1.
What does the abbreviation DBMS stand for?
- A.
Database Manipulation Software
- B.
Database Management System
- C.
Digital Base Mapping System.
- D.
Data Borrowing and Movement Software
Correct Answer
B. Database Management SystemExplanation
DBMS stands for Database Management System. This is a software that allows users to create, access, and manage databases. It provides a set of tools and functionalities to store, organize, retrieve, and manipulate data in a structured manner. DBMS is widely used in various industries and applications to efficiently handle large amounts of data and ensure data integrity, security, and reliability.Rate this question:
-
- 2.
What is a 'tuple'?
- A.
An attribute attached to a record.
- B.
A row or record in a database table.
- C.
Another name for the key linking different tables in a database.
- D.
Another name for a table in an RDBMS.
Correct Answer
B. A row or record in a database table.Explanation
A 'tuple' refers to a row or record in a database table. In a database, a table is made up of rows and columns, where each row represents a specific record or instance of data. A tuple is essentially a collection of data values that correspond to the columns in a table. It can be seen as a single unit of information within the table, containing all the relevant data for a particular record. Therefore, the correct answer is that a 'tuple' is a row or record in a database table.Rate this question:
-
- 3.
Redundancy is minimized with a computer based database approach.
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
A computer-based database approach helps minimize redundancy by storing data in a centralized location and allowing for efficient data management and retrieval. It eliminates the need for duplicate data storage and ensures data consistency and accuracy. With a well-designed database system, data redundancy is reduced, leading to improved data integrity and efficiency in data processing.Rate this question:
-
- 4.
A row in a database can also be called a domain.
- A.
True
- B.
False
Correct Answer
B. FalseExplanation
A row in a database is not called a domain. A row represents a single record in a table, while a domain refers to the set of possible values that an attribute can take. Therefore, the statement is false.Rate this question:
-
- 5.
Which of the following is component of DBMS Software?
- A.
Hardware
- B.
Software
- C.
Data
- D.
All of the above
Correct Answer
D. All of the aboveExplanation
The correct answer is "All of the above." This is because a DBMS (Database Management System) software includes all the mentioned components: hardware (the physical devices used to store and process data), software (the programs and applications that manage the database), and data (the actual information stored in the database). All three components are essential for the functioning of a DBMS.Rate this question:
-
- 6.
What is part of a database that holds only one type of information?
- A.
Report
- B.
Field
- C.
Record
- D.
File
Correct Answer
B. FieldExplanation
A field is a part of a database that holds only one type of information. It represents a single piece of data within a record, such as a person's name or a product's price. Fields are used to organize and categorize data within a database, allowing for efficient storage and retrieval of information.Rate this question:
-
- 7.
'DB' abbreviation usually means ?
- A.
Database
- B.
Double Byte
- C.
Data Block
- D.
Driver Boot
Correct Answer
A. DatabaseExplanation
The abbreviation 'DB' typically stands for Database. A database is an organized collection of data that is stored and accessed electronically. It is designed to efficiently manage and retrieve large amounts of information, allowing users to store, update, and retrieve data in a structured manner. The term 'DB' is commonly used in the field of computer science and information technology to refer to a database system or related concepts.Rate this question:
-
- 8.
'.JPG' extension refers usually to what kind of file?
- A.
System file
- B.
Animation/movie file
- C.
MS Encarta document
- D.
Image file
Correct Answer
D. Image fileExplanation
The '.JPG' extension is commonly used to identify image files. This file format is widely recognized and supported by various devices and software applications, making it convenient for storing and sharing digital images.Rate this question:
-
- 9.
'CD' abbreviation usually means ?
- A.
Command Description
- B.
Change Data
- C.
Copy Density
- D.
Compact Disc
Correct Answer
D. Compact DiscExplanation
The abbreviation "CD" commonly refers to "Compact Disc." A compact disc is a small, portable storage medium used for storing and playing back digital audio, video, and other data. It is a widely recognized abbreviation and is commonly used in the context of music, movies, and computer technology.Rate this question:
-
- 10.
On the Task bar the time is shown in the...?
- A.
Start menu
- B.
Scroll bar
- C.
Desktop
- D.
Notification area or Tray
Correct Answer
D. Notification area or TrayExplanation
The time is shown in the Notification area or Tray on the Taskbar. This area typically contains icons for various system and program notifications, including the time and date. It is located at the right side of the Taskbar and provides quick access to important information and functions.Rate this question:
-
- 11.
Another word for the CPU is...
- A.
Execute
- B.
Microprocessor
- C.
Micro chip
- D.
Decode
Correct Answer
B. MicroprocessorExplanation
The correct answer is "Microprocessor". A microprocessor is another word for the CPU (Central Processing Unit). It is the main component of a computer that carries out the instructions of a computer program by performing basic arithmetic, logical, control, and input/output (I/O) operations. It is responsible for executing instructions, decoding them, and performing calculations in a computer system.Rate this question:
-
- 12.
Which of the following is not a version of Microsoft Windows?
- A.
Red Hat
- B.
XP
- C.
ME
- D.
Vista
Correct Answer
A. Red HatExplanation
Red Hat is not a version of Microsoft Windows. It is a Linux-based operating system developed by Red Hat, Inc. On the other hand, XP, ME, and Vista are all versions of Microsoft Windows. XP stands for Windows XP, ME stands for Windows Millennium Edition, and Vista is a version of Windows released after XP.Rate this question:
-
- 13.
How many bits is a byte?
- A.
4
- B.
8
- C.
16
- D.
32
Correct Answer
B. 8Explanation
A byte is composed of 8 bits. Each bit is a binary digit that can represent either a 0 or a 1. Therefore, a byte consists of 8 of these binary digits, allowing for a total of 256 possible combinations (2^8). This is the most common unit of digital information storage and is used to represent characters, numbers, and other data in computer systems.Rate this question:
-
- 14.
How many layers are there in DBMS architecture?
- A.
2
- B.
3
- C.
4
- D.
5
Correct Answer
B. 3Explanation
The correct answer is 3 because DBMS architecture typically consists of three layers: the external or user layer, the conceptual or logical layer, and the internal or physical layer. The external layer is the interface through which users interact with the database, the conceptual layer defines the logical structure and organization of the data, and the internal layer deals with the physical storage and retrieval of the data.Rate this question:
-
- 15.
What is a "relation" in DBMS?
- A.
Tuple
- B.
Table
- C.
Attribute
- D.
Field
Correct Answer
B. TableExplanation
A "relation" in DBMS refers to a table. In a database, a table is used to store data in a structured manner. It consists of rows and columns, where each row represents a record or a tuple, and each column represents a specific attribute or field. Therefore, a table is the correct answer as it is the fundamental component for organizing and storing data in a database management system.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 22, 2023Quiz Edited by
ProProfs Editorial Team -
Jan 28, 2010Quiz Created by
Maninderkaur
- 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