Technical Interview Questions and Answers :: Capgemini
- Select All
- C++
- Informatica
- DBMS
- Operating System
- Networking
- HR Question in TR
- C
- Soft. Engineering
11 / 33
No Discussion on this question yet!
12 / 33
A database is a logically coherent collection of data with some inherent meaning, representing some aspect of real world and which is designed, built and populated with data for a specific purpose.
13 / 33
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.
14 / 33
The database and DBMS software together are called as Database system.
15 / 33
1. Reduces Data Redundancy
2. Maintains Data Consistent
3.Query to access data
4. Security
5. Easier access by tables
16 / 33
1. Redundant Data
2. Inconsistency
3. Not easy to access data.
4. No security
5. Concurrent access is not allowed.
17 / 33
ACID properties are 4 important properties of a transaction that a DBMS must ensure to maintain data in the case of concurrent access
18 / 33
Interpreter | Compiler |
---|---|
Translates program one statement at a time. | Scans the entire program and translates it as a whole into machine code. |
It takes less amount of time to analyze the source code but the overall execution time is slower. | It takes a large amount of time to analyze the source code but the overall execution time is comparatively faster. |
No intermediate object code is generated, hence are memory efficient. | Generates intermediate object code which further requires linking, hence requires more memory. |
Continues translating the program until the first error is met, in which case it stops. Hence debugging is easy. | It generates the error message only after scanning the whole program. Hence debugging is comparatively hard. |
Programming language like Python, Ruby use interpreters. | Programming language like C, C use compilers. |
19 / 33
No Discussion on this question yet!
20 / 33
No Discussion on this question yet!