Introduction to Database System Which command(s) is(are) used to redefine a column of the table in SQL ? DEFINE TABLE all of the listed here MODIFY TABLE ALTER TABLE DEFINE TABLE all of the listed here MODIFY TABLE ALTER TABLE ANSWER DOWNLOAD EXAMIANS APP
Introduction to Database System Which of the following is not the responsibility of the utilities component of DBMS software? removing flagged records for deletion creating and maintaining the data dictionary None of these creating the physical and logical designs monitoring performance removing flagged records for deletion creating and maintaining the data dictionary None of these creating the physical and logical designs monitoring performance ANSWER DOWNLOAD EXAMIANS APP
Introduction to Database System To have a file hold a list, it is necessary to identify the name, width and type of the fields of each record. identify the records in the list All of the listed here decide which fields will be used as sort or index keys identify the name, width and type of the fields of each record. identify the records in the list All of the listed here decide which fields will be used as sort or index keys ANSWER DOWNLOAD EXAMIANS APP
Introduction to Database System An identifier typically uses more than one attribute. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to Database System Which language has recently become the de-facto standard for interfacing application programs with relational database system? SQL dBASE 4GL Oracle None of these SQL dBASE 4GL Oracle None of these ANSWER DOWNLOAD EXAMIANS APP
Introduction to Database System Which command is used to select distinct subject (SUB) from the table (BOOK)? None of these SELECT SUB FROM BOOK SELECT DISTINCT SUB FROM BOOK SELECT ALL FROM BOOK All of these None of these SELECT SUB FROM BOOK SELECT DISTINCT SUB FROM BOOK SELECT ALL FROM BOOK All of these ANSWER DOWNLOAD EXAMIANS APP