What will be the output of a query given below?SELECT Employee_id, Fir – McqOptions

MCQOPTIONS

1.	What will be the output of a query given below?SELECT Employee_id, FirstName, LastNameFROM EmployeeWHERE Employee_id=1;
A.	Show all columns and rows
B.	Shows only columns Employee_id
C.	Show only columns(Employee_id, FirstName, LastName) but only those rows which belongs to Employee_id=1
D.	All of above
E.	None of these
Answer» D. All of above

Discussion

No Comment Found

Related MCQs

In the following query * stands for SELECT * FROM Employee;
In the following query Employee stands forSELECT Emp_id, fname, lname, Birth_date FROM Employee;
What will be the output of a query given below?SELECT *FROM Employee;
Find the error?SELECT *;
What will be the output of a query given below?SELECT Employee_id, FirstName, LastNameFROM person;
Is there any error in executing the following query?SELECT USER (),VERSION (), DATABASE ();
Is there any error in executing the following query?SELECT Student_id, ACTIVE ,Student_id * 3.145,UPPER (LastName)FROM Student;
If in Table Customer , a column Customer_id consists of {1,2,2,3,3,5,6,7,8,8} then what will be the output on executing the following query?SELECT DISTINICT emp_idFROM employee;
If in Table account , a column Customer_id consists of {1,2,2,3,3,5,6,7,8,8} then what will be the output on executing the following query?SELECT DISTINICT Customer_idFROM account;
What will be the result of the query given below?SELECT Person_id, ACTIVE AS STATUS,Person_id * 3.14 AS Person_pi,UPPER (LName) AS Last_NameFROM Person;