Ist 210 Review Final Exam Questions And Answers

Ist 210 Review Final Exam Questions And Answers /. Database Management System - Answer-Which of the following is used to create and maintain the physical database? /.System analysis - Answer-***In which step of the Systems Development Life Cycle (SDLC) is the solution to the identified problem determined and understood? /.Composite primary key - Answer-***Which of the following can lead to partial dependence? /.FROM - Answer-***To indicate which database table contains the data to be selected by a query, the table name should be listed in the ___ clause. /.15 - Answer-***What is the correct solution for the arithmetic expression (2+8)/2*9/3 using the order of operations. /.SELECT title, retail+retail FROM books; - Answer-Based upon the contents of the BOOKS table, which of the following SQL statements will display the retail price for two copies of each book currently in inventory? /.Data definition language (DDL) - Answer-***Which of the following terms refers to commands that are used to create or modify database tables? /.ALTER TABLE... SET UNUSED - Answer-***Which of the following keywords is used to mark a column for deletion at a later time? /.After the MAXRETAIL column - Answer-**If a new column is added to the PROMOTION table, where will the new column be listed? /.When you create constraints at the column level, the constraint being created applies to the column specified - Answer-***Which of the following statements about creating constraints is incorrect? /.UNIQUE - Answer-The purpose of ___ constraint is to ensure that two records do not have the same value stored in the same column. However, it can contain NULL values. /.NOT NULL - Answer-The __ constraint prevents the user from adding a NULL value in the specified column.