Consider the table ‘Teacher’ given below. -Technology

Consider the table ‘Teacher’ given below. -Technology
by

1 Answer

Answer :

(i) Select count(Department) from Teacher ;(ii) Select count (*) from Teacher ;
by

Related questions

Consider the table STUDENT given below: RollNo Name Class DOB Gender City Marks 1 Anand XI 6/6/97 M Agra 430 -Technology

Description : Consider the table STUDENT given below: RollNo Name Class DOB Gender City Marks 1 Anand XI 6/6/97 M Agra 430 -Technology

Last Answer : (1)b. Both (iii) and (iv)(2) b.RollnoNameClassDOBGenderCityMarks6734MaakhiyNehaGeetPreetiXIXXIXII12/12/948/12/956/5/978/8/95FFFFDubaiMoscowAgraMumbai256324470492

Consider the following dataframe, and answer the questions given below: -Technology

Description : Consider the following dataframe, and answer the questions given below: -Technology

Last Answer : (i) print(df.mean(axis = 1, skipna = True)) print(df.mean(axis = 0, skipna = True))(ii) print(df.sum(axis = 1, skipna = True))(iii) print(df.median())

Consider the tables given below. Salesperson -Technology

Description : Consider the tables given below. Salesperson -Technology

Last Answer : (i) Primary, Foreign(ii) Salespersons cannot be set as the primary key in the table Orders because table Orders has already primary key and one table cannot have more than one primary key column.

Write the HTML code to create the exact table which is given below: ADMNO SNAME NAME DOB -Technology

Description : Write the HTML code to create the exact table which is given below: ADMNO SNAME NAME DOB -Technology

Last Answer : The HTML code is ADMNO SNAMENAMEDOB1110MANJITRANJIT4-MAR-1998

In Marks column of ‘Student’ table, for Rollnumber 2, the Class Teacher entered the marks as 45. -Technology

Description : In Marks column of ‘Student’ table, for Rollnumber 2, the Class Teacher entered the marks as 45. -Technology

Last Answer : UPDATE Student SET Marks = 50 WHERE Roll number = 2;

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.

When you define a field for a table, which of the following parameters do Access always consider optional? -Technology

Description : When you define a field for a table, which of the following parameters do Access always consider optional? -Technology

Last Answer : (d) Description field of the table is optional, as it depends on the databasedesigner that he/she wants to describe a field or not.

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

Consider the table ‘Employee’. -Technology

Description : Consider the table ‘Employee’. -Technology

Last Answer : SELECT DISTINCT (Location) FROM Employee ;

Consider the Stu table , -Technology

Description : Consider the Stu table , -Technology

Last Answer : The output is

Consider the following Series object, S_amt Table 350 Chair 200 Sofa 800 Stool 150 i. Write the command which will display the name -Technology

Description : Consider the following Series object, S_amt Table 350 Chair 200 Sofa 800 Stool 150 i. Write the command which will display the name -Technology

Last Answer : i. print(S_amt[S_amt>250])ii. S_amt.name= 'Furniture'

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

Write the HTML code to generate the following table on a Web page with the contents and alignment exactly as shown below: -Technology

Description : Write the HTML code to generate the following table on a Web page with the contents and alignment exactly as shown below: -Technology

Last Answer : The HTML code is

Consider a given Series , M1: Write a program in Python Pandas to create the series. -Technology

Description : Consider a given Series , M1: Write a program in Python Pandas to create the series. -Technology

Last Answer : import pandas as pdm1=pd.Series([45,65,24,89],index=['term1','term2','t erm3','term4'])

Look at the given table called ‘Item’ and answer the questions. ItemId ItemName ItemStock ItemDOP Quanity Purchased -Technology

Description : Look at the given table called ‘Item’ and answer the questions. ItemId ItemName ItemStock ItemDOP Quanity Purchased -Technology

Last Answer : 1. ItemID —> TextItemName —> TextItemStock —> NumberItemDOP —> DateQuantityPurchased —> Number2. ItemID and ItemName can act as primary key.

Observe the table named “Training” given above carefully and predict the output of the following queries: -Technology

Description : Observe the table named “Training” given above carefully and predict the output of the following queries: -Technology

