DB Mania

Create an image of a person with glasses working on a laptop, surrounded by database symbols like tables, SQL code snippets, and data diagrams, in a modern office setting.

DB Mania Quiz

Test your knowledge of databases with our engaging DB Mania Quiz! This 34-question quiz covers a wide range of topics including relational algebra, SQL commands, and database normalization. Perfect for students, teachers, and database enthusiasts.

Challenge yourself with questions on:

Database Structures
SQL Commands
Normalization Forms
Database Integrity

34 Questions8 MinutesCreated by LearningCoder123

Degree of relationships is

Number of participating entity types

number of participating relations

number of participating attribute types

number of participating constraints

_______stores metadata about the structure of the database, in particular the schema of the database

Indices

Data Dictionary

Data files

ACID stands for

Atomicity, Consistency, Isolation, Durability

Aggregation, Consistency, Isolation, Durability

Atomicity, Consistency, Identity, Durability

An attribute or combination of attributes in one table whose values must either match the primary key in another table or be null is called __________

Secondary Key

Super key

Candidate Key

Foreign Key

A transaction state changes from active to______, after the transaction has been rolled back and the database restored to its state prior to the start of the transaction

Partially committed

Committed

Aborted

Failed

The problem caused by independent multivalued dependencies is eliminated in which of the normal form?

3NF

4NF

5NF

BCNF

A schedule for a set of transactions must

Consist of all instructions of those transactions

Preserve the order in which the instructions appear in each individual transaction

Both a and b

None of these

With SQL, how can you return the number of records in the "Persons" table?

SELECT COUNT(*) FROM Persons

SELECT LEN(*) FROM Persons

SELECT NO(*) FROM Persons

SELECT COLUMNS(*) FROM Persons

With SQL, how can you delete the records where the "FirstName" is "Rahul" in the Persons Table?

DELETE FROM Persons WHERE FirstName = 'Rahul'

DELETE FirstName='Rahul' FROM Persons

DELETE ROW FirstName='Rahul' FROM Persons

None Of These

What do you mean by one to many relationship between Teacher and Class table?

One class may have many teachers

One teacher can have many classes

Many classes may have many teachers

Many teachers may have many classes

. When a primary key is define in the table , DBMS automatically creates a ____ on a primary key column

Unique index

Sequence

Trigger

Synonym

NULL is

The same as 0 for integer

The same as blank for character

The same as 0 for integer and blank for character

Not a value

Using Relational Algebra the query that finds customers, who have a balance of over 1000 is

PCustomer_name(s balance >1000(Deposit))

S Customer_name(P balance >1000(Deposit))

PCustomer_name(s balance >1000(Borrow))

S Customer_name(P balance >1000(Borrow))

A logical schema

Is the entire database

Is a standard way of organising information into an accessible part

Describe how data is actually stored on disk

None of these

The minimum number of tables required to represent M, N, P, R₁and R₂ is

Match the following with respect to RDBMS:

List - I	List - II
(a) Entity integrity	(i) Enforces some specific business rules that do not fall into entity or domain
(b) Domain integrity	(ii) No deletion of rows which are used by other records
(c) Referential integrity	(iii) Enforces valid entries for a column
(d) User defined integrity	(iv) No duplicate rows in a table

(a) -(iii), (b) -(iv), (c) -(i), (d) -(ii)

(a) -(iv), (b) -(iii), (c) -(ii), (d) -(i)

(a) -(iv), (b) -(ii), (c) -(iii), (d) -(i)

(a) -(ii), (b) -(iii), (c) -(iv), (d) -(i)

With SQL, how can you return all the records from a table named "Persons" sorted descending by "FirstName"?

SELECT * FROM Persons ORDER FirstName DESC

SELECT * FROM Persons ORDER BY FirstName DESC

SELECT * FROM Persons SORT 'FirstName' DESC

SELECT * FROM Persons SORT BY 'FirstName' DESC

The overall description of a database is called______.

Data integrity

Data manipulation

Database schema

Data definition

It is used to establish an association between related tables.

Line

Relationship

Primary Key

Records

Which name must be unique within a database ?

Table

Field

Record

Character

Which of the following is used to denote the selection operation in relational algebra ?

Pi (Greek)

Sigma (Greek)

Lambda (Greek)

Omega (Greek)

Consider attributes ID , CITY and NAME . Which one of this can be considered as a super key ?

NAME

CITY

CITY , ID

Trigger are supported in

Delete

Update

Views

All of the mentioned

Which of the following is false?

Every BCNF relation is in 3NF.

Every binary relation is never in BCNF

1 NF, 2 NF, 3 NF and BCNF are based on functional dependencies

Multivalued Dependency (MVD) is a special case of Join Dependency (JD).

The ''PROJECT'' operator of a relational algebra creates a new table that has always

More columns than columns in the original table

More rows than the original table

Same number of rows as the original table

Same number of columns as the original table

____ refers loosely to the process of semi-automatically analysing large databases to find useful patterns

Data mining

Data warehousing

DBMS

Data mirroring

For a database relation R (A, B, C, D), where the domains of A, B, C and D include only atomic values, only the following functional dependencies and those that can be inferred from them are: A --> C, B -->D The relation R is in _______

First normal form but not in second normal form

Both in first normal form as well as in second normal form

Second normal form but not in third normal form

Both in second normal form as well as in third normal form

Which of the following statements is/are true with reference to 'view' in DBMS? (a) A 'view' is a special stored procedure executed when certain event occurs. (b) A 'view' is a virtual table, which occurs after executing a pre-compiled query.

Only (a) is true.

Only (b) is true.

Both (a) and (b) are true.

Neither (a) nor (b) is true.

How can you change "Hansen" into "Nilsen" in the "LastName" column in the Persons table?

UPDATE Persons SET LastName='Hansen' INTO LastName='Nilsen'

MODIFY Persons SET LastName='Nilsen' WHERE LastName='Hansen'

UPDATE Persons SET LastName='Nilsen' WHERE LastName='Hansen'

MODIFY Persons SET LastName='Hansen' INTO LastName='Nilsen

Which SQL keyword is used to sort the result-set?

ORDER

ORDER BY

SORT

SORT BY

DB Mania

DB Mania Quiz

More Quizzes