The Timer has started 10:00
-
1)
An entity type is
- A) defined when the database is actually constructed
- B) a specific type such as an integer, text, date, logical etc
- C) a coherent set of similar objects that we want to store data on (e.g. STUDENT, COURSE, CAR)
- D) defined by the database designer
-
2)
An entity can be logically connected to another by defining a ____.
- A) hyperlink
- B) common attribute
- C) primary key
- D) superkey
-
3)
You can’t modify more than one table at a time through a view.
- A) True
- B) False
-
4)
Which of the following is one of the purposes of using DML commands?
- A) Creating databases
- B) Destroying databases
- C) Inserting data in tables
- D) Non of the above
-
5)
Which of the following statements is true about the views?
- A) view is always a complete set of all the tables in a database
- B) View can not be used for retrieving data
- C) The results of using a view are not permanently stored in the database.
- D) Rows can not be updated or deleted in the view
-
6)
What is the alternate name of Data Dictionary?
- A) Index
- B) Metadata
- C) Data
- D) System Catalog
-
7)
IN function helps reduce the need to use multiple AND conditions.
- A) True
- B) False
-
8)
Which of the following are the general activities, which are performed during the development of application programs?
- A) Data input programs
- B) Editing
- C) Display
- D) All of given
-
9)
Which of the following is not true about De-normalization?
- A) It is the process of attempting to optimize the performance of a database
- B) De-normalization is a technique to move from lower to higher normal forms of database modeling
- C) It enhances the performance of DB
- D) In de-normalization it is required to add redundant data.
-
10)
Which of the following types of partitioning reduces the chances of unbalanced partitions?
- A) Vertical
- B) List
- C) Hash
- D) Range
