DB Mania
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
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
Data files
ACID stands for
Atomicity, Consistency, Isolation, Durability
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, R1 and R2 is
2
3
4
5
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
ID
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
{"name":"DB Mania", "url":"https://www.quiz-maker.com/QPREVIEW","txt":"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 StructuresSQL CommandsNormalization FormsDatabase Integrity","img":"https:/images/course5.png"}