CodeInclude

Learn about Exalytics, Exadata and Exalogic - Oracle

2017-10-13T02:30:00.003+06:00

1) What is Oracle Exalytics?

2) What components come with Exalytics?
3) Is there a demonstration of Exalytics anywhere?
4) What is the difference between Exalytics, Exadata and Exalogic?
5) I already have Oracle BI 11g, does Exalytics replace my existing hardware?
6) What is TimesTen?
7) How does the TimesTen in-memory database get populated?
8) Can we cache further data into the in-memory database whilst the system is running?
9) Using the in-memory database seems to be similar to BI Server "caching", is this true?
10) My data is not stored in an Oracle database, can I still use Exalytics?
11) It sounds fantastic, but does Exalytics have any limitations?
12) I don't currently use Essbase, so how would I use the Essbase component on Exalytics?
13) I have more than 1TB of data, can I still use Exalytics?
14) Does Exalytics support real-time Business Intelligence?
15) Does this mean I no longer need a Data Warehouse?
16) With Exalytics can I still use Maps, Mobile Analytics (iPad) and Balance Scorecards?
17) How is Exalytics licensed?
18) I am already licensed for Oracle BI 11g, can I migrate my existing licenses?
19) How has Essbase changed for Exalytics?
20) Once the box arrives, do I have to install Exalytics or is it all pre-installed?
21) What happens if I load in more data than TimesTen's memory capacity?
22) What happens if I reboot the machine, do I lose my in-memory cache?

ANSWERS

1) What is Oracle Exalytics?

Oracle Exalytics is a new "BI machine" designed specifically for Business Intelligence and Enterprise Performance Management. With a massive 1TB RAM and 40 CPU cores, this machine can and will take performance to a level never seen before.

The reason why performance is to extreme is that the Exalytics architecture is designed to store your business intelligence data in main memory, this means response time is dramatically faster with no network latency or disk I/O.

The term "speed of thought" has already been used a lot with Exalytics - this is referring to the fact that your reports run so quickly that they refresh with new data even whilst you are typing in the filter criteria.

2) What components come with Exalytics?

Exalytics is a pre-installed / pre-configured machine running on Linux 64-bit. It comes with 3 main software components:

- Oracle BI Foundation 11g (OBIEE release 11.1.1.6)
- Oracle TimesTen (in-memory database)
- Oracle Essbase 11g (memory optimized)

3) Is there a demonstration of Exalytics anywhere?

Yes, see this recorded demonstration on YouTube: http://www.youtube.com/watch?v=oLLic4ytFsw

4) What is the difference between Exalytics, Exadata and Exalogic?

Fundamentally, the three "Exa" machines built by Oracle are designed to overcome bottlenecks in either one of 3 areas: Memory, Disk, CPU

Memory:	Exalytics is designed to massively boost performance of Business Intelligence queries by processing vast amounts of data in memory
Disk:	Exadata is designed to optimise the performance of large databases where most of the query overhead is experienced whilst reading or writing from disk
CPU:	Exalogic is designed for large application servers (e.g. server farms, data centres, virtualization) with massively parallel and scalable CPU performance

5) I already have Oracle BI 11g, does Exalytics replace my existing hardware?

Yes. Your existing Oracle BI 11g application would be migrated in its entirety to the new Exalytics machine.

6) What is TimesTen?

TimesTen is Oracle's "in-memory" database - this means it stores all its data in memory so there is no disk overhead. Historically TimesTen has been used for applications which require lightning fast real-time data management. For example: Banks would use TimesTen to do fraud checks in a fraction of a second.

With the introduction of Exalytics, TimesTen has been enhanced to support analytical processing for business intelligence queries. For Exalytics, your Oracle BI 11g queries will be directed against the TimesTen in-memory database cache rather than your underlying data sources.

TimesTen also comes with "columnar compression" which means that columns of data (e.g. Customer Name) are compressed at ratios of upto 5x to help expand the amount of data that can be stored in memory.

7) How does the TimesTen in-memory database get populated?

The TimesTen in-memory database actually gets populated dynamically by the Oracle BI 11g server - so you don't have to manually write any scripts. The mechanism is actually an enhanced form of the "Aggregate Persistence Wizard" which has been a feature of Oracle BI since version 10g.

