Select ‘NORTH’, CUSTOMER From CUST_DTLS Where REGION = ‘N’ Order By CUSTOMER Union Select ‘EAST’, CUSTOMER From CUST_DTLS Where REGION = ‘E’ Order By CUSTOMER The above is a) Not an error b) Error - the string in single quotes ‘NORTH’ and ‘SOUTH’ c) Error - the string should be in double quotes d) Error - ORDER BY clause

Select ‘NORTH’, CUSTOMER From CUST_DTLS Where REGION = ‘N’ Order By CUSTOMER Union Select ‘EAST’, CUSTOMER From CUST_DTLS Where REGION = ‘E’ Order By CUSTOMER  The above is  a) Not an error  b) Error - the string in single quotes ‘NORTH’ and ‘SOUTH’  c) Error - the string should be in double quotes  d) Error - ORDER BY clause
by

1 Answer

Answer :

d) Error - ORDER BY clause
by

Related questions

Can you use select in FROM clause of SQL select ?

Description : Can you use select in FROM clause of SQL select ?

Last Answer : Yes.

How many LONG columns are allowed in a table ? Is it possible to use LONG columns in WHERE clause or ORDER BY ?

Description : How many LONG columns are allowed in a table ? Is it possible to use LONG columns in WHERE clause or ORDER BY ?

Last Answer : Only one LONG columns is allowed. It is not possible to use LONG column in WHERE or ORDER BY clause.

Suppose a customer table is having different columns like customer no, payments.What will be the query to select top three max payments?

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

SQL> SELECT * FROM MY_SCHEMA.MY_TABLE; SP2-0678: Column or attribute type cannot be displayed by SQL*Plus Why I’m getting this error?

Description : SQL> SELECT * FROM MY_SCHEMA.MY_TABLE; SP2-0678: Column or attribute type cannot be displayed by SQL*Plus Why I’m getting this error?

Last Answer : The table has a BLOB column.

Which parameter specified in the DEFAULT STORAGE clause of CREATE TABLESPACE cannot be altered after creating the tablespace?

Description : Which parameter specified in the DEFAULT STORAGE clause of CREATE TABLESPACE cannot be altered after creating the tablespace?

Last Answer : All the default storage parameters defined for the tablespace can be changed using the ALTER TABLESPACE command. When objects are created their INITIAL and MINEXTENS values cannot be changed.

When do you use WHERE clause and when do you use HAVING clause?

Description : When do you use WHERE clause and when do you use HAVING clause?

Last Answer : HAVING clause is used when you want to specify a condition for a group function and it is written after GROUP BY clause. The WHERE clause is used when you want to specify a condition for columns, single row functions except group functions and it is written before GROUP BY clause if it is used.

What WHERE CURRENT OF clause does in a cursor?

Description : What WHERE CURRENT OF clause does in a cursor?

Last Answer : LOOP SELECT num_credits INTO v_numcredits FROM classes WHERE dept=123 and course=101; UPDATE students FHKO;;;;;;;;;SET current_credits=current_credits+v_numcredits WHERE CURRENT OF X;

Explain the usage of WHERE CURRENT OF clause in cursors ?

Description : Explain the usage of WHERE CURRENT OF clause in cursors ?

Last Answer : WHERE CURRENT OF clause in an UPDATE,DELETE statement refers to the latest row fetched from a cursor. Database Triggers

Which parameter in Storage clause will reduce no. of rows per block?

Description : Which parameter in Storage clause will reduce no. of rows per block?

Last Answer : PCTFREE parameter Row size also reduces no of rows per block.

What is the significance of having storage clause ?

Description : What is the significance of having storage clause ?

Last Answer : We can plan the storage for a table as how much initial extents are required, how much can be extended next, how much % should leave free for managing row updations etc.,

What is a property clause?

Description : What is a property clause?

Last Answer : A property clause is a named object that contains a list of properties and their settings. Once you create a property clause you can base other object on it. An object based on a property can inherit the setting of any property in the clause that makes sense for that object.

Can a property clause itself be based on a property clause?

Description : Can a property clause itself be based on a property clause?

Last Answer : Yes

The region of the United States with the lowest pH values found in rainwater (acid rain) is: w) Mid West x) North West y) North East z) South East

Description : The region of the United States with the lowest pH values found in rainwater (acid rain) is: w) Mid West x) North West y) North East z) South East 

Last Answer : ANSWER: Y -- NORTH EAST 

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?

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.

Is it better to use single or double quotes when coding with PHP?

Description : Is it better to use single or double quotes when coding with PHP?

Last Answer : They’re actually interpreted differently. See here.

There is a string 120000 12 0 .125 , how you will find the position of the decimal place?

Description : There is a string 120000 12 0 .125 , how you will find the position of the decimal place?

Last Answer : INSTR('120000 12 0 .125',1,'.') output 13

What is the difference between the order by and group by clause when used along with the select statement. -Technology

Description : What is the difference between the order by and group by clause when used along with the select statement. -Technology

Last Answer : The order by clause is used to show the contents of a table/relation in a sorted manner with respect to the column mentioned after the order by clause. The contents of the column can be arranged in ... a given column and then apply an aggregate function eg max(), min() etc on the entire group.

……………… clause is an additional filter that is applied to the result. A) Select B) Group-by C) Having D) Order by

Description : ……………… clause is an additional filter that is applied to the result. A) Select B) Group-by C) Having D) Order by

Last Answer : C) Having

What is the most critical aspect in developing a project plan that meets project specifications within the timeframe and at the lowest costs? Select one: a. Assessing risk managemenc. Emphasizing error prevention and customer satisfaction d. Requiring commitment to quality by all the employees and business partners e. Developing a project execution plan that matches the complexity level of the projectt b. Providing documents that specifically comply with the quality standards in use

Description : What is the most critical aspect in developing a project plan that meets project  specifications within the timeframe and at the lowest costs? Select one: a. Assessing risk management b ... business partners e. Developing a project execution plan that matches the complexity level of the project

Last Answer : e. Developing a project execution plan that matches the complexity level of the project

Consider the following railway zones: 1. North-Eastern Railway 2. Central Railway 3. North-Western Railway 4. South-Eastern Railway Which one of the following is the correct order of locations of the headquarters of the above railway zones from west to east ? [Asstt Commt 2010] (a) 1-2-3-4 (b) 2-3-1-4 (c) 3-2-4-1 (d) 3-4-2-1

Description : Consider the following railway zones: 1. North-Eastern Railway 2. Central Railway 3. North-Western Railway 4. South-Eastern Railway Which one of the following is the correct order of locations of the headquarters of the above railway zones from west ... 1-2-3-4 (b) 2-3-1-4 (c) 3-2-4-1 (d) 3-4-2-1

Last Answer : Ans: (b)

What pull factor is responsible for the east to west migration pattern evident in the European Union region?

Description : What pull factor is responsible for the east to west migration pattern evident in the European Union region?

Last Answer : What is the answer ?

Is this a grammatical error? What type of clause is this?

Description : Is this a grammatical error? What type of clause is this?

Last Answer : All three sentences need to begin with Whilst or While. Plus, it will be tedious if the author uses the same sentence structure constantly. Generally, one wants to mix sentences of different ... (unless the sentences are so long and convoluted that they're difficult and painful to follow).

How do you trap the error in forms 3.0 ?

Description : How do you trap the error in forms 3.0 ?

Last Answer : using On-Message or On-Error triggers.

What is ORA-01555 - Snapshot Too Old error and how do you avoid it?

Description : What is ORA-01555 - Snapshot Too Old error and how do you avoid it?

Last Answer : The ORA-01555 is caused by Oracle read consistency mechanism. If you have a long running SQL that starts at 11:30 AM, Oracle ensures that all rows are as they appeared at 11:30 AM, ... -01555 snapshot too old also relates to your setting for automatic undo retention ▪ Don't fetch between commits

What is ORA-01555 - Snapshot Too Old error and how do you avoid it?

Description : What is ORA-01555 - Snapshot Too Old error and how do you avoid it?

Last Answer : The ORA-01555 is caused by Oracle read consistency mechanism. If you have a long running SQL that starts at 11:30 AM, Oracle ensures that all rows are as they appeared at 11:30 AM, ... -01555 snapshot too old also relates to your setting for automatic undo retention ▪ Don't fetch between commits

Explain UNION,MINUS,UNION ALL, INTERSECT ?

Description : Explain UNION,MINUS,UNION ALL, INTERSECT ?

Last Answer : INTERSECT returns all distinct rows selected by both queries.MINUS - returns all distinct rows selected by the first query but not by the second.UNION - returns all distinct rows selected by either queryUNION ALL - returns all rows selected by either query, including all duplicates.

What is the use of break group? What are the various sub events a mouse double click event involves?

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.

What are the various sub events a mouse double click event involves? What are the various sub events a mouse double click event involves?

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.

What is an anchoring object & what is its use? What are the various sub events a mouse double click event involves?

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.

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?

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.

What are the various sub events a mouse double click event involves? What are the various sub events a mouse double click event involves?

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.

What is the use of hidden column? What are the various sub events a mouse double click event involves?

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.

What is the use of place holder column? What are the various sub events a mouse double click event involves?

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.

1. What is the Branch of science which deals with the study of skin of man? 2. Up to howmuch age can the Members of the Union Public Service Commission function? 3. The north pole of the earth’s magnet is near the geographical which direction? 4. Which region gets no rainfall throughout the year? 5. Tansen, the greatest musician of Akbar’s court, belonged to which place?

Description : 1. What is the Branch of science which deals with the study of skin of man? 2. Up to howmuch age can the Members of the Union Public Service Commission function? 3. The north pole of the ... is the largest irrigation canal in the world? 20. Who bestowed the Office of Peshwa on Balaji Vishwanath ?

Last Answer : Answer : 1. Dermatology 2. 65 years 3. South 4. The Tundra Region 5. Gwalior 6. Hague 7. Oct. 24, 1945 8. Malacology 9. Cirque 10. Akbar 11. UK 12. Yeast 13. Promoting adult ... Inselberg 15. Todar Mal 16. S. Chandrashekhar 17. Rifampicin 18. French revolution 19. Indira Gandhi Canal 20. Shahu

Why is the erie canal important to the north east region?

Description : Why is the erie canal important to the north east region?

Last Answer : it makes it faster to deliver goods

Which region in India is known as the 'Rice Bowl of India'? (a) Indo-Gangetic Plain (b) Krishna-Godavari Delta region (c) North-East region (d) Kerala and Tamil Nadu

Description : Which region in India is known as the 'Rice Bowl of India'? (a) Indo-Gangetic Plain (b) Krishna-Godavari Delta region (c) North-East region (d) Kerala and Tamil Nadu

Last Answer : Ans: (b)

Match List I with List II and select the correct answer by using the codes gives below the lists: List-I (Climatic conditions) List-II (Resons) A. Chennai is warmer than Kolkata 1. North-East Monsoon B. Snowfall in Himalayas 2. Altitude C. Rainfall decreases from West Bengal to Punjab 3. Western depressions D. Sutlej-Ganga Plain gets some rain in winter 4. Distance from sea 5. Latitude Codes: A B C D (a) 1 2 4 5 (b) 4 5 1 3 (c) 5 2 4 3 (d) 5 1 3 4

Description : Match List I with List II and select the correct answer by using the codes gives below the lists: List-I (Climatic conditions) List-II (Resons) A. Chennai is warmer than Kolkata 1. North-East Monsoon B. Snowfall in Himalayas 2. Altitude C. ... (a) 1 2 4 5 (b) 4 5 1 3 (c) 5 2 4 3 (d) 5 1 3 4

Last Answer : Ans: (c)

Is it possible to split the print reviewer into more than one region?

Description : Is it possible to split the print reviewer into more than one region?

Last Answer : Yes

A burst error means that two or more bits in the dataunit havechanged. A) double-bit B) burst C) single-bit D) none of the above

