Drop Table cannot be used to drop a table referenced by a ______ constraint.
Primary Key
Local Key
Foreign Key
Composite Key
Correct Answer :
C. Foreign Key
Related Questions
A top-to-bottom relationship among the items in a database is established by a
Hierarchical schema
Network schema
Relational Schema
All of the above
Grant and revoke are _____ statements.
TCL
DCL
DDL
DML
Which of the following is not a recovery technique?
Deferred update
Immediate update
Two-phase commit
Shadow paging
______is a special type of integrity constraint that relates two relations & maintains consistency across the relations.
Domain Integrity Constraints
Referential Integrity Constraints
Domain Constraints
Entity Integrity Constraints
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));
Which one is correct statement?
Logical data independence provides following without changing application programs:
(i) Changes in access methods.
(ii) Adding new entities in database
(iii) Splitting an existing record into two or more records
(iv) C
(i) and (ii)
(iv) only
(i) and (iv)
(ii) and (iii)
E-R Modeling is achieved by using ____ diagrams
DFD
Flowcharts
Gantt Charts
E-R
If both the functional dependencies : X�Y and Y�X hold for two attributes X and Y then the relationship between X and Y is
M:N
M:1
1:M
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
DBMS helps achieve
Centralized control of data
Data independence
Both A and B
Neither A nor B
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
_____clause is an additional filter that is applied to the result.
Select
Order by
Group-by
Having
A _____ is used to define overall design of the database
code
data definition language
application program
schema
Whenever two independent one-to-many relationships are mixed in the same relation, a __________ arises.
Functional dependency
Multi-valued dependency
Transitive dependency
Partial dependency
Which normal form is considered adequate for normal relational database design?
2NF
5NF
4NF
3NF
In SQL the statement select * from R, S is equivalent to
Select * from R natural join S.
Select * from R cross join S.
Select * from R union join S.
Select * from R inner join S.
If the closure of an attribute set is the entire relation then the attribute set is a
superkey
candidate key
primary key
not a key
A relation is in attribute of other composite key. if an attribute of a composite key is dependent on an
2NF
3NF
BCNF
1NF
The default level of consistency in SQL is
repeatable read
read committed
read uncommitted
serializable
It is an abstraction through which relationships are treated as higher level entities
Generalization.
Specialization.
Aggregation.
Inheritance.
In an ER model,_____ is described in the database by storing its data.
Entity
Attribute
Relationship
Notation
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
The normal form that is not necessarily dependency preserving is
2NF
3NF
BCNF
4NF
A data type or format is specified for each _________
Relation
Tuple
Database
Domain
The relational model is based on the concept that data is organized and stored in two-dimensional tables called ______
Fields
Records
Relations
Keys
The set of all values that can be taken by the attribute is called as _______ of the attribute.
Tuple
Cardinality
Degree
Domain
Employees in a company are each assigned their own office, i.e. for each employee there exists a unique office and for each office there exists a unique employee; This statement is an example of ____ type of relation.
1:1
1: Many
Many: One
Many : Many
According to the levels of abstraction, the schema at the intermediate level is called
Logical schema.
Physical schema.
Subschema.
None of the above.
………………… approach reduces time and effort required for design and lesser risk in database management.
Single global database
Multiple databases
Top-down approach
None of the above
____specifies a search condition for a group or an aggregate.
GROUP BY Clause
HAVING Clause
FROM Clause
WHERE Clause