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
Correct Answer :
D. all of the above
Related Questions
Key to represent relationship between tables is called
primary key
secondary key
foreign key
none of the above
A ____ key specifies a uniqueness constraint that no two distinct tuples in any state r of relation R can have the same value for super key.
Sub
Parent
Candidate
Super
Precedence graphs help to find a
Serializable schedule.
Recoverable schedule.
Deadlock free schedule.
Cascadeless schedule.
The keyword to eliminate duplicate rows from the query result in SQL is
DISTINCT
NO DUPLICATE
UNIQUE
None of the above
The rule that a value of a foreign key must appear as a value of some specific table is called a
Referential constraint.
Index.
Integrity constraint.
Functional dependency.
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
The ______ key of a relation is the attribute (column) or collection of attributes, which uniquely identify a given tuple.
Primary
Foreign
Candidate
Alternate
Checkpoints are a part of
Recovery measures.
Security measures.
Concurrency measures.
uthorization measures.
A data type or format is specified for each _________
Relation
Tuple
Database
Domain
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
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
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
The clause in SQL that specifies that the query result should be sorted in ascending or descending order based on the values of one or more columns is
View
Order by
Group by
Having
The _____ category includes storage media that can be operated on directly by the computers central processing unit.
Primary storage
Secondary Storage
All
Tertiary Storage
It is an abstraction through which relationships are treated as higher level entities
Generalization.
Specialization.
Aggregation.
Inheritance.
_______ product was acquired by Informix, integrated into its RDBMS and introduced as the Informix Universal Server an ORDBMS.
Star
llustar
SQL
Cygnus
DBMS helps achieve
Centralized control of data
Data independence
Both A and B
Neither A nor B
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 ______ language consists of SQL statements for operating on the data (insert, Modify, Delete) in tables that already exist.
Data Manipulation
Data Definition
Data Control
None
In E-R Diagram total participation is represented by
Double lines
Single line
Dashed lines
Triangle
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
The full form of GUI is _________
Government Union Internet
Graphical Unit Interface
Graphical User Interface
Graphical University Interface
Which one is true statement :
With finer degree of granularity of locking a high degree of concurrency is possible.
Locking prevents non-serializable schedules.
Locking cannot take place at field level.
An exclusive lock on data item X is granted even if a shared lock is already held on X.
Immediate database modification technique uses
Both undo and redo.
Undo but no redo.
Redo but no undo.
Neither undo nor redo.
_____ database is used to provide statistical information or summaries of values based on various criteria.
Statistical
Mathematical
Normalized
Un normalized
The collection of information stored in a database at a particular moment is called as ......
schema
instance of the database
data domain
independence
Which of the syntax is correct for insert statement?
i) insert into values
ii) insert into (column list) values
ii) insert into
i-only
ii-only
Both of them
None of them
_____ is a utility to capture a continuous record of server activity and provide auditing capability.
SQL server Profile
SQL server wizard.
SQL server service manager
SQL server setup
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
What are the desirable properties of a decomposition
Partition constraint.
Dependency preservation.
Redundancy.
Security.