Database MCQ: Database

ofthe producer of a given movie as follows:
CREATE MATERIALIZED VIEW MovieProd AS
SELECT title, year, name
FROM Movies. MovieExec
WHERE producer# - cert#
Which of the following modification will affect the MovieProd materialized view?

[A]
Insert a new tuple into Studio
[B]
Delete a tuple from Studio
[C]
Insert a new tuple into Movies or delete a tuple from Movies
[D]
None of the others

Answer: C

Select the right statement

[A]
All of the others
[B]
Every constraint has a name. If we don't define constraint's name explicitly, then DBMS automatically generates a name for it
[C]
We can create constraint on a tuple as a whole.
[D]
We can create constraint on a single attribute

Answer: A

Choose an incorrect statement

[A]
None of the others
[B]
Database is created and maintained by a DMBS
IC]
Database is a collection of information that exists over a long opened of time
[D]
Database is a collection of data that is managed by a DBMS

Answer: A

When declaring foreign key constraint for relation A thai references relation B. the referenced attribute(s) of the relation B must be declare as_______

[A]
UNIQUE or PRIMARY KEY
[B]
FOREIGN KEY
[C]
INDEX KEY
[D]
All of the others

Answer: A

Choose the right statement to grant the INSERT and SELECT privileges on table Movies to users torn' and jerry'

[A]
GRANT SELECT. INSERT on Movies
[B]
GRANT SELECT. INSERT on Movies TO torn, jerry CASCADE
[C]
GRANT SELECT. INSERT on Movies TO torn, jerry WITH GRANT OPTION
[D]
GRANT SELECT. INSERT on Movies TO ALL

Answer: C

Four characteristics of transactions are

[A]
None of the others
[B]
Read uncommitted, Read committed, Repeatable read, Serializable
[C]
Atomicity. Isolation. Concurrency. Durability
[D]
Atomicity. Isolation. Consistency. Durability

Answer: D

Choose the right statement

[A]
The action associated with the trigger executes no matter what the condition is hold or not
[B]
Triggering events do not support INSERT and DELETE.
[C]
All of the others.
[D]
When the trigger is awakened, it tests a condition. If the condition is satisfied, the action associated with the trigger is executed.

Answer: D

Choose right answer(s).

[A]
NULL value is unknown, inapplicable, or withheld
[B]
Comparisons with NULL values will return UNKNOWN
[C]
Arithmetic operators on NULL values will return a NULL value
[D]
All of other

Answer: D

A relation is a set of tuples.

A relation is a list of tuples.

XML files are semi-structured data.

How many data models mentioned in our database course?

What is the oldest data model?

When the Relational Data Model first proposed?

In relational data model, a tuple is a record or a row

Look at the following data for table R:

Look at this line:MOVIES (Id, Name, Description)What the above represent?

DBMS stands for what?

A data model is a notation for describing data or information. And the description generally consist of:

In relational data model, an attribute is a column.

Given relations Movies(title, year, length, genre. studioName. producer#). MovieExec(name. address. cert#). and Studio(name. address. presC#). Suppose we have the materialized view that finds the name -