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
Relational algebra expression the sequence of operations in a relation algebra.
Anonymous Quiz
95%
T
5%
F
What is the result of the SELECT operation in relational algebra?
Anonymous Quiz
5%
A vertical partition of the relation into two sets of attributes.
10%
A combination of tuples from two relations.
85%
A subset of tuples that satisfy a qualifying condition.
degree of the relation resulting from a SELECT operation its number of attributes is the less than the degree of R
Anonymous Quiz
38%
T
62%
F
number of tuples in the resulting relation is always less than or equal to the number of tuples in R.
Anonymous Quiz
94%
T
6%
f