Latest Technical Interview Questions and Answers

What is difference between user right and user permission?

Answers:
user rights:user rights is that user is authorized to used password.if his password/file/dir is expired he is not able to loginuser permission:permission is user is permitted to to use file/directory.that is authenticationif he is authentication for particular file or not. it might be true as per my suggestion.

What is the real mean of DHCP?

Answers:
Dynamic addressing simplifies network administration because the s/w keeps track of IP addresses rather than requiring an administrator to manage the task.That means new computer can be added to the network without any risk of manually assigning unique IP address.

Describe the boot process of your favorite Linux in as much detail as you can?

Answers:
Boot process takes place in 4 scenes with 4 main characters. Scene 1 when the computer is switched on,it automatically invokes BIOS[a ROM chip embedded in the motherboard].The BIOS will start the processor and perform a POST[power on self test] to check whether the connected device are ready to use and are working properly.Once the POST is [...]

What is the minimum number of partitions you need to install Linux?What command can you use to review boot messages?

Answers:
1. Three Partition. boot partition, swap partition and root partition, these are the minimum partitions to install the linux. 2. dmesg or /var/log/messages

What command you execute to display the last five commands you have entered? Which partitions might you create on mail server HDDs other than the root, swap and boot partitions? Which partitioning tool is available in all distributions? Which two commands can you use to delete directories? Which file defines all users on your system?

Answers:
1. history|tail -5 2. /var 3. fdisk, parted 4. rm, rmdir 5. /etc/passwd

How to install 8139 realtek drivers in rhel5.0? Please help me out?

Answers:
Download the driver from internet. then just unzip the tarball using tar -zxvf then for first compile it using make and make install For proper installation of the driver read the INSTALL / README file given in the tarball.


What are the possible data marts in Retail sales.?

Answers:
Product information,sales information Retailor_site_Dim, product_dim, Time_dim, Sales_staff_dim,Return_method_dim,

What is the main differnce between schema in RDBMS and schemas in DataWarehouse?

Answers:
RDBMS Schema * Used for OLTP systems * Traditional and old schema * Normalized * Difficult to understand and navigate * Cannot solve extract and complex problems * Poorly modelled DWH Schema * Used for OLAP systems * New generation schema * De Normalized * Easy to understand and navigate * Extract and complex problems can be easily solved * Very good model

What are the vaious ETL tools in the Market ?

Answers:
Various ETL tools used in market are: Informatica Data Stage Oracle Warehouse Bulider Ab Initio Data Junction

What is Dimensional Modelling ?

Answers:
Dimensional Modelling is a design concept used by many data warehouse desginers to build thier datawarehouse. In this design model all the data is stored in two types of tables - Facts table and Dimension table. Fact table contains the facts/measurements of the business and the dimension table contains the context of measuremnets ie, the [...]

What is VLDB?

Answers:
The perception of what constitutes a VLDB continues to grow. A one terabyte database would normally be considered to be a VLDB.

What is degenerate dimension table?

Answers:
Degenerate Dimensions : If a table contains the values, which r neither dimesion nor measures is called degenerate dimensions.Ex : invoice id,empno

What is ER Diagram ?

Answers:
The Entity-Relationship (ER) model was originally proposed by Peter in 1976 [Chen76] as a way to unify the network and relational database views. Simply stated the ER model is a conceptual data model that views the real world as entities and relationships. A basic component of the model is the Entity-Relationship diagram which is used to [...]

Difference between Snow flake and Star Schema. What are situations where Snow flake Schema is better than Star Schema to use and when the opposite is true?

Answers:
Star schema contains the dimesion tables mapped around one or more fact tables. It is a denormalised model.No need to use complicated joins.Queries results fastly.Snowflake schemaIt is the normalised form of Star schema.contains indepth joins ,bcas the tbales r splitted in to many pieces.We can easily do modification directly in the tables.We hav to use comlicated [...]

What is a CUBE in datawarehousing concept?

Answers:
Cubes are logical representation of multidimensional data.The edge of the cube contains dimension members and the body of the cube contains data values.

Differences between star and snowflake schemas ?

Answers:
Star schema A single fact table with N number of Dimension Snowflake schema Any dimensions with extended dimensions are know as snowflake schema star schema is a logical structure that can be arranged with fact and dimension tables in a star formation.it looks like a star with fact table at the core of the star and the dimension tables along [...]

What are Data Marts?

Answers:
A data mart is a focused subset of a data warehouse that deals with a single area(like different department) of data and is organized for quick analysis.

Can a dimension table contains numeric values?

Answers:
Yes.But those datatype will be char (only the values can numeric/char)

What is hybrid slowly changing dimension ?

Answers:
Hybrid SCDs are combination of both SCD 1 and SCD 2. It may happen that in a table, some columns are important and we need to track changes for them i.e capture the historical data for them whereas in some columns even if the data changes, we don’t care. For such tables we implement Hybrid SCDs, where [...]

What is the data type of the surrogate key?

Answers:
Data type of the surrogate key is either integer or numeric or number There is no data type for a Surrogate Key. Requirement of a surrogate Key:UNIQUE Recommended data type of a Surrogate key is NUMERIC.

What is a Fact,Dimension,Measure?

Answers:
Fact is key performance indicator to analyze the business.Dimension is used to analyze the fact.Without dimension there is no meaning for fact.

What are the different types of data warehousing?

Answers:
Types of data warehousing 1. Enterprise Data warehousing 2. ODS (Operational Data Store) 3. Data Mart

Can any body explain clearly how to explain any (sales) project in interview.actually feom where report developer work starts?pls reply as soon as possible?

Answers:
if you are a Report developer 1,you have to specify the front end and back end tool used for creating the reports 2,Then you have to tell the purpose of the project..what you are going to acheive using the reports. 3,Then you can explain the backend part which is important.FOr example,you have to tell what are all the [...]

What do you mean by static and local variable?

Answers:
Static variable is not created on function stack but is created inthe initialized data segment and hence the variable can be shared across the multiple call of the same function. Usage of static variables within a function is not thread safe. On the other hand local variable or auto variable is created on function stack...


Download More