With Exalytics, a "storage advisor" can be used to automatically analyse the usage of your BI deployment (i.e. the queries initiated by your end users) and make recommendations as to what data should be cached in TimesTen. You can then accept these recommendations (if you wish to do so) or you can make your own decisions.

The cache structures within the TimesTen database will reflect the structure of the "Business Model" within your BI Repository (RPD).

So if you have a logical dimension table "Dim - Account" with three columns "Account ID", "Account Name", "Account Type" then a table will exist on the TimesTen in-memory database with a similar structure. Note that if you choose to cache your data at the higher "Account Type" level then obviously the in-memory database will not contain any data for "Account Id" or "Account Name".

For your fact logical tables, the TimesTen in-memory database will also contain tables to cache your logical facts. So there will be columns to store "$ Revenue" and then surrogate keys to join to the related dimension structures on the in-memory database (e.g. for Dim - Account).

The actual physical tables created automatically on TimesTen will have system generated names.

8) Can we cache further data into the in-memory database whilst the system is running?

The answer from Oracle Product Development is "yes". So if a new BI Dashboard is published during the week then you can dynamically start caching the underlying data into the TimesTen in-memory database without any downtime.

9) The in-memory database seems to be similar to BI Server "caching", is this true?

No, not really! BI Server caching is for caching the end results of "Logical SQL" queries. With Exalytics, the TimesTen in-memory database caches data in structures that resemble the Business Model in your RPD.

BI Server caching is optimized for lots of small results sets whereas TimesTen in-memory database can handle upto 5TB of cached data (making use of compression). BI Server caching is also a file-based cache, whereas TimesTen data will reside totally in RAM.

There is no reason however why you should not also use BI Server caching Exalytics - as it will cache the results of any ad hoc or other queries which were previously not sourced directly from the TimesTen in-memory database. The BI Server cache on an Exalytics machine can be tuned to reside on a "RAM disk" so it also benefits from in-memory capability.

10) My data is not stored in an Oracle database, can I still use Exalytics?

Yes, definitely. Because the TimesTen in-memory database is populated through the Oracle BI 11g Server, the underlying data can be stored in just about any type of database.

11) It sounds fantastic, but does Exalytics have any limitations?

So far the signs are extremely positive and Oracle have conducted several successful pilots with "beta" customers. However, there are a few limitations which are worth highlighting, the first of which is common to all "aggregate layers" within a BI architecture:

1) To make use of the TimesTen in-memory database, your calculations must be "additive" i.e. you must be able to accurately derive the calculation results from the data stored in the TimesTen cache. So you will need to take care when performing averages, for example. COUNT DISTINCT operations are also non-additive.

2) In order to make use of the TimesTen in-memory database, you need to bulk load data into it. So this means there will be an extra task at the end of your ETL cycles to repopulate the entire TimesTen cache. Exalytics comes with extremely fast network cards so data transfer can be rapid, and there is even an Infiniband (40GB/s) connection to connect to an Exadata machine. There is a "double buffering" technique with high-availability architectures which could potentially simulate incremental and trickle-feed loading.

UPDATED: Incremental loading for Exalytics is now possible using Peak ETA! Please visit the Peak ETA Product Overview page for details on how Peak ETA can significantly enhance the capabilities provided by the Exalytics "Summary Advisor" by incrementally loading TimesTen in-memory aggregates and in parallel.

3) We have seen that Ragged, Skipped-Level and Parent-Child hierarchies are not supported. So this means only level-based hierarchies are supported, for the time being at least.

12) I don't currently use Essbase, so how would I use the Essbase component on Exalytics?

The memory-optimised Essbase that ships with Exalytics is designed to replace your existing Essbase cubes and boost the performance of your EPM applications. If you don't currently use Essbase then your initial focus should be on the Oracle BI 11g Foundation and TimesTen components of Exalytics. However there is nothing to stop you from using the Essbase functionality whenver it suits you!

13) I have more than 1TB of data, can I still use Exalytics?

First of all, it is worth pointing out that although the Exalytics machine comes with 1TB of RAM, the reality is that around 400GB will be available for your "in-memory" data. The reason is that the TimesTen has two main memory configuration parameters:

