3i Infotech Placement: Sample Questions 1106 - 1108 of 1245

Glide to success with Doorsteptutor material for competitive exams : get questions, notes, tests, video lectures and more- for all subjects of your exam.

Question 1106

Edit

Write in Short

Short Answer▾

What is an opaque pointer?

Explanation

  • A pointer is opaque if definition of the type to which it points to is not included in the current translation unit.
  • A translation unit results by merging an implementation file with all its headers and header files.
Given the the Opaque Pointers to an Instance of a Struct Defined in the Class Implementation File

Question 1107

Edit

Describe in Detail

Essay▾

What is 1 NF (Normal Form) ?

Explanation

  • The domain of attribute must include only atomic (simple, indivisible) values.

1NF (First Normal Form) Rules

  • Each table cell should contain a single value.
  • Each record needs to be unique.

    1NF Example:

  • Understanding the example of above Normalization table
Table Shows the 1NF Example
Full NamePhysical AddressMOVIES RENTEDSALTUTATION
JanatFirst Street Plot No 4Pirates of the CaribbeanMs.
JanatFirst Street Plot No 4Clash of the TitansMs.
Rohit3rd Street 34Forgetting Sarah MarshalMr.
Rohit3rd Street 34Daddy՚s Little GirlsMr.
Rohit5th AvenueClash of the TitansMr.

Question 1108

Question

MCQ▾

A B C is a set of attributes. The functional dependency is a follows:

AB B

AC C

C B

Choices

Choice (4)

a.

Is in 3NF

b.

Is in BCNF

c.

Is in 2NF

d.

Is in 1NF

Answer

d.

Explanation

Table Shows the a, B and C Attributes
{A, B, C}

AC is the primary key

Neither C is a key nor B is a prime attribute

So, it is not 3NF

  • Now, B is not functionally dependent on key AC
  • So, it is not in 2NF
  • Hence, given functional dependency is 1 NF.

Developed by: