Advanced SQL
1. The language used in application programs to request data from the DBMS is referred to as the
A.  DML B.  DDL C.  VDL D.  SDL
2. The statement in SQL which allows to change the definition of a table is
A.  Alter B.  Update C.  Create D.  select
3. Which of the following is an advantage of view?
A.  Data security B.  Derived columns C.  Hiding of complex queries D.  All of the above
4. Which of the following database object does not physically exist?
A.  base table B.  index C.  view D.  none of the above
5. . Which one of the following is not true for a view:
A.  View is derived from other tables. B.  View is a virtual table. C.  A view definition is permanently stored as part of the database. D.  View never contains derived columns.
6. A primary key if combined with a foreign key creates
A.  Parent-Child relationship between the tables that connect them. B.  Many to many relationship between the tables that connect them. C.  Network model between the tables that connect them. D.  None of the above.
7. _________ is a virtual table that draws its data from the result of an SQL SELECT statement.
A.  View B.  Synonym C.  Sequence D.  TrAnsaction
8. Which one of the following is not true for a view:
A.  View is derived from other tables. B.  View is a virtual table. C.  A view definition is permanently stored as part of the database. D.  View never contains derived columns.
9. A _____ indicates an absent value that may exist but be unknown or that may not exist at all.
A.   Empty tuple B.   New value C.   Null value D.   Old value
10. If the attribute phone number is included in the relation all the values need not be entered into the phone number column. This type of entry is given as
A.   0 B.   � C.   Null D.   Empty space