view is a virtual table you can dynamically generate using a previously saved query
Anonymous Quiz
93%
T
7%
F
WITH LOCAL CHECK OPTION, which rejects any insert or update that does not fulfill the conditions of the WHERE clause
Anonymous Quiz
83%
T
17%
F
database trigger is a stored procedure that is automatically called whenever a specific event happens in the database.
Anonymous Quiz
95%
T
5%
F
What is the purpose of a trigger in a database?
Anonymous Quiz
7%
To store and organize data
88%
To execute a set of actions automatically in response to a specific event
5%
To provide a graphical representation of data
Which join type returns all rows from the left table and the matching rows from the right table, and fills in NULL values for non-matching rows on the right table?
Anonymous Quiz
32%
Inner join
46%
Left join
22%
Right join
Which join type returns all rows from the left table and the right table, regardless of whether they have matching values?
Anonymous Quiz
14%
Inner join
8%
Left join
6%
Right join
73%
Full outer join
Which of the following scenarios is an appropriate use case for a trigger in a database?
Anonymous Quiz
22%
Performing complex mathematical calculations on a column
50%
Logging all changes made to a specific table.
18%
Generating random values for a column.
10%
Encrypting sensitive data in a column.
What is a foreign key in a database?
Anonymous Quiz
9%
A key that uniquely identifies each row in a table.
87%
A key that establishes a link between two tables based on a related column.
4%
A key that is automatically generated by the database system.
Which of the following modifications can be performed using the ALTER TABLE statement?
Anonymous Quiz
9%
Deleting a row from a table
65%
Adding a new column to a table
27%
Updating the data in a table.
In the ALTER TABLE statement, what keyword is used to add a new column to an existing table?
Anonymous Quiz
82%
ADD COLUMN
7%
MODIFY COLUMN
2%
DELETE COLUMN
10%
UPDATE COLUMN
Relational algebra in DBMS is a procedural query language, which describes the procedure to obtain the result.
Anonymous Quiz
94%
T
6%
F
What is the purpose of the SELECT operation in relational algebra?
Anonymous Quiz
15%
To combine two relations based on a common attribute
7%
To perform set union between two relations
77%
To filter and keep only the tuples that satisfy a qualifying condition