Database Management System Question
Database Management System Question With Answer & Solution
Que. - 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
Que. - A relation project guidance Project Guidance(professor, project, student no. st-name, dept) A professor can give many projects to many students A project will have many students A project may be guided by many professors The 4 NF relation corresponding to this are
Que. - A 3 NF relation is split into 4 NF
Que. - Using the SQL GROUP BY phrase with a SELECT statement can help detect which of the following problems?
Que. - What SQL command will allow you to change the table STUDENT to add the constraint named GradeCheck that states that the values of the Grade column must be greater than 0?
Que. - The NOT EXISTS keyword will be true if:
Que. - Changing cardinalities in a database is:
Que. - Which one of the following sorts rows in SQL?
Que. - The SQL keyword(s) ________ is used with wildcards.
Que. - If a relationship has a cascade updates constraint, then if ________ in the parent table is changed, then the same change will automatically be made to any corresponding foreign key value.
Showing
1261
To
1270 of 1293 results