Font size
WorksheetsSQL-Basics-SET-1
Total questions: 25
Worksheet time: 25mins
Which of the following cannot be done using SQL?
Insert records into a Database
Retrieve data from a Database
Delete records from a Database
Update multiple tables of a Database
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
RDBMS stands for _______
Relative Database Management System
Related Database Management System
Relational Database Management System
Relative Database Management System
The data in RDBMS is stored in ______
Database Object
SQL Object
SQL Server
Database server
Which of the following is not true about tables?
It is a Database Object
It is a collection of irrelevant data entries
It consists of Fields known as Columns
It consists of Records known as Rows
Where the specific information about every record of a table is stored?
(a)
What is a Record?
A record is a Vertical entity
A record is each individual entry that exists in a table
A record is an entity that contains all information associated with the fields of a table
A record is a column
SQL keywords are case sensitive
True
False
Which character is used to separate SQL statements in database systems?
: (colon)
; (Semi-colon)
_ (underscore)
% (percentage)
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 used to modify an existing table?
Alter
Alter Table
Modify
Update
Which of the following is a valid SQL command for an Index?
Create Index
Change Index
Add Index
Remove Index
Which character in the select clause denotes “ALL ATTRIBUTES”?
+
%
*
_
Which type of index is automatically created by the database management system to enforce the PRIMARY KEY constraint?
Clustered index
Non-clustered index
Unique index
Composite index
What is a transaction in SQL?
A set of operations that are executed as a single unit of work
A temporary storage area used for intermediate data processing
A constraint that ensures data integrity
A function that calculates aggregate values
What is the purpose of a rollback in SQL?
To commit the changes made by a transaction
To save the changes made by a transaction
To undo the changes made by a transaction
To finalize the changes made by a transaction
What is the purpose of a savepoint in SQL transactions?
To rollback the entire transaction
To mark a point within a transaction to which you can later roll back
To commit the changes made by a transaction
To finalize the changes made by a transaction
Which SQL statement is used to begin a transaction?
BEGIN TRANSACTION
START TRANSACTION
INITIATE TRANSACTION
TRANSACTION BEGIN
What does the SQL acronym CRUD stand for?
Create, Read, Update, Destroy
Create, Read, Update, Delete
Copy, Read, Update, Delete
Construct, Retrieve, Update, Delete
Which SQL statement is used to update existing data in a table?
MODIFY
ALTER
UPDATE
CHANGE
