Anjali writes the following commands with respect to a table employee having fields, empno, name, department, commission. -Technology

Anjali writes the following commands with respect to a table employee having fields, empno, name, department, commission. -Technology
by

1 Answer

Answer :

This is because the column commission contains a NULL value and the aggregate functions do not take into account NULL values. Thus Command1 returns the total number of records in the table whereas Command2 returns the total number of non NULL values in the column commission.
by

Related questions

Consider the following table: Employee EmpNo EmpName Designation -Technology

Description : Consider the following table: Employee EmpNo EmpName Designation -Technology

Last Answer : 1. EmpNo can be selected as a primary key.2. EmpName is having unique values, but there is no guarantee that if more employees are included then there would not be multiple people with similar names.So, in future, its values may be duplicate. Thus, it cannot be made as a primary key.

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.

What is table? Name the basic commands for creating a table. -Technology

Description : What is table? Name the basic commands for creating a table. -Technology

Last Answer : Tables are made up of rows and columns. In HTML, tables are used to display tabular data in Web pages.The basic commands for creating tables are as follows:Table tags Row tags Cell tags andCaption tags .

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 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...

Name two possible primary keys for an Employee table. -Technology

Description : Name two possible primary keys for an Employee table. -Technology

Last Answer : Possible primary keys for an Employee table are emp code, emp phone number.

Out of the following, which one is the most appropriate data field in context of employee table, if only one of these is required? -Technology

Description : Out of the following, which one is the most appropriate data field in context of employee table, if only one of these is required? -Technology

Last Answer : (b) Date of birth is the most appropriate data field in the context of the employee table.

While creating a table named “Employee”, Mr. Rishi got confused as which data type he should chose for the column “EName” out of char and varchar. -Technology

Description : While creating a table named “Employee”, Mr. Rishi got confused as which data type he should chose for the column “EName” out of char and varchar. -Technology

Last Answer : Varchar would be the suitable data type for EName column as char data type is a fixed length data type while varchar is a variable length data type.Any employee‟s name will be of variable length so it‟s advisable to choose varchar over char data type.

Consider the table ‘Employee’. -Technology

Description : Consider the table ‘Employee’. -Technology

Last Answer : SELECT DISTINCT (Location) FROM Employee ;

How are fields, record and a table related to each other? Explain with the help of an example. -Technology

Description : How are fields, record and a table related to each other? Explain with the help of an example. -Technology

Last Answer : Fields are one type of information. A record contains logically related fields. A table Emp name contains logically related records.Emp NoNameSalary1.Shridhar200002.Raghav40000Here EmpNo, Name, and Salary are three different fields. 1, Shridhar, 20000 represents one complete record.

Anjali Of name Money What ?

Last Answer : Anjali Of name Money Additive.

What are the commands contained by Create tab? -Technology

Description : What are the commands contained by Create tab? -Technology

Last Answer : The Create tab has various commands such as Table Design, Table Templates, Pivotchart, Form, Report, Macro and Query Wizard.

Rishi, a class XII student has given following commands for the given purposes: (i) To add a new column “Rating” : -Technology

Description : Rishi, a class XII student has given following commands for the given purposes: (i) To add a new column “Rating” : -Technology

Last Answer : No, above commands will not be able to achieve desired task as update and alter commands have been interchanged.In order to achieve desired result, following corrections should be incorporated in the previously used ... give an increase of 50 Rs. to all the books:Update library set price=price+50;

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

Write the commands to do the following operations on the dataframes given above : (i) To add dataframes df1 and df2. -Technology

Description : Write the commands to do the following operations on the dataframes given above : (i) To add dataframes df1 and df2. -Technology

Last Answer : import numpy as npimport pandas as pddf1 = pd.DataFrame({'mark1':[30,40,15,40],'mark2':[20,45,30,70]});df2 = pd.DataFrame({'mark1':[10,20,20,50],'mark2':[15,25,30,30]});print(df1)print(df2)(i) ... , inplace=True) print(df1)(iv) df1.rename(index = {0: 'zero', 1:'one'}, inplace = True) print(df1)

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);

A teacher commands prestige, authority esteem and respect. He should make use of it through suggestion. He should not try to command respect through Options: A) Scholarship B) Punishing And Creating Revolting Situation C) Experience D) Tact

Description : A teacher commands prestige, authority esteem and respect. He should make use of it through suggestion. He should not try to command respect through Options: A) Scholarship B) Punishing And Creating Revolting Situation C) Experience D) Tact

Last Answer : B) Punishing And Creating Revolting Situation

A person can enjoy teaching as a profession when he (A) has control over students. (B) commands respect from students. (C) is more qualified than his colleagues. (D) is very close to higher authorities.

Description : A person can enjoy teaching as a profession when he (A) has control over students. (B) commands respect from students. (C) is more qualified than his colleagues. (D) is very close to higher authorities.

Last Answer : (B) commands respect from students.

Individual, Paid employee, Confidential officer, a Government department

