1. “DBMS” is a gathering of _____________allows user to make and uphold a database.
A) Keys
B) Translators
C) Program
D) Language Activity
see answer
C) Program
2. In a relational schema, each tuple is distributed into fields called:
A) Relations
B) Domains
C) Queries
D) All of the above
see answer
B) Domains
3. In an ER model, _______________________ is labelled in the database by storage its data.
A) Entity
B) Attribute
C) Relationship
D) Notation
see answer
A) Entity
4. “DFD” stands for:
A) Data Flow Document
B) Data File Diagram
C) Data Flow Diagram
D) None ,
see answer
C) Data Flow Diagram
5. A top-to-bottom bond among the items in a database is recognized by a:
A) Hierarchical schema
B) Network schema
C) Relational Schema
D) All of the above
see answer
A) Hierarchical schema
6._______________________ table store info about database or about the system.
A) SQL
B) Nested
C) System
D) None of these
see answer
C) System
7. _____________________clause is an extra filter that is functional to the result.
A) Select
B) Group-by
C) Having
D) Order by
see answer
C) Having
8. A logical schema:
A) Is the entire database
B) Is a standard way, of organizing information, into accessible parts
C) Describes how data is actually stored on disk.
D) All,
see answer
B) Is a standard way, of organizing information, into accessible parts
9._______________________ 1s a full, form of SQL.
A) Standard query language,
B) Sequential query language,
C) Structured query language,
D) Server side query language,
see answer
C) Structured query language,
10) A relational database designer refers to a record as:
A. a criteria,
B. a relation,
C. a tuple,
D. an attribute,
see answer
C. a tuple,
