Practice Library
All MCQs
Browse exam-wise, subject-wise, and country-wise MCQs with explanations.
Choose an option to check your answer.
A.
a table-valued attribute that can store multiple related values within a row structure
B.
a log table used only for crashes
C.
a copy of the system catalog
D.
a table that contains only one column
Show Answer
Correct Answer: A. a table-valued attribute that can store multiple related values within a row structure
Explanation:
This statement is correct because nested table in object-relational systems means that a table-valued attribute that can store multiple related values within a row structure.
Choose an option to check your answer.
A.
a table-valued attribute that can store multiple related values within a row structure
B.
a table that contains only one column
C.
a log table used only for crashes
D.
a copy of the system catalog
Show Answer
Correct Answer: A. a table-valued attribute that can store multiple related values within a row structure
Explanation:
nested table in object-relational systems is used in Advanced DBMS because a table-valued attribute that can store multiple related values within a row structure.
Choose an option to check your answer.
A.
a copy of the system catalog
B.
a log table used only for crashes
C.
a table that contains only one column
D.
a table-valued attribute that can store multiple related values within a row structure
Show Answer
Correct Answer: D. a table-valued attribute that can store multiple related values within a row structure
Explanation:
The correct answer explains nested table in object-relational systems in the context of Advance Data Models.
Choose an option to check your answer.
A.
a data type that cannot be queried
B.
a physical page size chosen by the OS
C.
a user-defined or structured type that can represent nested or composite values
D.
a password stored inside a table
Show Answer
Correct Answer: C. a user-defined or structured type that can represent nested or composite values
Explanation:
This statement is correct because complex data type in object-relational databases means that a user-defined or structured type that can represent nested or composite values.
Choose an option to check your answer.
A.
a data type that cannot be queried
B.
a physical page size chosen by the OS
C.
a password stored inside a table
D.
a user-defined or structured type that can represent nested or composite values
Show Answer
Correct Answer: D. a user-defined or structured type that can represent nested or composite values
Explanation:
complex data type in object-relational databases is used in Advanced DBMS because a user-defined or structured type that can represent nested or composite values.
Choose an option to check your answer.
A.
a physical page size chosen by the OS
B.
a user-defined or structured type that can represent nested or composite values
C.
a password stored inside a table
D.
a data type that cannot be queried
Show Answer
Correct Answer: B. a user-defined or structured type that can represent nested or composite values
Explanation:
The correct answer explains complex data type in object-relational databases in the context of Advance Data Models.
Choose an option to check your answer.
A.
a subclass can reuse and specialize properties of a superclass
B.
a transaction is forced to wait forever
C.
all users automatically get DBA privileges
D.
each file block stores one attribute only
Show Answer
Correct Answer: A. a subclass can reuse and specialize properties of a superclass
Explanation:
This statement is correct because inheritance in object-oriented databases means that a subclass can reuse and specialize properties of a superclass.
Choose an option to check your answer.
A.
each file block stores one attribute only
B.
all users automatically get DBA privileges
C.
a transaction is forced to wait forever
D.
a subclass can reuse and specialize properties of a superclass
Show Answer
Correct Answer: D. a subclass can reuse and specialize properties of a superclass
Explanation:
inheritance in object-oriented databases is used in Advanced DBMS because a subclass can reuse and specialize properties of a superclass.
Choose an option to check your answer.
A.
all users automatically get DBA privileges
B.
a transaction is forced to wait forever
C.
a subclass can reuse and specialize properties of a superclass
D.
each file block stores one attribute only
Show Answer
Correct Answer: C. a subclass can reuse and specialize properties of a superclass
Explanation:
The correct answer explains inheritance in object-oriented databases in the context of Advance Data Models.
Choose an option to check your answer.
A.
queries are always executed on a single server
B.
indexes are removed to improve security
C.
all tables must be converted to flat files
D.
data and operations are bundled together inside objects
Show Answer
Correct Answer: D. data and operations are bundled together inside objects
Explanation:
This statement is correct because encapsulation in object-oriented databases means that data and operations are bundled together inside objects.
Choose an option to check your answer.
A.
indexes are removed to improve security
B.
all tables must be converted to flat files
C.
queries are always executed on a single server
D.
data and operations are bundled together inside objects
Show Answer
Correct Answer: D. data and operations are bundled together inside objects
Explanation:
encapsulation in object-oriented databases is used in Advanced DBMS because data and operations are bundled together inside objects.
Choose an option to check your answer.
A.
indexes are removed to improve security
B.
queries are always executed on a single server
C.
data and operations are bundled together inside objects
D.
all tables must be converted to flat files
Show Answer
Correct Answer: C. data and operations are bundled together inside objects
Explanation:
The correct answer explains encapsulation in object-oriented databases in the context of Advance Data Models.
