In the following query * stands for SELECT * FROM Employee; – McqOptions

MCQOPTIONS

1.	In the following query * stands for SELECT * FROM Employee;
A.	Retrieve data of primary key only
B.	Retrieve NULL data
C.	Retrieve all data from the table
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;