MCQ IN COMPUTER SCIENCE & ENGINEERING

Previous
Next

COMPUTER SCIENCE AND ENGINEERING

SQL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
The SQL statement to retrieve information from a table uses..
A
CREATE TABLE <table name> (field ____ name DATATYPE ____ );
B
SELECT <field ____ name> FROM <table name>;
C
SELECT <table name> FROM <table name>;
D
CREATE DATABASE <database name>;
Explanation: 

Detailed explanation-1: -In SQL, to retrieve data stored in our tables, we use the SELECT statement. The result of this statement is always in the form of a table that we can view with our database client software or use with programming languages to build dynamic web pages or desktop applications.

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: -You can use an append query to retrieve data from one or more tables and add that data to another table.

Detailed explanation-4: -An asterisk (” * “) can be used to specify that the query should return all columns of the queried tables. SELECT is the most complex statement in SQL, with optional keywords and clauses that include: The FROM clause, which indicates the table(s) to retrieve data from.

There is 1 question to complete.
Previous
Next