Unit-5 2 Mark Question and Answer

  1. Define OLE.

OLE-Object Linking and Embedding OLE is a part of Windows 95; it providesthe component foundation of Microsoft’s desktop, enterprise and Internet/Intranetproducts.

  1. What are the client OS trends?

The client OS trends are:

• The desktop is becoming more fragmented.

• The web will generate a huge demand for documents.

• There will be huge demand for fat PC’s.

• Shippable places will become new desktops.

• Embedded clients will be everywhere.

  1. What are the cons of MAC OS?

Mac OS is not a very good server platform.

• It does not scale well and has limited multithreading options.

• It is also not a good advanced client platform.

  1. What are the cons of Windows 95?

• Windows 95 OOUI is inconsistent.

• Mixes GUI and OOUI paradigms.

• Still built on DOS;

• Not robust for corporate client market.

  1. What are the features of Windows NT workstation?

• Windows NT workstation is a robust 32-bit client OS. It supports preemptivemultitasking, multithreading, memory protection and a transactional file system. Network supports TCP/IP, NetBEUI, IPX/SPX, PPP and AppleTalk.

  1. What are the cons of Windows NT?

• NT workstation is a resource hog. It requires minimum of 16Mbytes RAM and512 Mbytes (disk).

• Support for laptop is poor.

• Limited PCMCIA support and power management.

• Does not support virtual device drivers.

• Does not support plug and play.

• Expensive client platform.

• Does not get the same level of ISV support as the rest of the windows platform.

  1. What are the cons of NT server?

• NT server does not scale well.

• Addition of processor makes it slow

• Does not provide an enterprise directory server; does not even integrate with

Other back office applications.

• Back up facilities are not good.

• Have security holes.

  1. What are the features of OS/2 warp server?

• OS/2 is an excellent application server. 32-bit Operating system incubates leadingedge server software including

• Lotus Notes and CORBA services. Auto detects hardware, easier to find and

configure network adapters. Provides disk mirroring, remote administration, remotesoftware distribution, a Back server, software metering.

  1. What are the cons of OS/2 warp server?

• OS/2 is an Intel-only server platform.

• OS/2 does not incur the extra burden of a portability layer.

  1. Define WinSock.

The windows socket API is known as Winsock, which is a multivendor specificationthat standardizes the use of TCP/IP under windows. The Winsock API is based on theBerkeley sockets interface.

  1. Define SQL.

SQL-Structured Query Language.

SQL is a standard language for accessing and manipulating databases.SQL (StructuredQuery Language) is a database computer language designed for the retrieval andmanagement of data in relational database management systems (RDBMS), database schema creation and modification, and database object access control .management.

  1. What are the features of SQL?

SQL has the following features:

  1. SQL is an interactive query language.
  1. SQL is a database programming language.
  1. SQL is a data definition and data administration language.
  1. SQL is the language of networked database servers.
  1. SQL helps protect the data in a multi-user networked environment.
  1. Mention few ISO standards of SQL.

ISO standards of SQL are:

SQL-89

SQL-92(also called SQL2) SQL-3

  1. What are the SQL database architectures?

There are three SQL database architectures namely: Process-per-client architecture.

  1. Multithreaded architecture.
  2. Hybrid architecture.
  1. Define stored procedure.
  1. stored procedure is a named collection of SQL statements and procedural logic that is complied, verified, and stored in the server database. Stored procedure is typically treated like any other database object and registered in the SQL catalog.
  1. Define static SQL.

Static SQL statements are defined in code and converted into an access plan at program preparation time. The SQL statement is known before program is running.

17. Define dynamic SQL.

Dynamic SQL statements are created and issued at run time. They offer maximum flexibility at the expense of execution speed. Dynamic SQL is an interpretive form of the SQL language.

18. Define Trigger.

Triggers are special user-defined functions usually in the form of stored procedures that are automatically invoked by the server based on data-related events. Triggers can perform complex actions and can use the full power of a procedural language.

  1. Mention two SQL middleware options.

The SQL middleware options include:

