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

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
by

1 Answer

Answer :

alternative answer
by

Related questions

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

Which committee recommended the establishment of the scheme of ‘democratic decentralization’, which finally came to be known as Panchayati Raj? a. Balwant Rai Mehta Committee b. Ajay Chitnis Committee c. L M Sanghvi Committee d. G V K Rao Committee

Description : Which committee recommended the establishment of the scheme of ‘democratic decentralization’, which finally came to be known as Panchayati Raj? a. Balwant Rai Mehta Committee b. Ajay Chitnis Committee c. L M Sanghvi Committee d. G V K Rao Committee

Last Answer : a. Balwant Rai Mehta Committee

The balance appearing in the books of a company at the end of year were CRR A/c Rs. 50,000, Security Premium Rs. 5,000, Revaluation Reserve Rs. 20,000, P & L A/c (Dr) Rs. 10,000. Maximum amount available for distribution of Bonus Share will be– (A) Rs. 50,000 (B) Rs. 55,000 (C) Rs. 45,000 (D) Rs. 57,000

Description : The balance appearing in the books of a company at the end of year were CRR A/c Rs. 50,000, Security Premium Rs. 5,000, Revaluation Reserve Rs. 20,000, P & L A/c (Dr) Rs. 10,000. Maximum amount available for distribution of ... will be- (A) Rs. 50,000 (B) Rs. 55,000 (C) Rs. 45,000 (D) Rs. 57,000

Last Answer : Answer: Rs. 55,000

Write a C++ program to declare a class ‘College’ with data members as name and college code. Derive a new class ‘student’ from the class college with data members as sname and roll no. Accept and display details of one student with college data.

Description : Write a C++ program to declare a class ‘College’ with data members as name and college code. Derive a new class ‘student’ from the class college with data members as sname and roll no. Accept and display details of one student with college data.

Last Answer : #include<iostream.h> #include<conio.h> class college { char name[10]; int collegecode; public: void getcollege() { cout<<"Enter college name:"; cin>>name; cout< ... (); s.getstudent(); s.putcollege(); s.putstudent(); getch(); }

If a company has five employees with annual salaries of 40000 90000 40000 30000 and 80000 respectively what is the mean annual salary at the company?

Description : If a company has five employees with annual salaries of 40000 90000 40000 30000 and 80000 respectively what is the mean annual salary at the company?

Last Answer : mean = (sum of data items)/(number of data items)= (40,000 + 90,000 + 40,000 + 30,000 + 80,000)/5= 280,000/5= 56,000

In the <td> tag, td stands for (a) Table Data (b) Table Time and Date -Technology

Description : In the tag, td stands for (a) Table Data (b) Table Time and Date -Technology

Last Answer : (a) td stands for Table Data.

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.

Do you get written objectives from your boss at the beginning of the year and does your salary or bonus depend on this?

Description : Do you get written objectives from your boss at the beginning of the year and does your salary or bonus depend on this?

Last Answer : I get written objectives from my boss, although they tend to be more subjective than objective. I'm a software engineer, and it's impossible to predict what projects I'll be working on in a year, and ... the team's goals to line up with the company's goals. The more transparent this is, the better.

Jose Suarez has been promoted to sales manager at a new firm and is trying to come up with a sales -force compensation method. He would like to have selling expenses relate directly to sales resources, a highly aggressive sales force, and minimization of nonselling tasks. What compensation method(s) would best fulfill his requirements? A)Combination B)Straight salary C)Straight salary plus generous fringe benefits D)Straight commission E)Salary plus a bonus

Description : Jose Suarez has been promoted to sales manager at a new firm and is trying to come up with a sales -force compensation method. He would like to have selling expenses relate directly to ... B)Straight salary C)Straight salary plus generous fringe benefits D)Straight commission E)Salary plus a bonus

Last Answer : D)Straight commission

Payment made by an employer to employee monthly, other than salary is called …………. A) Bonus B) Allowances C) Benefits D) None of these

Description : Payment made by an employer to employee monthly, other than salary is called …………. A) Bonus B) Allowances C) Benefits D) None of these

Last Answer : B) Allowances

Which of the following committees is not concerned with Panchayati Raj? (1) Santhanam Committee (2) Ashok Mehta. Committee (3) Balwant Rai Mehta Committee (4) V.K.R.V. Rao Committee

