If a relation is in BCNF, then it is also in

Report

Report an issue

Name

Email

Message

Submit

Cancel

PGCET CSE Exam (Karnataka) 2011 click here to view all questions

If a relation is in BCNF, then it is also in

A1 NF

B2 NF

C3 NF

D4 NF

Akilesh Kharvi ? Dec 8 '2016 at 22:17

Answer:3 NF

Explanation:

Normalization is a process that “improves” a database design by generating relations that are of higher normal forms.

there are four normal form
->1 NF
->2 NF
->3 NF
->BCNF

 

View Answer

Discuss

Relations produced from an E-R model will always be in

Report

Report an issue

Name

Email

Message

Submit

Cancel

PGCET CSE Exam (Karnataka) 2011 click here to view all questions

Relations produced from an E-R model will always be in

A1 NF

B2 NF

C3 NF

D5 NF

Akilesh Kharvi ? Dec 8 '2016 at 21:39

Answer: 3 NF

Explanation:

BCNF is higher form of normalization then 1,2,3 NF forms so BCNF will always be in 3NF,2NF,1NF
A binary relation is always a BCNF relation.

View Answer

Discuss

A driver's salary may not exceed Rs. 25,000 p.m. This is a

Report

Report an issue

Name

Email

Message

Submit

Cancel

PGCET CSE Exam (Karnataka) 2011 click here to view all questions

A driver's salary may not exceed Rs. 25,000 p.m. This is a / an

Aintegrity constraint

Breferential constraint

Cfeasibility constraint

Dlogical constraint.

Akilesh Kharvi ? Dec 8 '2016 at 21:36

Answer : integrity constraint

Explanation:

Integrity Constraints are used to apply business rules for the database tables.
The constraints available in SQL are Foreign Key, Not Null, Unique, Check.
Check Constraint :This constraint defines a business rule on a column. All the rows must satisfy this rule. The constraint can be applied for a single column or a group of columns.

Syntax to define a Check constraint:
[CONSTRAINT constraint_name] CHECK (condition)
example: [CONSTRAINT salary] CHECK  salary<25000

View Answer

Discuss

Given the relational functional dependencies x —> w ; x ->y

Report

Report an issue

Name

Email

Message

Submit

Cancel

PGCET CSE Exam (Karnataka) 2011 click here to view all questions

Given the relational functional dependencies x —> w ; x ->y ; y -> z and z -> pq which of the following is NOT VALID ?

Ax -> z

Bx ->wy

Cy —> pq

Dw ->z

Akilesh Kharvi ? Dec 8 '2016 at 21:33

Answer:w ->z

Explanation:

If X→Y and Y→Z then X→Z so it is valid.
If X→W and X→Y then X→WY so it is valid.
If Y→Z and Z→PQ then Y→PQ so it is valid.
w not implies anything so w ->z is not valid.
so answer is w->Z

View Answer

Discuss

Which of the following is an example of multilevel indexing

Report

Report an issue

Name

Email

Message

Submit

Cancel

PGCET CSE Exam (Karnataka) 2011 click here to view all questions

Which of the following is an example of multilevel indexing ?

AA-tree

BB-tree

CDictionary

DNetwork.

Akilesh Kharvi ? Dec 8 '2016 at 21:31

Answer : B-tree

Explanation:

A B-tree is a method of placing and locating files (called records or keys) in a database. (The meaning of the letter B has not been explicitly defined.) The B-tree algorithm minimizes the number of times a medium must be accessed to locate a desired record, thereby speeding up the process.

Reference: http://searchsqlserver.techtarget.com/definition/B-tree

View Answer

Discuss