Register

UGC NET CSE | June 2013 | Part 3 | Question: 47

• recategorized by
1,827 views
3 votes
3 votes

Match the following:

a. Foreign keys i. Domain constraint
b. Private key ii. Referential integrity
c. Event control action model iii. Encryption
d. Data security iv. Trigger
  1. a-iii, b-ii, c-i, d-iv
  2. a-ii, b-i, c-iv, d-iii
  3. a-iii, b-iv, c-i, d-ii
  4. a-i, b-ii, c-iii, d-iv
• recategorized by
User Avatar

2 Answers

Best answer
2 votes
2 votes

correct answer is : a-ii, b-i, c-iv, d-iii

a. Foreign keys                                  ii. Referential integrity
b. Private key                                     i. Domain constraint 
c. Event control action model              iv. Trigger
d. Data security                                 iii. Encryption 

Foreign Key : A foreign key is a column that references a column of another table. The purpose of the foreign key is to ensure referential integrity of the data.

Trigger : A trigger is a special kind of stored procedure that automatically executes when an event occurs in the database server.

Domain Constraint : refer this

• selected by
User Avatar
0 votes
0 votes

Ans is B

 Foreign keys                                  ii. Referential integrity

 Data security                                 iii. Encryption

Event control action model         iv. Trigger (executed automatically on execution of some event

 Private key                                    iii. Domain constarint

User Avatar
Voting & Accepting an answer helps improve the community
Answer:
← PreviousNext →
← Previous in categoryNext in category →

Related questions

5 votes
5 votes
3 answers
2
go_editor asked Jul 16, 2016
1,520 views
UGC NET CSE | June 2013 | Part 3 | Question: 9
For a database relation R(a, b, c, d) where the domains of a, b, c, d include only the atomic values. The functional dependency a $\rightarrow$ c, b $\rightarrow$ d holds in the following relation. In 1NF not in 2NF In 2NF not in 3NF In 3NF in 1 NF
For a database relation R(a, b, c, d) where the domains of a, b, c, d include only the atomic values. The functional dependency a $\rightarrow$ c, b $\rightarrow$ d holds...
User Avatar
0 votes
0 votes
1 answer
4
go_editor asked Jul 16, 2016
3,238 views
UGC NET CSE | June 2013 | Part 3 | Question: 7
The “PROJECT” operator of a relational algebra creates a new table that has always More columns than columns in original table More rows than original table Same number of rows as the original table Same number of columns as the original table
The “PROJECT” operator of a relational algebra creates a new table that has alwaysMore columns than columns in original tableMore rows than original tableSame...
User Avatar
Link Copied!