Description : A burst error means that two or more bits in the dataunit havechanged. A) double-bit B) burst C) single-bit D) none of the above

Last Answer : burst

Can you use select in FROM clause of SQL select ?

Description : Can you use select in FROM clause of SQL select ?

Last Answer : Yes.

Do people "over use" "double quotes" more than is "necessary"?

Description : Do people "over use" "double quotes" more than is "necessary"?

Last Answer : “No.”

How to add conditions in select statement in oracle?

Description : How to add conditions in select statement in oracle?

Last Answer : Just add the decode

How do u implement the If statement in the Select Statement

Description : How do u implement the If statement in the Select Statement

Last Answer : We can implement the if statement in the select statement by using the Decode statement. e.g select DECODE (EMP_CAT,'1','First','2','Second'Null); Here the Null is the else statement where null is done .

Can a formula column be obtained through a select statement?

Description : Can a formula column be obtained through a select statement?

Last Answer : Yes

maxvalue.sql Select the Nth Highest value from a table?

Description : maxvalue.sql Select the Nth Highest value from a table?

Last Answer : select level, max('col_name') from my_table where level = '&n' connect by prior ('col_name') > 'col_name') group by level; Example: Given a table called emp with the following columns: -- id number -- name ... , max(sal) from emp -- where level=2 -- connect by prior sal > sal -- group by level

minvalue.sql Select the Nth lowest value from a table?

Description : minvalue.sql Select the Nth lowest value from a table?

Last Answer : select level, min('col_name') from my_table where level = '&n' connect by prior ('col_name') < 'col_name') group by level; Example: Given a table called emp with the following columns: -- id number -- name ... , min(sal) from emp -- where level=2 -- connect by prior sal < sal -- group by level

What a SELECT FOR UPDATE cursor represent.?

Description : What a SELECT FOR UPDATE cursor represent.?

Last Answer : SELECT......FROM......FOR......UPDATE[OF column-reference][NOWAIT] The processing done in a fetch loop modifies the rows that have been retrieved by the cursor. A convenient way of ... the FOR UPDATE clause in the cursor declaration, WHERE CURRENT OF CLAUSE in an UPDATE or declaration statement.

How is it possible to select generate a select set for the query in the query property sheet?

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.

What is a difference between pre-select and pre-query?

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.

Can you audit SELECT statements?

Description : Can you audit SELECT statements?

Last Answer : YES. But beware; you will need a storage mechanism to hold your SQL SELECT audits, a high data volume that can exceed the size of your whole database, every day. SQL SELECT auditing can be ... data in the audit trail must also be audited to see who has selected data from the audit trail.