Rational Rose Tools Interview Questions
..
..
aa
This section talks about how many tables are there and what data is lying in what table and what tables are there in production server? And also describes the relation between all the tables and how they are linked each other…etc..
It is basically the connection between deployment and production server. That is table names may differ in two servers but data will be same. Mapping between the tables that have the same data.
There are two types of operations in SQL. One is retrieval and other is modification. Where as BA only works with retrieval and not with modifications.
Ex: select customer_name from CUST where dept = 10.
The above statement retrieves all customers from CUST table who belong to department 10.
photo