DB2 Interview Questions - part V

1. How would you find out total number of rows in a table?

Use Select Count(*)

2.How do you eliminate duplicate values in SELECT?

Use SELECT DISTINCT

Too Tough Letter Series

1. A C BDEFGI - I H K J L Show the Answer

2. AIZBEYCIXDI - GENJW Show the Answer

3. ADGJMP - RWTS Show the Answer

4. XWEFGVUHIJK - PNSRT Show the Answer

5. ABFGKLPQ - TSVUW Show the Answer

Answers of a brilliant student

Q: In which battle did napoleon died?

Ans: His Last Battle.

Q: Where was the declaration of independence signed?

Ans: At the bottom of the page

Q: River Ravi flows in which state?

Ans: Liquid State

Q: What's the main reason for divorce?

Ans: Marriage

Q: What's the main reason for failure?

Ans: Exams

32-bit or 64-bit?

Sometimes we need to know the box is 32-bit or 64-bit. For example we want to install oracle. Before installing, we need to know the box version so that accordingly we could choose the release software file. Here i am just writing on how to get the unix box is 32-bit or 64-bit and oracle, perl and so on.

How to know the unix box is 32-bit or 64-bit?

Use command isainfo -kv to get the 32 bit or 64 bit machine.

How to find whether perl is 32-bit or 64-bit?

file /usr/bin/perl

if it 64-bit then it display ELF 64-bit otherwise ELF 32-bit.

-bash$ file /usr/perl/bin/perl
/usr/perl/bin/perl: ELF 32-bit MSB executable SPARC Version 1, dynamically linked, not stripped

How to find Oracle is 32-bit or 64-bit?

-bash$ file /soft/oracle/product/11.2.0/db/lib/libclntsh.so.11.1
/soft/oracle/product/11.2.0/db/lib/libclntsh.so.11.1: ELF 64-bit MSB dynamic lib SPARCV9 Version 1, dynamically linked, not stripped

How to find the python is 32-bit or 64-bit?

-bash$ file /usr/bin/python
/usr/bin/python: ELF 32-bit MSB executable SPARC Version 1, dynamically linked, not stripped, no debugging information available

K9 Web Protection

Internet is having wide data. It have advantages and disadvantages. The open internet is unsafe for children. It is difficult for the parents to control the children accessing the unwanted content.

K9 Web Protection is open source web protection system. It helps to filter the sites in more than 70 categories like pornography, drugs, vilonence, hate...

By filtering using this software the children could see the filtered site contents. We can set always allow sites and always not allow sites. We can block the access by password.

It provides the reports to monitor and control web access. It work in windows and Mac systems. In this we can also set time restriction so the children could browse on specified times.
K9 is also available for iPhone, iPad, iPod.

DBIx Query Construction - select, distinct, order by , not null, getting total number of records - Part I

Perl CPAN have module called DBIx::Class. It gives a object oriented layer for database. Each table in the database have one schema file in the perl.

These schema files are loaded using the single App/Shcema.pm using the load_namespaces().

The schema files contains the specification for columns, primary, unique keys, relation between other tables.

Syndicate content