Computer Architecture and Organization Kiran Book Notes

                         

1000 Questions IT Officer Ebook Video

Videos For 10 MCQ from IT officer Ebook........In this video i explain the 10 questions and elaborate the level of ebook.........So Download Now to Learn all 1000 Questions.........Link provided in Video description and also on my website.........

IT OFFICER EBOOK(1000 QUESTIONS)

DOWNLOAD NOW IT OFFICER EXAM EBOOK

(1000 QUESTIONS)

In this ebook ,1000 important questions given of following topics:

1)DBMS

2)ORACLE

3)COMPUTER NETWORKS

4)SOFTWARE ENGINEERING

5)OPERATING SYSTEM

6)WEB TECHNOLOGY

7)C/C++

8)COMPUTER FUNDAMENTAL

9)DATA STRUCTURE

These all questions are very important and must read before it officer exam.

10 MCQ of Computer Networks.....

1)In the Ethernet network, What method is used to access the media?
a)Demand priority
b)CSMA/CD
c)Polling
d)CSMA/CA
e)None of these

2)Which of the following Ethernet components is unique for each card created?
a)Frame Type
b)CRC Address
c)IRQ
d)MAC Address
e)None of these

3)ALOHA
a)is used for channel allocation problem
b)is use of data transfer
c)is buffering
d)all of the above
e)None of these

4)Which project 802 standard provides for a collision free protocol?
a)802.2
b)802.3
c)802.5
d)802.4
e)None of these

5)Unnumbering frame in HDLC are used for
a)Unnumbering a frame
b)Deleting a frame
c)System Management
dAdding frame 
e)None of these

6)The store and forward mechanism is used in..................
a)Packet switching
b)Message switching
c)Circuit switching
d)Datagram switching
e)None of these

7)Which one is the least expensive that can support 100Mbps?
a)Coaxial
b)UTP
c)Fibre-optic
d)STP
e)None of these

8)Broadband uses
a)Manchester encoding
b)FSK encoding
c)ASK encoding
d)PSK encoding
e)None of these

9)In CRC Checking, the divisor is ..............the CRC
a)One bit less than
b)One bit more than
c)The same size as
d)These bits more than
e)None of these

10)In the 1-persistent approach when a station finds an idle line, it...............
a)Waits 1s before sending
b)It waits for a random amount of time
c)Its sends immediately
d)Its sends 0.1 sec before sending
e)None of these



Answers:
1)b
2)d
3)a
4)c
5)c
6)b
7)b
8)d
9)b
10)c

Software Engineering Notes Part-1

Software Engineering is  an engineering approach for software development.The basic principle of software engineering is to use structured, formal and disciplined methods for building and using systems.The outcome of software engineering is an efficient and reliable software product.

Without using software engineering principles it would be difficult to develop large programs. In industry it is usually needed to develop large programs to accommodate multiple functions. A problem with developing such large commercial programs is that the complexity and difficulty levels  of  the  programs  increase  exponentially  with  their  sizes.  Software  engineering  helps  to reduce  this  programming  complexity.  Software  engineering  principles  use  two  important techniques  to  reduce  problem  complexity:  abstraction  and  decomposition.  The  principle  of abstraction  implies  that  a  problem  can  be  simplified  by  omitting  irrelevant  details.  In  other words, the main purpose of abstraction is to consider only those aspects of the problem that are relevant  for  certain  purpose  and  suppress  other  aspects  that  are  not  relevant  for  the  given purpose.  Once  the  simpler  problem  is  solved,  then  the  omitted  details  can  be  taken  into consideration to solve the next lower level abstraction, and so on. Abstraction is a powerful way of reducing the complexity of the problem. 
The other approach to tackle problem complexity is decomposition.  In  this  technique,  a  complex  problem  is  divided  into several  smaller  problems and then the smaller problems are solved one by one. However, in this technique any random decomposition of a problem into smaller parts will  not help. The problem has to be decomposed such that each component of the decomposed problem can be solved independently and then the solution  of  the  different  components  can  be  combined  to  get  the  full  solution.  A  good decomposition  of  a  problem  should  minimize  interactions  among  various  components. 

System Requirement Specification(SRS):
It is obtained after excessive discussions with the users.Software requirement specification (SRS) is a document that completely describes what the proposed software should do without describing how software will do it.SRS is important and difficult task of a System Analyst.

Characteristics of SRS:

• Correct
• Complete and Unambiguous
• Verifiable
• Consistent
• Traceable
• Modifiable

Software Life Cycle Models:

A  software  life  cycle  model  (also  called  process  model)  is  a  descriptive  and  diagrammatic representation of the software life cycle. A life cycle model represents  all the activities required to  make  a  software  product  transit  through  its  life  cycle  phases.  It  also  captures  the  order  in which these activities are to be undertaken. In other words, a life cycle model maps the different activities performed on a software product from its inception to retirement. Different life cycle models may map the basic development activities to phases in different ways. Thus, no matter which  life  cycle  model  is  followed,  the  basic  activities  are  included  in  all  life  cycle  models though the activities may be carried out in different orders in different life cycle models. During any life cycle phase, more than one activity may also be carried out. A software life cycle model is a particular abstraction representing a software life cycle.Such a model may be:

