SQL Multiple choices


Total available count: 51
Subject - Databases
Subsubject - SQL

With SQL, how can you insert "Olsen" as the "LastName" in the "Persons" table?


 

 

 

 



B


Solution:-

The SQL INSERT INTO Statement is used to insert new records in a table.

INSERT INTO Syntax is given as follows:
It is possible to write the INSERT INTO statement in the following two ways. The first way specifies both the column names and the values to be inserted:

INSERT INTO table_name (column1, column2, column3, column4,...) VALUES (value1, value2, value3, value4,...);

The second way specifies the values to be inserted. However, make sure the order of the values is in the same order as the columns in the table. 
The INSERT INTO syntax would be as follows:

INSERT INTO table_name VALUES (value1, value2, value3, value4, ...);

INSERT INTO Example
The following SQL statement inserts a new record in the "SlightBook" table:

Example

INSERT INTO SlightBook (OwnerName, ContactName, Address, City, PostalCode, Country) VALUES ('Chaitanya', 'Kudumula', 'Street 11', 'Gandhi Nagar', '500064', 'Bangalore');

Insert Data Only in Specified Columns is as follows:

INSERT INTO Customers (OwnerName, City, Country) VALUES ('Chaitanya', 'Bangalore', 'India');

 




Next 5 multiple choice(s)

1

With SQL, how can you insert a new record into the "Persons" table?

2

With SQL, how can you return all the records from a table named "Persons" sorted descending by "FirstName"?

3

Which SQL keyword is used to sort the result-set?

4

Which SQL statement is used to return only different values?

5

With SQL, how do you select all the records from a table named "Persons" where the "LastName" is alphabetically between (and including) "Hansen" and "Pettersen"?

Comments