MIS 421 Lecture Quizzes (All solved Accurately)

A program whose job is to create, process and administer databases is called a ________. correct answers Database Management System A database is considered "self-describing" because ________. correct answers It contains a description of its own structure (meta-data) Logical data model is an output from which of the following steps? correct answers Requirements analysis SQL Server Management Studio is a correct answers Database application Dynamic Systems Development Method advocates software deliverables from an increment to be placed into software foundations if they are reusable for other projects correct answers True The team project development method in this class is the closest to which of the following method? correct answers Dynamic Systems Development Method (DSDM) Identity field in SQL Server Management System is an alternative to which of the following term? correct answers Both auto-incremental field and surrogate key (field) You write SQL statement in which of the following windows in SQL Server Management Studio (SSMS) correct answers Query editor After you modify a table structure, which requires a table re-creation, such as change the primary key, when you try to save the change, you may encounter an error message stating "Saving changes is not permitted. The changes you have made require the following tables to be dropped and recreated....", in which of the following option window, you can uncheck "Prevent saving changes that require table re-creation"? Format of the answers, using Tools-Environment as an example, means that you click Tools in the menu bar, then click the Environment link to show the options you can set for the Environment. correct answers Tools-Designers In a SELECT statement, which clauses are minimal requirement for an executable SELECT statement correct answers Select Clause and From Clause Which key word is used to remove duplication values from a column in the result from a SQL SELECT statement? correct answers DISTINCT The following two statements in WHERE clause of an SQL SELECT statement define the same range of numbers, where Width is a column that has int (integer) data type in a table: Width BETWEEN 1 and 10 Width 1 and Width 10 correct answers False