Activity-centered----Focusing on the activities of software development

Entity-centered----Focusing on the work products created by these activities

A software life cycle model is often referred to as a Software Development Life Cycle(SDLC).ISO/IEC 12207 is an international standard for software life-cycle processes. It aims to be the standard that defines all the tasks required for developing and maintaining software.

Waterfall Model:

The Waterfall Model was first Process Model to be introduced.

The waterfall Model is a linear sequential flow. In which progress is seen as flowing steadily downwards (like a waterfall) through the phases of software implementation. This means that any phase in the development process begins only if the previous phase is complete. The waterfall approach does not define the process to go back to the previous phase to handle changes in requirement. The waterfall approach is the earliest approach that was used for software development.

Requirement Gathering and Analysis	Capture all the possible requirement of the system to be developed and documented in a software requirement.
System Design	Helps in specifying hardware and system requirements and also helps in defining overall system architecture.
Implementation	With inputs from system design, the system is first developed in small programs called units, which are integrated in the next phase. Each unit is developed and tested for its functionality which is referred to as Unit Testing.
Integration and Testing	All the units developed in the implementation phase are integrated into a system after testing of each unit. During this phase, each module is unit tested to determine the correct working of all the individual modules. It involves testing each module in isolation as this is the most efficient way to debug the errors identified at this stage.
Integration and System Testing	During  the  integration  and  system  testing  phase,  the  modules  are integrated in a planned manner. The different modules making up a software product are almost never integrated in one shot. Integration is normally carried out incrementally over a number ofsteps.  During  each  integration  step,  the  partially  integrated  system  is  tested  and  a  set  of previously planned modules are added to it. Finally, when all the modules have been successfully integrated and tested, system testing  is carried out. The goal of system testing is to ensure that the developed system conforms to its requirements laid out in the SRS document. System testing usually consists of three different kinds of testing activities: α – testing: It is the system testing performed by the development team. β –testing: It is the system testing performed by a friendly set of customers. Acceptance testing: It is the system testing performed by the customer himself after the product delivery to determine whether to accept or reject the delivered product.
Deployment of System	Once the functional and non functional testing is done, the product is deployed in the customer environment or released into the market.
Maintenance	Maintenance of a typical software product requires much more than the  effort necessary  to  develop  the  product  itself.  Many  studies  carried  out  in  the  past  confirm  this  and indicate that the relative effort of development of a typical software product to its maintenance effort is roughly in the 40:60  ratios. Maintenance involves performing any one or more of the following three kinds of activities: Correcting errors that were not discovered during the product development phase. This is called corrective maintenance. Improving  the  implementation  of  the  system,  and  enhancing  the  functionalities  of  the system according to the customer’s requirements. This is called perfective maintenance. Porting  the  software  to  work  in  a  new  environment.  For  example,  porting  may  be required to get the software to work on a new computer platform or with a new operating system. This is called adaptive maintenance.

Advantages of waterfall model:

• This model is simple and easy to understand and use.
• It is easy to manage due to the rigidity of the model – each phase has specific deliverables and a review process.
• In this model phases are processed and completed one at a time. Phases do not overlap.
• Waterfall model works well for smaller projects where requirements are very well understood.

 Disadvantages of waterfall model:

• Once an application is in the testing stage, it is very difficult to go back and change something that was not well-thought out in the concept stage.
• No working software is produced until late during the life cycle.
• High amounts of risk and uncertainty.
• Not a good model for complex and object-oriented projects.
• Poor model for long and ongoing projects.
• Not suitable for the projects where requirements are at a moderate to high risk of changing.

When to use the waterfall model:

• This model is used only when the requirements are very well known, clear and fixed.
• Product definition is stable.
• Technology is understood.
• There are no ambiguous requirements
• Ample resources with required expertise are available freely
• The project is short.

Very less customer enter action is involved during the development of the product. Once the product is ready then only it can be demoed to the end users. Once the product is developed and if any failure occurs then the cost of fixing such issues are very high, because we need to update everywhere from document till the logic.

10 Previous Year MCQ of DBMS

1)Which privilege is required to create a database?
(A) SYSDBA
(B) DBA
(C) SYSOPER
(D) RESOURCE

2)Which Normal Form(NF) is considered adequate for normal relational database design?
(A) 2NF
(B) 5NF
(C) 4NF
(D) 3NF

3)A Foreign key in one table points to a ________ key in another table.
(A) Alternate
(B) Default
(C) Primary
(D) None of the above

4)In SQL, the spaces at the end of the string are removed by _______ function 
(A) Lower
(B) String
(C) Trim
(D) None of the above

5)The highest level in the hierarchy of data organization is called________
(A) data base
(B) data file
(C) data record
(D) None of the above

6)_______ is the process of organizing data into related tables.
(A) Generalization
(B) Normalization
(C) Specialization
(D) None of the above

7)Which of the following keyword can be used to return different values?
(A) SELECT
(B) GET
(C) OPEN
(D) DISTINCT

