To select tuples with some salary, Siddharth has written the following erroneous SQL statement : -Technology

To select tuples with some salary, Siddharth has written the following erroneous SQL statement : -Technology
by

1 Answer

Answer :

The correct code is :SELECT ID, Salary FROM empsalaryWHERE Salary = 56000 ;
by

Related questions

Suppose ORACLE relation R(A, B) currently has tuples {(1, 2), (1, 3), (3, 4)} and relation S(B, C) currently has {(2, 5), (4, 6), (7, 8)}. Consider the following two SQL queries SQ1 and SQ2 : SQ1 : Select * From R Full Join S On R.B=S.B; SQ2 : Select * From R Inner Join S On R.B=S.B; The numbers of tuples in the result of the SQL query SQ1 and the SQL query SQ2 are given by : (A) 2 and 6 respectively (B) 6 and 2 respectively (C) 2 and 4 respectively (D) 4 and 2 respectively

Description : Suppose ORACLE relation R(A, B) currently has tuples {(1, 2), (1, 3), (3, 4)} and relation S(B, C) currently has {(2, 5), (4, 6), (7, 8)}. Consider the following two SQL queries SQ1 and SQ2 ... (A) 2 and 6 respectively (B) 6 and 2 respectively (C) 2 and 4 respectively (D) 4 and 2 respectively

Last Answer : (D) 4 and 2 respectively

Consider the following two commands C1 and C2 on the relation R from an SQL database: C1: drop table R; C2: delete from R; Which of the following statements is TRUE? I. Both C1 and C2 delete the schema for R. II. C2 retains relation R, but deletes all tuples in R. III. C1 deletes not only all tuples of R, but also the schema for R. (A) I only (B) I and II only (C) II and III only (D) I, II and III

Description : Consider the following two commands C1 and C2 on the relation R from an SQL database:  C1: drop table R; C2: delete from R; Which of the following statements is TRUE? I. Both C1 and C2 delete the schema for R. II. C2 ... R. (A) I only (B) I and II only (C) II and III only (D) I, II and III

Last Answer : (C) II and III only

Which of the following is a legal expression in SQL? (A) SELECT NULL FROM EMPLOYEE; (B) SELECT NAME FROM EMPLOYEE; (C) SELECT NAME FROM EMPLOYEE WHERE SALARY = NULL; (D) None of the above

Description : Which of the following is a legal expression in SQL? (A) SELECT NULL FROM EMPLOYEE; (B) SELECT NAME FROM EMPLOYEE; (C) SELECT NAME FROM EMPLOYEE WHERE SALARY = NULL; (D) None of the above

Last Answer : B) SELECT NAME FROM EMPLOYEE;

Write the output of the following SQL command. select round (49.88); (a)49.88 (b)49.8 (c)49.0 (d)50 -Technology

Description : Write the output of the following SQL command. select round (49.88); (a)49.88 (b)49.8 (c)49.0 (d)50 -Technology

Last Answer : The correct answer is : (a) 50

Pick up the correct statement from the following: (A) The apparent error on reversal is twice the actual error (B) The correction may be made equal to half the observed discrepancy (C) The good results may be obtained from a defective instrument by reversing and taking the mean of two erroneous results (D) All the above

Description : Pick up the correct statement from the following: (A) The apparent error on reversal is twice the actual error (B) The correction may be made equal to half the observed discrepancy (C) The ... a defective instrument by reversing and taking the mean of two erroneous results (D) All the above

Last Answer : (D) All the above

What are the four major parts of a SQL SELECT statement? Briefly describe each one.

Description : What are the four major parts of a SQL SELECT statement? Briefly describe each one.

Last Answer : The four major parts of a SELECT statement are SELECT, FROM, WHERE, and ORDER BY. SELECT specifies the fields to be retrieved. FROM specifies the table from which the records are to be retrieved. WHERE ... the records to be retrieved, and ORDER BY allows you to specify a sort order for the records.

The statement in SQL which allows to change the definition of a table is (A) Alter. (B) Update. (C) Create. (D) select.

Description : The statement in SQL which allows to change the definition of a table is (A) Alter. (B) Update. (C) Create. (D) select

Last Answer : (A) Alter.

Consider a “CUSTOMERS” database table having a column “CITY” filled with all the names of Indian cities (in capital letters). The SQL statement that finds all cities that have “GAR” somewhere in its name, is: (A) Select *from customers where city=’%GAR%’; (B) Select *from customers where city=’$GAR$’; (C) Select *from customers where city like ‘%GAR%’; (D) Select *from customers where city as ’%GAR’;