Last Answer : (i) New DelhiFaridabadGurugram(ii) 2(iii) 11000(iv) Ms. Neena

What is the degree and cardinality of the above given table named ‘Training’. -Technology

Description : What is the degree and cardinality of the above given table named ‘Training’. -Technology

Last Answer : Degree: 6Cardinality: 5

Observe the given table named “Loan” carefully and predict the output of the following queries: -Technology

Description : Observe the given table named “Loan” carefully and predict the output of the following queries: -Technology

Last Answer : (i)(ii)(iii)(iv)

What is the degree and cardinality of the above given table named ‘Training’. -Technology

Description : What is the degree and cardinality of the above given table named ‘Training’. -Technology

Last Answer : Degree: 6Cardinality: 5

Given the table ‘Player’ with the following columns : -Technology

Description : Given the table ‘Player’ with the following columns : -Technology

Last Answer : Output of the given statements(i)AVG (POINTS)30(ii)COUNT(POINTS)2

Identify input/output devices from the clues given below: (a) Transfers typed or handw -Technology

Description : Identify input/output devices from the clues given below: (a) Transfers typed or handw -Technology

Last Answer : (a) Scanner(b) Barcode reader(c) Optical Mark Recognition (OMR)(d) Magnetic Ink Character Recognition (MIGR)(e) Printer (f) Speaker

The director of a company uses a database to store data about job title. This is a part of the database given below: -Technology

Description : The director of a company uses a database to store data about job title. This is a part of the database given below: -Technology

Last Answer : 1. 62. 63. Secretary4. Finance department and their Payroll Numbers are A621 and M502.

Name the term defined by given below statement: “A group of computers connected to each other by a link.” -Technology

Description : Name the term defined by given below statement: “A group of computers connected to each other by a link.” -Technology

Last Answer : Computer network is defined as a group of computers connected to each other by a link.

Answer the following questions based on the database given below: Prod_Id Prod_Name Category -Technology

Description : Answer the following questions based on the database given below: Prod_Id Prod_Name Category -Technology

Last Answer : 1. The primary key of the given table Product will be Prod _Id because no two products have the same Product_Id. So, it will be uniquely identified for each record in the table.2. The suitable data ... = 88. The data type OLE Object is suitable for adding the photograph of the product to the table.

Some features of a specific operating system are given below: 1. Free/Open source -Technology

Description : Some features of a specific operating system are given below: 1. Free/Open source -Technology

Last Answer : (i) Linux(ii) With Linux, you get four desktop screens known as workspace.

Carefully study the Web page given below. Identify 10 tags (structural as well as formatting tags) that have been utilized -Technology

Description : Carefully study the Web page given below. Identify 10 tags (structural as well as formatting tags) that have been utilized -Technology

Last Answer : 1. to specify the title of the Web page.2. contains all the content that is to be displayed on the Web page and all the various formatting and structural tag.3. used to create an unordered ... anchor tag. Use the href attribute to provide the reference of the Web page that you want to hyperlink.

Carefully study the Web page given below. Identify 10 tags (structural as well as formatting tags) that have been utilized in creating this -Technology

Description : Carefully study the Web page given below. Identify 10 tags (structural as well as formatting tags) that have been utilized in creating this -Technology

Last Answer : 1. to specify title of the Web page.2. contains all the text content that is to be displayed on Web page and all the various formatting and structural tag.3. defines the most important and biggest ... provide caption to the table.9. used to create a table row.10. used to define data cells.

Draw the XML tree for code given below: -Technology

Description : Draw the XML tree for code given below: -Technology

Last Answer : The XML tree is

Draw the XML tree for the code given below: <MOVIES> <ENGLISH> -Technology

Description : Draw the XML tree for the code given below: -Technology

Last Answer : The XML tree is

Draw the XML tree for the code given below -Technology

Description : Draw the XML tree for the code given below -Technology

Last Answer : The XML tree is

Draw the XML tree for the code given below: -Technology

Description : Draw the XML tree for the code given below: -Technology

Last Answer : The XML tree is

Draw the XML tree for the code given below: -Technology

Description : Draw the XML tree for the code given below: -Technology

Last Answer : Draw the XML tree

