Test: Database Concepts - 1 - CUET Humanities MCQ

Database applications were built directly on top of file system to overcome the following drawbacks of using file-systems.

• Data redundancy and inconsistency is the concept of repetition of data, i.e. each data may have more than a single copy. We can overcome it with the help of normalisation.
• Difficulty in accessing data can be overcome by different types of queries, i.e. procedural and non-procedural queries.
• Data isolation can be removed by join, etc.
• Integrity problems are the compulsory conditions which should be satisfied by every data value present in the relational table at any instance of time to ensure that the database consists of only meaningful and relevant data.

There are four types of integrity constraints: So, option (4) is correct.

• Domain constraints: Every attribute should have values within its defined domain.
• Key constraints: There should be a primary key for every relational table.
• Entity integrity constraints: No null values should be there for primary keys.
• Referential integrity constraints: In relational model, when two tables are related to each other with the help of some common attributes, the value of referencing attribute should be present in the referenced attribute, else it should be null.

The queue data structure is used in time sharing system in which programs are placed in the data structure waiting to be executed by the CPU.

Yes, all of the above are functions of a database management system.

Query plan is a set of steps used to access information in an SQL relational database management system.

Oracle server is an Oracle database management system that is able to store, manage and manipulate data.

SQL server is a product of Microsoft.

It is used to maintain Integrity constraint in SQL.

Data element is the smallest unit of data because it will not provide further decomposition.

With Relational Model, we can find the key feature and we can normalize the data easily.

Primary key is a set of one or more attributes that can uniquely identify tuples within the relation.