Description : Individual, Paid employee, Confidential officer, a Government department

Last Answer : Find the odd one : (I) Individual, Paid employee, Confidential officer, a Government ... Chamber of Commerce, Consumer Co-operative stores.

Which of the following is not a primary concern for your Finance Department? a. Acquiring capital b. Setting credit policies for customers and suppliers c. Employee turnover d. Establishing a dividend policy e. Capital structure of the firm

Description : Which of the following is not a primary concern for your Finance Department? a. Acquiring capital b. Setting credit policies for customers and suppliers c. Employee turnover d. Establishing a dividend policy e. Capital structure of the firm

Last Answer : c. Employee turnover

As a new employee, John is most likely to look to which one of the following to learn the ethical culture of his new organisation? A)Coworkers B)Customer contact employees C)Other new employees D)The legal department E)Top management

Description : As a new employee, John is most likely to look to which one of the following to learn the ethical culture of his new organisation? A)Coworkers B)Customer contact employees C)Other new employees D)The legal department E)Top management

Last Answer : E)Top management

A ……… is a group of related fields. -Technology

Description : A ……… is a group of related fields. -Technology

Last Answer : A databaseis a group of related fields.

A database that contains tables linked by common fields is called a (a) Centralized database (b) Flat file database -Technology

Description : A database that contains tables linked by common fields is called a (a) Centralized database (b) Flat file database -Technology

Last Answer : (c) Relational database stores data in the form of tables which are linked by common fields.

Which of the following fields will not make a suitable primary key? (a) A customer’s account number -Technology

Description : Which of the following fields will not make a suitable primary key? (a) A customer’s account number -Technology

Last Answer : (b) From the given options, the data field can not be set as a primary key because it can’t be fixed for an object.

How NUMBER and DATE/TIME type fields are different in Access? Give any one difference. -Technology

Description : How NUMBER and DATE/TIME type fields are different in Access? Give any one difference. -Technology

Last Answer : NUMBER data type contains numeric values, while DATE/TIME type field contains date and time values.

What are the views in which fields can be deleted in MS_Access? -Technology

Description : What are the views in which fields can be deleted in MS_Access? -Technology

Last Answer : Datasheet View and Design View.

Predict the output displayed in text fields named jTextField2 and jTextField3 after running the above code. -Technology

Description : Predict the output displayed in text fields named jTextField2 and jTextField3 after running the above code. -Technology

Last Answer : (i) GREEN WORLD, CLEAN WORLD76 more characters can be entered(ii)length(),toUpperCase()

I put myself as a OP on a server for minecraft and none of the commands are working what do I do?

Description : I put myself as a OP on a server for minecraft and none of the commands are working what do I do?

Last Answer : answer:Make sure you’re putting the / before your server commands, of course. Otherwise, try and restart the server. Some changes like enabling monsters take time and a few restarts occasionally.

You happen to have purchased a house from the future. It accepts all kinds of voice commands. What are some of your commands?

Description : You happen to have purchased a house from the future. It accepts all kinds of voice commands. What are some of your commands?

Last Answer : “Make Bacon”

How could you execute DDL commands, such as ALTER or CREATE TABLE, against a database with ADO.NET?

Description : How could you execute DDL commands, such as ALTER or CREATE TABLE, against a database with ADO.NET?

Last Answer : You must use a Command object to execute DDL commands. You can set the CommandType property to Text and enter the appropriate DDL command in the CommandText property. Then call Command.ExecuteNonQuery to execute the command.

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

Some of the disadvantages in treating the IT department as a profit centre include all the following except: -Technology

Description : Some of the disadvantages in treating the IT department as a profit centre include all the following except: -Technology

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

To store object like image, you need to create a field in a table, having field type as …………. . -Technology

Description : To store object like image, you need to create a field in a table, having field type as …………. . -Technology

Last Answer : To store object like image, you need to create a field in a table, having field type as OLE Object.

Harmonic electromagnetic fields refer to fields varying sinusoidally with respect to time. State True/False. a) True b) False

Description : Harmonic electromagnetic fields refer to fields varying sinusoidally with respect to time. State True/False. a) True b) False

Last Answer : a) True

Constitutionally the registration and recognition of political parties is the function performed by - (1) The State Election Commission of respective States (2) The Law Ministry of Government of India (3) The Election Commission of India (4) Election Department of the State Governments

Description : Constitutionally the registration and recognition of political parties is the function performed by - (1) The State Election Commission of respective States (2) The Law Ministry of Government of India (3) The Election Commission of India (4) Election Department of the State Governments

Last Answer : (3) The Election Commission of India Explanation: Constitutionally the registration and recognition of political parties is the function performed by Election Commission of India.

The executive branch of government in charge of policy making in the telecommunications. A. National telecommunications commission B. Telecommunications control bureau C. Department of transportation and communications D. Bureau of telecommunications

Description : The executive branch of government in charge of policy making in the telecommunications. A. National telecommunications commission B. Telecommunications control bureau C. Department of transportation and communications D. Bureau of telecommunications