Description : Which of the following committees is not concerned with Panchayati Raj? (1) Santhanam Committee (2) Ashok Mehta. Committee (3) Balwant Rai Mehta Committee (4) V.K.R.V. Rao Committee

Last Answer : (1) Santhanam Committee Explanation: The santhanam Committee Report 1964 defines corruption as a complex problem having roots and ramifications in society as a whole.

A committee appointed in 1977 to review working of the Panchayti Raj was chaired by (1) Balwant Rai Mehta (2) Ashok Mehta (3) K.N. Katju (4) Jagjivan Ram

Description : A committee appointed in 1977 to review working of the Panchayti Raj was chaired by (1) Balwant Rai Mehta (2) Ashok Mehta (3) K.N. Katju (4) Jagjivan Ram

Last Answer : (2) Ashok Mehta Explanation: The Committee appointed in 1977 to review working of the Panchayati Raj was chaired by Ashok Mehta. The committee submitted its report in August 1978 and made 132 ... Jagjivan Ram was the first labour Minister and later served as Deputy Prime Minister in 1977-1979.

The Committee appointed in 1977 to review working of the Panchayati Raj was chaired by (1) Balwant Rai Mehta (2) Ashok Mehta (3) K. N. Katju (4) Jagjivan Ram

Description : The Committee appointed in 1977 to review working of the Panchayati Raj was chaired by (1) Balwant Rai Mehta (2) Ashok Mehta (3) K. N. Katju (4) Jagjivan Ram

Last Answer : (2) Ashok Mehta Explanation: In. December 1977, the Janata Government appointed a committee on Panchayati Raj institutions under the chairmanship of Ashok Mehta. The committee submitted its report in ... report, the Indian states of Karnataka, Andhra Pradesh, and West Bengal passed new legislation.

Who is the father of plant pathology in India ? a. E J Butler b. K C Mehta c. B B Mundakur d. R Prasad

Description : Who is the father of plant pathology in India ? a. E J Butler b. K C Mehta c. B B Mundakur d. R Prasad

Last Answer : a. E J Butler

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 a disk queue with I/O requests on the following cylinders in their arriving order: 6,10,12,54,97,73,128,15,44,110,34,45 The disk head is assumed to be at cylinder 23 and moving in the direction of decreasing number of cylinders. Total number of cylinders in the disk is 150. The disk head movement using SCAN-scheduling algorithm is: (1) 172 (2) 173 (3) 227 (4) 228

Description : Consider a disk queue with I/O requests on the following cylinders in their arriving order: 6,10,12,54,97,73,128,15,44,110,34,45 The disk head is assumed to be at cylinder 23 and moving in the direction ... . The disk head movement using SCAN-scheduling algorithm is: (1) 172 (2) 173 (3) 227 (4) 228

Last Answer : (2) 173

Consider the following database: Product Code Product Name Date of sale QtySold Customer Name Amount -Technology

Description : Consider the following database: Product Code Product Name Date of sale QtySold Customer Name Amount -Technology

Last Answer : 1. Qty Sold and Amount fields2. ProductCode field3. Date/Time data type4. ProductCode, ProductName and CustomerName fields5. 6 fields and 5 records6. Validation Rule

Indian penal code 1860 Consists i) 584 Sections, 5 Schedules & 5 chapters j) 511 Sections, 23 chapter k) 156 Sections, 3 Schedules l) None of these

Description : Indian penal code 1860 Consists i) 584 Sections, 5 Schedules & 5 chapters j) 511 Sections, 23 chapter k) 156 Sections, 3 Schedules  l) None of these

Last Answer : j) 511 Sections, 23 chapter

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 table ‘Teacher’ given below. -Technology

Description : Consider the table ‘Teacher’ given below. -Technology

Last Answer : (i) Select count(Department) from Teacher ;(ii) Select count (*) from Teacher ;

Consider the Stu table , -Technology

Description : Consider the Stu table , -Technology

Last Answer : The output is

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

Which of the following is not a data type? (a) Picture/Graphic (b) Date/Time -Technology

Description : Which of the following is not a data type? (a) Picture/Graphic (b) Date/Time -Technology

Last Answer : (a) From the given options Date/Time, Text and Number are the data types.

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)

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

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

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

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

