DBMS helps achieve
Data independence
Centralized control of data
Neither A) nor B)
both A) and B)
Correct Answer :
D. both A) and B)
Related Questions
Select the correct
i) A timestamp-based scheduler cant produce live lock
ii) Aggregate functions cant appear with HAVING clause.
iii) Isolation is a property of database transaction.
i and ii only
ii and iii only
i and iii only
i only
The ability to modify the conceptual schema without causing any change to the application program is known as
Physical data independence
Logical data independence
External data independence
Static data
In E-R diagram Generalization is represented by
Circle
Rectangle
Hyperbola
Triangle
The host part in a class A type of an IP address has
12 bits
16 bits
24 bits
28 bits
Data Manipulation Language DML) is not to
Create information table in the Database
Insertion of new information into the Database
Deletion of information in the Database
Modification of information in the Database
Data fragmentation is performed by the …… and each fragment is stored at…………..
DBMS, same site
OS ,same site
DBMS ,different site
OS ,different site
The syntax to select all column from the table is
select all from tablename
select * from tablename
select from tablename
none of these
A lock that allows concurrent transactions to access different rows of the same table is known as a
Field-level lock
Row-level lock
Table-level lock
Database-level lock
Natural mask for a Class A network
255.0.0.0
255.255.0.0
255.255.255.0
none of these
A table that displays data redundancies yields ____________ anomalies
Insertion
Deletion
Update
All of the above
Which of the following extracts its data from the result of an SQL SELECT statement.
View
Synonym
Sequence
Transaction
A relation is said to be in ………. If it doesnt contain partial dependency
1NF
2NF
3NF
BCNF
Consider the join of a relation R with relation S. If R has m tuples and S has n tuples,
then the maximum size of join is:
mn
m+n
m+n)/2
2 m+n)
Which of the following is not an Aggregate function?
Min
Max
Select
Avg
Data integrity refers to
the uniqueness of the data in a database
the correctness and completeness of the data in a database
the un redundancies of the data in a database
Data independence of the database
A transaction is said to have terminated if it has
either committed or aborted
either partially committed or aborted
either committed or failed
none of these
A relation which is in 3NF is
in 1NF also
in 2NF also
free from transitive dependencies
All of these
The class based addressing is known as
Classless addressing
Classful addressing
Classified addressing
Classical addressing
In the architecture of a database system external level is the
physical level.
logical level.
conceptual level
view level.
A type of query that is placed within a WHERE or HAVING clause of another query is called
Super query
Sub query
Master query
Multi-query
A subschema expresses
the logical view.
the physical view.
the external view.
all of the above.
The minimal set of super key is called
Primary key
Secondary key
Candidate key
Foreign key
Which of the following are the properties of entities?
Groups
Table
Attributes
Switchboards
The types of noiseless channels are
i) Selective Reject ARQ
ii) simplest protocol
iii) Go-Back-N ARQ
iv) Stop-and-Wait Protocol
i, ii only
ii and iv only
ii and iv only
i, iv only
What is the max data capacity of STP?
1 Gbps
56 Mbps
100 Mbps
256 Mbps
The index table has …… Columns.
1
2
3
4
Log into a computer across an internet
IMAP
TELNET
POP3
Infrared
The exists construct returns the value true, if the argument subquery is
empty
nonempty
contains null values
none of the above
The overall design of a database is called
Subschema of the database
Schema of the database
Structure of the database
View of the database
The number of cursors depend on the
number of queries
number of attributes
size of memory area
none of these