List of top Geographic Information System Questions on Database Management Systems

The first value in the output of a SQL query (given below) when run on a table having name “Table-1” is?

SQL Query: SELECT LastName FROM Table-1 WHERE State = "IN" ORDER BY FirstName

LastNameFirstNameStreetNumberStreetNameCityState
SquiresEdwin4589Shamar Rd.UplandIN
RothrockPaul91657Carex Ave.UplandIN
RamirezDouglas123Fake St.SpringfieldIN
PetersonChris4687Windthrow WayKanePA
GibsonDavid354Bluestem St.CarbondaleIL

The table below is an attribute table about employee records. Which attribute can be used as a primary key?

EmployeeNameDesignationDepartment
(Emp_ID)(Emp_Name)(Emp_Desig)(Emp_Dept)
100260PrashantSoftware DeveloperInformation Technology
100265DineshJunior EngineerEmbedded System
100252SomyaHR ManagerManagement
100271DineshJunior EngineerInformation Technology