Introduction to Database System Which command is used to remove an index from the database in SQL? DELETE INDEX REMOVE INDEX DROP INDEX ROLL BACK INDEX DELETE INDEX REMOVE INDEX DROP INDEX ROLL BACK INDEX ANSWER DOWNLOAD EXAMIANS APP
Introduction to Database System In a relation, the order of the columns does not matter. True False True False 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 MODIFY PROCEDURE ALTER PROCEDURE None of the listed here COMPILE PROCEDURE MODIFY PROCEDURE ALTER PROCEDURE None of the listed here ANSWER DOWNLOAD EXAMIANS APP
Introduction to Database System In SQL, which command(s) is(are) used to enable/disable all triggers on a table? MODIFY TRIGGERS IN TABLE ALTER TRIGGERS All of the listed here ALTER TABLE MODIFY TRIGGERS IN TABLE ALTER TRIGGERS All of the listed here ALTER TABLE ANSWER DOWNLOAD EXAMIANS APP
Introduction to Database System What is the abbreviation used for a software package that permits the users to create, retrieve and maintain records in a database? EMMS DASD DBMS None of these FMS EMMS DASD DBMS None of these FMS ANSWER DOWNLOAD EXAMIANS APP
Introduction to Database System A compound key both (a) and (b) is made up a several pieces of information uniquely identifies an item in a list is a combination of each unique key None of these both (a) and (b) is made up a several pieces of information uniquely identifies an item in a list is a combination of each unique key None of these ANSWER DOWNLOAD EXAMIANS APP