Answered Questions

  • Jun 07 2013
    02:11 PM
    4543
    3

    Is it worth getting in manual testing profile??
    • mayankwadehra

    Hey I am an ECE fresher and have got a placement in a manual testing profile in Aon Hewitt, I dont know much about the profile so is it worth joining this profile, does it have scope in the future??i am a very ambitious kind of a person so I dont want to join which makes my future stagnant. To add to this there is a 18 month bond of service there. My other option is that I will be going for 6months...

    suji

    • Aug 23rd, 2013

    Hi, As this is your first job, you will start as soon as you complete college. I would take the tester Job as you learn more things then any other . There is nothing like you are struck with the pr...

  • Jan 14 2012
    10:52 AM
    9643
    21

    Can i update views in SQL

    • rahul.solanke

    Can i update views in SQL if yes in what scenarios? if your view is joining multiple tables

    Ayushi

    • May 7th, 2015

    We can update simple views(having data from one table) and complex views(having data from multiple tables) but columns should be taken from one base table for update.

    asifeqbal

    • Mar 18th, 2015

    Yes, we can update view when view is created by single table (simple view). If we want to Update view that are based on multiple tables using Joins, Update does not work. So we used "Instead of Triggers" for updating Complex view.

  • Nov 15 2011
    06:04 AM
    47117
    21

    What is soundness of cement?
    • bhavik

    sathwika

    • Jan 29th, 2019

    It is essential that the cement concrete does not undergo large changing in volume after setting this is ensured by limiting the quantity of free lime, magnesia in whole cement.

    B. NARENDRA

    • Oct 23rd, 2018

    Specific gravity of cement to conduct the material was sink or float

  • Nov 06 2011
    01:32 PM
    9789
    3

    How to store HTML file in SQL server 2008 ?
    • ravi sonaiya

    Star Read Best Answer

    Editorial / Best Answer

    suji  

    • Member Since Sep-2005 | Nov 7th, 2011

    I would use full-text indexing as you are on the latest version. Create and store the html in varbinary(max) column and set its associated file type to ".html" in a file type column. Then enable full-text index, so indexer will parse the data and search only the text content while ignoring the HTML tags. We had been using blob to store the documents, with the new features have come out in the later versions, this seems to be best option. We are in the process of migrating one of the app to use varbinary and to take advantage of the search feature. There is another way of storing using filestrem. Here is a good read-up from MS . FILESTREAM enables SQL Server-based applications to store unstructured data, such as documents and images, on the file system. Applications can leverage the rich streaming APIs and performance of the file system and at the same time maintain transactional consistency between the unstructured data and corresponding structured data http://blogs.msdn.com/b/manisblog/archive/2007/10/21/filestream-data-type-sql-server-2008.aspx Here is another old report from MS back in 2006 explains about using oldway of BLOG http://research.microsoft.com/apps/pubs/default.aspx?id=64525 There are multiple options for you, pick the best approach that matches your needs Thanks, Suji

    suji

    • Nov 7th, 2011

    I would use full-text indexing as you are on the latest version. Create and store the html in varbinary(max) column and set its associated file type to ".html" in a file type column. Then enable fu...

  • Oct 26 2011
    08:30 PM
    13185
    6

    what is pseudo pressure ?
    • abbas

    shah siddharth j

    • Feb 24th, 2015

    Pseudo pressure is the mathematical expresion accounts for variable compressibility and viscosity of gas with respect to pressure

    suji

    • Mar 19th, 2012

    In regard to pressure the mathematical pressure function for the variable viscosity and compressibility of gas is Pseudo-pressure or real gas potential. It’s the changes that occur in gas properties with pressure.

  • Oct 21 2011
    04:42 AM
    7744
    12

    what is header in brick work?
    • kkulkarni2009

    azmath

    • Jul 5th, 2012

    The short face of the brick in known as header and the longer is stretcher

    dhaval

    • Jun 5th, 2012

    The one brick header frog in cement mortar and second brick surface joint one brick and two brick

  • Sep 12 2011
    09:25 AM
    14798
    9

    How to control escalations from customer?
    • Gaurav

    King_D

    • Apr 15th, 2014

    Well first you listen very well to the customers complain don't talk while the customer is still talking and always use sympathy statements like " I know how it feels and I'm more than willing to help you resolve your problems"

    Prashant Rajpurohit

    • Sep 25th, 2012

    well it depends more on your customer handling skills and use sympathy words and sentences wherever necessary . As it reduces the frustration of customer , Also use this sentence " i totally understan...

  • Sep 04 2011
    01:46 AM
    19344
    6

    What is open graded aggregate?
    • ytdfja

    shahanth

    • Mar 11th, 2013

    Open graded aggregate contains only a small percentage of aggregate particles in the small range. This results in more air voids because there are not enough small particles to fill in the voids betwe...

    suji

    • Mar 7th, 2012

    Open graded aggregate is the base of single-sized, angular pieces it is washed to remove fines, stone size can vary between 3 in to ¼ in. It has Low-settling compaction, void spaces may constitute up...

  • Sep 04 2011
    01:33 AM
    4887
    3

    Open graded aggregate
    • what is the use of open graded aggregate??

    For economical purpose we are using open graded aggregate .... how it is economical.... and are there any problems in using this??

    suji

    • Mar 7th, 2012

    Open graded aggregate provides environmental benefits like ....
    1.Noise reduction.
    2.Durability for new construction or asphalt overlays.
    3.Skid resistance.
    and also Cost reduction compared to barriers.

  • Aug 26 2011
    08:43 AM
    7927
    9

    Microorganisms
    • sachin patil

    What is difference between micro-organisms & micro pollutants?

    omenli collins

    • Oct 13th, 2016

    Micro-organism exists internally and can be destroyed at high temperature. It performs multiple functions, it can cause harmful diseases but can also help to enrich the soil. It is a living thing. M...

    Khalid I Jamadar

    • Jun 1st, 2016

    A microorganism or microbe is an organism which is too small to be seen by the unaided human eye. They are microscopic. The study of microorganisms is called microbiology. Microorganisms include bacteria, fungi, archaea or protists and viruses.

  • May 25 2011
    12:00 AM
    6550
    6

    Using examples differentiate between a DBMS, RDBMS and a Distributed database
    • JimiJames

    Been given this question from my son and he has told me that he googled the question but got no satisfactory answer. Would much appreciate an answer.

    raman sharma

    • Mar 2nd, 2012

    DBMS is a when data are not stored in table and RDBMS is used to all data are stored in table and distributed database when more than one table are connected with each other so its is called a distributed database

    suji

    • Dec 21st, 2011

    DBMS - It’s a software package combination of various computer programs which can be used to control, administer, maintain and use of the database. RDBMS - Its a database management system (DBMS) b...

  • Feb 23 2011
    09:20 AM
    20185
    3

    What is the default admin console port number in WebSphere?
    • kirankumar samudrala

    Star Read Best Answer

    Editorial / Best Answer

    suji  

    • Member Since Sep-2005 | Apr 12th, 2011

    WebSphere Application Server default ports

    •Web container port (HTTP_TRANSPORT) - 9080
    •Web container secure port (HTTPS_TRANSPORT) -  9443
    •Administrative console port (HTTP_TRANSPORT_ADMIN) -  9090
    •Adminstrative console secure port (HTTPS_TRANSPORT_ADMIN) -  9043
    •Name service or RMI connector port (BOOTSTRAP_ADDRESS) -  2809
    •Simple Object Access Protocol (SOAP) port (SOAP_CONNECTOR_ADDRESS) -  8880
    •Data replication service client port (DRS_CLIENT_ADDRESS) -  7873
    •Java Message Service (JMS) queued port (JMSSERVER_QUEUED_ADDRESS) -  5558
    •JMS security port (JMSSERVER_SECURITY_PORT) -  5557
    •JMS direct port (JMSSERVER_DIRECT_ADDRESS) -  5559
    •Secure Association Services (SAS) SSL server authentication port (SAS_SSL_SERVERAUTH_LISTENER_ADDRESS) -  9501
    •Common Secure Interoperability Version 2 (CSIV2) server transport port (CSIV2_SSL_SERVERAUTH_LISTENER_ADDRESS) -  9503
    •CSIV2 client transport port (CSIV2_SSL_MUTUALAUTH_LISTENER_ADDRESS) -  9502


    WebSphere Deployment deployment manager default ports

    •Administrative console port (HTTP_TRANSPORT_ADMIN) - 9090
    •Adminstrative console secure port (HTTPS_TRANSPORT_ADMIN) - 9043
    •Name service or RMI connector port (BOOTSTRAP_ADDRESS) - 9809
    •Simple Object Access Protocol (SOAP) port (SOAP_CONNECTOR_ADDRESS) - 8879
    •Data replication service client port (DRS_CLIENT_ADDRESS) - 7989
    •Cell discover port (CELL_DISCOVERY_ADDRESS) - 7277
    •Secure Association Services (SAS) SSL server authentication port (SAS_SSL_SERVERAUTH_LISTENER_ADDRESS) - 9401
    •Common Secure Interoperability Version 2 (CSIV2) transport port (CSIV2_SSL_SERVERAUTH_LISTENER_ADDRESS) - 9402
    •CSIV2 transport port (CSIV2_SSL_MUTUALAUTH_LISTENER_ADDRESS) - 9403
    •Object Request Broker (ORB) listener port (ORB_LISTENER_ADDRESS) - 9100

    WebSphere Application Server node agent default ports

    •Name service or RMI connector port (BOOTSTRAP_ADDRESS) - 2809
    •Simple Object Access Protocol (SOAP) port (SOAP_CONNECTOR_ADDRESS) - 8878
    •Data replication service client port (DRS_CLIENT_ADDRESS) - 7888
    •Secure Association Services (SAS) SSL server authentication port (SAS_SSL_SERVERAUTH_LISTENER_ADDRESS) - 9901
    •Common Secure Interoperability Version 2 (CSIV2) transport port (CSIV2_SSL_SERVERAUTH_LISTENER_ADDRESS) - 9101
    •CSIV2 transport port (CSIV2_SSL_MUTUALAUTH_LISTENER_ADDRESS) - 9201
    •Object Request Broker (ORB) listener port (ORB_LISTENER_ADDRESS) - 9900
    •Node discovery port (NODE_DISCOVERY_ADDRESS) - 7272
    •Node multicast discovery port (NODE_MULTICAST_DISCOVERY_ADDRESS) - 5000


    WebSphere Application Server JMS server default ports

    •Java Message Service (JMS) queued port (JMSSERVER_QUEUED_ADDRESS) - 5558
    •JMS security port (JMSSERVER_SECURITY_PORT) - 5557
    •JMS direct port (JMSSERVER_DIRECT_ADDRESS) - 5559
    •Simple Object Access Protocol (SOAP) port (SOAP_CONNECTOR_ADDRESS) - 8876

    suji

    • Apr 12th, 2011

    WebSphere Application Server default ports•Web container port (HTTP_TRANSPORT) - 9080•Web container secure port (HTTPS_TRANSPORT) -  9443•Administrative console port (HTTP_TRANSPOR...

  • Nov 11 2008
    10:50 AM
    7759
    6

    What is Short Term Solvency Ratio?
    • divyagarg09

    anil joshi

    • Feb 2nd, 2013

    Ratios used to judge the adequacy of liquid assets for meeting short-term
    obligations as they come due, including
    1) the current ratio,
    2) the acid-test ratio,
    3) the inventory turnover ratio, and
    4) the accounts receivable turnover ratio.



    suji

    • Feb 29th, 2012

    Short-term Solvency Ratios – It’s a ratio to measure the firm’s ability to meet short-term financial obligations. With this the firm will avoid financial distress in the short-run. There are two most important Short-term Solvency Ratios
    1. Current Ratio.
    2. Quick Ratio.

  • May 10 2008
    08:31 AM
    4267
    3

    How to set Windows as Default OS when Dual Booting Ubuntu?
    • Amit Shiknis

    Star Read Best Answer

    Editorial / Best Answer

    suji  

    • Member Since Sep-2005 | Apr 12th, 2011

    Command is - sudo gedit /boot/grub/menu.lst

    This will show output as -
    ## default num
    # Set the default entry to the entry number NUM. Numbering starts from 0, and
    # the entry number 0 is the default if the command is not used.
    #
    # You can specify 'saved' instead of a number. In this case, the default entry
    # is the entry saved with the command 'savedefault'.
    # WARNING: If you are using dmraid do not change this entry to 'saved' or your
    # array will desync and will not let you boot your system.
    default 0

    The important line is the last one. You will need to change that number 0 to match the Windows boot section. Typically it's always going to be 4 on a default dual-boot configuration. Change this value to 4, and then save and reboot your machine. You should go into Windows instead of Ubuntu automatically.

    suji

    • Apr 12th, 2011

    Command is - sudo gedit /boot/grub/menu.lstThis will show output as - ## default num# Set the default entry to the entry number NUM. Numbering starts from 0, and# the entry number 0 is the default ...

  • Jan 08 2007
    01:20 AM
    4664
    6

    What is defncopy and it's usage.
    • James

    Copies definitions for specified views, rules, defaults, triggers, procedures, or reports from a database to an operating system file or from an operating system file to a database.

    suji

    • Jan 8th, 2007

    The defncopy utility cannot copy table definitions or reports created with Report Workbench.   Invoke the defncopy program directly from the operating system. defncopy provides a non-interac...

  • Oct 03 2006
    01:32 PM
    4691
    4

    Give example for binary datatype non binary datatype?
    • Gajalakshmi

    Star Read Best Answer

    Editorial / Best Answer

    suji  

    • Member Since Sep-2005 | Nov 6th, 2011

    Here are the Binary data types in sql server - bit, binary, varbinary, image. Bit variables store a single bit with a value of 0, 1 or NULL. binary(n) variables store n bytes of fixed-size binary data. They may store a maximum of 8,000 bytes. varbinary(n) variables store variable-length binary data of approximately n bytes. They may store a maximum of 8,000 bytes. image variables store up to 2 gigabytes of data and are commonly used to store any type of data file. Rest of the data types are non-binary

    suji

    • Nov 6th, 2011

    Here are the Binary data types in sql server - bit, binary, varbinary, image. Bit variables store a single bit with a value of 0, 1 or NULL. binary(n) variables store n bytes of fixed-size binary da...

    krishnakumar

    • Nov 3rd, 2006

    The binary datatype is used for storing the images in the database.the non binary datatypes are integer,varchar etc

  • Sep 23 2006
    06:43 AM
    6672
    7

    What is meant by iframe?
    • GeekAdmin

    Star Read Best Answer

    Editorial / Best Answer

    suji  

    • Member Since Sep-2005 | Apr 3rd, 2011

    iframe is used for creating an inline or floating frame. As most of know frames are mainly used to structure the page or for placing a menu bar on the side and so on. But iframe is used in a different context. That is in other words <iframe> is used to embed or insert content on a page of padding. This is done for several reasons. Say the content may be large enough that the user may wish to place it separately and scroll through it. There are many attributes present in <iframe> and some of the attributes used with <iframe> are namely:

    NAME:
    Used for specifying the name of the frame.

    SCROLL:
    Used for specifying the scrolling action to be activated. Can take three values namely AUTO, YES or NO. AUTO will allow the browser to take the decision and activate scroll bar when needed YES specify scroll bar is needed and NO specifies scroll bar is not needed.

    ALIGN:
    This is used for alignment of text and the values that can be taken by it are namely LEFT, RIGHT, TOP, MIDDLE, and BOTTOM.

    FRAMEBORDER:
    Used for setting borders, around the frames if needed. A value of 1 set the border around the frame and 0 specify for no border.

    HEIGHT:
    Used to specify the height of the frame and this value is mentioned in pixels.

    HSPACE:
    Used for specifying horizontal spacing around the frames.

    dinesh

    • Aug 12th, 2011

    Iframe means inline frame

    suji

    • Apr 3rd, 2011

    iframe is used for creating an inline or floating frame. As most of know frames are mainly used to structure the page or for placing a menu bar on the side and so on. But iframe is used in a differ...

  • Aug 30 2006
    03:07 PM
    165820
    50

    What is DESCRIBE command in SQL Server?
    • Priya

    What is its purpose?How to use it?

    Star Read Best Answer

    Editorial / Best Answer

    suji  

    • Member Since Sep-2005 | Nov 5th, 2011

    Here are multiple ways to get the table information. The DESCRIBE command does not exist in MS SQL SERVER. This is an Oracle command used to describe the structure of objects within a given database. To achieve the same task in MSSQL Server, there are a series of stored procedures with the prefix SP_ that can be used. To view the structure of a table within the current database, use the command 

    Code
    1. sp_help 'TABLE_NAME';
    If you would like to see more details, Create your custom procedure 
    Code
    1. CREATE procedure DESCRIBE 
      2. 

    2. (
      3. 

    3. @tablename varchar(256)
      4. 

    4. )
      5. 

    5. AS 
      6. 

    6. begin
      7. 

    7. SELECT DISTINCT sCols.colid AS 'order', sCols.name, sTyps.name, sCols.length
      8. 

    8. FROM [syscolumns] sCols
      9. 

    9. INNER JOIN [systypes] sTyps ON sCols.xtype = sTyps.xtype
      10. 

    10. INNER JOIN [sysobjects] sObjs ON sObjs.id = sCols.[id]
      11. 

    11. AND UPPER(sObjs.name) = UPPER(@tablename)
      12. 

    12. ORDER BY sCols.colid
      13. 

    13. end
    Here is another alternative way to get the same information 
    Code
    1. sp_columns 'TableName' (e.g. sp_columns 'Employee')
      2. 

    2. sp_columns [ @table_name = ] object [ , [ @table_owner = ] owner ] 
      3. 

    3. [ , [ @table_qualifier = ] qualifier ] 
      4. 

    4. [ , [ @column_name = ] COLUMN ] 
      5. 

    5. [ , [ @ODBCVer = ] ODBCVer ]
    Here is the usage : 
    Code
    1. EXEC sp_columns @table_name = 'Department', @table_owner = 'sa';
      2. 

    2. SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'TableName'
    Contributors for the editorial answer : Kewlshiva, srilakshmi.b, raaghav,kevaburg

    Rooshi

    • Oct 17th, 2014

    Sp_help will give all the details about the table columns, indexes, partitions etc.

    Saket Kale

    • Oct 24th, 2012

    Sp_help dbo.customers;

    worked for me just fine.

    Thanks to the OP, this runs perfectly on SQL 2008 R2, do not know about other versions

  • Jul 25 2005
    03:28 PM
    792504
    110

    How would you describe yourself as a person?

    Star Read Best Answer

    Editorial / Best Answer

    suji  

    • Member Since Sep-2005 | Apr 3rd, 2011

    "Describe yourself!", This question is almost invariably asked in the majority of interviews, and just as invariably answered dismally! What does one say and why do we always seem so flustered by the question? Because we have always been taught by our parents and respected elders not to boast or talk about ourselves.

    With a childhood full of such repressive advice, its not surprising that the majority of us begin the answer with a stammer and a blush, almost instantly changing from flash to foolish and ruining our chances of employment.

    So what do we say? Frankly, just answer the question as it comes. Most disconcerted candidates dread this question and begin with a silly "Basically, my name is ...". Why don't we realize that our CV is there right in front of the interviewer, and he knows this already.

    By repeating the stuff that fills our CV, we just demonstrate that we are an 'in-the-box' kind of person, with little if any skill in innovation and presentation.

    Actually, a question of this kind is an ideal way to plug in everything we want to say about ourselves that we had leave out of the CV. If you have attended a premier institution, say that the institution taught you much more than the degree it awarded you, mention people who influenced you, talk about the books you like reading, your hobbies and your other interests.

    Talk about your strengths; perhaps mention an instance when you used your conflict resolution skills or selling skills or whatever. But make certain that it does not sound like blowing your trumpet. Mention these instances as learning.

    Tall about your weaknesses, but make sure that they are 'positive' weaknesses. For instance you could say that that you sometimes pay more attention to detail than is warranted. You can openly confess a tendency to be impatient with team members who cannot carry their own weight, or who cannot contribute sufficiently.

    But first, think today what you want to say and practice. Remember, if you hesitate about yourself, your interviewers will doubt whether you fit their bill of requirements. After all, if you don't know about you, who does?

    How to describe yourself

    Nadeem Aslam

    • Mar 21st, 2017

    As a joke yet a very informational elevator speech I always love to say "Hello my name is Nadeem Aslam I am a student of..... I play cricket, football and if you want to know anymore unnecessary info...

    Arlyn Abarillo

    • Nov 27th, 2016

    Hi, I am Arlyn and as I describe myself I am an ambitious, kind, and doing things that can be good to others, I know how dealing people rich or poor, and most I am a fun loving person.