- PermSize: The permanent memory region - this is where your data is stored
- TempSize: The temporary memory region (used for sorts etc)

The recommended setting for both of these memory regions will be 400GB, consuming a total of 800GB RAM. This will leave approximately 200GB for OBIEE and any other overheads.

However, despite the 400GB recommended limit, TimesTen also has a compression feature so that you could potentially fit 5x more in to your in-memory cache.

You should also remember that Exalytics is designed to be an "aggregate" layer, so you shouldn't really be thinking about loading ALL you data into the TimesTen in-memory cache. Instead, you should aim to load in as much summarised data as possible.

So if you have >1TB of data then you can still use Exalytics!

NOTE: The memory-optimised Essbase component does not have a compression feature.

14) Does Exalytics support real-time Business Intelligence?

Yes and no. Your Exalytics queries do not all have to come from the TimesTen in-memory database, so you could report directly off your live transactional database and perform real-time BI.

However, as things currently stand, the Exalytics TimesTen in-memory database is not configured for "trickle-feed" incremental loading to support near-real-time BI. So if you need to boost the performance of your real-time database queries then Exalytics may not be the answer for you.

As stated above, there is a "double buffering" technique with high-availability architectures which could potentially simulate incremental and trickle-feed loading.

15) Does this mean I no longer need a Data Warehouse?

Absolutely not! Data Warehouses are fundamental when it comes to data consolodation, cleansing and scalability (for storing enormous quantites of data in a format suitable for reporting purposes).

You should view Exalytics as an "aggregate" or "performance" layer in your architecture - sitting on top of your Data Warehouse (such as Exadata).

16) With Exalytics can I still use Maps, Mobile Analytics (iPad), and Balance Scorecards?

Yes, the entire range of features available with the Oracle BI 11g Foundation suite is supported.

17) How is Exalytics licensed?

As always, you should contact your Oracle Sales Rep to gain full clairity on the license situation. But just as a guidance, licensing will typically be done on a per user basis:

- Minimum 100 named users for both Times Ten & BI Foundation Suite
- Existing customers of OBIEE or BI Foundation Suite can migrate licenses to Exalytics

Exalytics supports clustered solutions for disaster recovery and high availability:

- Requires a minimum of 2 hardware machines
- You need to also have a Weblogic Server Enterprise Edition full license

The accurate pricing is available on Oracle's price list. To avoid reporting incorrect pricing figures, we will not hard code any pricing or links in this FAQ! However, you can search on Google for things such as "exalytics license cost" to get the latest information.

18) I am already licensed for Oracle BI 11g, can I migrate my existing licenses?

Yes, see question 17.

19) How has Essbase changed for Exalytics?

Essbase on Exalytics has a number of optimizations for in-memory operation including improvements to overall storage layer performance, enhancements to parallel operations, enhanced MDX syntax and a high performance MDX query engine. Essbase on Exalytics provides up to 16X faster query execution as well as up to 6X reduction in write-back and calculation operations, including batch processes. These enhancements are particularly important for advanced use cases such as planning and forecasting.

20) Once the box arrives, do I have to install Exalytics or is it all pre-installed?

Once you have the box plugged in you will then need to download and install the Exalytics software components: OBIEE, TimesTen and Essbase (Optional).
There are two main reasons for this:

1) You are always downloading and installing the latest software version
2) You are not tied down to a specific hostname or network configuration

A utility is provided to fully install and configure OBIEE and TimesTen together.

21) What happens if I load in more data than TimesTen's memory capacity?

The short answer to this is that you can't! TimesTen is designed to work with all data in memory. So if TimesTen has 400GB allocated to your data, then you will not be able to load in more than this. If you try then you'll get an error!

22) What happens if I reboot the machine, do I lose my in-memory cache?

Although TimesTen is an in-memory database, the data is actually also stored on disk. So if you reboot the Exalytics machine then you won't lose your data! When you start up the TimesTen services after the reboot it will load all the data from disk into main memory.

NOTE: to avoid data loss/inconsistency you should always shut down TimesTen services gracefully before you reboot the machine.

How to Copy Arabic text to MS Word

2017-05-30T16:41:00.000+06:00

Question: How to enable right-to-left language support for Word 2003 and Word 2002 on computers that are running on Windows Server 2003, on Windows XP, or on Windows 2000

Solution: The reverse paste problem can be solved by doing the following settings.

Configure the Microsoft Office Language Settings

Click Start, point to All Programs, and then do one of the following:
- Point to Microsoft Office, point to Microsoft Office Tools, and then click Microsoft Office 2003 Language Settings.
- Point to Microsoft Office XP Tools, and then click Microsoft Office XP Language Settings.
On the Enabled Languages tab, verify that the language that you want to proof is included in the Enabled languages list.
If the User Interface tab is available, follow these steps:
- In the Display menus and dialog boxes in list, select the language that you want the menus and dialog boxes to be displayed in.
- In the Display Help in list, select the language that you want the Help files to be displayed in.
Note The User Interface option is only available if you installed the Multilingual User Interface Pack.

( Copy and Paste Arabic text into Word )

After doing above configuration, you can correctly paste in arabic. It will solve the problem of reverse arabic text.

For More details , Visit : Microsoft Support for Language

Shutdown Timer shortcut in Windows

2017-03-22T20:31:00.000+06:00

How To create Shutdown Timer shortcut in Windows from textfile.

METHOD # 1
Do you know that you can make your PC shutdown at a time u wish to?

Here is the trick!!
How To Make A Shutdown Timer!

Step 1:

Right click on your desktop and choose "New=>shortcuts".

Step 2:

In the box that says "Type the location of the shortcut",
type in "shutdown -s -t 3600" without the quotation marks and click next.

Note: 3600 are the amount of seconds before your computer shuts down. So , 60secs*60mins=3600secs.

Step 3:

Make up a name for the shortcut and you're done.
You can change the icon by right clicking=>properities=>change icon=>browse.

To abort

To make an abort key to stop the shutdown timer just create another shortcut and make
the "location of the shortcut" to "shutdown -a" without the quotes.

METHOD # 2
Here is another trick to shutdown at a specific time, for example you wish to shutdown at 11:35am. Type this in CODE

Go to start=>Run

Write:


at 11:35 shutdown -s

And click ok.

To Abort:


shutdown -a

Note: all time are in 24hr, example u would like to shutdown at 8:30pm, you should type

at 20:30 shutdown -s

METHOD # 3
you can use a batch for that as well it makes it easier to use just run the batch and enter the time you want it to shutdown

Open notepad.

Write below code block:


@echo off

title Scheduled Shutdown Batch Example by chacha1234
color A
echo Enter Time To Shutdown (example 19:30)
set /p stime=
cls
at %stime% ""shutdown -s -t 00"" >nul
echo Your PC Will Auto Shutdown At %stime%
echo Press Any Key To Exit
pause >nul
exit

Save as with file name : shutdown.bat

Get ip address using PHP

2017-02-09T02:19:00.000+06:00

To get the ip address of the visitor / user , use the following PHP code section :

<?php
//returns the ip of the user / visitor
$ip = $_SERVER['REMOTE_ADDR'];
?>

Here ,
$ip is the variable which holds the ip address .
$_SERVER is used to get information about server and execution.
REMOTE_ADDR is the environment variable which holds the ip address of the user.

Using JSON inside PHP

2017-02-08T19:50:00.000+06:00

JSON (JavaScript Object Notation) allows to pass data between server and web application similar to XML .
PHP: Hypertext Preprocessor , is ueed for creating dynamic web pages. It can be used inside HTML as input and the output can be in HTML too.

PHP has two functions to handle JSON objects.
1) json_decode( )
    It takes a JSON encoded string input , and returns into PHP variable

2) json_encode( )
    It takes PHP variable and return JSON representation of the value

There is another function useful in case of debugging :
    json_last_error()
    It returns the last error due to recent JSON parsing.

Example #1 (php code) use of json_encode()

<?php
$arr = array ('a'=>1,'b'=>2,'c'=>3,'d'=>4,'e'=>5);

echo json_encode($arr);
?>

Output:

{"a":1,"b":2,"c":3,"d":4,"e":5}

Example #2 (php code) using json_decode()

