Technical Interview Questions and Answers :: Sopra Steria
- Select All
- SQL
- Java
- C++
- Informatica
- C
- DBMS
- Data Structure
- HR Question in TR
51 / 138
No Discussion on this question yet!
52 / 138
Unlike Relational systems in System R
> Domains are not supported
> Enforcement of candidate key uniqueness is optional
> Enforcement of entity integrity is optional
> Referential integrity is not enforced
53 / 138
A collection of conceptual tools for describing data, data relationships data semantics and constraints.
54 / 138
This data model is based on the real world that consists of basic objects called entities and of a relationship among these objects. Entities are described in a database by a set of attributes.
55 / 138
This model is based on a collection of objects. An object contains values stored in instance variables within the object. An object also contains bodies of code that operate on the object. These bodies of code are called methods. Objects that contain same types of values and the same methods are grouped together into classes.
56 / 138
A database schema is specified by a set of definitions expressed by a special language called DDL.
57 / 138
It executes low-level instruction generated by compiler.
58 / 138
The domain of an attribute must include only atomic (simple, indivisible) values.
59 / 138
It is based on the concept of full functional dependency. A functional dependency X -> Y is full functional dependency if removal of any attribute A from X means that the dependency does not hold any more.
60 / 138
A relation schema R is in 2NF if it is in 1NF and every non-prime attribute A in R is fully functionally dependent on primary key.