MCQ IN COMPUTER SCIENCE & ENGINEERING

Previous
Next

COMPUTER SCIENCE AND ENGINEERING

SQL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
Which would show all fields from the Pupils table?
A
SELECT * FROM Pupils
B
SELECT Name, Form FROM Pupils
C
SELECT * FROM *
D
SELECT * FROM Forms
Explanation: 

Detailed explanation-1: -In a query editor, if you highlight the text of table name (ex dbo. MyTable) and hit ALT + F1, you’ll get a list of column names, type, length, etc.

Detailed explanation-2: -The SELECT statement is used to select data from a database. The data returned is stored in a result table, called the result-set.

Detailed explanation-3: -SELECT statement uses * character to retrieve all records from a table, for all the columns. The above query will show all the records of student table, that means it will show complete dataset of the table.

Detailed explanation-4: -The SELECT statement is the most commonly used command in Structured Query Language. It is used to access the records from one or more database tables and views.

There is 1 question to complete.
Previous
Next