Consider the following table: Employee EmpNo EmpName Designation -Technology

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

1 Answer

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

Related questions

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

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

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

Write a C++ program to declare a structure employee with members as empid and empname. Accept and display data for one employee using structure variable.

Description : Write a C++ program to declare a structure employee with members as empid and empname. Accept and display data for one employee using structure variable. 

Last Answer : #include<iostream.h> #include<conio.h> struct employee  { int empid; char empname[10];  }; void main()  { employee e; clrscr(); cout<<"\nEnter employee id ... empid; cout<<"\nThe Employee Name is "<<e.empname; getch();  }

Consider the table ‘Employee’. -Technology

Description : Consider the table ‘Employee’. -Technology

Last Answer : SELECT DISTINCT (Location) FROM Employee ;

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.

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.

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

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

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

Does the designation “emotional support animal” make any sense?

Description : Does the designation “emotional support animal” make any sense?

Last Answer : This page outlines the legal distinction between emotional support animals and service animals. They are considered to be different things. But it sounds like you are opposed to the concept of an emotional support ... it should be thought of as no different than a service animal for the blind, etc.

What is the qualification for designation as Hawk-Eagle ?

Description : What is the qualification for designation as Hawk-Eagle ?

Last Answer : answer:Taxonomy of the Changeable Hawk Eagle There are also Ornate, Mountain and African Hawk Eagles. http://en.wikipedia.org/wiki/Ornate_Hawk-Eagle http://en.wikipedia.org/wiki/Mountain_Hawk-Eagle http://en.wikipedia.org/wiki/African_Hawk-Eagle

What does the designation medium or high mean on contact lenses?

Description : What does the designation medium or high mean on contact lenses?

Last Answer : answer:Bifocal contact lenses generally contain one additional number which is the add power. A special field will be given for this number. Notes 1. A contact lens prescription is not the same as ... correct for it by changing the power of the lens. Still Have Questions? Email : [email protected]

What does the Hertz (Hz) designation in LCD TV specs mean?

Description : What does the Hertz (Hz) designation in LCD TV specs mean?

Last Answer : The refresh rate of the picture; as the screen is drawn , the pixels are refreshed a certain number of times per second, thus refresh rate. Rate is measured in cycles per second and ... , as some camera technologies suffer from refresh issues when acquiring the image (CMOS sensors in particular).

What's the difference between EF and EF-S designation for Canon lenses?

Description : What's the difference between EF and EF-S designation for Canon lenses?

Last Answer : EF means that it is an electronic focus lens, basically every lens made since the late 80s. Also called auto focus. EF-S are crop sensor camera lenses. They will only fit on APS-C cameras, which ... L lens you know you are getting the best optical quality available. You will also pay dearly for it.

What is the designation of a District Judge when he deals with criminal cases? -SST 10th

Description : What is the designation of a District Judge when he deals with criminal cases? -SST 10th

Last Answer : When a District Judge deals with criminal cases he is called a Sessions Judge.

which of the following is a scientific species designation? -General Knowledge

Description : which of the following is a scientific species designation? -General Knowledge

Last Answer : Homo sapiens is a scientific species designation.

What is the meaning of Designation ?

Description : What is the meaning of Designation ?

Last Answer : Designation means surname.

What is the designation of a winter tire?

Description : How are the tires on cars marked as winter tires?

Last Answer : https://www.teligumit.hu/teli-gumi-jelzesek-jelentesei The rubber is marked with a small figure.

The R/S designation for the following stereoisomers of 1,3-Dibromo-2-methylbutane is :

Description : The R/S designation for the following stereoisomers of 1,3-Dibromo-2-methylbutane is :

Last Answer : The R/S designation for the following stereoisomers of 1,3-Dibromo-2-methylbutane is : A. 2R, 3R B. 2R, 3S C. 2S, 3R D. 2S, 3S

The R/S designation for the following stereoisomers of 1,3-Dibromo-2-methylbutane is :

Description : The R/S designation for the following stereoisomers of 1,3-Dibromo-2-methylbutane is :

Last Answer : The R/S designation for the following stereoisomers of 1,3-Dibromo-2-methylbutane is : A. 2R, 3R B. 2R, 3S C. 2S, 3R D. 2S, 3S

A lady called Hajjaj Bin Yousaf for help. The designation of Hajjaj Bin Yousaf was: A. King of Iraq B. Governor of Iraq C. Warrior of Iraq D. Governor of Kufa

