22 Questions
Which of the following is a Data Manipulation Language (DML) statement?
SELECT
Which DML statement is used to add new records to a table?
INSERT
Which DML statement is used to modify existing records in a table?
UPDATE
Which DML statement is used to remove records from a table?
DELETE
Which DML statement is used to retrieve data from a table?
SELECT
Which of the following is not a characteristic of DML statements?
They are auto-committed, meaning changes are permanent to the database
Which DML statement is used to undo changes made to a database?
ROLLBACK
Which DML statement is used to make changes to a database permanent?
COMMIT
Which DML statement is used to start a transaction?
BEGIN
Which DML statement is used to control the level of access that users have on database objects?
GRANT
What operation in Database Management System is used to delete a tuple from a relation?
Delete operation
In a relational model, what is the term used to refer to the degree of a relation?
Number of columns
Which type of operation in Database Management System creates a new relation with fewer attributes than the original relation?
Project operation
What is the purpose of the join operation in a Database Management System?
Combines two relations based on a common attribute
Which Database Model organizes data in an upside-down tree structure?
Hierarchical Model
What type of language is SQL (Structure Query Language) considered to be?
Declarative language
What should be avoided in predicates for query optimization?
Using functions
When using LIKE operator in a predicate, what should be avoided?
Wildcards (%) at the beginning
Which type of join is advised over the other for better performance?
INNER JOIN
In SQL, when should the ORDER BY clause be used?
To get a sorted result
What is a common guideline for indexing columns in SQL for optimization?
Index all columns used in WHERE, ORDER BY, and GROUP BY clauses
What is a common recommendation to minimize the number of columns in a table for optimization?
Avoid too many columns
Test your knowledge on the components of a Database Management System (DBMS), such as hardware, software, data, and users. Learn about how DBMS is used to input, sort, organize, and store data effectively.
Make Your Own Quizzes and Flashcards
Convert your notes into interactive study material.
Get started for free