How can the values in the relation teaches be deleted?

Related MCQs

• In the above teaches relation ” Select * from teaches where Year = ‘2010’” displays how many rows?
• Given the relation Supplier(s_id, p_order, s_name, qty) Given that there is a unique s_name for each s_id and that s_id, p_order is a composite key, find the correct statement among the following: i. this relation is a BCNF ii. this is 3 NF relation iii. this is a 2 NF relation iv. this is a 1 NF relation
• Instead of locking index leaf nodes in a two-phase manner, some index concurrency- control schemes use                        on individual key values, allowing other key values to be inserted or deleted from the same leaf.
• Which one of the following can be treated as a primary key in teaches relation?
• Which of the syntax is correct for insert statement? i) insert into <table_name> values <list of values> ii) insert into <table_name> (column list) values <list of values>
• An attribute in a relation is a foreign key if the                key from one relation is used as an attribute in that relation.
• The relation with the attribute which is the primary key is referenced in another relation. The relation which has the attribute as a primary key is called                              
• A                  on an attribute of a relation is a data structure that allows the database system to find those tuples in the relation that have a specified value for that attribute efficiently, without scanning through all the tuples of the relation.
• An attribute in a relation is a foreign key if the _______ key from one relation is used as an attribute in that relation.
• The relation with the attribute which is the primary key is referenced in another relation. The relation which has the attribute as a primary key is called ______________