Intermediate Database Management and SQL

Question 1
In relational databases, what is the main goal of normalization?

(A) To split a table based solely on speed optimization

(B) To physically separate data storage on different servers

(C) To increase data duplication for backup purposes

(D) To structure the data in such a way that redundancy is minimized and integrity is maintained

Question 2
Which SQL command is primarily used to retrieve data from a database?

(A) SELECT

(B) FETCH

(C) UPDATE

(D) INSERT

Question 3
What does the SQL command 'UPDATE' do in a relational database?

(A) Modifies existing data within a table

(B) Refreshes table structure by re-indexing data

(C) Creates a new table within the database

(D) Deletes a record from a table

Question 4
Which SQL statement is used to remove a table and its structure from the database?

(A) TRUNCATE

(B) DELETE

(C) DROP

(D) REMOVE

Question 5
In a relational database, what is a primary key?

(A) A unique identifier for table records

(B) A field that can contain repeated values

(C) A set of attributes that may serve as a unique identifier but not guaranteed

(D) A key used for encrypting data in a column

Question 6
What does the 'Isolation' component in the ACID properties refer to in database transactions?

(A) Sharing data openly between transactions for speed

(B) Combining multiple transactions to enhance performance

(C) Closing transactions immediately after changes are made to prevent deadlocks

(D) Ensuring that each transaction is executed as if it were the only one in the system

Question 7
Which clause in SQL is used to filter results based on a specified condition?

(A) GROUP BY

(B) HAVING

(C) ORDER BY

(D) WHERE

Question 8
In SQL, what is the function of the 'JOIN' clause in queries?

(A) To merge columns from the same table into one column

(B) To delete rows from a table that meet a condition

(C) To combine rows from two or more tables based on a related column

(D) To insert new rows into a table

Question 9
Which SQL command would you use if you want to add a new column to an existing table?

(A) MODIFY TABLE

(B) ALTER TABLE

(C) INSERT INTO

(D) UPDATE

Question 10
Within a transaction, if a failure occurs, what does the 'ROLLBACK' command do?

(A) It temporarily logs errors without changing the data

(B) It undoes some, but not all changes, to maintain performance

(C) It reverts the database back to the state before the transaction began

(D) It permanently commits all changes in the transaction

Rate this quiz (optional)

Helpful for Study?

Yes

No

Relevant to Topic?

Yes

No

Difficulty Appropriate?

Yes

No