Last Answer : C. Department of transportation and communications

Constitutionally the registration and recognition of political parties is the function performed by (A) The State Election Commission of respective States (B) The Law Ministry of Government of India (C) The Election Commission of India (D) Election Department of the State Governments

Description : Constitutionally the registration and recognition of political parties is the function performed by (A) The State Election Commission of respective States (B) The Law Ministry of Government of India (C) The Election Commission of India (D) Election Department of the State Governments 

Last Answer : (C) The Election Commission of India 

Explain the given terms with respect to computer networks: 1. File and Data Sharing 2. Distributing Computing Power -Technology

Description : Explain the given terms with respect to computer networks: 1. File and Data Sharing 2. Distributing Computing Power -Technology

Last Answer : 1. File and Data SharingAt a time, file-sharing consisted mostly of saving documents to floppy disks that could be physically transferred to other computers by hand. With networking, files can be shared ... to a network. Any user on the network can access the resources stored on the server.

“Multimedia can stimulate the eyes, ears, brain and fingertips of a person.” With respect to the given statement explain the meaning of multimedia. -Technology

Description : “Multimedia can stimulate the eyes, ears, brain and fingertips of a person.” With respect to the given statement explain the meaning of multimedia. -Technology

Last Answer : Multimedia means any combination of text, audio, images, animation or video used for communicating through messages or information.

The text layout within’a paragraph with respect to document margins is called text alignment. -Technology

Description : The text layout within’a paragraph with respect to document margins is called text alignment. -Technology

Last Answer : TrueThe text alignment can be horizontal or vertical.

In …………….. referencing, the relative address of the cell gets adjust with respect to the current cell. -Technology

Description : In …………….. referencing, the relative address of the cell gets adjust with respect to the current cell. -Technology

Last Answer : In relative referencing, the relative address of the cell gets adjust with respect to the current cell.

What is e_Learning? Mention any two main benefits of e –learning with respect to the use of Information Technology. -Technology

Description : What is e_Learning? Mention any two main benefits of e –learning with respect to the use of Information Technology. -Technology

Last Answer : Learning with the help of electronic resources like computers, tablets, smart phone, internet etc. is known as E-learning.Advantages of eLearning are:It is time saving as well as removes the ... than traditional classroom-based instruction.It is less expensive to set-up an e-learning environment.

Define cell padding and cell spacing with respect to tables in HTML. -Technology

Description : Define cell padding and cell spacing with respect to tables in HTML. -Technology

Last Answer : CELLSPACING controls the space between table cells and CELLPADDING sets the amount of space between the contents of the cell and the cell wall.

Mark the incorrect option a) An Inspector must posses a practical knowledge of post office work, and with all departmental forms so as to be qualified to instruct his subordinates in their duties, especially when any new class of business is undertaken by the Department. b) He must also be qualified to take charge of a head office or important sub-office in any sudden emergency c) An inspector must be having knowledge of Technology and management. d) None of these

Description : Mark the incorrect option a) An Inspector must posses a practical knowledge of post office work, and with all departmental forms so as to be qualified to instruct his subordinates in their duties ... emergency c) An inspector must be having knowledge of Technology and management. d) None of these

Last Answer : c) An inspector must be having knowledge of Technology and management.

Which one of the following is incorrect in respect of Local Government in India? (1) According to the Indian Constitution, local government is not an independent tier in the federal system. (2) 30% of the seats in local bodies are reserved for women (3) Local government finances are to be provided by a Commission (4) Elections to local bodies are to be determined by a Commission

Description : Which one of the following is incorrect in respect of Local Government in India? (1) According to the Indian Constitution, local government is not an independent tier in the federal system. (2) 30% ... to be provided by a Commission (4) Elections to local bodies are to be determined by a Commission

Last Answer : (2) 30% of the seats in local bodies are reserved for women Explanation: According to 73rd amendment act 1993, under article 243D, not less than 1/3rd i.e. 33% seats should be reserved for women.

Which one of the following statements is not correct about the University Grants Commission (UGC)? (A) It was established in 1956 by an Act of Parliament. (B) It is tasked with promoting and coordinating higher education. (C) It receives Plan and Non-Plan funds from the Central Government. (D) It receives funds from State Governments in respect of State Universities

Description : Which one of the following statements is not correct about the University Grants Commission (UGC)? (A) It was established in 1956 by an Act of Parliament. (B) It is tasked with promoting ... from the Central Government. (D) It receives funds from State Governments in respect of State Universities

Last Answer : (D) It receives funds from State Governments in respect of State Universities

Manager's salary details are to be hidden from Employee Table. This Technique is called as (A) Conceptual level Datahiding (B) Physical level Datahiding (C) External level Datahiding (D) Logical level Datahiding

Description : Manager's salary details are to be hidden from Employee Table. This Technique is called as (A) Conceptual level Datahiding (B) Physical level Datahiding (C) External level Datahiding (D) Logical level Datahiding

Last Answer : (C) External level Datahiding