Quiz 4- SEC A
.
- 1.A top-to-bottom relationship among the items in a database is established by a :
- A.
Hierarchical schema
- B.
Network schema
- C.
Relational schema
- D.
All of the above
- 2.The level of data abstraction which describes how the data is actually stored is :
- A.
Conceptual level
- B.
Physical level
- C.
file level
- D.
None of these
- 3.Collection of information stored in a database at a particular moment is :
- A.
View
- B.
Schema
- C.
Instance
- D.
None of the above
- 4.DBA stands for :
- A.
Data Bank Access
- B.
Database Access
- C.
Data Bank Administration
- D.
Database Administrator
- 5.Between the users and the database itself, a DBMS will act as :
- A.
Barrier
- B.
Interface
- C.
Referee
- D.
Obstacle
- 6.A schema describes :
- A.
Record Relationship
- B.
Data Elements
- C.
Record and files
- D.
All of the above
- 7.Which one is lowest level data model ?
- A.
Physical data model
- B.
Logical data model
- C.
External data model
- D.
None of the above
- 8.Data are :
- A.
Raw facts and figures
- B.
Information
- C.
Electronic representation of facts
- D.
None of the above
- 9.DBMS is used to :
- A.
Eliminate data redundancy
- B.
Maintain data integrity
- C.
Establish relationships among different files
- D.
All of the above
- 10.A set of objects that share a common structure and a common behavior is called :
- A.
Object
- B.
Class
- C.
Entity
- D.
None of these
- 11.The data dictionary tells the DBMS :
- A.
What files are in the database
- B.
What attributes are possessed by the data
- C.
What these files contain
- D.
All of the above
- 12.The logical data structure with a one-to-many relationship is a :
- A.
Network
- B.
Tree
- C.
Chain
- D.
Relationship
- 13.Data processing comprises of :
- A.
Capturing of data
- B.
Storing of data
- C.
Updating and retrieving data
- D.
All of the above
- 14.The highest level in the hierarchy of data organization is called :
- A.
Data bank
- B.
Database
- C.
Data file
- D.
Data record
- 15.File is the collection of all related :
- A.
Database
- B.
Records
- C.
Fields
- D.
File
- 16.Which one of the following provides the ability to query information from the database and to insert tuples into, delete tuples from, and modify tuples in the database?
- A.
DML(Data Manipulation Langauge)
- B.
DDL(Data Definition Langauge)
- C.
Query
- D.
Relational Schema
- 17.Create table employee (name varchar ,id integer) What type of statement is this
- A.
DML
- B.
DDL
- C.
View
- D.
Integrity constraint
- 18.An advantage of the database management approach is
- A.
Data is dependent on programs
- B.
Data redundancy increases.
- C.
Data is integrated and can be accessed by multiple programs.
- D.
None of the above
- 19.A DBMS query language is designed to
- A.
Support end users who use English-like commands
- B.
Support in the development of complex applications software
- C.
Specify the structure of a database.
- D.
All of the above.
- 20.Which database level is closest to the users?
- A.
External
- B.
Internal
- C.
Physical
- D.
Conceptual
- 21.The language which has recently become the defacto standard for interfacing application programs with relational database system is
- A.
. Oracle.
- B.
SQL.
- C.
DBase
- D.
4GL
Questions: 7 | Attempts: 551 | Last updated: Mar 22, 2022
-
Sample QuestionJill has 5 cookies. James has 10. How many more cookies does James have then Jill?
Questions: 23 | Attempts: 340 | Last updated: Mar 31, 2022
-
Sample QuestionAuthentic:
Questions: 5 | Attempts: 1241 | Last updated: Mar 21, 2022
-
Sample QuestionWhat did the children do between the ages of 8 and 12?
Back to top