Sunday, November 28, 2010

The ' PROJECT '

Hi don't remember the coding languages like(C, C++, Java, COBOL) as this is not about my any final year project, are any project that i have done so far, they are required and you can buy them.But this is about ours(every ones) final Project, and it will be.

Famous Book Writer writes Years are Short, The Days are Long is 100% correct. She started this project for her daughter.
Each day Gretchen Rubin posts about her adventures as she test-drive popular tips, current scientific studies, and the wisdom of the ages about how to be happy—She report on what really works. I hope you’ll visit the blog and post your own experiences and suggestions.

I guess you definitely like this, Many things you can get out of her blog, make a book mark or subscribe to her mailing lists.


Monday, November 22, 2010

BMTC Bus Routes, Bus Numbers, Bangalore.

BMTC- Stands for Bangalore Metropolitan Transport Corporation, is the only means of transporatation which covers entire city.
More info on the type of buses available at Travel Info.
From last 4 months it has started a concept called Bus Day, on 4th of every month. This kind of things may avoid Traffic a little bit, but definitely  needs a co-operations from the people who travel in and around the city on that day.
BMTC has one among the top BUS Service in the country, but still has got lot of loop holes to fill.
I will keep posting my 6 years Experience with BMTC under the above title.

New K Series buses from BMTC, these buses are very useful if you have a long journey in city every day without catching any other bus and to reach with minimal traffic. The route chosen by this buses are all minimal congested areas and wont connect to Mejestic/Market which are heavy congested points in the city. Since these are all new buses, many people not aware of their timings and routes information's.
i.e.
K1
Connects Yeshwantpur to St. Johns Hospital.
St. Johns Hospital * Koramangala Complex* Koramangala 80 Ft Rd* Ejipura* Domlur Bus Stand* Military Hospital* Trinity Church* Mayo Hall* Brv College* Indian Express Circle* Cunningham Rd* Vasanthanagara Temple* Mekhri Circe* Cpri Gate* Yeshwanthpur Bus Stand

K2
Starts from Hebbal Bridge near railway Gate to  Mysore Road Satellite Terminal.
 *Hebbal *Naga Shetty Halli* M S Ramaiah Col * Sadashivanagar Police Staion* Yeshwanthpur Bus Stand* Govt Soap Factory * Iskon Temple* Rajajinagar 1st Block* Shankarmutt* Havanur Circle* Khb Colony* Vijayanagar Bus Stand * Attiguppe * Mysore Road Satellite Terminal.

These K series buses routes are very long and K2 bus takes 1.30 mins to reach Mejestic and taking 2-3 buses to reach from Hebbal to satallite town bus stand. without much traffic which is very good especially in the evening time so that we can avoid going to Me. we can find buses every half an hour, you can see the timings of each bus of K2 in hebbal bus stand which is under hebbal bridge.

K3
Connects VijayNagar to Koramangala.
* Vijayanagar Bus Stand* Attiguppe* Mysore Road Satellite Terminal* Sirsi Circle* Chamrajpet* *Ramakrishna Ashrama * Basavanagudi Polce Station* Nettakallappa Circle* Shanthi Talkies* South End Circle* Jayanagar Bus Stand * Carmel Convent School* Bangalore Dairy* Krupanidhi College* St. Johns Hospital* Koramangala Complex.

Bangalore Transport Information System

This web site is having all that you need about BMTC.
I insist you to have look at the site BITS to check about BMTC Buses and routes and city Traffic updates on to your mobile, which is must required feature for sillicon valley Bangalore.
Happy Traveling, Have a Safe Journey avoid traffic Jam.

Friday, November 12, 2010

DB2 Contd...

Here i bought some more questions.