SQL nirvana: The single vendor operation. SQL nightmare: The multivendor operation.

  1. Define OLTP.

OLTP (online transaction processing) is a class of program that facilitates and manages transaction-oriented applications, typically for data entry and retrieval transactions in a number of industries, including banking, airlines, mail order, supermarkets, and manufacturers.

21. Define DSS.

Decision Support Systems (DSS) are used to analyze data and create reports. They provide the business professional and information hounds with means to obtainexactly the information they need. A successful decision-support system must provide user with flexible access to data and the tools to manipulate and present that data in all kinds of report formats.

  1. Define EIS.

Executive Information Systems (EIS) are powerful, easy-to-use, and business specific than DSS tools. They are certainly more expensive, which may explain why the “executive” attribute is in the name.

23. Define data warehouse.

Data warehouse is a central repository for all or significant parts of the data that an enterprise's various business systems collect. The term was coined by W. H. Inmon. IBM sometimes uses the term "information warehouse."Richard Hack thorn defines warehouse as “a collection of data objects that have been inventoried for distributionto a business community”.

  1. What are the elements of data warehousing?

Data warehousing includes four elements: The data replication manager

  1. The informational database.
  1. The information directory.
  1. EIS/DSS tool support.
  1. Define OLAP.

Online Analytical Processing, a category of software tools that provides analysis of data stored in a database. OLAP tools enable users to analyze different dimensions of multidimensional data. For example, it provides time series and trend analysis views. OLAP often is used in data mining.

16 Marks Question and answer

  1. Explain front end tools and Client server and internet
  2. Hidden fields
  3. A cookie
  4. Process-per client architecture
  5. Multithreaded architectures
  • Web client server
  • 3 tier client server web style
  • CGI
  • The server side of web
  • A CGI Scenario
  • CGI and State
  • Hidden Fields
  • Cookies
  • Middleware and federated databases
  • SQL Middleware: The options
  • SQL API
  • Open SQL Gateways
  • GroupWare Server
  • What is GroupWare?
  • Components of GroupWare
  • Multimedia document management
  • Workflow
  • Email
  • Group Conferencing
  • Group Scheduling

2.Obtain a listing of all windows and menus.

This will probably be in a library (PowerBuilder PBL files).

a. Review the icons and their functionality

b. Review the popup menus for completeness and consistency.

c. Review event lists

d. Review parent and child menus relationships.

3.Review the Database Management Interface.

a. Database painter

1. Create, alter, and drop tables

2. Drop views

3. Create and drop indices

4. Create, alter, and drop keys

5. Define and modify extended column attributes

b. Data Manipulation painter

1. Retrieve rows

2. Insert rows

3. Update rows

4. Delete rows

5. Save data

c. View painter

1. Create views

d. Database Administration painter

1. Define security

2. Execute SQL

e. Review display formats, edit styles and validation rules

f. Review the views

4. Explain about FRONT-END AUDIT STEPS

1. Determine what type of GUI the application is using

Using the definitions of the front-end GUI obtain the following:

The application name

The objects associated with the application

Procedures

Scripts

Functions

User or System Objects

The Menus associated with the application

Edits

Rules

Conditional Variables

The Database(s) associated with the application

Obtained by using the front-end but usually stored on the back-end

Tables for the Database

Columns

Default Values

Rules

Triggers

Determine what is stored on the front-end and in what format source or object

GUI

Procedures

Functions

Scripts

Objects

Determine who can modify the front-end

who has access to the source

who has access to the program generator

Determine how the modification is completed

Version control

Downloaded from the back-end (file server)

  1. Describe the case study account and financial system in detail

Financial services activities, including:

  • Database acceleration, including trade acceleration, routing, and management
  • Real-time processing of highly distributed data
  • High-volume market data capture for pricing
  • Risk management
  • Real-time P&L analysis
  • Portfolio management and accounting
  • Asset management
  • Straight-through processing for clearing and settlement
  • Real-time access to large market databases for advanced analytics
  • Market data and reference data management
  • Compliance