Introduction to Database System Which of the following command(s) is(are) used to recompile a stored procedure in SQL? COMPILE PROCEDURE ALTER PROCEDURE MODIFY PROCEDURE None of the listed here COMPILE PROCEDURE ALTER PROCEDURE MODIFY PROCEDURE None of the listed here ANSWER DOWNLOAD EXAMIANS APP
Introduction to Database System An ID-dependent entity is an entity whose identifier is a composite identifier where no portion of the composite identifier is an identifier of another entity. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to Database System A candidate key is a determinant that determines all the other columns is a relation. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to Database System In SQL, the CREATE TABLESPACE is used to add/rename data files, to change storage None of these to create a place in the database for storage of scheme objects, rollback segments, and naming the data files to comprise the tablespace to create a database trigger All of these to add/rename data files, to change storage None of these to create a place in the database for storage of scheme objects, rollback segments, and naming the data files to comprise the tablespace to create a database trigger All of these ANSWER DOWNLOAD EXAMIANS APP
Introduction to Database System What is the language used by most of the DBMSs for helping their users to access data? High level language 4GL Query language SQL High level language 4GL Query language SQL ANSWER DOWNLOAD EXAMIANS APP
Introduction to Database System A relation in this form is free of all modification anomalies. Third normal form First normal form Second normal form Domain/key normal form Third normal form First normal form Second normal form Domain/key normal form ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS