Interview Questions and Answers

Jul 152015
 

26. TALK: Chat to Users The “talk” command is used to chat with another logged-in user(s) or allow chat to users on other systems. Example: $ talk user3 This command will allow the current user to talk to user “user3”. 27. UNAME: Print system information The “uname” command is used to print the name, version

[Read More]
Jul 132015
 

UNIX Commands    1. CAT: Concatenate files to standard output The “cat” command can be used to: Display text files Copy text files into a new document Append the contents of a text file to the end of another text file, combining them Syntax: cat [options] [file_names] Example: $ cat myfile.txt This command will display the

[Read More]
Dec 232014
 

14) SQL Query to compare NULL values in Oracle table Step 1: Create two Table “Test1” and “Test2”: CREATE TABLE TEST1 (A NUMBER,B NUMBER); CREATE TABLE TEST2 (A NUMBER,B NUMBER); Step 2: Insert Rows: INSERT INTO TEST1 VALUES (1,25); INSERT INTO TEST1 VALUES (2,20); INSERT INTO TEST1 VALUES (3,NULL); INSERT INTO TEST1 VALUES (4,30); INSERT

[Read More]
Dec 222014
 

1) SQL query to fetch first 50 rows from a Table.  SELECT   * FROM   employee WHERE   ROWNUM < 51; 2) SQL query to fetch 50 random rows from a Table  SELECT   * FROM   (SELECT   * FROM   employee ORDER BY   DBMS_RANDOM.VALUE) WHERE   ROWNUM < 51; 3) SQL Query to generate Serial/Sequence Number for a Table.  SELECT  

[Read More]
Dec 162014
 

Solved 51 SQL Queries 37) SQL query to create a role and grant it to a user Create role <role_name>; //Create Role Grant create table, create view to <role_name>; // Grant privileges to role Grant <role_name> to <user_name1>, <user_name2>; // Grant Role to Users 38) SQL query to revoke select and insert privileges from a

[Read More]
Dec 152014
 

Solved 51 SQL Queries 25) SQL query to get the first day of a month Select trunc(to_date(’30-Nov-2014′,’DD-MON-YYYY’),’month’)from dual; Output: 01-Nov-2014 26) SQL query to get the first day of a Year Select trunc(to_date(’30-Nov-2014′,’DD-MON-YYYY’),’Year’)from dual; Output: 01-Jan-2014 27) SQL query to spell a day Select To_char(to_date(’20-Nov-2014′,’DD-MON-YYYY’),’ddspth’)from dual; Output: twentieth [day 20 is spelled as twentieth] 28)

[Read More]
Dec 112014
 

Solved 51 SQL Queries 13) SQL query to copy structure of a table Create table employee_new as select * from employee where 1>2; [Where”employee_new” is a copied table to “employee” table without any data] 14) SQL query using MERGE statement MERGE INTO bonuses D USING (SELECT employee_id, salary, department_id FROM employees WHERE department_id = 80)

[Read More]
Dec 102014
 

Solved 51 SQL Queries 1) SQL query to create partition by range on a table create table product (product_id number, product_name varchar2(30), Manufactured_Date date) partition by range (Manufactured_Date) ( partition part1 values less than (TO_DATE(‘2013-01-01 00:00:00’, ‘YYYY-MM-DD HH24:MI:SS’)), partition part2 values less than (TO_DATE(‘2014-01-01 00:00:00’, ‘YYYY-MM-DD HH24:MI:SS’)) ); 2) SQL query to create database link

[Read More]
Sep 102014
 

Top 51 Questions for Oracle Reports that are frequently asked in Interview. What is Oracle Developer? What is a Report Builder? What are the various styles used in the Reports? What is GUI? What are the different Report Builder Components? What is a difference between Object Navigator and property Palette? What is a Syntax Palette?

[Read More]
Sep 082014
 

If you want to attend any interview then it is sure that you are going to face HR Interview at very first or last stage. Without clearing the HR interview you are not going to get any offer even you feel strong enough technically in your area or skills set. HR interview is not too

[Read More]