Font size
Worksheetsdatabase concepts
Total questions: 51
Worksheet time: 29mins
The number of rows in a relation
degree
tuple
cardinality
domain
SQL stands for
(a)
Data about data is ______________
Data Description
Metadata
Data redundancy
Data inconsistency
How many records are in this database?
8
5
9
12
What is the primary key in this database?
Emp_Id
Last Name
Gender
Title
(a) is the degree of table Employee?
(a) is the cardinality of table Employee.
The number of columns in a table is known as (a) of a table.
The number of records in table is known as (a) of a table.
Which all options are correct regarding a Primary key?
Can have many primary keys in a table
it can't be left blank
it can't have duplicate values
Which one is correct?
Alternate key – primary key = Candidate keys
Candidate keys - Alternate key = primary key
Candidate keys – primary key = Alternate key
Which key is used to maintain relationship between tables?
Candidate key
Foreign key
Primary key
Alternate key
In a table there can be many alternate keys.
True
False
In a table there can be many candidate keys.
True
False
All items in a column of a table should be .................
heterogeneous
homogeneous
Vertical subset of a table is known as .................
Fields
Records
Attributes
Tuple
Horizontal subset of a table is known as .....................
Records
Fields
Tuple
Rows
Raw facts which people gather is referred to as ...
information
data
knowledge
wisdom
What gives meaning to these numbers and figures is ...
information
data
knowledge
wisdom
A .... is an organized pool of logically related data.
wisdom
database
information system
data
We need database for ...
accessing data and information .
processing the data as needed.
updating existing data.
all of the above.
A transaction is a unit of work performed within a database management system against a database.
false
true
... is the process of ensuring that a program operates on clean, correct and useful data.
Data consistency
Data concurrency
Data validation
Data verification
... ensures users can access data at the same time.
Data consistency
Data concurrency
Data validation
Data verification
A relational database consists of a collection of ..............
tables
fields
records
keys
............ is a field in a database table (or a combination of fields) that has a unique value.
a foreign key
a primary key
metadata
an alternate key
A field in a database table whose values are the same as the primary key of another table is called .......
a foreign key
a primary key
metadata
an alternate key
The column which has unique values in all the rows but is not a primary key is called ............. key.
candidate
alternate
composite
foreign
All candidate keys are primary keys.
True
False
Alternate keys are not primary keys.
True
False
Repetition of data is called data ..............
dependance
redundancy
inconsistency
isolation
Mismatched redundant copies of data is known as data ............
dependance
redundancy
inconsistency
isolation
A ............ is an organized collection of structured data.
information
file
database
DBMS
A ............ is a software management system designed to maintain a database.
information
file
database
DBMS
......... refers to the data about data.
instance
schema
metadata
relation
A single set of related data values is referred to as
Data Value
Field
Record
Table
What is used to uniquely identify each record in a table?
Foreign key
Field
Data type
primary key
What data type stores date and time values between the years 100 through 9999?
Date
Time
Date/Time
Memo
Indicate whether the following statement is true or false. Statement: A table can have only one Primary Key
True
False
The association that is created between tables when they are joined is called a __________________.
Module
Relationship
One-to-one
Referential Integrity
Macro
Which of the following database objects allows you to search for information and then display the result?
Query
Table
Report
Forms
What is a database?
An application that allows you to carry out general book-keeping tasks.
A file that stores and organises large amounts of related data.
A file that stores your computer’s configuration details.
A device used to store deleted files.
Your database is not made up of tables and records.
True
False
(a)
Software that
manages and controls
access to the
database
(a) is a collection of related data
What are the limitation of File Based Approach?
Duplication of data
Data Dependence
Data Independence
Incompatible file format
A non key attribute ,whose values are derived from the primary key of some other table is known as
Alternate key
Foreign key
Candidate key
None
A candidate key that is not a primary key is known as
Alternate key
Foreign key
Primary key
None
A column of a database relation is also known as
Tuple
Degree
Attribute
Record
The number of rows in a relation
degree
tuple
cardinality
domain
