Introduction to Database System The DBMS acts as an interface between what two components of an enterprise-class database system? The user and the database application Database application and SQL Data and the database Database application and the database The user and the database application Database application and SQL Data and the database Database application and the database ANSWER DOWNLOAD EXAMIANS APP
Introduction to Database System In SQL, which command is used to remove a stored function from the database? DELETE FUNCTION None of these REMOVE FUNCTION DROP FUNCTION ERASE FUNCTION DELETE FUNCTION None of these REMOVE FUNCTION DROP FUNCTION ERASE FUNCTION ANSWER DOWNLOAD EXAMIANS APP
Introduction to Database System In SQL, the CREATE TABLESPACE is used None of these to add/rename data files, to change storage All of these to create a database trigger to create a place in the database for storage of scheme objects, rollback segments, and naming the data files to comprise the tablespace None of these to add/rename data files, to change storage All of these to create a database trigger to create a place in the database for storage of scheme objects, rollback segments, and naming the data files to comprise the tablespace ANSWER DOWNLOAD EXAMIANS APP
Introduction to Database System Which of the following is not the responsibility of the utilities component of DBMS software? creating and maintaining the data dictionary None of these removing flagged records for deletion creating the physical and logical designs monitoring performance creating and maintaining the data dictionary None of these removing flagged records for deletion creating the physical and logical designs monitoring performance ANSWER DOWNLOAD EXAMIANS APP
Introduction to Database System The master list of an indexed file is sorted in ascending order None of these contains only a list of keys and record numbers both (b) and (c) has a number assigned to each record is sorted in ascending order None of these contains only a list of keys and record numbers both (b) and (c) has a number assigned to each record ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS