Introduction to Database System Which of the following command(s) is(are) used to recompile a stored procedure in SQL? MODIFY PROCEDURE None of the listed here COMPILE PROCEDURE ALTER PROCEDURE MODIFY PROCEDURE None of the listed here COMPILE PROCEDURE ALTER PROCEDURE ANSWER DOWNLOAD EXAMIANS APP
Introduction to Database System Which command(s) is(are) used to enable/disable/drop an integrity constraint in SQL? ALTER TABLE MODIFY TABLE All of the listed here DEFINE TABLE ALTER TABLE MODIFY TABLE All of the listed here DEFINE TABLE ANSWER DOWNLOAD EXAMIANS APP
Introduction to Database System A data dictionary is a special file that contains the data types of all fields in all files All of these the widths of all fields in all files the names of all fields in all files None of these the data types of all fields in all files All of these the widths of all fields in all files the names of all fields in all files None of these ANSWER DOWNLOAD EXAMIANS APP
Introduction to Database System What name is given to the collection of facts, items of information or data which are related in some way? Information tree Directory information Database Information provider Information tree Directory information Database Information provider ANSWER DOWNLOAD EXAMIANS APP
Introduction to Database System The master list of an indexed file None of these contains only a list of keys and record numbers is sorted in ascending order has a number assigned to each record both (b) and (c) None of these contains only a list of keys and record numbers is sorted in ascending order has a number assigned to each record both (b) and (c) ANSWER DOWNLOAD EXAMIANS APP
Introduction to Database System In an enterprise-class database system, business users interact directly with database applications, which directly access the database data. True False True False ANSWER DOWNLOAD EXAMIANS APP