Write the HTML code to generate the following web page with the given below specifications: -Technology

Description : Write the HTML code to generate the following web page with the given below specifications: -Technology

Last Answer : Income Tax Slabs 2017-18INCOME TAX SLABS 2017-18S.No.Income RangeTax%10-250000NIL2250001-50000010%3500001-100000020%4>100000030%Next Page

Dev, a website designer with “Creative Designers Pvt. Ltd.” has written the following code. Observe the code given below -Technology

Description : Dev, a website designer with “Creative Designers Pvt. Ltd.” has written the following code. Observe the code given below -Technology

Last Answer : (i) XML code(ii) Company(iii) name, dept(iv) eid, deptid

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 a code to plot the speed of a passenger train as shown in the figure given below: -Technology

Description : Write a code to plot the speed of a passenger train as shown in the figure given below: -Technology

Last Answer : import matplotlib.pyplot as pltimport numpy as npx = np.arange(1, 5)plt.plot(x, x*1.5, label='Normal')plt.plot(x, x*3.0, label='Fast')plt.plot(x, x/3.0, label='Slow')plt.legend()plt.show()

Write a python code to create a data frame with appropriate headings from the list given below : -Technology

Description : Write a python code to create a data frame with appropriate headings from the list given below : -Technology

Last Answer : import pandas as pd# initialize list of listsdata = [['S101', 'Amy', 70], ['S102', 'Bandhi', 69], ['S104','Cathy', 75], ['S105', 'Gundaho', 82]]# Create the pandas DataFramdf = pd.DataFrame(data, columns = ['ID', 'Name', 'Marks'])# printdataframe. print(df )

Write a small python codeto create a dataframewith headings(a and b) from the list given below : [[1,2],[3,4],[5,6],[7,8]] -Technology

Description : Write a small python codeto create a dataframewith headings(a and b) from the list given below : [[1,2],[3,4],[5,6],[7,8]] -Technology

Last Answer : import pandas as pddf = pd.DataFrame([[1, 2], [3, 4]], columns = ['a','b'])df2 = pd.DataFrame([[5, 6], [7, 8]], columns = ['a','b'])df = df.append(df2)

Write the code given below using ‘for’ loop instead of ‘while’ loop : -Technology

Description : Write the code given below using ‘for’ loop instead of ‘while’ loop : -Technology

Last Answer : The given code using ‘for’ loop instead of ‘while’ loop :int ifor (i = 1 ; i < = 5 ; i + +){if (1 * i = = 4)jTextFieldl. setText ( “ “ + i) ;}

A relation Vehicles is given below : V_no Type Company Price Qty AW125 Wagon Maruti 250000 25 J0083 Jeep Mahindra 4000000 15 -Technology

Description : A relation Vehicles is given below : V_no Type Company Price Qty AW125 Wagon Maruti 250000 25 J0083 Jeep Mahindra 4000000 15 -Technology

Last Answer : a. select Type, avg(Price) from Vehicle group by Type having Qty>20;b. select Company, count(distinct Type) from Vehicle group by Company;c. Select Type, sum(Price* Qty) from Vehicle group by Type;

The energy consumption and production patterns in a chemical plant over a 9 month period is provided in the table below; Month 1 2 3 4 5 6 7 8 9 Production in Tonnes / month 493 297 381 479 585 440 234 239 239 Energy Consumption MWh /month 78.2 75.7 76.3 76.1 78.1 70.7 73.7 64.4 72.1 Estimate the cumulative energy savings at end of the 9th month and give your inference on the result ? ( consider 9 month data for evaluation for predicted energy consumption)

Description : The energy consumption and production patterns in a chemical plant over a 9 month period is provided in  the table below; Month 1 2 3 4 5 6 7 8 9 Production in Tonnes / month 493 ... and give your inference on the  result ? ( consider 9 month data for evaluation for predicted energy consumption)

Last Answer : It is required to use the equations Y= mX + C and  nC + mΣX = ΣY  cΣX + mΣX2 = ΣXY Month X =  Production in  Tonnes /  month Y =Energy  Consumption MWh  /month  X 2 XY 1 493 78.2 ... 73.7 54756 17240.63 8 239 64.4 57121 15402.96 9 239 72.1 57121 17228.98 3387 665.3 1410683 253221

Input device used in evaluating answer sheets by a teacher. (a) OCR (b) OMR (c) MICR (d) Barcode -Technology

Description : Input device used in evaluating answer sheets by a teacher. (a) OCR (b) OMR (c) MICR (d) Barcode -Technology

Last Answer : (b) OMR (Optical Mark Recognition) is the process of capturing human marked data from document forms such as surveys and test.

Below are given some probable characteristics of an in-effective teacher, which of them is most likely to be characterized the ineffective teacher (a) Emphasis upon pupil discussion in the clarification of groups’ goals. (b) Emphasis upon standards (c) Emphasis upon the control of the immediate situation (d) None of the above

Description : Below are given some probable characteristics of an in-effective teacher, which of them is most likely to be characterized the ineffective teacher (a) Emphasis upon pupil discussion in the clarification of groups ... (c) Emphasis upon the control of the immediate situation (d) None of the above

Last Answer : (c) Emphasis upon the control of the immediate situation

Below are given some probable characteristics of an ineffective teacher, which of the following is most likely to be characterized the ineffective teacher? Options: A) Emphasis upon standards B) Emphasis upon pupil discussion in the clarification of group's goals C) emphasis upon the control of immediate situation D) None of these

Description : Below are given some probable characteristics of an ineffective teacher, which of the following is most likely to be characterized the ineffective teacher? Options: A) Emphasis upon standards B) Emphasis upon ... of group's goals C) emphasis upon the control of immediate situation D) None of these

Last Answer : C) emphasis upon the control of immediate situation 

You have been selected in all the four professions given below. Where would you like to go? Options: A) Teacher B) Police C) Army D) Bank

Description : You have been selected in all the four professions given below. Where would you like to go? Options: A) Teacher B) Police C) Army D) Bank

Last Answer : A) Teacher 

The main objectives of student evaluation of teachers are: (a) To gather information about student weaknesses. (b) To make teachers take teaching seriously. (c) To help teachers adopt innovative methods of teaching. (d) To identify the areas of further improvement in teacher traits. Identify the correct answer from the codes given below: (A) (a) and (b) only (B) (b), (c) and (d) only (C) (a), (b) and (c) only (D) (a) only

Description : The main objectives of student evaluation of teachers are: (a) To gather information about student weaknesses. (b) To make teachers take teaching seriously. (c) To help teachers adopt innovative methods of teaching. (d) To identify the ... (c) and (d) only (C) (a), (b) and (c) only (D) (a) only

Last Answer : Answer: B 

Which of the following attributes denote great strengths of a teacher? (a) Full-time active involvement in the institutional management (b) Setting examples (c) Willingness to put assumptions to the test (d) Acknowledging mistakes Select the correct answer from the codes given below: (A) (a), (b) and (d) (B) (b), (c) and (d) (C) (a), (c) and (d) (D) (a), (b), (c) and (d)

Description : Which of the following attributes denote great strengths of a teacher? (a) Full-time active involvement in the institutional management (b) Setting examples (c) Willingness to put assumptions to the test (d) Acknowledging mistakes Select the ... (C) (a), (c) and (d) (D) (a), (b), (c) and (d)

Last Answer : Answer: B

Techniques used by a teacher to teach include: (a) Lecture (b) Interactive lecture (c) Group work (d) Self study Select the correct answer from the codes given below: (A) (a), (b) and (d) (B) (a), (b) and (c) (C) (a), (b), (c) and (d) (D) (b), (c) and (d)

Description : Techniques used by a teacher to teach include: (a) Lecture (b) Interactive lecture (c) Group work (d) Self study Select the correct answer from the codes given below: (A) (a), (b) and (d) (B) (a), (b) and (c) (C) (a), (b), (c) and (d) (D) (b), (c) and (d)

Last Answer : Answer: B

Would you consider implanting a GPS chip [or similar technology] in your child's body?

Description : Would you consider implanting a GPS chip [or similar technology] in your child's body?

Last Answer : I don’t have children, but no fucking way. That scares the shit out of me. Dogs and cats is one thing, but people…