NEW
Font size
WorksheetsSQL Fundamentals Worksheet Questions
Total questions: 25
Worksheet time: 25mins
What does SQL stand for?
Structured Query Language
Standard Query Language
Simple Query Language
Sequential Query Language
Which of the following SQL command(s) retrieves information from a Database?
Update
Extract
Select
Retrieve
Using which command one can delete existing data from database without deleting the table?
Drop
Delete
Remove
Collapse
Which SQL command is used to modify data in a Database?
Modify
Change
Save
Update
To insert new data into a database, which of the following SQL command is used?
Insert
Insert Into
Update
Add New
Which command is used to eliminate a table from a database?
Drop
Delete
Remove
Eliminate
Which of the following is NOT a valid keyword in SQL?
SELECT
DELETE
WHERE
INCLUDE
Which of the following tasks CANNOT be accomplished using SQL?
Creating and modifying database structures
Writing complex algorithms for data analysis
Retrieving specific data from a database
Adding new data to a database
Which of the following is basis for SQL?
SQL Server
DBMS
RDBMS
Oracle
Which character is used to separate SQL statements in database systems?
:
%
_
;
Which statement(s) are mandatory in a simple SQL SELECT statement?
Select, From
Select, OrderBy
Select, Where
Select, GroupBy
Which of the following command is used to create a database in SQL?
MAKE
CREATE
INSERT
DEVELOP
Which SQL keyword is used to sort the data returned by a SELECT statement?
Group
Order
Group By
Order By
SELECT statement retrieves _________
Records from only one table
Records from one or more tables
Data from only one column
Data from only one row
Which character in the select clause denotes ?
+
%
*
_
What is the syntax for SELECT statement?
SELECT table_name FROM database_name;
SELECT column_list FROM table_name;
SELECT row_list FROM table_name;
SELECT record_list FROM table_name;
Which function returns the average value of a numeric expression?
Average( )
Avg( )
Ave( )
Average Num( )
Which of the following function returns the total sum of a numeric column?
Add( )
Addition( )
Sum( )
Total sum( )
Which of the following terms is used to get the smallest value of the selected field?
Small( )
Smallest( )
Min( )
Minimum( )
Which function is used to find out the record with maximum value among a record set?
Maximum( )
Max( )
Large( )
Largest( )
UPDATE is a ________ command.
Data definition language
Data manipulation language
Data control language
Transaction control language
Which of the following provides a correct syntax for UPDATE statement?
Update table_name Set column1=value1, column2=value2, Where condition(s);
Update table_name Alter column1=value1, column2=value2, Where condition(s);
Which of the following terms represents a COLUMN of a Database table?
Attribute, Field
Field, Record
Tuple, Record
Tuple, Attribute
Which of the following terms represents a ROW of a Database table?
Field, Record
Attribute, Field
Tuple, Attribute
Tuple, Record
Which function is used to get the number of rows that matches specified criteria?
Number( )
Count( )
Total( )
Calculate( )
