". VdoTips: COMPUTER FUNDAMENTAL PRACTICE SET 15

APPLY LATEST GOVT JOBS

hi

COMPUTER FUNDAMENTAL PRACTICE SET 15

156. What SQL command can be used to delete columns from a table ?
(A) MODIFY TABLE Table Name DROP COLUMN Column Name
(B) MODIFY TABLE Table Name DROP Column Name Column Name
(D) ALTER TABLE Table Name DROP Column Name


157. Which of the following modifications may not succeed?
(A) Changing a column data type from char to date
(B) Changing a column data type from numeric to char
(C) Both of the above actions should succeed
(D) Neither of the above actions will succeed


158. Changing cardinalities in a database is
(A) A common database design task
(B) A rare database design task, but does occur
(C) A database design task that never occurs
(D) Is impossible to do, so a new database must be constructed and the data moved into it


159. A regular sub query can be processed
(A) From the top down
(B) From the bottom up
(C) By nesting
(D) From the right up


160. How many copies of the database schema are typically used in the redesign process ?
(A) One
(B) Two
(C) Three
(D) Four