Introduction to Database System Which of the following is not the responsibility of the utilities component of DBMS software? monitoring performance creating the physical and logical designs None of these removing flagged records for deletion creating and maintaining the data dictionary monitoring performance creating the physical and logical designs None of these removing flagged records for deletion creating and maintaining the data dictionary 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 an indexed file None of these a hashed file a sequential file a tree file an indexed file None of these a hashed file a sequential file a tree file ANSWER DOWNLOAD EXAMIANS APP
Introduction to Database System Which command is used to remove a table from the database in SQL? DROP TABLE DELETE TABLE UNATTACH TABLE ERASE TABLE DROP TABLE DELETE TABLE UNATTACH TABLE ERASE TABLE ANSWER DOWNLOAD EXAMIANS APP
Introduction to Database System The different classes of relations created by the technique for preventing modification anomalies are called: referential integrity constraints. functional dependencies. None of these normal forms. referential integrity constraints. functional dependencies. None of these normal forms. ANSWER DOWNLOAD EXAMIANS APP
Introduction to Database System In SQL, which command(s) is(are) used to create a synonym for a schema object? CREATE SCHEMA CREATE SYNONYM All of the listed here CREATE SAME CREATE SCHEMA CREATE SYNONYM All of the listed here CREATE SAME ANSWER DOWNLOAD EXAMIANS APP
Introduction to Database System The Management Information system (MIS) structure with one main computer system is called a decentralized MIS structure hierarchical MIS structure centralized MIS structure distributed MIS structure decentralized MIS structure hierarchical MIS structure centralized MIS structure distributed MIS structure ANSWER DOWNLOAD EXAMIANS APP