All Categories MCQs
Topic Notes: All Categories
General Description
Plato
- Biography: Ancient Greek philosopher (427–347 BCE), student of Socrates and teacher of Aristotle, founder of the Academy in Athens.
- Important Ideas:
- Theory of Forms
- Philosopher-King
- Ideal State
331
A telephone number, birth date, and customer name are examples of:
Answer:
Record
A record is a collection of related fields of data treated as a single unit, such as all the information about one customer.
332
The view level of abstraction is primarily concerned with:
Answer:
Hiding parts of the database from certain users.
The view level is the highest level of abstraction. It describes only a part of the entire database relevant to a particular user or group of users. This simplifies interaction and enhances security by hiding sensitive or irrelevant data.
333
Which TCL command is used to create a point in a transaction to which you can later roll back?
Answer:
SAVEPOINT
The `SAVEPOINT` command is used to temporarily save a transaction so that you can roll back to that point whenever necessary. It allows you to undo parts of a transaction instead of the entire transaction.
334
What does the `DROP TABLE` command do?
Answer:
It permanently deletes the table structure, its data, and all related objects like indexes.
`DROP TABLE` is a DDL command that completely removes a table from the database. This operation is irreversible and deletes the table's definition, all its data, and associated indexes and constraints.
335
Microsoft Access and MySQL are examples of __.
Answer:
Database management systems (DBMSs)
Both are popular DBMS software used to create, manage, and interact with databases.
336
What are the rules that restrict how data is entered into a database?
Answer:
Constraints
Constraints are rules enforced on data columns in a table to ensure the accuracy and reliability of the data.
337
What does a dashed underline for an attribute in an ER diagram signify?
Answer:
It is a partial key (discriminator).
The partial key, or discriminator, of a weak entity is underlined with a dashed line. This attribute helps distinguish instances of the weak entity in relation to its owner entity.
338
Which RDBMS supports full-fledged client-server application development?
Answer:
Oracle 7.1
Oracle 7.1 was a significant release that provided robust and advanced capabilities for developing and deploying client-server applications, where client machines could request services and data from a central server.
339
In which scenario would denormalization be a reasonable strategy?
Answer:
In a read-heavy data warehouse or reporting database where query speed is critical.
Denormalization is most often used in data warehousing and business intelligence applications. In these systems, data is written once but read many times for reports, so optimizing for fast data retrieval (reads) by reducing joins is a key priority.
340
The constraint that deals with the accuracy and correctness of data in the database is broadly termed:
Answer:
Data Integrity
Data integrity refers to the overall accuracy, completeness, and consistency of data. Constraints (like primary key, foreign key, check, etc.) are the mechanisms used to enforce data integrity rules.