E-R Modeling is achieved by using ____ diagrams
DFD
Flowcharts
Gantt Charts
E-R
Correct Answer :
D. E-R
Related Questions
In SQL, testing whether a subquery is empty is done using
DISTINCT
UNIQUE
NULL
EXISTS
The _____ category includes storage media that can be operated on directly by the computers central processing unit.
Primary storage
Secondary Storage
All
Tertiary Storage
Protection of data from unauthorized Disclosure results in loss of _______
Integrity
Availability
Confidentiality
Discretionary Security
Which of the following is not a consequence of concurrent operations?
Lost update problem.
Update anomaly.
Unrepeatable read.
Dirty read.
A _____ is used to define overall design of the database
code
data definition language
application program
schema
Cascading rollback is avoided in all protocol except
strict two-phase locking protocol.
tree locking protocol
two-phase locking protocol
validation based protocol.
A list consists of last names, first names, addresses and pin codes. If all people in the list have the same last name and same pin code a useful key would be
the pin code
the last name
the compound key first name and last name
Tr from next page
The normalization was first proposed by .
Code
Codd
Boyce Codd
Boyce
Create a table with the following attributes: Employee(EMPNO integer, EMPNAME of 10 characters)
Create table Employee(EMPNO int, EMPNAME char(10));
Create table Employee(EMPNO integer, EMPNAME String(10));
Create table Emplo(EMPNO number, EMPNAME string);
Create table Emp(EMPNO int, EMPNAME char(10));
What will be the number of columns and rows respectively obtained for the operation, A- B, if A B are Base union compatible and all the rows of a are common to B? Assume A has 4 columns and 10 rows; and B has 4 columns and 15 rows
4,0
0,0
4,5
8,5
The full form of GUI is _________
Government Union Internet
Graphical Unit Interface
Graphical User Interface
Graphical University Interface
DBMS helps achieve
Centralized control of data
Data independence
Both A and B
Neither A nor B
____ table store information about database or about the system.
SQL
System
Nested
None of these
The statement that is executed automatically by the system as a side effect of the modification of the database is
backup
assertion
recovery
trigger
The part of a database management system which ensures that the data remains in a consistent state is
authorization and integrity manager
buffer manager
transaction manager
file manager
_______ product was acquired by Informix, integrated into its RDBMS and introduced as the Informix Universal Server an ORDBMS.
Star
llustar
SQL
Cygnus
In a relational schema, each tuple is divided into fields called
Relations
Queries
Domains
All of the above
An advantage of views is
Data security
Derived columns
Hiding of complex queries
All of the above
______defines the structure of a relation which consists of a fixed set of attribute-domain pairs.
Instance
Program
Schema
Super Key
Grant and revoke are _____ statements.
TCL
DCL
DDL
DML
The size of a data item is called its _______, which can be a field of some record or may be a larger unit such as a record.
Similarity
Granularity
Dimensionality
Arity
E-R Modeling is achieved by using ____ diagrams
DFD
Flowcharts
Gantt Charts
E-R
Which normal form is considered adequate for normal relational database design?
2NF
5NF
4NF
3NF
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
If a transaction T has obtained an exclusive lock on item Q, then T can
read Q
write Q
both read and write Q
write Q but not read Q
Shadow paging has
no redo
no undo
redo but no undo
neither redo nor undo
Which of the following is not a property of transactions?
Atomicity
Concurrency
Isolation
Durability
The set of all values that can be taken by the attribute is called as _______ of the attribute.
Tuple
Cardinality
Degree
Domain
_____ First proposed the process of normalization.
Edgar. W
Edward Stephen
Edgar F. Codd
Edward Codd
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