A data type or format is specified for each _________
Relation
Tuple
Database
Domain
Correct Answer :
B. Tuple
Related Questions
What are the desirable properties of a decomposition
Partition constraint.
Dependency preservation.
Redundancy.
Security.
Which of the following is a reason to model data?
Understand each user's perspective of data
Understand the data itself irrespective of the physical representation
Understand the use of data across application areas
All of the above
What is data integrity?
It is the data contained in database that is non redundant.
It is the data contained in database that is accurate and consistent.
It is the data contained in database that is secured.
It is the data contained in database that is shared.
E-R Modeling is achieved by using ____ diagrams
DFD
Flowcharts
Gantt Charts
E-R
The cost of reading and writing temporary files while evaluating a query can be reduced by
building indices
pipelining
join ordering
none of the above
A relation is in attribute of other composite key. if an attribute of a composite key is dependent on an
2NF
3NF
BCNF
1NF
Which of the following is not a logical database structure?
Chain
Network
Tree
Relational
A table can have only one
Secondary key
Alternate key
Unique key
Primary key
It is an abstraction through which relationships are treated as higher level entities
Generalization.
Specialization.
Aggregation.
Inheritance.
In b-tree the number of keys in each node is than the number of its children.
one less
same
one more
half
Which of the following is not a consequence of non-normalized database?
Update Anomaly
Insertion Anomaly
Redundancy
Lost update problem
Which normal form is considered adequate for normal relational database design?
2NF
5NF
4NF
3NF
In SQL the statement select * from R, S is equivalent to
Select * from R natural join S.
Select * from R cross join S.
Select * from R union join S.
Select * from R inner join S.
In an ER diagram the ___shape specifies the Attibute and a ____ shape specifies the primary key attribute.
Oval; An oval with an underlined attribute
Circle; A circle with bolded attribute inside it
Diamond; A bolded attribute
Square; An attribute within the square
A ______ module is typically designed so that it will run on a user workstation or personal computer.
Software
Server
Program
Client
The clause alter table in SQL can be used to
add an attribute
delete an attribute
alter the default values of an attribute
all of the above
The concept of mapping of ______ entity types is the concept in which the for each strong entity type E in the ER schema, create a relation R that includes all the simple attributes of E.
Regular
Irregular
None
Weak
______defines the structure of a relation which consists of a fixed set of attribute-domain pairs.
Instance
Program
Schema
Super Key
Data independence means
data is defined separately and not included in programs.
programs are not dependent on the physical attributes of data
programs are not dependent on the logical attributes of data
both B and C
Which of the following is true for network structure?
It is a physical representation of the data.
It allows many to many relationship.
It is conceptually simple.
It will be the dominant database of the future.
Which of the following is not a characteristic of a relational database model?
Table
Tree like structure
Complex logical relationship
Records
A _____ is used to define overall design of the database
code
data definition language
application program
schema
When an E-R diagram is mapped to tables, the representation is redundant for
weak entity sets
weak relationship sets
strong entity sets
strong relationship sets
Tree structures are used to store data in
Network model.
Relational model.
Hierarchical model.
File based system.
A relational database developer refers to a record as
an attribute
a tuple
a criteria
a relation
DFD stands for
Data Flow Document
Data File Diagram
Data Flow Diagram
Non of the above
In E-R Diagram total participation is represented by
Double lines
Single line
Dashed lines
Triangle
Which of the following ensures the atomicity of the transaction?
Transaction management component of DBMS
Application Programmer
Concurrency control component of DBMS
Recovery management component of DBMS
DBMS is a collection of _____ that enables user to create and maintain a database.
Keys
Program
Translators
Language Activity
______is a preferred method for enforcing data integrity
Constraints
Triggers
Stored procedure
Cursors