Description : A lady called Hajjaj Bin Yousaf for help. The designation of Hajjaj Bin Yousaf was: A. King of Iraq B. Governor of Iraq C. Warrior of Iraq D. Governor of Kufa

Last Answer : ANSWER: C

A lady called Hajjaj Bin Yousaf for help. The designation of Hajjaj Bin Yousaf was: A. King of Iraq B. Governor of Iraq C. Warrior of Iraq D. Governor of Kufa

Description : A lady called Hajjaj Bin Yousaf for help. The designation of Hajjaj Bin Yousaf was: A. King of Iraq B. Governor of Iraq C. Warrior of Iraq D. Governor of Kufa

Last Answer : ANSWER: C

A lady called Hajjaj Bin Yousaf for help. The designation of Hajjaj Bin Yousaf was: A. King of Iraq B. Governor of Iraq C. Warrior of Iraq D. Governor of Kufa

Description : A lady called Hajjaj Bin Yousaf for help. The designation of Hajjaj Bin Yousaf was: A. King of Iraq B. Governor of Iraq C. Warrior of Iraq D. Governor of Kufa

Last Answer : ANSWER: C

A lady called Hajjaj Bin Yousaf for help. The designation of Hajjaj Bin Yousaf was: A. King of Iraq B. Governor of Iraq C. Warrior of Iraq D. Governor of Kufa

Description : A lady called Hajjaj Bin Yousaf for help. The designation of Hajjaj Bin Yousaf was: A. King of Iraq B. Governor of Iraq C. Warrior of Iraq D. Governor of Kufa

Last Answer : ANSWER: C

Chromosorne designation of Turner sydrorne is : (1) 44A+XO (2) 44A+XXX (3) 44A+XXY (4) 44A+XYY

Description : Chromosorne designation of Turner sydrorne is : (1) 44A+XO (2) 44A+XXX (3) 44A+XXY (4) 44A+XYY

Last Answer : (1) 44A+XO Explanation: Turner syndrome is a rare chromosomal disorder characterized by partial or complete loss (monosomy) of one of the X chromosomes that affects females. Individuals with ... +XO). The abnormal condition probably originates from exceptional egg or sperm with no X chromosome.

From which designation is it preferred to send the output to the printed?

Description : From which designation is it preferred to send the output to the printed?

Last Answer : Previewer

What does following alloy designation indicate FG 250 ?

Description : What does following alloy designation indicate FG 250 ?

Last Answer : Grey cast iron with tensile strength of 250 MPa.

In radio signal emission designation, the fifth symbol means A. Details of signals B. Type of information transmitted C. Nature of multiplexing D. Nature of signal modulating the main carrier

Description : In radio signal emission designation, the fifth symbol means A. Details of signals B. Type of information transmitted C. Nature of multiplexing D. Nature of signal modulating the main carrier

Last Answer : C. Nature of multiplexing

What is the emission designation of a single sideband reduced carrier signal? A. H3E B. J3E C. R3E D. B8E

Description : What is the emission designation of a single sideband reduced carrier signal? A. H3E B. J3E C. R3E D. B8E

Last Answer : C. R3E

In radio regulation, the first symbol in the designation of radio emission is ______. A. Bandwidth B. Nature of signal(s) modulation the main carrier C. Type of modulation of the main carrier D. Type of information to be transmitted

Description : In radio regulation, the first symbol in the designation of radio emission is ______. A. Bandwidth B. Nature of signal(s) modulation the main carrier C. Type of modulation of the main carrier D. Type of information to be transmitted

Last Answer : C. Type of modulation of the main carrier

Refers to the first symbol in an emission designation with an amplitude modulated main carrier represented by letter H. A. Single sideband suppressed carrier B. Double sideband full carrier C. Independent sideband D. Double sideband

Description : Refers to the first symbol in an emission designation with an amplitude modulated main carrier represented by letter H. A. Single sideband suppressed carrier B. Double sideband full carrier C. Independent sideband D. Double sideband

Last Answer : B. Double sideband full carrier

Refers to an emission designation for facsimile? A. J3E and F4E B. A3J and A4E C. A3E and F3C D. R3E and A3E

Description : Refers to an emission designation for facsimile? A. J3E and F4E B. A3J and A4E C. A3E and F3C D. R3E and A3E

Last Answer : C. A3E and F3C

In the designation of bandwidth and emission, what letter in the first symbol represents a double-sideband type of modulation? A. A B. B C. C D. H

Description : In the designation of bandwidth and emission, what letter in the first symbol represents a double-sideband type of modulation? A. A B. B C. C D. H

