Introduction to Database System The physical location of a record is determined by a mathematical formula that transforms a file key into a record location in a hashed file a sequential file a tree file None of these an indexed file a hashed file a sequential file a tree file None of these an indexed file ANSWER DOWNLOAD EXAMIANS APP
Introduction to Database System Which of the following command(s) is(are) used to recompile a stored procedure in SQL? ALTER PROCEDURE COMPILE PROCEDURE None of the listed here MODIFY PROCEDURE ALTER PROCEDURE COMPILE PROCEDURE None of the listed here MODIFY PROCEDURE ANSWER DOWNLOAD EXAMIANS APP
Introduction to Database System The _____ command is used to allocates an extent for the table in SQL MODIFY TABLE None of these ALTER TABLE MODIFY ALLOCATES REDEFINE TABLE MODIFY TABLE None of these ALTER TABLE MODIFY ALLOCATES REDEFINE TABLE ANSWER DOWNLOAD EXAMIANS APP
Introduction to Database System In SQL, the _____ command is used to recompile a view ALTER VIEW COMPILE VIEW DEFINE VIEW None of these CREATE VIEW ALTER VIEW COMPILE VIEW DEFINE VIEW None of these CREATE VIEW ANSWER DOWNLOAD EXAMIANS APP
Introduction to Database System A DBMS that combines a DBMS and an application generator is ________ . Microsoft's SQL Server Microsoft's Access Oracle Corporation's Oracle IBM's DB2 Microsoft's SQL Server Microsoft's Access Oracle Corporation's Oracle IBM's DB2 ANSWER DOWNLOAD EXAMIANS APP
Introduction to Database System Structured Query Language (SQL) is an internationally recognized standard language that is understood by all commercial database management system products. False True False True ANSWER DOWNLOAD EXAMIANS APP