". VdoTips: COMPUTER FUNDAMENTAL PRACTICE SET 30

COMPUTER FUNDAMENTAL PRACTICE SET 30

236. The EXISTS keyword will be true if
(A) Any row in the sub query meets the condition only
(B) All rows in the sub query fail the condition only
(C) Both of these two conditions are met
(D) Neither of these two conditions is met
237. How can you find rows that do not match some specified condition ?
(A) EXISTS
(B) Double use of NOT EXISTS
(C) NOT EXISTS
(D) ROWS EXIT
238. The process of reading a database schema and producing a data model from that schema is known as
(A) Data modeling
(B) Database design
(C) Reverse engineering
(D) Inverse engineering
239. A tool that can help designers understand the dependencies of database structures is a
(A) Dependency graph
(B) Data model
(C) Graphical display
(D) Hierarchical model
240. Which SQL-92 standard SQL command can be used to change a table name ?
(A) RENAME TABLE
(B) CHANGE TABLE
(C) ALTER TABLE
(D) None of the above is correct