Introduction to Database System A set of programs that handle a firm's data base responsibilities is called a Data Base Processing System (DBPS) Data Base Management System (DBMS) None of these All of these Data Management System (DMS) Data Base Processing System (DBPS) Data Base Management System (DBMS) None of these All of these Data Management System (DMS) 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 A report user data indexes metadata A report user data indexes ANSWER DOWNLOAD EXAMIANS APP
Introduction to Database System All instances of an entity class have the same attributes. False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to Database System In SQL, which command is used to add a column/integrity constraint to a table MODIFY TABLE ADD COLUMN ALTER TABLE INSERT COLUMN MODIFY TABLE ADD COLUMN ALTER TABLE INSERT COLUMN ANSWER DOWNLOAD EXAMIANS APP
Introduction to Database System Which of the following is a serious problem of file management systems? data redundancy difficult to update program dependence lack of data independence All of these data redundancy difficult to update program dependence lack of data independence All of these ANSWER DOWNLOAD EXAMIANS APP
Introduction to Database System The activity of a file is a measure of the percentage of existing records updated during a run refers to how closely the files fits into the allocated is a low percentages of number of records added or deleted from a file None of these if high, reduces processing efficiency for sequential and nonsequential files is a measure of the percentage of existing records updated during a run refers to how closely the files fits into the allocated is a low percentages of number of records added or deleted from a file None of these if high, reduces processing efficiency for sequential and nonsequential files ANSWER DOWNLOAD EXAMIANS APP