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.
Wait!
Here's an interesting quiz for you.