The statement that is executed automatically by the system as a side effect of the modification of the database is
Answer: D
Correct answer: trigger
A trigger is a piece of code the DBMS runs automatically when a specified modification occurs, which is exactly the description given. An assertion is a condition that must hold but does not itself act.
Please log in or register to report this question.
The normal form that is not necessarily dependency preserving is
Answer: A
Correct answer: BCNF
A relation can always be decomposed into third normal form while preserving all its functional dependencies, but a BCNF decomposition sometimes cannot: enforcing one of the original dependencies may require a join. That is the price of BCNF's stronger guarantee, and it is why 3NF is often preferred in practice.
Please log in or register to report this question.
_____is a full form of SQL.
Answer: C
Correct answer: Structured query language
SQL stands for Structured Query Language. It is more than a query language, since it also defines and controls data, but the name records its origin.
Please log in or register to report this question.
The relational model is based on the concept that data is organized and stored in two-dimensional tables called ______
Answer: C
Correct answer: Relations
The relational model stores data in two-dimensional tables called relations, whose rows are tuples and columns attributes. The name comes from the mathematical relation, a set of tuples over given domains.
Please log in or register to report this question.
A _____ is used to define overall design of the database
Answer: D
Correct answer: schema
A schema is the definition of the whole database structure - its tables, their columns and the constraints between them. A data definition language is what the schema is written in, which is not the same as the schema itself.
Please log in or register to report this question.
Which of the following ensures the atomicity of the transaction?
Answer: A
Correct answer: Transaction management component of DBMS
Atomicity - all of a transaction's effects or none - is enforced by the transaction manager, which decides when to commit and calls for undo when a transaction aborts. Concurrency control provides isolation, a different one of the ACID properties.
Please log in or register to report this question.
The default level of consistency in SQL is
Answer: D
Correct answer: serializable
The SQL standard's default isolation level is serializable, the strictest, in which concurrent execution must be equivalent to running the transactions one after another. Individual products often default to something weaker for performance, but the standard's default is this.
Please log in or register to report this question.
If a transaction T has obtained an exclusive lock on item Q, then T can
Answer: C
Correct answer: both read and write Q
An exclusive lock gives the holder complete access - it may both read and write the item - and excludes every other transaction. A shared lock permits reading only, but allows other readers at the same time.
Please log in or register to report this question.
Which one is the correct statement? Logical data independence provides the following without changing application programs: (i) Changes in access methods. (ii) Adding new entities in the database. (iii) Splitting an existing record into two or more records. (iv) Changing the storage structure of the database.
Answer: D
Correct answer: (ii) and (iii)
Logical data independence protects programs from changes to the logical structure: adding an entity or splitting a record leaves existing programs working, because they still see the fields they asked for. Changing access methods or the storage structure is a change at the physical level, and immunity to those is physical data independence.
Please log in or register to report this question.
The full form of GUI is _________
Answer: C
Correct answer: Graphical User Interface
GUI stands for Graphical User Interface - an interface of windows, icons and pointers, as against a command line.
Please log in or register to report this question.