1.       RUNSTATS Command can be used  to get the statistics about given  choices
a)      Table
b)      Database
c)       Row
d)      Index, all of the  above was also given. 
2.       Whats the command to combine the Full copy and Incremental copy given  4 different copy commnds to choose.
a)      Copy
b)      Load
c)       Merge copy and one more option was given.
1.       Is it possible for the application programmers to change the value of Current SQLID register value.
Choces true or false.
2.       Given an Co-related Sub Query with stmt like
Update table2 set val1= val1 + 50
Where val1 in (select * from table1);
Asked to chose the number of rows updated by giving choices.
3.       When a Distributed Data Facility is Planned then which of the skill is not required
a)      DBA
b)      Strategist
c)       Business Analyst
d)      LAN administrator.
4.       Question was given on Whats Index key, is used for ?
Giving 4 choices, find it difficult to answer.
5.        Whats 1NF?
Choices was given on 2NF and 3NF defintions and none of the above.
6.       One Question was based on refrences keyword .
7.       One question was given on Column name on Group by and Order by clause and its select statements regarding the column names. This question most of them will know the answer, its an important Question I Say. Set of statements were given to choose the right one.
8.       Question was on Isolation levels.
Phantom Penomenan can occur in
a)      CS
b)      RR
c)       RS
d)      UR
e)      All of the above.
9.       Which statement is used to give a privileges to the user?
10.   Which of the fallowing is a valid column name.
a)      EMPLOYEE_name.
b)      Employee-name.
c)       10Employee Name.
d)      And one more wrong option.

11.   Again there was a question on column names and their constrants of table with stmts 
a)      all the column names must be unique in a table
b)      all the columns can be defined with unique constraint
c)       Unique constraints can be defined on a same set of columns.
d)      bit tricky we need to chose the right answer.

Wednesday, November 10, 2010

DB2 Continued...


1.      From the fallowing statements choose the right option
A. Double can be used fro numbers ranging from 23digits to 53 digits.
 B. Size of the doble data type is 8 bytes.
a)      Only A is true and B is False.                                                
b)      Both A & B are Flase.
c)       A is false and B is Also false.
d)      Both A and B are true.
2.       Whats is Meant by cartesian Product.
a.       Its a row from the every combination of the joining tables.
b.      Its a row from ...
c.       Its a roe from ..
d.      Like this   4 options were given.
3.       The question was bit easy  and asked on Incremental Copy of the table(which kind of copy is used ?  they  have mentioned the situation.
4.       Q was like this defined on table create statements with  create stmt was given and one of the columns is defined as  ‘Blo clob(1000) loggedpicture Blob(24M)’ . Given the two state ments on this declarations to identify their correctenes. The question was asked like “if the value of the above column is changed will it going to log each of the changes to the column”.
5.       Foriegn Key
a)       Can not be Null.
b)      Must Match with the Unique Key of the Parent Table.(they have not mentioned as primary key.. and i did not go with this answer).
c)       Can have duplicates.
d)      None of these. 
6.       How to close the Access to a User
a)      SQL Remove
b)      SQL reovke
c)       One more choice
d)      Both A and B.
7.       For this question i could not get the right answer,
On a workstation platform  which of the fallowing locks can not be obtained.
Page.
Table.
Row.
All of the above.(i guess it should be none of the above).
8.       Access Startergy for a Static SQL statement is stored in the package permanently be a bind process. Give True or  False as choices.
9.       Using ‘Alter Table’ Statement its  not possible to (tricky qn ).
a.       Add a new Column.
b.      Alter the columnn Constraints.
c.       Alter the name of the column.
d.      Drop the Column.
Whats your Answer reply me?
When a  Drop Table command is given on a table choose the right statements
A: Table data is deleted from the table.
B:Catalogue Tables are updated. 
Whhich of the SQl tool Supports ‘Format Report Option’ given following choice to select.
a)      SPUFI
b)      Command Center
c)       QMF.
d)      One more tool name was given.

Data Base Fundamentals and Concepts.

Hi Guys, I could remember Some Questions from my Exam. I will keep on posting here, for more Questions keep visit my blog soon.
1.When all the processors are working on same job we call it as
Multi Processor Paritioned Execution.
Massively Parllel Processing.
Multi Processor Program Execution.
And two more options.
2.Version recovery is not possible in ______
Mentioned two OS Unix/Linux, windows
3.Which of the fallowing is not a type of access privilige
a)Implicit.
b)Explicit.
c)Direct.
d)Indirect.
4.Possible ways to delete database Objects in a database.
a)Remove
b)Delete
c)Drop
d)And one more command was mentioned.
5.DB2Extenders are ____________ from DB2_________ Code.
a)Inluded with & Server.
b)Separated and Server
c)And two more options are given, the Qn is mainly on DB2 extenders are included with DB2 server Code or Not.
6.From the fallowing statements choose the right option
A. Double can be used fro numbers ranging from 23digits to 53 digits.
B. Size of the doble data type is 8 bytes.
a)Only A is true and B is False.
b)Both A & B are Flase.
c)A is false and B is Also false.
d)Both A and B are true.