Technical MCQ by MCS'17 covers key topics in database management, including relational algebra, transaction properties, recovery measures, and data modeling.
Network model
Relational model
Hierarchical model
File based system
Rate this question:
   Trees
   Graphs
   Arrays
   None of above
Rate this question:
Atomicity
Concurrency
Isolation
Durability
Rate this question:
Recovery measures
Security measures.
Concurrency measures
Authorization measures.
Rate this question:
   Sorting
   Merging
   Inserting
   Traversal
Rate this question:
View
Order by
Group by
Having
Rate this question:
calloc
free
malloc
realloc
Rate this question:
   Processor and memory
   Complexity and capacity
   Time and space
   Data and space
Rate this question:
   When Item is somewhere in the middle of the array
   When Item is not in the array at all
   When Item is the last element in the array
   When Item is the last element in the array or is not there at all
Rate this question:
   Traversal
   Search
   Sort
   None of above
Rate this question:
Referential constraint
Index.
Integrity constraint
Functional dependency.
Rate this question:
It is the data contained in database that is non redundant.
It is the data contained in database that is accurate and consistent.
It is the data contained in database that is secured.
It is the data contained in database that is shared.
Rate this question:
10..10
10..50
Error
Rate this question:
   O(n)
   O(log n)
   O(n2)
   O(n log n)
Rate this question:
-37
-42
-32
-28
Rate this question:
   for relatively permanent collections of data
   for the size of the structure and the data in the structure are constantly changing
   for both of above situation
   for none of above situation
Rate this question:
   Counting microseconds
   Counting the number of key operations
   Counting the number of statements
   Counting the kilobytes of algorithm
Rate this question:
   O(n)
   O(log n)
   O(n2)
   O(n log n)
Rate this question:
   by this way computer can keep track only the address of the first element and the addresses of other elements can be calculated
   the architecture of computer memory does not allow arrays to store other than serially
   both of above
   none of above
Rate this question:
   for relatively permanent collections of data
   for the size of the structure and the data in the structure are constantly changing
   for both of above situation
   for none of above situation
Rate this question:
Partition constraint
Dependency preservation
Redundancy
Security.
Rate this question:
   Arrays
   Linked lists
   Both of above
   None of above
Rate this question:
   The item is somewhere in the middle of the array
   The item is not in the array at all
   The item is the last element in the array
   The item is the last element in the array or is not there at all
Rate this question:
   the name of array
   the data type of array
   the first data from the set to be stored
   the index set of the array
Rate this question:
It requires that an entity belongs to no more than one level entity set.
The same entity may belong to more than one level.
The database must contain an unmatched foreign key value.
An entity can be joined with another entity in the same level entity set.
Rate this question:
1
2
6
Error
Rate this question:
Procedural DML
Non-Procedural DML
Procedural DDL
Non-Procedural DDL
Rate this question:
Goodbye
Odbye
Bye
dbye
Rate this question:
Selection operator
Projection operator
Aggregation operators
Division operator
Rate this question:
2NF
3NF
BCNF
1NF
Rate this question:
Total participation
Multiple participation.
Cardinality N
None of the above.
Rate this question:
Union
Intersection
Difference
Join
Rate this question:
   Counting the maximum memory needed by the algorithm
   Counting the minimum memory needed by the algorithm
   Counting the average memory needed by the algorithm
   Counting the maximum disk space needed by the algorithm
Rate this question:
Both undo and redo
Undo but no redo
Redo but no undo
Neither undo nor redo.
Rate this question:
Elements can be added from front
Elements can be added to or removed from either the front or rear
Elements can be added from rear
None of the above
Rate this question:
Error
10
10 10
none of these
Rate this question:
Join
Selection
Union
Cross product
Rate this question:
Serializable schedule
Recoverable schedule
Deadlock free schedule
Cascadeless schedule
Rate this question:
prints 100
print garbage
prints ASCII equivalent of 100
None of the above
Rate this question:
Generalization
Specialization
Aggregation
Inheritance
Rate this question:
Functional dependency
Multivalued dependency
Join dependency
Domain-key.
Rate this question:
2
3
4
5
Rate this question:
C
C++
#c/c++
C/c++
Compiler error
Rate this question:
30
36
108
42
Rate this question:
   O(n)
   O(log )
   O(n2)
   O(n log n)
Rate this question:
The element will be set to 0
The compiler would report an error
The program may crash if some important data gets overwritten
The array size would appropriately grow
Rate this question:
program will not compile
10
god only knows
address of I
Rate this question:
   Much more complicated to analyze than that of worst case
   Much more simpler to analyze than that of worst case
   Sometimes more complicated and some other times simpler than that of worst case
   None or above
Rate this question:
Quiz Review Timeline (Updated): Mar 20, 2023 +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
Database Management Ultimate Quiz!
Do you know what is database management? Database management allows the user to organize, store and retrieve information from a computer. It can also describe the data storage,...
Questions:
49 |
Attempts:
550 |
Last updated:
Mar 21, 2023
|
Infromation Technology Quiz: Database Management
This Infromation Technology Quiz focuses on Database Management, assessing knowledge in logical database structures, entity-relationship diagrams, and entity set conversions. It's...
Questions:
56 |
Attempts:
387 |
Last updated:
Mar 21, 2023
|
Database Management Concepts Quiz! Test
How strong is your knowledge of database management concepts? A database is a collection of data with the same characteristics. The database management system a firm uses is...
Questions:
44 |
Attempts:
577 |
Last updated:
Mar 20, 2023
|
Database Chapters 4,5,7 Midterm 2 Quiz
This midterm quiz for Database Chapters 4, 5, 7 assesses key concepts in data management including nonkey attributes, primary keys, attribute meanings, and relational merging. It...
Questions:
120 |
Attempts:
254 |
Last updated:
Mar 20, 2023
|
Database (MSSQL | MYSQL)
This quiz focuses on key aspects of database management in MSSQL and MySQL environments. It tests knowledge on database naming, storage options, troubleshooting steps, and...
Questions:
10 |
Attempts:
276 |
Last updated:
Mar 21, 2023
|
Module 5 Theory Questions
Module 5 Theory Questions explores key concepts in database management, focusing on roles, indexing, structure, relational integrity, and data organization. It assesses...
Questions:
10 |
Attempts:
2281 |
Last updated:
Mar 17, 2023
|
Wait!
Here's an interesting quiz for you.