Introduction to Database System In SQL, which of the following is not a data Manipulation Language Commands? UPDATE CREATE DELETE SELECT UPDATE CREATE DELETE SELECT ANSWER DOWNLOAD EXAMIANS APP
Introduction to Database System When the values in one or more attributes being used as a foreign key must exist in another set of one or more attributes in another table, we have created a(n): normal form. insertion anomaly. transitive dependency. referential integrity constraint. normal form. insertion anomaly. transitive dependency. referential integrity constraint. ANSWER DOWNLOAD EXAMIANS APP
Introduction to Database System A relation is in Boyce-Codd Normal Form (BCNF) if every determinant is a composite key. False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to Database System In SQL, the _____ command is used to recompile a view ALTER VIEW None of these COMPILE VIEW DEFINE VIEW CREATE VIEW ALTER VIEW None of these COMPILE VIEW DEFINE VIEW CREATE VIEW ANSWER DOWNLOAD EXAMIANS APP
Introduction to Database System A multiple-form file management system allow you to entry data in all the forms None of these both (a) and (b) lets you define different forms for different operations lets you create a look-up form with an associated read-only password to prevent access by unauthorized users allow you to entry data in all the forms None of these both (a) and (b) lets you define different forms for different operations lets you create a look-up form with an associated read-only password to prevent access by unauthorized users ANSWER DOWNLOAD EXAMIANS APP
Introduction to Database System In SQL, which command is used to remove a stored function from the database? DROP FUNCTION REMOVE FUNCTION ERASE FUNCTION None of these DELETE FUNCTION DROP FUNCTION REMOVE FUNCTION ERASE FUNCTION None of these DELETE FUNCTION ANSWER DOWNLOAD EXAMIANS APP