Introduction to Database System Which of the following is not an advantage of the data-base approach? program/data independence ability to associate related data increased security All of these elimination of the data redundancy program/data independence ability to associate related data increased security All of these elimination of the data redundancy ANSWER DOWNLOAD EXAMIANS APP
Introduction to Database System Periodically adding, changing and deleting file records is called file restructuring renewing Updating upgrading restructuring renewing Updating upgrading ANSWER DOWNLOAD EXAMIANS APP
Introduction to Database System Which command(s) is(are) used to redefine a column of the table in SQL ? all of the listed here MODIFY TABLE DEFINE TABLE ALTER TABLE all of the listed here MODIFY TABLE DEFINE TABLE ALTER TABLE ANSWER DOWNLOAD EXAMIANS APP
Introduction to Database System The _____ command is used to allocates an extent for the table in SQL MODIFY ALLOCATES ALTER TABLE MODIFY TABLE None of these REDEFINE TABLE MODIFY ALLOCATES ALTER TABLE MODIFY TABLE None of these REDEFINE TABLE 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 In SQL, the CREATE TABLESPACE is used None of these All of these to create a place in the database for storage of scheme objects, rollback segments, and naming the data files to comprise the tablespace to create a database trigger to add/rename data files, to change storage None of these All of these to create a place in the database for storage of scheme objects, rollback segments, and naming the data files to comprise the tablespace to create a database trigger to add/rename data files, to change storage ANSWER DOWNLOAD EXAMIANS APP