River Alaknanda forms confluences (Prayags) in Uttrakhand. Match the codes given in Figure with Table (Prayags) and select the correct answer using the code given below. Figure Table (Pr ayags) D A L A K N A N D A C B A I. Karn Prayag II. Rudra Prayag III. Nand Prayag IV. Vishnu Prayag

Description : River Alaknanda forms confluences (Prayags) in Uttrakhand. Match the codes given in Figure with Table (Prayags) and select the correct answer using the code given below. Figure Table (Pr ayags) D A L A K N A N D A C B A I. Karn Prayag II. Rudra Prayag III. Nand Prayag IV. Vishnu Prayag

Last Answer : (1) A-II, B-I, C-III, D-IV

A table named School (containing data of students of the whole school) is created -Technology

Description : A table named School (containing data of students of the whole school) is created -Technology

Last Answer : AdmissionNo should be set as the primary key because admission numbers are unique for each and every student of the school, which is not possible in the case with RollNo and Name.

Data is stored in RDBMS in the form of (a) table (b) query -Technology

Description : Data is stored in RDBMS in the form of (a) table (b) query -Technology

Last Answer : (a) Relational Database Management System stores data in the form of relation. As we know, relations are known as table.

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.

………….. is the smallest part of a table in which one data item can be kept. -Technology

Description : ………….. is the smallest part of a table in which one data item can be kept. -Technology

Last Answer : Fieldis the smallest part of a table in which one data item can be kept.

What data type should you choose for a zipcode field in a table? (a) Text (b) Number -Technology

Description : What data type should you choose for a zipcode field in a table? (a) Text (b) Number -Technology

Last Answer : (b) Number data type should be chosen for a zip code field in a table.

For what, Memo data type is used? (a) To add table (b) To store objects created in other programs -Technology

Description : For what, Memo data type is used? (a) To add table (b) To store objects created in other programs -Technology

Last Answer : (c) As we know, Memo provides character upto 65536 so, it is used for long text entries.

Which field property helps in setting data validation in a table? -Technology

Description : Which field property helps in setting data validation in a table? -Technology

Last Answer : (d) Validation Rule property specifies a condition that must be met before the data is accepted into the database.

Memo data type allows you to store character type values in a table. -Technology

Description : Memo data type allows you to store character type values in a table. -Technology

Last Answer : True Memo data type allows upto 65536 characters.

Memo data type allows you to store only 255 characters in the table. -Technology

Description : Memo data type allows you to store only 255 characters in the table. -Technology

Last Answer : False Memo data type is used when character size is more than 255.

The Datasheet View displays the data in a table in tabular format. -Technology

Description : The Datasheet View displays the data in a table in tabular format. -Technology

Last Answer : True A datasheet is a simple view of data arranged in rows and columns.

Design View allows users to enter data in the table. -Technology

Description : Design View allows users to enter data in the table. -Technology

Last Answer : False Because Design View is used to edit the table design only.

The tag is used to specify the individual table data in a table. (a) <tr> (b) <td> -Technology

Description : The tag is used to specify the individual table data in a table. (a) (b) -Technology

Last Answer : (b)The tag is used to specify the individual table data in a table.

Which one of the following is not an option for aligning data in a table? (a) justify (b) right -Technology

Description : Which one of the following is not an option for aligning data in a table? (a) justify (b) right -Technology

Last Answer : (a) justify option is not used for aligning data in a table.

What is data cell? Name the <table> tag, which is used as data cell. -Technology

Description : What is data cell? Name the tag, which is used as data cell. -Technology

Last Answer : The data cell defines a cell of a table that contains data. The table data cell is coded with tag of tag. Here, td stands for Table Data. The content in the table data cell is normal and left-aligned.

…………… tag is used to insert data into a table. -Technology

Description : …………… tag is used to insert data into a table. -Technology

Last Answer : tag is used to insert data into a table.

Help Ramesh in identifying any two columns for a table named student along with their suitable data type. -Technology

Description : Help Ramesh in identifying any two columns for a table named student along with their suitable data type. -Technology

Last Answer : Column NameData TypeRollNoIntegerNameVarchar(20)

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.

Write the code in python to read the contents of “number.csv” file consisting of data from a mysql table and print the data of the table -Technology

Description : Write the code in python to read the contents of “number.csv” file consisting of data from a mysql table and print the data of the table -Technology

Last Answer : f = open('numbers.csv', 'r') with f:reader = csv.reader(f)for row in reader:for e in row:print(e)