Description : Consider a CUSTOMERS database table having a column CITY filled with all the names of Indian cities (in capital letters). The SQL statement that finds all cities that have GAR somewhere in its name, ... *from customers where city like %GAR%'; (D) Select *from customers where city as '%GAR';

Last Answer : Answer: C

What is the purpose of SQL? -Technology

Description : What is the purpose of SQL? -Technology

Last Answer : SQL is structured query language. It is a standard language of all the RDBMS.

Help him in writing SQL query for the following purpose: (i) To count how many female candidates will be attending the training. -Technology

Description : Help him in writing SQL query for the following purpose: (i) To count how many female candidates will be attending the training. -Technology

Last Answer : (i)Select count(name) from training where name like ‘Ms.%’;(ii) Select * from training where fee is NULL;(iii) Select city, fee from training where topic = ‘Cyber Security’;(iv) Alter table training add feedback varchar(20);

Ms. Pari, a beginner in SQL is not able to understand the meaning of “Cancelling a Transaction”. Help her in understanding the same. -Technology

Description : Ms. Pari, a beginner in SQL is not able to understand the meaning of “Cancelling a Transaction”. Help her in understanding the same. -Technology

Last Answer : Cancelling a transaction means rolls the transaction to the beginning. It aborts any changes made during the transaction and the state of database is returned to what it was before the transaction began to execute.Rollback command is used for the same.

Write SQL query to create a table “BOOKS” with the following structure: Table: BOOKS -Technology

Description : Write SQL query to create a table “BOOKS” with the following structure: Table: BOOKS -Technology

Last Answer : Create table Books(BOOK_ID Integer (2) Primary Key,BOOK_NAME Varchar (20),CATEGORY Varchar (20),ISSUE_DATE Date);

Write SQL query to create a table “Registration” with the following structure: -Technology

Description : Write SQL query to create a table “Registration” with the following structure: -Technology

Last Answer : Create table Registration(Reg_Id Integer(2) Primary Key,Name varchar(20),Course varchar(10),Join_Dt date);

With reference to the above given tables, write commands in SQL for (i) and (ii) and output for (iii) below: -Technology

Description : With reference to the above given tables, write commands in SQL for (i) and (ii) and output for (iii) below: -Technology

Last Answer : (i) select TName, Passenger from Train T, Reservation R where T.TrainId=R.TrainId;(ii) select T.* from Train T, Reservation R where T.TrainId!=R.TrainId;(iii)TrainIdTNameSourceDestination3424Lucknow MailLucknowNew Delhi5400Century ExpressNew DelhiKanpur

What is the use of COMMIT in sql ? -Technology

Description : What is the use of COMMIT in sql ? -Technology

Last Answer : Commit is used to save all the DML transactions, and once saved they cannot be rolled back.

What is the purpose of SQL? -Technology

Description : What is the purpose of SQL? -Technology

Last Answer : SQL is structured query language. It is a standard language of all the RDBMS.

Name SQL Single Row functions (for each of the following) that 1. returns a number. -Technology

Description : Name SQL Single Row functions (for each of the following) that 1. returns a number. -Technology

Last Answer : (i) ASCII () function returns a number.(ii) LCASE () function returns lowercase letters .(iii) DAYNAME () function returns names of days.(iv) DAYOFWEEK () function returns weekday number

Consider the following table Furniture. Write SQL commands for the statements (i) to (viii) and write output for SQL queries (ix) and (x). -Technology

Description : Consider the following table Furniture. Write SQL commands for the statements (i) to (viii) and write output for SQL queries (ix) and (x). -Technology

Last Answer : SQL commands for the given statements (i) to (viii) ;1. SELECT FCODE, NAME. PRICE FROM Furniture WHERE PRICE < 5000;2. SELECT NAME. PRICE FROM Furniture3.4. WHERE NAME LIKE %table% ;5. SELECT DISTINCT WCODE ... ;15.16. Output for SQL queries (ix) and (x)(ix)SUM(PRICE)6500(x)COUNT(DISTINCT PRICE)5

Write SQL query to create a table Inventory with the following structure : -Technology

Description : Write SQL query to create a table Inventory with the following structure : -Technology

Last Answer : CREATE TABLE Inventory(Material Id Integer Primary Key,Material Varchar (50) NOT NULL,Category Char,DatePurchase Date) :

Write SQL query to create a table Player with the following structure : -Technology

Description : Write SQL query to create a table Player with the following structure : -Technology

Last Answer : CREATE TABLE Player(};

Write SQL Query commands based on the following table: -Technology

Description : Write SQL Query commands based on the following table: -Technology

