Multiple Choice Questions -database Concepts
-
In the relational model, cardinality is termed as:
-
A number of attributes.
-
A number of tuples
-
A number of tables
-
A number of constraints.
-
This quiz focuses on fundamental database concepts within relational models, including cardinality, schema, and data records, emphasizing data independence and management advantages.
Quiz Preview
- 2.
In a relational model, relations are termed as
-
Tuples
-
Attributes
-
Tables
-
Rows
Correct Answer
A. TablesExplanation
In a relational model, relations are represented as tables. Tables consist of rows and columns, where each row represents a record or tuple, and each column represents an attribute or field. Therefore, the correct answer is "Tables."Rate this question:
-
- 3.
A logical schema
-
Is the entire database
-
Is a standard way of organising information into accessible parts.
-
Describes how data is actually stored on disk.
-
Both (A) and (C)
Correct Answer
A. Is the entire databaseExplanation
A logical schema refers to the entire database, including all the tables, relationships, and constraints. It represents the overall structure and organization of the data, without specifying how it is physically stored on disk. Therefore, the correct answer is "is the entire database."Rate this question:
-
- 4.
Related fields in a database are grouped to form a
-
Data file
-
Data record
-
Menu.
-
Bank
Correct Answer
A. Data recordExplanation
In a database, related fields are grouped together to form a data record. A data record is a collection of related data elements or fields that are treated as a single unit. It represents a complete set of information about a specific entity or object in the database. By grouping related fields into a data record, it allows for efficient storage, retrieval, and manipulation of data in the database.Rate this question:
-
- 5.
The relational model feature is that there
-
Is no need for primary key data.
-
Is much more data independence than some other database models.
-
Are explicit relationships among records
-
Are tables with many dimensions
Correct Answer
A. Is much more data independence than some other database models.Explanation
The correct answer is "is much more data independence than some other database models." This means that in the relational model, the data is stored separately from the applications that use it, allowing for easier modifications and updates without affecting the entire system. This level of data independence is not present in some other database models, where changes to the data structure can have a significant impact on the applications using it.Rate this question:
-
- 6.
An advantage of the database management approach is
-
Data is dependent on programs.
-
Data redundancy increases.
-
Data is integrated and can be accessed by multiple programs.
-
None of the above.
Correct Answer
A. Data is integrated and can be accessed by multiple programs.Explanation
The advantage of the database management approach is that data is integrated and can be accessed by multiple programs. This means that the data is centralized in a database, making it easier for different programs to access and use the same data. This eliminates the need for each program to have its own separate data storage and reduces data redundancy. It also ensures data consistency and integrity, as any changes made to the data are reflected across all programs that access it.Rate this question:
-
- 7.
A DBMS query language is designed to
-
Support end-users who use English-like commands.
-
Support in the development of complex applications software.
-
Specify the structure of a database.
-
All of the above
Correct Answer
A. All of the aboveExplanation
A DBMS query language is designed to support end-users who use English-like commands by providing a user-friendly interface that allows them to interact with the database using familiar language. Additionally, it supports in the development of complex applications software by providing tools and capabilities for querying and manipulating data within the database. Lastly, it also allows users to specify the structure of a database by providing commands and syntax for creating, modifying, and managing the database schema. Therefore, the correct answer is "all of the above."Rate this question:
-
- 8.
Key to represent the relationship between tables is called
-
Primary key
-
Secondary key
-
Foreign key
-
None of these
Correct Answer
A. Foreign keyExplanation
A foreign key is used to establish a relationship between two tables in a database. It is a field in one table that refers to the primary key in another table. This relationship helps maintain data integrity and ensures that the data in the related tables remains consistent. The foreign key allows for the linking of data across tables, enabling the retrieval of related information when needed.Rate this question:
-
- 9.
DBMS helps to achieve
-
Data independence
-
Centralised control of data
-
Neither (A) or (B)
-
Both A and B
Correct Answer
A. Both A and BExplanation
DBMS (Database Management System) helps to achieve both data independence and centralized control of data. Data independence refers to the ability to modify the database schema without affecting the applications that use the data. This allows for flexibility and ease of maintenance. Centralized control of data means that the DBMS provides a centralized location for managing and controlling access to the data, ensuring data integrity and security. Therefore, the correct answer is "Both A and B".Rate this question:
-
- 10.
A set of possible data values is called
-
Attribute.
-
Degree
-
Tuple
-
Domain
Correct Answer
A. DomainExplanation
In the context of data, a domain refers to the set of all possible values that an attribute can have. It represents the range of values that a particular attribute can take on. Therefore, a set of possible data values is called a domain.Rate this question:
-
- 11.
A primary key is combined with a foreign key creates
-
Parent-Child relationship between the tables that connect them.
-
Many to many relationships between the tables that connect them.
-
Network model between the tables that connect them.
-
None of the above
Correct Answer
A. Parent-Child relationship between the tables that connect them.Explanation
When a primary key is combined with a foreign key, it creates a parent-child relationship between the tables that connect them. This means that the table with the primary key (parent table) is the parent, and the table with the foreign key (child table) is the child. The relationship ensures that each record in the child table is associated with a record in the parent table. This allows for data integrity and enables efficient querying and manipulation of related data.Rate this question:
-
- 12.
Data about data is normally termed as:
-
Directory
-
Data bank
-
Metadata
-
None of the above
Correct Answer
A. MetadataExplanation
Metadata refers to the data about data. It provides information about the characteristics, structure, and content of data. It helps in organizing, managing, and understanding the data by providing context and meaning. In this case, the correct answer is "metadata" because it accurately describes the concept of data about data.Rate this question:
-
- 13.
A _____ is a property of the entire relation, rather than of the individual tuples in which each tuple is unique.
-
Rows
-
Key
-
Attribute
-
Fields
Correct Answer
A. KeyExplanation
A key is a property of the entire relation, rather than of the individual tuples, in which each tuple is unique. A key is used to uniquely identify each tuple in a relation and is an important concept in database design. It ensures that there are no duplicate tuples in a relation and allows for efficient retrieval of data.Rate this question:
-
- 14.
Which one of the following attribute can be taken as a primary key ?
-
Name
-
Street
-
ID
-
Department
Correct Answer
A. IDExplanation
The attribute "ID" can be taken as a primary key because a primary key is a unique identifier for each record in a database table. It ensures that each record can be uniquely identified and retrieved. In this case, the "ID" attribute is likely to have a unique value for each entity in the table, making it suitable as a primary key.Rate this question:
-
- 15.
A attribute in a relation is a foreign key if the _______ key from one relation is used as an attribute in that relation .
-
Candidate
-
Primary
-
Super
-
Sub
Correct Answer
A. PrimaryExplanation
A attribute in a relation is a foreign key if the primary key from one relation is used as an attribute in that relation. This means that the attribute in question is referencing the primary key of another relation, establishing a relationship between the two relations. The foreign key helps maintain referential integrity and ensures that the values in the attribute correspond to valid values in the referenced primary key.Rate this question:
-
Quiz Review Timeline (Updated): Mar 21, 2023 +
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 -
Mar 17, 2020Quiz Created by
Aparnasunil75
Back to top