Introduction to Database System The primary key is selected from the: foreign keys. determinants. candidate keys. composite keys. foreign keys. determinants. candidate keys. composite keys. ANSWER DOWNLOAD EXAMIANS APP
Introduction to Database System A _____ means that one record in a particular record type can be related to many records in another record type and vice-versa. Many-to-many relationship One-to-many relationship Many-to-one relationship One-to-one relationship None of these Many-to-many relationship One-to-many relationship Many-to-one relationship One-to-one relationship None of these ANSWER DOWNLOAD EXAMIANS APP
Introduction to Database System Which of the following products implemented the CODASYL DBTG model? dBase-II DB2 R:base IDMS dBase-II DB2 R:base IDMS ANSWER DOWNLOAD EXAMIANS APP
Introduction to Database System Which of the following command(s) is(are) used to recompile a stored procedure in SQL? COMPILE PROCEDURE None of the listed here MODIFY PROCEDURE ALTER PROCEDURE COMPILE PROCEDURE None of the listed here MODIFY PROCEDURE ALTER PROCEDURE ANSWER DOWNLOAD EXAMIANS APP
Introduction to Database System An-owner-member set in the CODASYL specifications may have only one owner but many owner occurrences more than one member but only one occurrence per member All of the listed here only one member but many member occurrence only one owner but many owner occurrences more than one member but only one occurrence per member All of the listed here only one member but many member occurrence ANSWER DOWNLOAD EXAMIANS APP
Introduction to Database System In SQL, the CREATE TABLE is used 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 to create a table, defining its columns, integrity constrains, and storage allocation to add a column/integrity constraint to a table ANSWER DOWNLOAD EXAMIANS APP