Friday, September 4, 2009

DBMS Objective questions by anil nain 9416077273

DBMS Objective questions by anil nain 9416077273
CHAPTER-1
Solved examples
Fill in the blankhs
A DBMS is an interface between ______ and ______ requests. (physical databse, user)
The ______ sub-system provides facilities to optimise DBMS performance. (performance)
Protection and control of database access is the responsibilities of _______ sub-system. (security management)
One of the responsibilities of a ______ is to create database schema. (DBA)
A rectangle in ERD representstion represents ________. (entity set)

T/F
A database is large collection of rather unrelated data.(F)
Data independence is a desirable characteristic of a DBMS.(T)
Information is processed data.(T)
The desirable characteristics of data processing are speed, volume and accuracy.(T)
SQL is a universal database query language.(T)
Unsolved
Fill in the blanks
<<<<>>>>
T/F
1. Logical data independency is easier to achieve than physical data independence.
2. DDL and DML are two different names fo rthe same thing.
3. C and COBOL are examples of DBMS.
4. Query optimization means arranging the queries so that the response time is minimized.
5. The three models of database are heirarchy, network and relational.



CHAPTER-2
Solved
Fill in the blanks
Primary key is ______ level constraint. (column)
The maximum number of characters that can be stored in a CHAR type fo data is _____. (255)
_______ data type can store unstrucrured data. (raw)
_______ operation returns a sub-set of attribute set from a table.(projection)
_______ operation creates new table from two given tables.(join)

T/F
Average, maximumand minimum are aggregate functions that return a single value.(T)
Rollback is the act of undoing certain transaction back to a given point. (T)
Once COMITted the operations performed on database cannot be undone.(T)

Unsolved
Fill in the blanks
<<<<>>>>>
T/F
Referential constraints requires an attibute be used in two tables.
All primary keys are candidate keys but not vice-versa.
Every SELECT command must have one or two WHERE cluses in it.
SQL is the only database language.
Every table must have at least one primary key and three candidate keys.


CHAPTER-3

Solved examples
Fill in the blanks
A relation is in ______ if and only if it is in ___ NF and every non-key attribute is irreducibly dependent on the primary key. (2NF, 1)
______ is the process of relational databse design. (normalization)
T/F
If a table is in 2NF, it may be or may not be in 1NF. (F)
Fourth normal form uses multiple dependency criteria for relation decomposition.(T)

Unsolved
Fill in the blanks
<<>>>
T/F
A table is in 4NF if it is in 3NF and has no multiple sets of multivalued dependencies.
Normailization is an aid to database design.
BCNF has more merits than 3NF.
5NF is the maximum level of normalization possible in the normalization of databse.
Dependency is the basis of normalization.


CHAPTER-4
Solved examples
Fill in the blanks
Natural join is a _______operation. (commutaive)
The graphical representation of a query is ________. (query tree)
T/F
All the queries are equally faster. (F)
Natural join and cartesian product are one and the same operations.(T)

Unsolved
Fill in the blanks
<<<>>>
T/F
Canonical representation of a query tree is also minimum spanning tree.
The order in which operations are cariied out on a relation is significant for the execution speed.
In a cascade sequence of projections, the last one can be ignored.
The four operations of natural join, join, union and intersections are individually associateive.
Heuristics may be applied in query optimization.

CHAPTER-5
Solved examples
Fill in the blanks
A binary lock can have ______ states. (two)
In the ______phase the number of locks increases from zero to maximum. (growing)

T/F
Time stamp is a unique identifier to identify a transaction. (T)
2-phase locking does not guarantee strict schedule.(F)
Unsolved
Fill in the blanks
<<<<<>>>>
T/F
ACID are properties of a transaction.
More storage is neede to apply multiple concurrency techniques.
A red lock is also known as shared lock.
Locking technique always ensures serializability.
Concurrency can occur only in a multi-processor database systems.


CHAPTER-6
Solved examples
Fill in the blanks
Client-server architecture is used to implement _________. (distributed database)
________ implies that once a name is specified, the named objects can be accessed without additional specification.
T/F
A horizontal fragment of a relation is a subset of the tuples in that relation.(T)
Semijoin operations intend to reduce the number of tuples in a relation before it is tranferred.

Unsolved
Fill in the blanks
A _______ is that part of distributed system which makes a request to other parts for a service.
Distributes transparency means _____.
____ is a multidatabase system.
A set of vertical fragments of a relation R, whose projection lists include all the attributes in R but share only the primary key attribute is called _________ vertical fragmentation of R.
To reconstrct a relation from a vertical fragments sequence of ________ operations is employed.

T/F
A client may act as a server for another application.
A distributed database may be highly redundant for performance improvement.
A distributed database uses network to communicate with its components.
Location transparency means that the database should behave differently depending on the location from which iit is being accessed.
Distributed database query optimization focuses on reducing the size of the fragments to be transferred.

Monday, August 17, 2009

UGC NET (NATIONAL ELIGIBILITY TEST) FOR JRF AND ELIGIBILITY FOR LECTURSHIP QUESTION PAPER by anil nain 9416077273