<?php
$json = '{"a":1,"b":2,"c":3,"d":4,"e":5}';

var_dump(json_decode($json));
var_dump(json_decode($json, true));

?>

Output :

object(stdClass)#1 (5) {
    ["a"] => int(1)
    ["b"] => int(2)
    ["c"] => int(3)
    ["d"] => int(4)
    ["e"] => int(5)
}

array(5) {
    ["a"] => int(1)
    ["b"] => int(2)
    ["c"] => int(3)
    ["d"] => int(4)
    ["e"] => int(5)
}

PHP $$variable Double dollar sign Meaning

2017-02-07T18:59:00.000+06:00

In PHP language, $(dollar sign) is used to store variable data. $$ can be used to store variable of a variable. Data stored in $ is fixed while data stored in $$(double dollar sign) can be changed dynamically.

such as:

$a represents a variable

$$a represents a variable with the content of $a

Example:

$test = "hello world";$a = "test";echo $$a;

Output will be hello world

Explanation :

$$a = $($a) = $(test) = $test = hello world

Double dollar is a powerful way to programmatically create variables and assign values them.

Another Example:

$a = “amount”;
$$a =1000;
echo $amount; //echo’s 1000 on screen

Write HTML in PHP

2017-02-06T13:51:00.000+06:00

With print command , you can output HTML code inside php.

Sample code :

<?php

print("<b>This is Bolded</b>");

?>

To use quotes inside print command , use \" inside code.

<?php

print("<a href=\"http://www.google.com\">Visit Google</a>");

?>

With echo , html output can be done inside php.

Example:

echo "<h1>This is HTML code inside echo syntax inside php</h1>";

You need to practice and test and solve the problems you face.

Learn: How to write php inside HTML code

List of PHP ODBC functions

2017-02-04T23:32:00.000+06:00

PHP ODBC functions allows you to connect to database such as Microsoft Access db

odbc_connect ( database_source_name, user , password, cursor _type)
Connecting to an ODBC or data source

odbc_exec( connection_id , query_string , flags )
execute given SQL statement.

odbc_fetch_row ( result_id , row_number )
Retrieving Records

odbc_result ( result_id , field )
Retrieving Fields from a Record

odbc_close (connection_id )
Closing an ODBC Connection

To know about other fuctions of odbc in php, visit PHP manual website

Write PHP code inside HTML file

2017-02-03T12:39:00.000+06:00

To write PHP inside HTML, you need to use the less than and greater than brackets along with question mark with the starting one written 'php'.

For Example:

<div>
<?php
?>
</div>

To print something inside php, we can use the fuction named echo which is predefined in php for printing.

For Example:

<div>
<?php echo "Hello World";
?>
</div>

To use php variable value inside html tag: We have taken a variable with name 'year' and value is set as '2014'. And the value of the variable has been used inside input text box inside the 'value' attribute .

<?php $year = 2014 ; ?>
Input text:<input type="text" value="<?php echo $year ; ?>"/>

You have to be very careful when using php inside html. With little mistake, you may not get result.

Note: Make sure the file extension ends with .php , as php is scripting language, so it needs a server to execute the php code.

Learn: How to write HTML inside php

Short Note on Types of Array in PHP

2017-02-02T02:17:00.000+06:00

There are two types of Array in PHP. They are:
1) Numeric Array
2) Associative Array

1) Numeric Array:

This kind of array use index number to retrieve data. An element can be added to this array without setting any index number. The index will be auto-incremented to that element.

The indexing always starts from zero ( 0 ).

Example:

<?php
//USE OF NUMERIC ARRAY IN PHP
$myArray = array('zahid','bin');
echo "This is Value at index0: " . $myArray[0];
echo "<br/>";
echo "This is Value at index1: " . $myArray[1];
?>

2) Associative Array :

This kind of array use string values to retrieve data. A string index should be provided while creating a new element in array. The main use of associative array is memoization.

[Note: memoization is a technique to optimize performance and avoiding repeat of calculations which has been done once in previous results.]

Associative Array is useful for mapping data and searching.

Example:

<?php
//USE OF ASSOCIATIVE ARRAY IN PHP
$addressbook = array('zahid'=>'+88015500000000','manager1'=>'00002211');
echo "This is Zahids number " . $addressbook['zahid'];
?>

