Introduction to Database System A primary key is a composite key that was selected to be the main identifier for the relation. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to Database System In SQL, the _____ command is used to recompile a view ALTER VIEW None of these CREATE VIEW DEFINE VIEW COMPILE VIEW ALTER VIEW None of these CREATE VIEW DEFINE VIEW COMPILE VIEW ANSWER DOWNLOAD EXAMIANS APP
Introduction to Database System The master list of an indexed file is sorted in ascending order contains only a list of keys and record numbers both (b) and (c) None of these has a number assigned to each record is sorted in ascending order contains only a list of keys and record numbers both (b) and (c) None of these has a number assigned to each record ANSWER DOWNLOAD EXAMIANS APP
Introduction to Database System A logical schema None of these is a standard way of organizing information into accessible parts is the entire database All of these describes how data is actually stored on disk None of these is a standard way of organizing information into accessible parts is the entire database All of these describes how data is actually stored on disk ANSWER DOWNLOAD EXAMIANS APP
Introduction to Database System You have run an SQL statement that asked the DBMS to display data in a table named USER_TABLES. The results include columns of data labeled "TableName," "NumberOfColumns" and "PrimaryKey." You are looking at ________ . metadata indexes user data A report metadata indexes user data A report ANSWER DOWNLOAD EXAMIANS APP
Introduction to Database System For some relations, changing the data can have undesirable consequences called: transitive dependencies. referential integrity constraints. normal forms. modification anomalies. transitive dependencies. referential integrity constraints. normal forms. modification anomalies. ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS