The attribute that can be divided into other attributes is called
Simple Attribute
Composite Attribute
Multi-valued Attribute
Derived Attribute
Correct Answer :
B. Composite Attribute
Related Questions
In E-R diagram Generalization is represented by
Circle
Rectangle
Hyperbola
Triangle
Which of the following works as a filter?
UPDATE
DROP
ALTER
SELECT
A logical schema
is the entire database.
is a standard way of organizing information into accessible parts.
describes how data is actually stored on disk.
both A) and C)
RAID
Redundant Arrays of Independent Disks
Redundant Arrays of Independent Drives
Redundant Arrays of Interconnected Drives
Redundant Arrays of Interconnected Disks
Benefit of database normalization is
smaller number of tables
higher query processing efficiency
reduced I/O for most queries
reduced data redundancy
An operation that will increase the length of a list is
insert
modify
lookup
none of the above
A relation that has no partial dependencies is in which normal form
First
Second
Third
BCNF
The method by which the structure of the database is modified to eliminate hidden dependencies and replacing groups is
Normalization
Indexing
Enforcing referential integrity
Enforcing data integrity
By default a user who has been granted some form of authorization
is allowed to pass them to others
is not allowed to pass them to others
may be or may not be allowed to pass them to others
none
A subschema expresses
the logical view.
the physical view.
the external view.
all of the above.
The mode in which data item may be locked
Partner
Mutual
Exclusive
Atomic
The command used to delete a particular column in a relation
UPDATE
DROP
ALTER
DELETE
Unwanted energy from source other than the transmitter.
Attenuation
Distortion
Delay
Noise
State which of the following statements are True
i) TCP is connection oriented but unreliable
ii) UDP is connection oriented but unreliable
iii) TCP is connectionless but reliable
iv) UDP is connectionless but reliable
i and ii only
ii and iii only
i and iii only
None of these
In client/server computing data are
sent only upon the client's request
sent in complete copies for the client to filter and sort
never sent to the client machine
sent in very large sections to save processing time
Usenet is also known as
Newsgroups
10Km to 1Km
10^3Km to 100Km
100M to 10M
An advantage of the database management approach is
data is dependent on programs.
data redundancy increases.
data is integrated and can be accessed by multiple programs.
none of the above.
What is ACID properties of Transactions?
Atomicity, Consistency, Isolation, Database
Atomicity, Consistency, Isolation, Durability
Atomicity, Consistency, Inconsistent, Durability
Automatically, Concurrency, Isolation, Durability
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
As a side-effect of database update ,the system automatically executes a statement called
a view
a grant permission
a trigger
all of the above
Data stored in cursor is called ……………
record
active data set
object
none of the above
It is possible to define a schema completely using
VDL and DDL.
DDL and DML.
SDL and DDL.
VDL and DML.
Data fragmentation is performed by the …… and each fragment is stored at…………..
DBMS, same site
OS ,same site
DBMS ,different site
OS ,different site
Select the incorrect statement(s)
i) Foreign key values can be left blank
ii) In SQL duplicates may be present
iii) Theta join operation doesnt remove duplicate columns.
iv) NULL value means string of blank characters.
i ,iii only
ii, iv only
iii, iv only
ii, iii, iv
The number of cursors depend on the
number of queries
number of attributes
size of memory area
none of these
Extended Entity Relationship model consists of which of the following
i) Specialization
ii) Generalization
iii) Categorization
i and ii only
ii and iii only
i and iii only
All i, ii iii
Which of the following is true statement ?
SQL permits attribute names to be repeated in the same relation.
a SQL query automatically eliminates duplicates.
a SQL query will not work if there are no indexes on the relations
None of these
A logical description of some portion of database that is required by a user to perform task is called as
System View
User View
Logical View
Data View
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
The statement in SQL which allows to change the definition of a table is
Select
Update
Create
Alter