Last Answer : This answer was deleted by our moderators...

The ....... command can be used to makes changes in the rows of a table in SQL. -Technology

Description : The ....... command can be used to makes changes in the rows of a table in SQL. -Technology

Last Answer : The update command can be used to makes changes in the rows of a table in SQL.

Write the SQL command that will display the current time and date. -Technology

Description : Write the SQL command that will display the current time and date. -Technology

Last Answer : Select now();

Consider the decimal number x with value 8459.2654. Write commands in SQL to: i. round it off to a whole number -Technology

Description : Consider the decimal number x with value 8459.2654. Write commands in SQL to: i. round it off to a whole number -Technology

Last Answer : i. select round(8459.2654);ii.select round(8459.2654,-2);

Consider the following SQL string: “Preoccupied” Write commands to display: (a)“occupied” (b)“cup” -Technology

Description : Consider the following SQL string: “Preoccupied” Write commands to display: (a)“occupied” (b)“cup” -Technology

Last Answer : commands to display:(a)“occupied” (b)“cup”

Considering the same string “Preoccupied” Write SQL commands to display: (a) the position of the substring ‘cup’ in the string “Preoccupied” -Technology

Description : Considering the same string “Preoccupied” Write SQL commands to display: (a) the position of the substring ‘cup’ in the string “Preoccupied” -Technology

Last Answer : (a)select instr 'Preoccupied' , ‘ 'cup'));(b)select left 'Preoccupied',4);

Write the SQL functions which will perform the following operations: (i) To display the name of the month of the current date . -Technology

Description : Write the SQL functions which will perform the following operations: (i) To display the name of the month of the current date . -Technology

Last Answer : (i) monthname(date(now()))(ii) trim(“ Panaroma “)(iii) dayname(date(dob))(iv) instr(name, fname)(v) mod(n1,n2)

Ms. Shalini has just created a table named “Employee” containing columns Ename, Department, Salary. -Technology

Description : Ms. Shalini has just created a table named “Employee” containing columns Ename, Department, Salary. -Technology

Last Answer : SQL command to add a primary key column:Alter table employee add empid int primary key;Importance of Primary key in a table:Primary key column is used to uniquely identify each record of the table. A column defined as primary key cannot have a duplicate entry and can't be left blank.

Paid salary to staff rs 2500 -Technology

Description : Paid salary to staff rs 2500 -Technology

Last Answer : This answer was deleted by our moderators...

Write the command using Insert() function to add a new column in the last place(3rd place) named “Salary” from the list Sal=[10000,15000,20000] -Technology

Description : Write the command using Insert() function to add a new column in the last place(3rd place) named “Salary” from the list Sal=[10000,15000,20000] -Technology

Last Answer : EMP.insert(loc=3,column=”Salary”,value=Sal)

Mr. Pawan works as a programmer in “ABC Marketing Company” where he has designed a Salary -Technology

Description : Mr. Pawan works as a programmer in “ABC Marketing Company” where he has designed a Salary -Technology

