WorksheetsInformation Management-MidQuiz
Total questions: 31
Worksheet time: 17mins
Which key attribute is used to establish relationships between entities in a relational database?
Candidate key
Primary key
Foreign key
Alternate key
A key attribute that consists of two or more attributes used together to uniquely identify records.
Composite key
Primary key
Candidate key
Foreign key
Which data integrity constraint enforces that values in a column must be unique but allows for NULL values?
Not null constraint
Unique Constraint
Null constraint
Data Redundancy
What does SQL stand for?
Strong Question Language
Structured Question Language
Structured Query Language
Strong Query Language
What does the SQL DROP TABLE statement do?
Deletes a table and all its data from the database
Renames an existing table
Copies a table and its data to a new table
Clones a table
Which one of the following sorts rows in SQL?
ALIGN BY
ORDER BY
SORT BY
GROUP BY
Which SQL statement is used to add new record in a database?
INSERT NEW
ADD NEW
INSERT INTO
ADD RECORD
The result of a SQL SELECT statement is a ______.
FILE
REPORT
FORM
TABLE
In SQL, how do you select a column named "FirstName" from a table named Student?
SELECT Student.FirstName
EXTRACT FirstName FROM Student
SELECT FirstName FROM Student
SELECT Student FROM FirstName
Which operator performs pattern matching?
BETWEEN
LIKE
EXISTS
OR
Which of the SQL statement is correct?
SELECT Username AND Password FROM Users
SELECT Username, Password FROM Users
SELECT Username, Password WHERE Username='user1'
All of these
The FROM SQL clause is used to _______.
specify what table we are selecting or deleting data from
specify range for search condition
specify each condition
None of these
Which of the following SQL commands is used to retrieve data?
DELETE
INSERT
SELECT
JOIN
Which SQL statement is used to change data in a database?
DELETE
MODIFY
REMOVE
UPDATE
Display the Grade in increasing order of all students.
SELECT Name FROM Student ORDER BY Grade;
SELECT Name, Grade FROM Student;
SELECT Name, Grade FROM Student ORDER BY Grade;
SELECT Name, Grade FROM Student ORDER BY Name;
Which of the following is NOT a type of SQL constraint?
PRIMARY KEY
ALTERNATE KEY
FOREIGN KEY
UNIQUE
The wildcard in a WHERE clause is useful when?
An exact match is necessary in a CREATE statement
An exact match is necessary in a SELECT statement
An exact match is not possible in SELECT statement
An exact match is not possible in CREATE statement
Which of the following query is correct for using comparison operator in SQL?
SELECT * FROM Student WHERE Age>20 and <35;
SELECT * FROM Student WHERE Age>20 and Age<35;
SELECT * FROM Student WHERE Age>20 and WHERE Age<35;
SELECT * FROM Student WHERE Age<20 and Age>35;
With SQL, how do you select all columns from a table named "Students"?
SELECT Students
SELECT * FROM Students
SELECT [all] FROM Students
SELECT * Students
How can you change "John Lloyd" into "Derek" in the FirstName column in the Students table?
UPDATE Students SET FirstName='Derek' WHERE FirstName='John Lloyd';
UPDATE Students SET FirstName='John Lloyd' WHERE FirstName='Derek';
MODIFY Students SET FirstName='Derek' WHERE FirstName='John Lloyd';
MODIFY Students SET FirstName='John Lloyd' WHERE FirstName='Derek';
With SQL, how can you delete the records where the "FirstName" is "Nicole" in the Students table?
DELETE FROM Students WHERE FirstName = 'Nicole';
DELETE WHERE FirstName = 'Nicole' FROM Students;
DELETE ROW FirstName = 'Nicole' FROM Students;
DELETE FROM Students FirstName = 'Nicole';
In a fully normalized database, there is no redundancy, and data is stored in a single table.
TRUE
FALSE
The process of database normalization is typically a one-time task and doesn't need to be revisited as data requirements change.
TRUE
FALSE
Redundancy in a database can lead to data anomalies, such as the update anomaly, where changing data in one place leads to inconsistencies.
TRUE
FALSE
Multivalued dependencies are a concern in 5NF.
TRUE
FALSE
Normalization always results in fewer tables and more attributes per table.
TRUE
FALSE
In the First Normal Form (1NF), all attributes in a table must be atomic, meaning they cannot be further divided.
TRUE
FALSE
Database normalization is the process of decreasing data redundancy in a database to improve data integrity.
TRUE
FALSE
The Second Normal Form (2NF) deals with eliminating partial dependencies by ensuring non-key attributes are functionally dependent on the entire primary key.
TRUE
FALSE
A superkey is a set of attributes that uniquely identifies a tuple (row) in a relation.
TRUE
FALSE
In the Third Normal Form (3NF), transitive dependencies between non-key attributes are allowed.
TRUE
FALSE