Whats new:

How to Replace space with Dash in PHP

2017-02-01T21:38:00.000+06:00

It is very common requirement to do a task where you need to Replace space with Dash in PHP.

PHP has a function str_replace() function which takes 3 parameters:
i) look for that character
ii) replace with the character
iii) source string

Replace space with Dash in PHP

For example : If the string is "Dhaka is the capital city of Bangladesh"
then the result will be "Dhaka_is_the_capital_city_of_Bangladesh"

Example code :

<?php
    $str = "Dhaka is the capital city of Bangladesh":
    $result = str_replace(" ", "-", $str);

    echo $result ;
?>

Output:

Dhaka_is_the_capital_city_of_Bangladesh

ASCII code of dash/Hyphen symbol :

Syntax:

str_replace( find, replace, string, count )

find the value to look for
replace the value to change with
string the value to search for
count to count the number of times it occurs

Other PHP related post:

How to Open List of Links with help of Mozilla Addon

2017-01-15T16:25:00.000+06:00

There is a Mozilla browser Addon that is used to open Multiple links at once by pasting it in the window.

Add-on : Open Multiple Locations 0.5

This allow the users to go to list of sites and it will be open seperately on different tabs.

This Add-on is created by Jordan Matuszek.

Get it here : addons.mozilla.org

How To Remove Autorun Viruses

2016-03-17T12:35:00.003+06:00

There are several autorun viruses spreading via USB pen drives.Most of the viruses execute malicious codes such as svhost.exe through the autorun.inf file.

Even many anti viruses like AVG free version cannot detect these viruses.

If your....

1.Task manager disabled.

2.Folder options disabled.

3.Show Hidden files in the folder options not working.

4.If there are folders named svhost.exe or folders ending with the extension .exe.

5.If there are Autorun.inf files in your pen drives or hard drives.

6.If you get the "open with" dialog box when you try to open a drive.

7.If there are unusual files in your pen drives or hard drives which you have never copied.
or
8.If you can see the process bar311.exe in the Task manager processes.
this guide is just for you.

1.Uninstall your current Antivirus program specially if you have installed AVG Free Edition.
2.Download and Run Noob.Killer program.

About Noob Killer free software

Noob Killer is a small tool designed to easily rid common worms and viruses, it has many useful tools that would help users and administrators get back control and clean their PC´s/Workstations.

List of registry hotfixes that restores settings on the registry that has been modified by viruses causing severe errors and usability impairment.

* Folder Options
* Task Manager
* Regedit
* Control panel
* Task Bar Right Click
* IE Title Bar Caption
* and Turning on\off of autorun on CD Drives, and Flashdrives respectively.

The Noob Killer is under testing on Windows Vista, working for support to get things running properly, it has been tested under WINE on Linux and is able to run smoothly without too much quirks.
Homepage
Download(315 KB)

3.Update Noob.Killer by selecting "X>Live Update Now!"

4.Select "8-X Kill All" and Restart.

5.After the restart Run the Noob.Killer again and Select
"Tools">"Registry Patches">"Enable ALL"

6.Install Avira Personal Free Edition 8 AntiVirus
7.Update the Antivirus and Do a Full System Scan.
8.Delete every virus file such as svhost.exe and autorun.inf.
9.Disable Auto run on all Drives.
10.Click Start and then click Run.
11.Type gpedit.msc and click OK.

12.The Group Policy window will open. In the left pane, double-click Administrative Templates.

13.In the right pane, double-click System.

14.Scroll down the list and double-click Turn Off Autoplay.

15.In the Turn Off Autoplay Properties window, select Enabled. From the dropdown next to Turn Off Autoplay on, select All drives and then click OK.

16.Exit Group Policy by selecting File, then choosing Exit from the menu.
17.Restart Computer.

Make Sure to scan USB pen drives everytime before opening.

Read more: How To Remove Autorun Viruses

Regex for Matching Values

2014-04-14T17:15:00.000+06:00

Regex to match the following string :

Pattern 1:

Regex Expression:
$\w+$

String:
Bangladesh (Dhaka)

