Which of the following is software that is used to create, maintain, and provide controlled access
to database? *
A -
Database management system
B -
Attribute
C -
User view
D -
Network operating system
2-
Which of the following is true about a key?
A -
It may be unique
B -
It may be non-unique
C -
All of the above
D -
In may identify more than one row
3-
Which of the following would not be an example of database metadata? *
A -
Quries against records in the database tables
B -
Names of tables in a database
C -
Names of column in a database and their associated tables
D -
Properties of columns
4-
Which of the following is not a Group function?
A -
SUM
B -
AVG
C -
MAX
D -
SQRT
5-
Which of the following is a characteristic of an enterprise data model? *
A -
It duplicates data
B -
It creates physical relationships
C -
It stresses the integration of data
D -
It reduces storage
6-
Which of the following statements do you consider to be ’true’
A -
Relational Algebra defines a set of algebraic operations which operate on tables, and output tables are their results
B -
All of these answers
C -
Database can be modified by insertion, deletion or update of rows
D -
An authorized user (privileges granted) may query these tables, insert new rows, delete rows and modify row content
7-
Which of the following is true about a relation?
A -
All entries in any column must be of the same kind
B -
A relation may have suplicate column names
C -
A relation may have duplicate rows
D -
A relation may have multiple names
8-
Which of the following types of data can be stored in a database?
A -
Numbers
B -
Voice
C -
All of the above
D -
Letters
9-
Which of the following statement is true?
A -
It a table meets the minimum definition of a relation, it has an effective or appropriate structure.
B -
Multi-user databases are less complicated than single-user databases because the work is distributed to many people
C -
EXISTS and NOR EXISTS are actually just another of correlated subqueries
D -
A constraint based on a bussiness rule, that requires an instance of an entity to exist in one relation before it can be referenced in another relation is called an insertion anomaly
10-
Which of the following statement is true?
A -
A relation can be in 3NF without being in 2NF
B -
In order to connect the tables in a database, each row in each table must be identified by a table name
C -
In a database processing system, stored procedures are held by the database management system(DBMS)
D -
Each login account can have a different default language
