12th Class Computer Science MCQS
In relational database, table is also called:
File
Relation
Table
Schema
In 3NF, a non-key attribute must not depend on a :
Non-key attribute
Composite key
Sort key
Key attribute
Which of the following anomalies result from a transitive dependency ?
Insertion
Deletion
All
Modification
A rule that states each foreign key value must match a primary key value in the other relation is called:
Key match rule
Entity key group rule
Foreign/ primary match rule
Referential integrity constraints
Which is a possible value of flag?
+
All of these
–
Space
Which of the following is a decision making statement
all
break
getch ( )
if
A functional dependency between two or more non-key attributes is called:
Transitive dependency
Partial functional dependency
Partial non-key dependency
None
Which form of dependency is removed in 2NF?
Associative
Transitive
Functional
Partial
Need Assistance? In case of any query/problem, Please don’t hesitate to Contact us Pak Study Library Services for Student provide a wide range of Education
Google Ads