Description : What do you mean by Correlated subquery?
Last Answer : Subqueries, or nested queries, are used to bring back a set of rows to be used by the parent query. Depending on how the subquery is written, it can be executed once for the parent query or it can ... Select * From CUST Where 10/03/1990? IN (Select ODATE From ORDER Where CUST.CNUM = ORDER.CNUM)
Description : If the maximum record retrieved property of the query is set to 10 then a summary value will be calculated?
Last Answer : Only for 10 records.
Description : What is a Query Record Group?
Last Answer : A query record group is a record group that has an associated SELECT statement. The columns in a query record group derive their default names, data types, had lengths from the database columns ... rows retrieved by the query associated with that record group. What is a Non Query Record Group?
Description : What is the Difference between a post query and a pre query
Last Answer : A post query will fire for every row that is fetched but the pre query will fire only once.
Description : How you will avoid your query from using indexes?
Last Answer : SELECT * FROM emp Where emp_no+' '=12345; i.e you have to concatenate the column name with space within codes in the where condition. SELECT /*+ FULL(a) */ ename, emp_no from emp where emp_no=1234; i.e using HINTS
Description : Suppose a customer table is having different columns like customer no, payments.What will be the query to select top three max payments?
Last Answer : SELECT customer_no, payments from customer C1 WHERE 3
Description : There is a % sign in one field of a column. What will be the query to find it?
Last Answer : '' Should be used before '%'.
Description : How you will avoid duplicating records in a query?
Last Answer : By using DISTINCT
Description : My query was fine last week and now it is slow. Why? (for DBA
Last Answer : The likely cause of this is because the execution plan has changed. Generate a current explain plan of the offending query and compare it to a previous one that was taken when the query was ... the plan should be? Run the query with hints to see if this produces the required performance.
Description : A query fetched 10 records How many times does a PRE-QUERY Trigger and POST-QUERY Trigger will get executed ?
Last Answer : PRE-QUERY fires once. POST-QUERY fires 10 times.
Description : When is PRE-QUERY trigger executed ?
Last Answer : When Execute-query or count-query Package procedures are invoked.
Description : Why query fails sometimes ?
Last Answer : Rollback segment dynamically extent to handle larger transactions entry loads. A single transaction may wipeout all available free space in the Rollback Segment Tablespace. This prevents other user using Rollback segments.
Description : Where is the external query executed at the client or the server?
Last Answer : At the server.
Description : How is it possible to select generate a select set for the query in the query property sheet?
Last Answer : By using the tables/columns button and then specifying the table and the column names.
Description : What is a difference between pre-select and pre-query?
Last Answer : Fires during the execute query and count query processing after oracle forms constructs the select statement to be issued, but before the statement is actually issued. The pre-query trigger fires ... the query criteria in enter query mode.Pre-query trigger fires before pre-select trigger.
Description : Is it possible to modify an external query in a report which contains it?
Last Answer : No.
Description : If a parameter is used in a query without being previously defined, what diff. exist betw. report 2.0 and 2.5 when the query is applied?
Last Answer : While both reports 2.0 and 2.5 create the parameter, report 2.5 gives a message that a bind parameter has been created.
Description : What is a query?
Last Answer : A query with respect to DBMS relates to user commands that are used to interact with a data base. The query language can be classified into data definition language and data manipulation language.
Description : What is meant by query optimization?
Last Answer : The phase that identifies an efficient execution plan for evaluating a query that has the least estimated cost is referred to as query optimization.
Description : What is Query evaluation engine?
Last Answer : It executes low-level instruction generated by compiler.
Description : What is the use of break group? What are the various sub events a mouse double click event involves?
Last Answer : A break group is used to display one record for one group ones. While multiple related records in other group can be displayed.
Description : What are the various sub events a mouse double click event involves? What are the various sub events a mouse double click event involves?
Last Answer : Double clicking the mouse consists of the mouse down, mouse up, mouse click, mouse down & mouse up events.
Description : What is an anchoring object & what is its use? What are the various sub events a mouse double click event involves?
Last Answer : An anchoring object is a print condition object which used to explicitly or implicitly anchor other objects to itself.
Description : What are the default parameter that appear at run time in the parameter screen? What are the various sub events a mouse double click event involves?
Last Answer : Destype and Desname.
Description : What is the use of hidden column? What are the various sub events a mouse double click event involves?
Last Answer : A hidden column is used to when a column has to embed into boilerplate text.
Description : What is the use of place holder column? What are the various sub events a mouse double click event involves?
Last Answer : A placeholder column is used to hold calculated values at a specified place rather than allowing is to appear in the actual row where it has to appear.
Description : How can a break order be created on a column in an existing group? What are the various sub events a mouse double click event involves?
Last Answer : By dragging the column outside the group.
Description : Name the sub-systems of a RDBMS
Last Answer : I/O, Security, Language Processing, Process Control, Storage Management, Logging and Recovery, Distribution Control, Transaction Control, Memory Management, Lock Management
Description : Do you know how are overpopulation and transhumanism correlated with each other?
Last Answer : I think that the more overpopulation there is, the more people feel stresses from it, leading to more dissociation and distraction from embodied awareness, and more wishful thinking for an escape. Both of ... , tends to also want to mess with genetics and breed people and other animals in factories.
Description : How can I determine if two things are statistically correlated?
Last Answer : answer:Welcome to Fluther. Your hypothesis can be easily checked by direct observation. That is, list the districts that voted for McCain, then filter out those which already had a Republican Representative. You'll have a ... orders of each and see if it's true or not. Not much of a study, I think.
Description : Are flexibility and confidence correlated?
Last Answer : answer:I am flexible and I am confident. Just ask anyone I have arrested.
Description : What characteristics have you observed to be correlated with penis size?
Last Answer : I am a tall skinny guy. My penis is the same. Data Point.
Description : Is the ability to grow a good beard directly correlated to the time between shavings?
Last Answer : No, it really depends on your hair pattern. Some people just don’t have very thick facial hair and can’t grow a good beard no matter how long they try. I saw somewhere that shaving does nothing to effect the rate or thickness of hair growth.
Description : How are music preferences correlated with characteristics of the listener?
Last Answer : answer:You might be interested in the work of Samuel Gosling and Jason Rentfrow, although they are academics, not market researchers. http://www.apa.org/monitor/julaug03/listen.html
Description : How is biological loss of forest and wildlife correlated with loss of cultural diversity? -SST 10th
Last Answer : Biological loss of forest and wildlife is strongly correlated with the loss of cultural diversity as it has increasingly marginalised and impoverished many indigenous and other forest dependent communities who ... have to walk longer to get water or fuel which is directly affecting their lifestyle.
Description : If true would suggest that the speech was correlated but not a cause of his changing poll numbers?
Last Answer : Need answer
Description : Which of the following is correlated with blood pressure? (1) Liver (2) Testis (3) Pancreas (4) Adrenal
Last Answer : (4) Adrenal Explanation: Blood pressure is an important indicator of adrenal health and function. Mild adrenal weakness is usually accompanied by normal to high blood pressure. As Adrenal Fatigue advances, low blood pressure, at rest or related to posture becomes more prevalent.
Description : The variation of thermal conductivity of a metal with temperature is often correlated using an expression of the form K = K0 + at, where, K is the thermal conductivity and T is the temperature (in °K). The units of 'a' in SI system will be (A) W/m.k (B) W/m (C) W/m.k
Last Answer : (C) W/m.k
Description : Consider the following statements: 1. Standard penetration test is commonly used for cohesionless soils. 2. Standard penetration test results in respect of a cohesionless soil are correlated to its density index and friction angle. 3. Use of H- ... 2 & 3 (b) 1 & 2 only (c) 2 & 3 only (d) 1 & 3 only
Last Answer : (a) 1, 2 & 3
Description : The correlation between intelligence test scores and grades is: a. Positive b. Negative c. Perfect d. They are not correlated
Last Answer : a. Positive
Description : Which of the following adverse effects of neuroleptic drugs is positively correlated to the antipsychotic potency of the different compounds: A. Sedation B. Extrapyramidal motor disturbances C. Postural hypotension D. Lowering of seizure threshold
Last Answer : B. Extrapyramidal motor disturbances
Description : Research confirms that participation and conflict are: (a) positively correlated. (b) counterproductive. ; (c) negatively correlated. ; (d) always present together.
Last Answer : (a) positively correlated.
Description : Q scores are generally ........ correlated with academic performance. Options: A) least B) perfectly C) highly D) moderately
Last Answer : C) highly
Description : The importance of the correlation co-efficient lies in the fact that: (A) There is a linear relationship between the correlated variables. (B) It is one of the most valid measure of statistics. ... of the association be tween two variables. (D) It is a non-parametric method of statistical analysis.
Last Answer : (C) It allows one to determine the degree or strength of the association be tween two variables.
Description : Which of the following is correlated with blood pressure ? (1) Liver (2) Testis (3) Pancreas (4) Adrenal
Last Answer : Adrenal
Description : How can a search engine know exactly what you want to look for before completely finishing the query?
Last Answer : Based on what other people that typed the same ended up clicking on when they went to the page of results.
Description : FB query: I have timeline review on but things are still being shared on my timeline?
Last Answer : answer:I wish I knew because sometimes people post things on my timeline and I see other friends have liked them, which shows me that people can see them before I approve them. Other things ... can be so confusing sometimes with privacy settings and things like that, I wish they made it simpler.
Description : Another website design query (Details...)
Last Answer : answer:I would recommend looking in to writing scripts using jQuery. I'm currently in the process of designing a site myself and have been amazed at what can be accomplished now with just a ... here. They range from very simple beginner guides to some advanced shit that will rearrange your brain.
Description : How can there be "1000 search results per query?" no matter what the query is?
Last Answer : answer:If you can find more than a few dozen relevant results, you are very fortunate. By posting the 1,000 most relevant results for a search, you can give the person either more detail than they ... random stuff. In the former case, 1,000 results is enough, in the latter, search is unnecessary.