The statement in SQL which allows to change the definition of a table is
Select
Update
Create
Alter
Correct Answer :
D. Alter
Related Questions
FDDI protocol operates in
i) Transport layer
ii) Network layer
iii) Datalink layer
iv) Physical layer
i and ii only
ii and iii only
i and iii only
iii and iv only
Which of the following is not an Aggregate function?
Min
Max
Select
Avg
RAID
Redundant Arrays of Independent Disks
Redundant Arrays of Independent Drives
Redundant Arrays of Interconnected Drives
Redundant Arrays of Interconnected Disks
Aggregate functions are also called
serial functions
non-serial functions
row functions
column functions
A relation that has no partial dependencies is in which normal form
First
Second
Third
BCNF
Select the incorrect statement
BCNF is stronger than 3NF
Relational algebra is a non-procedural language
Every conflict serializable schedule is view serializable.
none of the above
Which of the following submit and execute query at run time?
Static SQL
Dynamic SQL
both
none of these
A subschema expresses
the logical view.
the physical view.
the external view.
all of the above.
The maximum number of children in a B-tree of order m is
m+1
m
m-1
m/2
The raw facts and figures are:
Data
Data field
DBMS
DBASE
In which of the following SET concept is used ?
Network Model
Hierarchical Model
Relational Model
None of these
The class based addressing is known as
Classless addressing
Classful addressing
Classified addressing
Classical addressing
The exists construct returns the value true, if the argument subquery is
empty
nonempty
contains null values
none of the above
In E-R diagram Generalization is represented by
Circle
Rectangle
Hyperbola
Triangle
Database locking concept is used to solve the problem of
Lost Update
Uncommitted Dependency
Inconsistent Data
All of the above
In two-phase locking
the data items are locked in growing phase.
the data items are released in shrinking phase.
Both A and B are true
Both A and B are false
The attribute that can be divided into other attributes is called
Simple Attribute
Composite Attribute
Multi-valued Attribute
Derived Attribute
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
Which of the following statement returns data to the host variables one at a time?
SELECT
RETURN
FETCH
GET
In an E-R diagram attributes are represented by
rectangle.
square.
ellipse.
triangle.
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
Authorization command in SQL
Allow
Access
Grant
none of the above
In an object oriented model, one object can access data of another object by passing?
Instance variable
Variable
Message
Function
.................. occurs due to velocity of propagation the frequency varies. Thus various frequency components of a signal arrive at the receiver at different times.
Noise
Delay distortion
Attenuation distortion
Dispersion
.................. means sending a digital signal over a channel without changing the digital signal to an analog signal.
Baseband transmission
Broadband transmission
Digital transmission
Analog transmission
Transaction access data using two operations
read(), print()
read(), write()
scan(), write()
none of the above
An entity set which have sufficient attributes to form a primary key
Tree structure
Subtree structure
Strong entity set
Table structure
The degree of the table with 500 rows and 7 columns is
500
7
3500
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 concurrency control schemes is not based on serializability property?
Two-phase locking
Timestamped based locking
Graph-based locking
none of the above