Technical Interview Questions and Answers :: Sopra Steria
- Select All
- SQL
- Java
- C++
- Informatica
- C
- DBMS
- Data Structure
- HR Question in TR
31 / 138
No Discussion on this question yet!
32 / 138
It is a collection of programs that enables the user to create and maintain a database. In other words, it is general-purpose software that provides the users with the processes of defining, constructing and manipulating the database for various applications.
33 / 138
1. Redundant Data
2. Inconsistency
3. Not easy to access data.
4. No security
5. Concurrent access is not allowed.
34 / 138
Physical Level - This is the lowest level of data abstraction which describes which describes how the data is to be stored in the database.
Logical level - The level describes the data in the database as well as relations between these database.
View Level- This is the highest level of data abstraction , only some part of actual database is viewed to the user.
35 / 138
There are two Integrity rules.
> Entity Integrity: States that “Primary key cannot have NULL valueâ€
> Referential Integrity: States that “Foreign Key can be either a NULL value or should be Primary Key value of other relation.
36 / 138
System R was designed and developed over a period of 1974-79 at IBM San Jose Research Center. It is a prototype and its purpose was to demonstrate that it is possible to build a Relational System that can be used in a real life environment to solve real life problems, with the performance at least comparable to that of the existing system.
Its two subsystems are
> Research Storage
> System Relational Data System.
37 / 138
No Discussion on this question yet!
38 / 138
No Discussion on this question yet!
39 / 138
No Discussion on this question yet!
40 / 138
No Discussion on this question yet!