8)Which of the following field type is used to store photograph of employees?
(A) Memo
(B) Picture
(C) OLE
(D) Photo

9)Which of the following is standard interactive and programming language for getting information from and updating a database.
(A) SQL
(B) PHP
(C) ASP
(D) None of the above

10)Which TCL command is used to permanently save any transaction into database?
(A) rollback
(B) savepoint
(C) commit
(D) None of the above




Answers:
1)a
2)d
3)c
4)c
5)a
6)b
7)d
8)c
9)a
10)c

STRATEGY TO CRACK THE INDIAN BANK AND SYNDICATE BANK MANIPAL PO RECRUITMENT

WATCH THE FULL VIDEO FOR STRATEGY OF INDIAN BANK AND SYNDICATE BANK MANIPAL PO RECRUITMENT..............FOLLOW THESE STRATEGY AND CRACK THE EXAM.........

10 Important MCQ Of Oracle....

1)The shared pool is also able to support ________ in data warehousing applications.
A. Unshared SQL
B. Stored SQL
C. Unsorted SQL
D. Shared SQL 
E. None of these

2)An important purpose of the shared pool is to cache the executable versions of _________ statements.
A. SQL
B. PL/SQL 
C. Both (A) and (B)
D. MS ACESS
E. None of these

3)___________ Database is the only database specifically designed as an Internet development and deployment platform
A. Oracle 8i 
B. Oracle 9i
C. Oracle 6i
D. Oracle 7i 
E. None of these

4)Oracle 9i Reports is the solution of _______
A. Paper publishing
B. Web publishing
C. Both (A) and (B)
D. Publishing is not possible
E. None of these

5)When a query is submitted to oracle server for execution, oracle checks if same query has been executed previously. If found the same then this event is known as ________
A. Library cache hit
B. Soft parsing
C. Both (A) and (B)
D. Redo log
E. None of these

6)The ________ performs recovery when a failed instance starts up again.
A. Log Writer(LGWR)
B. Checkpoint(CKPT)
C. Process Monitor(PMON) 
D. System Monitor(SMON)
E. None of these

7) Oracle 9i Reports gives us _______options for building a Web report.
A. two
B. three
C. four
D. five
E. None of these

8)Which of the following is an example for Embedded SQL Statement?
A. ROLLBACK
B. SETROLE
C. ALTER SYSTEM
D. FETCH
E. None of these

9)Oracle Database segregates a small amount of the shared pool for large objects(Over 5KB).The segregated area of the shared pool is called ______
A. Fixed Pool
B. Allocated Pool
C. Reserved Pool
D. All of the above
E. None of the above

10)The ______ process is used for inter-instance locking in Real Application Clusters.
A. Lock Manager Server
B. Back Manager Server
C. Front Manager Server
D. Administration Manager
E. None of these



Answers:
1)a
2)c
3)b
4)c
5)c
6)d
7)a
8)d
9)c
10)a

Keys, Relationship and Extended E-R.....

Watch the Full Video to understand the concept of Keys, Relationship, Cardinality and Extended E-R

Snapshot in Oracle Key Points.........

A snapshot is a recent copy of a table from db or in some cases, a subset of rows/cols of a table. They are used to dynamically replicate the data between distributed databases.

Snapshot connected to a Single Master Site:

Snapshots can also contain a WHERE clause so that snapshot sites can contain customized data sets. Such snapshots can be helpful for regional offices or sales forces that do not require the complete corporate data set.When a snapshot is refreshed, Oracle must examine all of the changes to the master table to see if any apply to the snapshot. Therefore, if any changes where made to the master table since the last refresh, a snapshot refresh will take some time, even if the refresh does not apply any changes to the snapshot. If, however, no changes at all were made to the master table since the last refresh of a snapshot, the snapshot refresh should be very quick.

Snapshot and materialized view are almost same same but with one difference.
You can say that materialized view =snapshot + query rewrite functionality query rewrite functionality:In materialized view you can enable or disable query rewrite option. which means database server  will rewrite the query so as to give high performance. Query rewrite is based on some rewritten standards(by oracle itself).So the database server will follow these standards and rewrite the query written in the materialized view ,but this functionality is not there in snapshots.

Simple snapshots are the only type that can use the FAST REFRESH method. A snapshot is considered simple if the defining query meets the following criteria:

• It does not contain any DISTINCT or aggregation functions.
• It does not contain a GROUP BY or CONNECT BY clause.
• It does not perform set operations (UNION, UNION ALL, INTERSECT, etc.).
• It does not perform joins other than those used for subquery subsetting.
• Essentially, a simple snapshot is one that selects from a single table and that may or may not use a WHERE clause.

Note

Oracle8 extends the universe of simple snapshots with a feature known as subquery subsetting, described in the later section entitled “Subquery Subsetting.”

Not surprisingly, any snapshot that is not a simple snapshot is a complex  snapshot. Complex snapshots can only use COMPLETE refreshes, which are not always practical. For tables of more than about 100,000 rows, COMPLETE refreshes can be quite unwieldy.You can often avoid this situation by creating simple snapshots of individual tables at the master site and performing the offending query against the local snapshots.