Introduction to Database System In SQL, which command is used to remove a stored function from the database? ERASE FUNCTION DROP FUNCTION DELETE FUNCTION None of these REMOVE FUNCTION ERASE FUNCTION DROP FUNCTION DELETE FUNCTION None of these REMOVE FUNCTION ANSWER DOWNLOAD EXAMIANS APP
Introduction to Database System You have run an SQL statement that asked the DBMS to display data in a table named USER_TABLES. The results include columns of data labeled "TableName," "NumberOfColumns" and "PrimaryKey." You are looking at ________ . metadata A report indexes user data metadata A report indexes user data ANSWER DOWNLOAD EXAMIANS APP
Introduction to Database System An on-line commercial site such as Amazon.com is an example of a(n) ________ . single-user database application e-commerce database application data mining database application multiuser database application single-user database application e-commerce database application data mining database application multiuser database application ANSWER DOWNLOAD EXAMIANS APP
Introduction to Database System In SQL, the CREATE TABLE is used to create a table, defining its columns, integrity constrains, and storage allocation to add a column/integrity constraint to a table to redefine a column to change a table's storage characteristics All of these to create a table, defining its columns, integrity constrains, and storage allocation to add a column/integrity constraint to a table to redefine a column to change a table's storage characteristics All of these ANSWER DOWNLOAD EXAMIANS APP
Introduction to Database System For some relations, changing the data can have undesirable consequences called: transitive dependencies. modification anomalies. normal forms. referential integrity constraints. transitive dependencies. modification anomalies. normal forms. referential integrity constraints. ANSWER DOWNLOAD EXAMIANS APP
Introduction to Database System Entities use identifiers while tables use keys. True False True False ANSWER DOWNLOAD EXAMIANS APP