Examveda

In the database directory of the database each view and trigger object is associated with how many files?

A. 0

B. 1

C. 2

D. 3

Answer: Option B

Solution (By Examveda Team)

This question asks about how many files are used to store views and triggers in a MySQL database. Think of files like containers that hold data.

Here's how it works:
- Views are like shortcuts to tables, allowing you to see data in a specific way without actually changing the underlying data.
- Triggers are like automated tasks that run when something happens in a table (like adding or changing data).

Now, to answer the question:
In the database directory, views and triggers are stored within the same file as the table definition.
This means there is only one file associated with each view and trigger object.

So the correct answer is Option B: 1.

This Question Belongs to MySQL >> MySQL Miscellaneous

Join The Discussion

Related Questions on MySQL Miscellaneous