Computer Objective Question 18

1) The process of reading a database schema and producing a data model from that schema is known as

1. Data modeling
2. Database design
3. reverse engineering
4. inverse engineering

2) The data model that is produced from reverse enginerring is

1. A conceptual model
2. an internal model
3. a logical model
4. note of the above is correct

3) A tool that can help designers understand the dependencies of database structures is a

1. dependency graph
2. data model
3. graphical display
4. hirechical model

4) How many copies of the redesign process ?

1. One
2. Two
3. Three
4. Four

5) Which SQL-92 standard SQL command can be used to change a table name ?

1. RENAME TABLE
2. CHANGE TABLE
3. ALTER TABLE
4. None of the above is correct

6) What SQL command can be used to add columns to a table ?

1. MODIFY TABLE table name ADD COLUMN column name
2. MODIGY TABLE table name ADD column name
3. ALTER TABLE table name ADD COLUMN COLUMNName
4. None of the Above is correct

7) What SQL command can be used to delete columns from a table ?

1. MODIGY TABLE Tablename DRO column columnName
2. MODIFY Table tablename DROP ColumeName
3. ALTER TABLE Tablename COLUMN ColumnName
4. ALTER TABLE TableName DROP ColumnName

8) To drop a column that is used as a foreign key, first

1. Drop the primary key
2. Drop the table Containing the foreign key
3. Drop the foreign key constraint
4. All of the above must be done

9) Which of the following modifications may not succeed ?

1. Changing a column data type from char to date
2. Changing a column data type from numerical to char
3. Both of the above actions should succeed
4. Neither of the above action will succeed
5. Neither of the above action will succeed

10) What SQL command will allow you to change the table STUDENT to add the constraint named Grade check that states that the values of the Grade column must be grater than 0 ?

1. ALTER TABLE STUDENT ALTER CONSTAINT Grade check (Grade > 0 );
2. ALTER TABLE GradeCheck (Grade> 0);
3. ALTER TABLE STUDENT ADD CONSTRAINT GradeChecj (grade > 0);
4. ALTER TABLE STUDENT ADD CONSTRANINT GradeCheck (Grade < 0);

11) changing cardinalities in a database is

1. a common database design task
2. a rare database design task, but does occur
3. a database design task that never occurs
4. is impossible to do, so a new database must be constructed and the data moved into it

12) Because of the importance of making data model changes correctly , many professionals are ------about using an automated process for database redesign

1. optimistic
2. skeptical
3. ambivalent
4. eptimistic