Introduction to Database System In SQL, the _____ command is used to recompile a view COMPILE VIEW DEFINE VIEW CREATE VIEW ALTER VIEW None of these COMPILE VIEW DEFINE VIEW CREATE VIEW ALTER VIEW None of these ANSWER DOWNLOAD EXAMIANS APP
Introduction to Database System SQL stands for ________ . Structured Query Language Sequential Query Language Structured Question Language Sequential Question Language Structured Query Language Sequential Query Language Structured Question Language Sequential Question Language ANSWER DOWNLOAD EXAMIANS APP
Introduction to Database System If you want to group the records in the abc database, you could use the Jobcode as the _____. Update Delete Sort Key Index Update Delete Sort Key Index ANSWER DOWNLOAD EXAMIANS APP
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 sequential file a tree file a hashed file None of these an indexed file a sequential file a tree file a hashed file None of these an indexed file ANSWER DOWNLOAD EXAMIANS APP
Introduction to Database System When the values in one or more attributes being used as a foreign key must exist in another set of one or more attributes in another table, we have created a(n): insertion anomaly. transitive dependency. referential integrity constraint. normal form. insertion anomaly. transitive dependency. referential integrity constraint. normal form. ANSWER DOWNLOAD EXAMIANS APP
Introduction to Database System Which of the following is not true of the traditional approach to information processing? It is inflexible All of these It is file-oriented There is common sharing of data among the various applications Programs are dependent on the files It is inflexible All of these It is file-oriented There is common sharing of data among the various applications Programs are dependent on the files ANSWER DOWNLOAD EXAMIANS APP