What is the difference between "-Mlib" and "-I" option in Perl?

Theses are the ways to modify @INC without modifying the program.

The benefit of using "-Mlib=/my/module_dir" over "-I /my/module_dir" is the former automatically removes any duplicate directories while the later does not.

How do you find Oracle SID and ORACLE_HOME?

ps -aef | grep smon

How do you execute UNIX command in PostgreSQL prompt?

\! <command>

How do you connect to PostgreSQL in UNIX?

psql -h <Host> -d <Database> -U <User> -W -p <PortNo>

where,
-W = prompts for password to be typed.

What is mod_perl?

mod_perl is the fusion of Apache and Perl which enhances a new approach to create dynamic content by utilizing the feature of Apache web server through a persistent interpreter embedded into web server. It lets you avoid the overhead of starting an external interpreter and the penalty of Perl start-up time as well.

How do you select random rows in Oracle?

SELECT *
FROM
( SELECT *
 FROM <TableName>
ORDER BY dbms_random.value )
WHERE rownum <= 10;

How do you select random rows in DB2?

SELECT *
FROM <TableName>
ORDER BY rand()
FETCH FIRST 10 ROWS ONLY;

How do you select random rows in Sybase?

SELECT TOP 10 *
FROM <TableName>
ORDER BY NEWID();

How do you select random 10 rows in MySQL?

SELECT *
FROM <TableName>
ORDER BY RAND()
LIMIT 10;

How do you select random rows in MsSQL Server?

SELECT TOP 10 *
FROM <TableName>
ORDER BY NEWID();