Last Answer : A. A

The third symbol in the designation of radio emission under the ITU rules refers to A. Type of the modulation of the main carrier B. Bandwidth C. Nature of the signals modulating the main carrier D. Type of information to be transmitted

Description : The third symbol in the designation of radio emission under the ITU rules refers to A. Type of the modulation of the main carrier B. Bandwidth C. Nature of the signals modulating the main carrier D. Type of information to be transmitted

Last Answer : D. Type of information to be transmitted

The first symbol in the designation of radio emission under the ITU rules to A. Nature of signals modulating the main carrier B. Type of information to be transmitted C. Bandwidth D. Type of modulation of the main carrier

Description : The first symbol in the designation of radio emission under the ITU rules to A. Nature of signals modulating the main carrier B. Type of information to be transmitted C. Bandwidth D. Type of modulation of the main carrier

Last Answer : D. Type of modulation of the main carrier

ECE Board Exam March 1996 The letter-number designation B8E is a form of modulation also known as ___________. A. pilot carrier system B. independent sideband emission C. lincomplex D. vestigial sideband transmission

Description : ECE Board Exam March 1996 The letter-number designation B8E is a form of modulation also known as ___________. A. pilot carrier system B. independent sideband emission C. lincomplex D. vestigial sideband transmission

Last Answer : B. independent sideband emission

ECE Board Exam March 1996 What is the IBM’s asynchronous data link protocol designation? A. 83 B B. 8A1 / 8B1 C. 93 B D. 9A1/ 9B1

Description : ECE Board Exam March 1996 What is the IBM’s asynchronous data link protocol designation? A. 83 B B. 8A1 / 8B1 C. 93 B D. 9A1/ 9B1

Last Answer : A. 83 B

If a PIO reasonably non exempted portions of a record from exempted portions and partially provides information to an applicant he/she has to a) Give the name and designation of the person giving the decision b) Reasons for the decision c) Details of fees the applicant may have to pay d) Applicants rights for a review of the decision e) All the above

Description : If a PIO reasonably non exempted portions of a record from exempted portions and  partially provides information to an applicant he/she has to a) Give the name and designation of the person giving the decision ... may have to pay d) Applicants rights for a review of the decision e) All the above

Last Answer : e) All the above

The designation M 36 × 2 means (A) Metric fine threads of 36 mm outside diameter and 2 mm pitch (B) Metric coarse threads of 36 mm outside diameter and 2 mm pitch (C) Metric threads of 36 mm pitch diameter and 2 mm pitch (D) Metric threads of 36 mm core diameter and 2 mm pitch

Description : The designation M 36 × 2 means (A) Metric fine threads of 36 mm outside diameter and 2 mm pitch (B) Metric coarse threads of 36 mm outside diameter and 2 mm pitch (C) Metric threads of 36 mm pitch diameter and 2 mm pitch (D) Metric threads of 36 mm core diameter and 2 mm pitch

Last Answer : (A) Metric fine threads of 36 mm outside diameter and 2 mm pitch

An article bearing “OIGS” addressed to the officer of Central Govt Service bearing his name & designation is delivered to a) Name b) Designation c) Incharge of the office d) None of these

Description : An article bearing “OIGS” addressed to the officer of Central Govt Service bearing his name & designation is delivered to a) Name b) Designation c) Incharge of the office d) None of these

Last Answer : b) Designation

Postal mails superscribed in “ On India Government Service” received for delivery a) Containing both name and address of the officer to be delivered redirected according to official designation b) Containing only the name to be delivered according to name of the addressee c) Postal mails not bearing the superscription “ On India government Service” but contain name and designation of the officer., to be delivered redirected according to name d) All the above

Description : Postal mails superscribed in On India Government Service received for delivery a) Containing both name and address of the officer to be delivered redirected according to official designation b) Containing ... of the officer., to be delivered redirected according to name d) All the above

Last Answer : d) All the above

Mark correct option a) In Head Record offices one key of the safe will be retained in the custody of HRO and other one is Accountant. b) The insured seal supplied to the set of mail office should be kept in the personal custody of Head Sorting assistant c) Each set of section is supplied with a portfolio with lock & key bearing designation of section d) All the above are correct.

Description : Mark correct option a) In Head Record offices one key of the safe will be retained in the custody of HRO and other one is Accountant. b) The insured seal supplied to the set of mail office ... supplied with a portfolio with lock & key bearing designation of section d) All the above are correct.

Last Answer : d) All the above are correct.