MODEL TESTPAPER(by anil kumar nain)
Section (1) contains 5 Question each carry 5 marks.
Section (11) contains 15 Question each carry 5 marks.
Section (111) contains 5 Question each carry 12 marks.
Section (1V) contains 1 Question each carry 40 marks.
5X5=25
Suppose we wish to degine software for a web based Examination application and hall ticket generation
15X5=75

FIFO page replacement is used with for initial empty pages trams and eight pages. How many pages faults will occur for the references string 0172337103?
What do you mean by authoring tool give its application also. What are various types of authoring tools?
Define phrase structure grammar of type 0,1,2,3 with an example of each.
what are three major multiplexing technique(tamp) and show that
If A=>B then ~B=> ~A.
What are advantages of combining segmentation of paging together?
Differentiates between software engineering and software reveres engineering.
Explain rapid app. Development model with its various RAD.
What is index fast full scan in oracle. Why does it not grant that the output will in shorted order of the index.
Explain how the concept of object identify in object oriented mode define the concept of tuple.
Write on 9085 assembly language program that finds the 2’s complement of again 8 bit integer.
With reference to the worst case behavior determine the complexity of binary search.
Determine the product 1234*758 using divide and conquer technique.
Discuses XML architecture.
Distinguish between Moore and mealytinity sate machining.
State in algorithm for converting a transitive graph into a regular expression with explanations.

5x12=60
Half man tree.
Encoding and decoding of L2 codes.
Main goals of JPEG compression images.
Fourier transforms.
Neural Network sun throughputs fuzzy system sum output.
f(x)=1/1+ex
Switch function x1+x2x3.
LCM Divisible.

One essay type question with internal options 40 marks
Describe the back propagation algorithm assure a feed forward neural network topology with single hidden lodger.
UNIX files protection. What is fiber obstruction providing by xp? How it differ from threads obstruction

Tuesday, June 30, 2009

Anil Nain experience with interview question

Anil Nain(9416077273) experience with interview question
1.) If Interview Asks a question and if i dont know the answer,what i have to do?can i say wrong answer?
If you don’t know the answer fo the question asked by the interviwer , never say wrong answer.Tak atleast few seconds and say , i am sorry sir/madam , at this moment i haven’t able to answer you , i will make sure that i will update my knowledge soon.
The above points makes you to present your frankness and your presentation abilities.
2.) What to answer and what not to answer for "Tell me something about you"?
hi,This kind of questions are best answered by focusing on 5 to 6 strong selling points of yours. when asking this question, the interview is not looking for your history of school work and employment but kind of giving you a chance to sell yourself in about 60 seconds. Why 60 seconds? Try to limit your answers to 60 seconds as far as possible because if you go on talking about your past at length then the interviewer might loose interest in you and the interview might end at that very point. The answer should include your achievements, skills and talents that would enable you to succeed in the position that is being discussed.Make a short, organized statement of your education and professional achievements and professional goals. Then, briefly describe your qualifications for the job and the contributions you could make to the organization.
3.) Would you be willing to relocate if required?
If I get a better learning oppurtunity & growth, then certainly yes. Otherwise, I have to think how much it is feasible from organization's point of view.
4.) What if we don't hire you?
Well, your current position will still remain open and you have to interview atleast one more person.It may be difficult for you to find a more dedicated and knowledgable person than myself. As for me, I have to continue my search for excellent and best in class company where I can get challenging and rewarding work experiance. I thought we had win-win situation.
5.) If you were hiring a person for this job, what would you look for?
In my point of view I would recommend the following things: 1. Required skills for the role.2.Can work in team3.Pro-activeness 4.Loyalty to the work.
6.) Speak about yourself professionally?
You should highlight your projects and your experience with other companies if you have worked with other comapnies.

Wednesday, June 10, 2009

Flash developer and instructor anil nain 9416077273 sonepat haryana

Anil nain 9416077273 has been working in Flash since version 4, focusing mainly on ActionScript. He has been certified as a Flash developer and instructor and now works as a Media Specialist for Ocean Systems Engineering focusing on web-based training. anil also has contributed articles to FlashMagazine.com as well as the MX Developers Journal. He also co-founded EMLlabs.com with Eddie Wilson as a tutorial based site for intermediate to advanced Flash usage. anil is also a very devoted supporter of snowboarding whenever free time and cold weather present themselves.

Thursday, June 4, 2009

technology anil nain most powerfull idea

Technologyanil nain 9416077273Light produced by a computer monitor is not constant. As you read this article, you are viewing approximately 30 separate images a second. Your brain rejects the information it doesn't want to see, and blocks out the frequent moments that your screen is blank. With this in mind, it is important not to make the colors on your web site too busy. This produces unnecessary strain on your eyes. Harsh, contrasting colors should be avoided. Giving people headaches does not aid in selling products!
It should also be noted that there are four factors that determine how color is rendered on your computer monitor: the CPU (the computer's brain), the computer platform (Windows, Mac OS, etc.), the video card, and the monitor itself. What you see may not be what others see. In some cases, royal red may appear as hot pink. Navy blue may look black. During the development process, try to view your site on different computers.
So what do you do?
You may find, in many cases, trial and error is the only way to determine what works. Be patient, and don't hesitate to make changes. The factors in determining color schemes of a web site, or any advertising for that matter, require careful consideration. Remember... Symbolism, Psychology, Gender, and Technology... Color does matter.