Last Answer : (i) We need to double click at the Commission button (jButtonl) and type the following code :int Commission :if (jRadioButtonl. isSelected ( ) = True )Commission = 500 ;elseif ( ... and type the following code :int Net_Sal ;Net_Sal = Gross_Sal-Fac_Charges ;jTextField6. setText (Net_Sal) ;

Consider a table SALESMAN with the following data: SNO SNAME SALARY BONUS DATE OF JOIN A01 Beena Mehta 30000 45.23 29_10_2019 A02 K. L. -Technology

Description : Consider a table SALESMAN with the following data: SNO SNAME SALARY BONUS DATE OF JOIN A01 Beena Mehta 30000 45.23 29_10_2019 A02 K. L. -Technology

Last Answer : alternative answer

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.

Would it be erroneous to call the morning or afternoon busy drive time "rush hour" in a small town?

Description : Would it be erroneous to call the morning or afternoon busy drive time "rush hour" in a small town?

Last Answer : Not necessarily. The small town may be between two larger cities and be covered up with traffic both morning and afternoon.

Would this type of disclosure be erroneous?

Description : Would this type of disclosure be erroneous?

Last Answer : answer:I think it's a great idea, @Ltryptophan. It would require some working out, though: you'd have to know the price in advance and agree to it, and there'd have to be some kind of ... idea? You couldn't. I sure think your question itself could use a much better and clearer subject line.

What is erroneous perception or practice ?

Description : What is erroneous perception or practice ?

Last Answer : Practicing or misdiagnosis is the name given to misdiagnosis of a real stimulus.

Is the belief that one can get rich by inventing games an erroneous?

Description : Is the belief that one can get rich by inventing games an erroneous?

Last Answer : Games can take a long time to develop. Triple A games created bymassive companies sell quite a lot of copies if they are popularenough, like Call of Duty or Battlefield. However, they also cost ... different from triple A titles.Short-answer: You'll need some help and experience to reach thatfirst.

What are the two types of fraud that may lead to an erroneous payment In the Purchase Card program?

Description : What are the two types of fraud that may lead to an erroneous payment In the Purchase Card program?

Last Answer : third party and government

When troubleshooting electronic equipment, you should use a high impedance multimeter ________________. A. to prevent excess current flow through the meter that would damage it B. for AC measurements only and a low resistance meter for DC measurements C. whenever a low impedance meter is not available, regardless of the components being tested D. so as not to load down the circuit and obtain erroneous voltage readings

Description : When troubleshooting electronic equipment, you should use a high impedance multimeter ________________. A. to prevent excess current flow through the meter that would damage it B. for AC measurements only ... being tested D. so as not to load down the circuit and obtain erroneous voltage readings

Last Answer : Answer: D

Sources of impulse noise induced in communication channels. A. Erroneous digital coding bit caused by an error on a transmission facility B. Transients due to relay operation C. Crosstalk from dc signaling systems D. All of these

Description : Sources of impulse noise induced in communication channels. A. Erroneous digital coding bit caused by an error on a transmission facility B. Transients due to relay operation C. Crosstalk from dc signaling systems D. All of these

Last Answer : D. All of these

Which method is used to detect double errors and pinpoint erroneous bits. a. Even parity method b. Odd parity method c. Check sum method. d. All of these

Description : Which method is used to detect double errors and pinpoint erroneous bits. a. Even parity method b. Odd parity method c. Check sum method. d. All of these

Last Answer : c. Check sum method.

When the auditor issues an erroneous opinion as a consequence of an underlying failure to comply with the requirements of generally accepted auditing standards, it results to a. Business failure. b. Audit failure. c. Audit risk. d. All of them

Description : When the auditor issues an erroneous opinion as a consequence of an underlying failure to comply with the requirements of generally accepted auditing standards, it results to a. Business failure. b. Audit failure. c. Audit risk. d. All of them

Last Answer : Audit failure.

If the area calculated form the plan plotted with measurements by an erroneous chain, accurate area of the plan is (A) Measured area × (Length of chain used/Nominal chain length) (B) Measured area × (Nominal chain length/ Length of chain used) (C) Measured area × (Nominal chain length/ Length of chain used)² (D) Measured area × (Length of chain used/Nominal chain length)²

Description : If the area calculated form the plan plotted with measurements by an erroneous chain, accurate  area of the plan is  (A) Measured area (Length of chain used/Nominal chain length)  (B) Measured ... of chain used)²  (D) Measured area (Length of chain used/Nominal chain length)² 

Last Answer : (D) Measured area × (Length of chain used/Nominal chain length)² 

Which one of the following mistakes/errors may be cumulative + or - : (A) Bad ranging (B) Bad straightening (C) Erroneous length of chain (D) Sag

Description : Which one of the following mistakes/errors may be cumulative + or - :  (A) Bad ranging  (B) Bad straightening  (C) Erroneous length of chain  (D) Sag

Last Answer : (C) Erroneous length of chain

Correct distance obtained by an erroneous chain is: (A) (Erroneous chain length/Correct chain length) × Observed distance (B) (Correct chain length/Erroneous chain length) × Observed distance (C) (Correct chain length/Observed distance) × Erroneous chain length (D) None of these

Description : Correct distance obtained by an erroneous chain is: (A) (Erroneous chain length/Correct chain length) × Observed distance (B) (Correct chain length/Erroneous chain length) × Observed distance (C) (Correct chain length/Observed distance) × Erroneous chain length (D) None of these

Last Answer : (A) (Erroneous chain length/Correct chain length) × Observed distance

The method of reversal (A) Is usually directed to examine whether a certain part is truly parallel or perpendicular to another (B) Makes the erroneous relationship between parts evident (C) Both (a) and (b) (D) Neither (a) nor (b)

Description : The method of reversal (A) Is usually directed to examine whether a certain part is truly parallel or perpendicular to another (B) Makes the erroneous relationship between parts evident (C) Both (a) and (b) (D) Neither (a) nor (b)

Last Answer : (C) Both (a) and (b

How are erroneous transfers of data prevented?

Description : How are erroneous transfers of data prevented?

Last Answer : By clearing the register.