Introduction to Database System One solution to the multivalued dependency constraint problem is to: change the theme. split the relation into two relations, each with a single theme. create a new theme. add a composite key. change the theme. split the relation into two relations, each with a single theme. create a new theme. add a composite key. ANSWER DOWNLOAD EXAMIANS APP
Introduction to Database System What is the language used by most of the DBMSs for helping their users to access data? 4GL Query language High level language SQL 4GL Query language High level language SQL ANSWER DOWNLOAD EXAMIANS APP
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 creating and maintaining the data dictionary removing flagged records for deletion None of these monitoring performance creating the physical and logical designs creating and maintaining the data dictionary removing flagged records for deletion None of these ANSWER DOWNLOAD EXAMIANS APP
Introduction to Database System A key: identifies a row. can only be one column. identifies a column. must always be composed of two or more columns. identifies a row. can only be one column. identifies a column. must always be composed of two or more columns. ANSWER DOWNLOAD EXAMIANS APP
Introduction to Database System Which of the following command(s) is(are) used to recompile a stored procedure in SQL? ALTER PROCEDURE MODIFY PROCEDURE None of the listed here COMPILE PROCEDURE ALTER PROCEDURE MODIFY PROCEDURE None of the listed here COMPILE PROCEDURE ANSWER DOWNLOAD EXAMIANS APP
Introduction to Database System If you want to group the records in the abc database, you could use the Jobcode as the _____. Update Delete Sort Key Index Update Delete Sort Key Index ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS