Technology Questions

SELECT statement has resulted in retrieval of more than one row.

- Physical Data Integration is all about creating new system that replicates data from the source systems.

- This process is done to manage the data independent of the original system.

- Data Warehouse is the example of Physical Data Integration.

- The benefits of PDI include data version management, combination of data from various sources, like mainframes, flat files, databases.

- A separate system is needed for handling vast data volumes.

Stack unwinding is a process of calling all destructors for all automatic objects constructed at run time when an exception is thrown. Destructors are called between the places where the exception was thrown and where it is caught.

• SBJson framework is supported by iOS.


• It is a JSON parser and generator for Objective-C (Objective-C is the primary programming language you use when writing software for OS X and iOS. It is a superset of the C-programming language and provides object-oriented capabilities and a dynamic runtime).


• SBJson provides flexible API's and additional control that makes JSON handling easy.

They get stored in System Catalog Views sys.server_principals and sys.sql_logins.

VSAM acts as an interface between Application program & Operating System.

Word and WordPad can save documents as ASCII text and HTML, but this approach can lead to problems. NotePad should launch with a new document open.

From the File pull-down menu, Select "Save As," save the file to the Desktop, and name the file using the ".html" extension (e.g., "home.html").

Data cleaning is also known as data scrubbing. Data cleaning is a process which ensures the set of data is correct and accurate. Data accuracy and consistency, data integration is checked during data cleaning. Data cleaning can be applied for a set of records or multiple sets of data which need to be merged.

Data cleaning is performed by reading all records in a set and verifying their accuracy. Typos and spelling errors are rectified. Mislabeled data if available is labeled and filed. Incomplete or missing entries are completed. Unrecoverable records are purged, for not to take space and inefficient operations.