Result/Output Matching Result:
(Dhaka)

Pattern 2:

Regex Expression:
\w+.\w+.*\(

String:
Apple (Fruit)

Result/ Matched output:
Apple (

Interview Questions - Networking

2014-03-30T10:13:00.000+06:00

Here is list of some short basic question answer related to Networking Concepts :

Q. Which layer of OSI model for routing ?
A: Network later (Layer 3)

Q. Which layer of OSI model for HTTP ?
A. Application Layer (Layer 7)

Q. Which cable is used to connect two PCs And Router to PC ?
A: Crossover Cable

Q. Which cable is used to connect PC to switch ?
A. Straight Cable

Q. What is the Maximum data rate of ISDN BRI ?
A. 128 kbps

Q. In ISDN BRI, how many B channels and D Channels ?
A. 2B , 1D

Q. What is the Maximum speed of T1 line ?
A. 1.544 Mbps

Q. What is the maximum speed of E1 line ?
A. 2.048 Mbps

Q. Which connector is used in Fiber Optic Connection?
A. MT-RJ

Q. Which ISO layer for File Transfer, Email ?
A. Application layer (Layer 7)

Q. IEEE 802.5 used in which network ?
A. Token-ring network

Q. IEEE 802.3 used in which network?
A. Ethernet

Q. IEEE 802.6 used in which network ?
A. MAN

How to Write Decimal Sequence in Order List in html using css

2014-03-25T17:24:00.001+06:00

For writing documents, sometimes we need ordering serial as 1.1,1.2,1.3 etc

We can do this serial in html with the help of CSS.

Check this code below:

<!DOCTYPE html>
<html>
<body>
<style>
OL { counter-reset: item }
LI { display: inline }
LI:before { content: counters(item, ".") " "; counter-increment: item }
</style>

<ol start="1">Section
<li><ol start="1">
Section<li></li><br/>
Section<li></li><br/>
Section<li></li><br/>
</ol>
</li>
</ol>

</body>
</html>

Check the Output:

Output of about html code

How to Subtract Two values in SQL query

2014-03-12T16:59:00.003+06:00

Problem: How to subtract two values in a sql query to get the difference ?

Solution: To subtract two values in sql, simply use - (minus) between two values.

For Example:

SELECT sellprice - costprice AS profit FROM account

Explaination:

SELECT: is used in a statement which returns a result from one or more tables. It is known to be DML language (Data Manipulation Language)
AS : used to give a alias name to the column in result.

Fix MSCOMCT2.OCX in Windows 7

2014-03-11T19:58:00.000+06:00

Problem:
Run-time Error 339: Component 'mscomctl.ocx' or one of its dependencies not correctly registered: a file is missing or invalid

Solution:

To fix this problem,

Download mscomct2.ocs from this Link

After downloading, copy the file and paste in c:\windows\system32

If you are using windows 7, go to start,
type cmd , and right click on cmd.exe , choose Run as administrator
Choose Yes

In the command line, type this:

cd C:\Windows\System32

then type this:

regsvr32 mscomct2.ocx

Done.

For Detail solution, visit here

I hope it worked in your pc.

Free open Source C copmplier for Windows IDE

2014-02-25T15:41:00.001+06:00

Code-Blocks is a Compiler IDE software for coding C language with IDE GUI interface and works in Windows.

You can use this software on any windows version and it dont need any update of your OS.
It is free of cost as it is open source.

Check its Featues: Codeblocks features

Download Link: codeblocks-13.12mingw-setup.exe

If you like to use in other OS such as Linux or Mac, visit here: codeblocks downloads

Implement of POP in ASP dot net

2014-02-17T23:36:00.000+06:00

Follow this steps:

Add button in the design view.

Double click the button in design view.

NOTE :: please replace some input with required info in the following code .
Use the following code to set POP of gmail in ASP.net

paste this code :


try
        {

            TcpClient tcpclient = new TcpClient();

// create an instance of TcpClient

            tcpclient.Connect("pop.gmail.com", 995);

//  HOST NAME POP SERVER

// and gmail uses port number  995 for POP 

            System.Net.Security.SslStream sslstream

                   = new SslStream(tcpclient.GetStream());

// This is Secure Stream

// opened the connection between client and POP Server

            sslstream.AuthenticateAsClient("pop.gmail.com");

// authenticate as client 

            //bool flag = sslstream.IsAuthenticated;

// check flag 

            System.IO.StreamWriter sw =

new StreamWriter(sslstream);

// Asssigned the writer to stream

            System.IO.StreamReader reader =

new StreamReader(sslstream);

// Assigned reader to stream

            sw.WriteLine("USER your_gmail_user_name@gmail.com");

// refer POP rfc command, there very few around 6-9 command

            sw.Flush();

// sent to server

            sw.WriteLine("PASS your_gmail_password");
            sw.Flush();

            sw.WriteLine("RETR 1");

// this will retrive your first email 

            sw.Flush();

            sw.WriteLine("Quit ");

// close the connection

            sw.Flush();

            string str = string.Empty;
            string strTemp = string.Empty;

            while ((strTemp = reader.ReadLine()) != null)
            {

                if (strTemp == ".")

// find the . character in line
                {

                    break;
                }

                if (strTemp.IndexOf("-ERR") != -1)
                {

                    break;
                }

                str += strTemp;

            }

            Response.Write(str);

            Response.Write("<BR>"

+ "Congratulation.. ....!!! You read your first gmail email ");
        }

        catch (Exception ex)
        {

            Response.Write(ex.Message);

        }

Add this following code at the top of your program (Replace the duplicate if present before):


using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.IO;
using System.Net.NetworkInformation;
using System.Net.Security;
using System.Net.Sockets;

Done.

How to make DropDownList work with OnSelectedIndexChanged in ASP.net

2014-02-17T23:31:00.001+06:00

Problem: Working with ASP.net , I got stuck working with dropdownlist . I chose the first item which would be copied to a textbox using onSelectedIndexChanged() . But it fails. How get the text value after clicking on dropdownlist on first click ?

Solution:
To do this,
change your sql query ( MS SQL Server 2005) to the following pattern :

SELECT '-Select Room-' AS Expr1
UNION ALL
SELECT DISTINCT [room] FROM [class_routine]

Note: If your data source is binded then this might not work . In this case , double click on the event "DataBinding" of the dropDownList.

and enter this code :

ddlSec.Items.Insert(0, "-Select Section-");

Manual of How to use Google Scholar Search

2014-02-11T19:54:00.000+06:00

Google Scholar search website is used to find article,journal paper, author, citations etc. It is very useful for paper writing and other research works.

To know how to use it, Read the pdf below:

Reference: www.rockinghamcc.edu

How to free reserved bandwidth from Windows operating system

2014-02-10T19:16:00.000+06:00

Windows 7/XP reserves 20% bandwidth by default for system services.

To change the default reserved bandwidth limit , do the following:

1. Go to start > Run > type gpedit.msc .

2. Go to Computer Configuration > Administrative Templates >. Expand it ,

3. Go to Network > QoS Packet Scheduler > Expand it .

4. On the right side of the pane , double click Limit Reservable Bandwidth > enable it .

5. Change the bandwidth limit to 0 (zero) or less than 5% and click apply.

Turning off Plugin in Web browser

2014-02-10T18:19:00.002+06:00

4.15.1 How to turn off Extension in Chrome browser

Go to controls on the right side of the browser,
Go to Tools > Extensions
Now you can either Uncheck the extension to disable it or Remove the extension permenantly .

4.15.2 How to turn off Add-ons Extension in Internet Explorer browser:

Go to Tools menu > Manage Add-ons
Select the extension and click Disable.

4.15.3 How to turn off Add-ons in Mozilla Firefox browser

1. Go to Tools menu > Add-ons

2. Choose the Add-on and Click Disable to stop running or Remove if you like to uninstall it.

How to set local DNS server to Public DNS server

2014-02-10T18:16:00.004+06:00

To change the DNS server in Windows OS,

1. Navigate to Control panel > Network Connections.

2. Right click on the Local Area Network connection and choose properties.

3. In the Networking tab, choose Internet protocol version 4 (TCP/IPv4) > click properties .

(Backup all the settings before making changes).

4. Select “use the following DNS server address” and type your desired DNS (public dns service address).