Q. In object-oriented data modeling, what is an 'object'?
-
A.
A collection of data and methods
-
B.
A single data entry in a database
-
C.
A type of database schema
-
D.
A relationship between entities
Solution
In object-oriented data modeling, an object is a collection of data and methods that operate on that data.
Correct Answer:
A
— A collection of data and methods
Learn More →
Q. In the context of DBMS architecture, what is a 'client-server' model?
-
A.
A model where all data is stored on the client
-
B.
A model where the server handles all data processing
-
C.
A model where clients and servers share processing tasks
-
D.
A model that does not use a network
Solution
In a client-server model, clients and servers share processing tasks, with clients requesting services and servers providing them.
Correct Answer:
C
— A model where clients and servers share processing tasks
Learn More →
Q. In the context of DBMS architecture, what is a 'data model'?
-
A.
A way to visualize data
-
B.
A structure for organizing data
-
C.
A method for querying data
-
D.
A technique for data encryption
Solution
A data model is a structure for organizing data, defining how data is connected and how it can be accessed.
Correct Answer:
B
— A structure for organizing data
Learn More →
Q. What is an object in Object-Oriented Data Modeling?
-
A.
A table in a database
-
B.
An instance of a class
-
C.
A relationship between entities
-
D.
A type of query
Solution
In Object-Oriented Data Modeling, an object is an instance of a class that encapsulates data and behavior.
Correct Answer:
B
— An instance of a class
Learn More →
Q. What is the purpose of concurrency control in a database?
-
A.
To ensure data redundancy
-
B.
To manage simultaneous operations without conflicting
-
C.
To improve data integrity
-
D.
To simplify database queries
Solution
Concurrency control is used to manage simultaneous operations on a database to prevent conflicts and ensure data integrity.
Correct Answer:
B
— To manage simultaneous operations without conflicting
Learn More →
Q. What is the role of a foreign key in a relational database?
-
A.
To uniquely identify a record
-
B.
To establish a relationship between two tables
-
C.
To enforce data integrity
-
D.
To improve query performance
Solution
A foreign key is used to establish a relationship between two tables by referencing the primary key of another table.
Correct Answer:
B
— To establish a relationship between two tables
Learn More →
Q. Which of the following best describes a 'weak entity' in an ER model?
-
A.
An entity that cannot exist without a strong entity
-
B.
An entity with no attributes
-
C.
An entity that has a composite key
-
D.
An entity that is not related to any other entity
Solution
A weak entity is an entity that cannot exist without a strong entity and relies on it for its identification.
Correct Answer:
A
— An entity that cannot exist without a strong entity
Learn More →
Q. Which of the following is NOT a type of database concurrency control?
-
A.
Pessimistic locking
-
B.
Optimistic locking
-
C.
Timestamp ordering
-
D.
Data normalization
Solution
Data normalization is not a type of concurrency control; it is a process of organizing data to reduce redundancy.
Correct Answer:
D
— Data normalization
Learn More →
Q. Which of the following is NOT a type of normalization form?
-
A.
First Normal Form (1NF)
-
B.
Second Normal Form (2NF)
-
C.
Third Normal Form (3NF)
-
D.
Fourth Normal Form (4NF)
Solution
All listed options are types of normalization forms; however, the question is misleading as all are valid forms.
Correct Answer:
D
— Fourth Normal Form (4NF)
Learn More →
Showing 1 to 9 of 9 (1 Pages)
