Introduction to Database System Table is synonymous with the term: record. field. column. relation. record. field. column. relation. 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 ________ . A report indexes metadata user data A report indexes metadata user data ANSWER DOWNLOAD EXAMIANS APP
Introduction to Database System In SQL, the _____ command is used to recompile a view ALTER VIEW COMPILE VIEW CREATE VIEW None of these DEFINE VIEW ALTER VIEW COMPILE VIEW CREATE VIEW None of these DEFINE VIEW ANSWER DOWNLOAD EXAMIANS APP
Introduction to Database System Which of the following indicates the minimum number of entities that must be involved in a relationship? Greater Entity Count (GEC) Minimum cardinality ERD Maximum cardinality Greater Entity Count (GEC) Minimum cardinality ERD Maximum cardinality ANSWER DOWNLOAD EXAMIANS APP
Introduction to Database System If attribute A determines both attributes B and C, then it is also true that: C → (B,C) → A → B → C → (B,C) → A → B → ANSWER DOWNLOAD EXAMIANS APP
Introduction to Database System A large computer information system maintains many different computer files. Which amongst them is called a perpetual file? Update file Master file Log file Specialized file Update file Master file Log file Specialized file ANSWER DOWNLOAD EXAMIANS APP