Question & Additional Information
 
What is the effect of setting the value 'FIRST_ROWS' for OPTIMIZER_GOAL parameter of the ALTER SESSION command ?
Add to My IQ
 

 | 
Inappropriate
Answer Title
Answer
This value causes the optimizer to use the cost-based approach for all SQL statements in the session regardless of the presence of statistics and to optimize with a goal of best response time.
Question Tag Title
Tags
Question Asked At Title
Asked At
None
Question Job Title
Job Titles


Check out our newest job listings!

Post a Job! $49 for 60 days



Your Name:
Add your comment text
 
Related Questions
Related Questions
Flag this interview question as inappropriate Inappropriate
See Answer
Firewalls can't protect very well against things like viruses or malicious software (malware). There are too many ways of encoding binary files for transfer over networks, and too many different architectures and viruses to try to search for them all. In other words, a firewall cannot replace security-consciousness on the part of your users. In general, a firewall cannot protect against a data-driven attack--attacks in which something is mailed or copied to an internal host where it is then executed.

Alternate Answer:
Properly configured firewalls can limit the propagation of worms - a form of malware.  Typically, firewalls are edge or parameter devices (separates network zones) and most viruses and malware targets end points (user workstations and servers).
Create Date
:
Tuesday, November 06, 2007
Asked At
:
None
Job Positions
:
None
Click here to improve the Interview Question, Answer and other fields.
Comments (0) :
Goto add your comment on the Question 
Flag this interview question as inappropriate Inappropriate
See Answer
  • To run the count program, which will display the process identification number of the job, enter: count &
  • To check the status of your job, enter: ps
  • To bring a background process to the foreground, enter: fg
  • If you have more than one job suspended in the background, enter: fg %#

    Replace  #  with the job number, as shown in the first column of the output of the jobs command.

  • You can kill a background process by entering: kill PID

    Replace PID with the process ID of the job. If that fails, enter the following:

    kill -KILL PID
  • To determine a job's PID, enter: jobs -l
  • If you are using sh, ksh, bash, or zsh, you may prevent background processes from sending error messages to the terminal. Redirect the output to /dev/null using the following syntax: count 2> /dev/null &
  • Create Date
    :
    Sunday, May 11, 2008
    Tags
    :
    Asked At
    :
    None
    Job Positions
    :
    Click here to improve the Interview Question, Answer and other fields.
    Comments (0) :
    Goto add your comment on the Question 
    Flag this interview question as inappropriate Inappropriate
    See Answer

    Silly window syndrome is a problem in computer networking caused by poorly-implemented TCP flow control. If a server with this problem is unable to process all incoming data, it requests that its clients reduce the amount of data they send at a time (the "window" setting on a TCP packet). If the server continues to be unable to process all incoming data, the window becomes smaller and smaller, sometimes to the point that the data transmitted is smaller than the packet header, making data transmission extremely inefficient. The name of this problem is due to the window size shrinking to a "silly" value.

    Since there is a certain amount of overheadassociated with processing each packet, the increased number of packets means increased overhead to process a decreasing amount of data. The end result is thrashing.

    Create Date
    :
    Monday, April 28, 2008
    Tags
    :
    Asked At
    :
    None
    Job Positions
    :
    Click here to improve the Interview Question, Answer and other fields.
    Comments (0) :
    Goto add your comment on the Question 
    Flag this interview question as inappropriate Inappropriate
    See Answer
    In n-tier architecture the entire application is divided in several pieces. These pieces can be logical or physical. Each piece performs a specific task such as displaying user interface or data access. There can be any number of tiers or layers of such pieces. Hence, the name n-tier (Note that many times the terms tier and layer are used interchangeably). However, most commonly applications have 3 distinct tiers or layers. They are:
    • Presentation Layer
    • Business Logic Layer
    • Data Access Layer
    As you can guess, presentation layer is nothing but a piece of software that deals with user interface of your application. Displaying data to the end user and allow them to interface with it is the core functionality of this layer.

    In most of the cases the data entered by the end user needs some kind of validation or further processing. This is the responsibility of Business Logic Layer.

    Finally, your application data needs to be stored and retrieved in some data store (RDBMS, XML etc.). This task is handled by Data Access Layer.

    In short, the process works like this:

    • User requests for some application data.
    • The data access layer retrieves the data and is forwarded to the presentation layer via business logic layer. Sometimes data access layer gives this data directly to presentation layer.
    • Presentation layer receives the data to be displayed via business logic layer.
    • The user changes the data and initiates the appropriate action (such as insert, or update).
    • The business logic layer validates the data submitted by the user.
    • If the data is valid it is handed over to data access layer for updating into the database.
    Advantages of N-Tier ArchitectureAt first glance this division of tasks may seem to be unnecessary. However, it gives following benefits:
    • The applications gets divided in logically isolated pieces reducing tight coupling between the UI, business processes and database.
    • Change in the underlying database and data access methods do not have any effect on the presentation layer or client application.
    • Client application no longer has SQL statements embedded in it. This makes it de-coupled from rest of the application.
    • Table and column names can be effectively eliminated from the client-side code.
    • The client application is unaware from where data comes (location transparency).
    • It becomes easier to modify or extend your application, without breaking or recompiling the client-side code.
    The downside of n-tier architecture is that you need to create many isolated classes and pieces of software. However, benefits of n-tier applications will far outweigh its disadvantage.
    Create Date
    :
    Tuesday, June 10, 2008
    Tags
    :
    Asked At
    :
    None
    Job Positions
    :
    None
    Click here to improve the Interview Question, Answer and other fields.
    Comments (0) :
    Goto add your comment on the Question 
    Flag this interview question as inappropriate Inappropriate
    See Answer
    An MSI installer, a CAB archive, and XCOPY command.
    Create Date
    :
    Tuesday, May 13, 2008
    Tags
    :
    Asked At
    :
    None
    Job Positions
    :
    Click here to improve the Interview Question, Answer and other fields.
    Comments (0) :
    Goto add your comment on the Question 
    Flag this interview question as inappropriate Inappropriate
    See Answer
    Multiple processes must agree that they will share the same connection, where every parameter is the same, including the security settings.  The connection string must be identical.
    Create Date
    :
    Tuesday, May 13, 2008
    Tags
    :
    Asked At
    :
    None
    Job Positions
    :
    Click here to improve the Interview Question, Answer and other fields.
    Comments (0) :
    Goto add your comment on the Question 
     
    • More Related Questions: