NEW
Font size
WorksheetsFinal Exam Review: Information Management
Total questions: 51
Worksheet time: 26mins
It is a major component of SQL that enables you to create and modify the database itself.
Data Control Language
Data Manipulation Language
Data Definition Language
Transaction Control Language
It is the process of organizing data to minimize redundancy in the design of a relational database management system.
Normalization
Functional Dependency
Transitive Dependency
Full Functional Dependency
A process of minimizing the differences between entities by identifying their common features.
Superclass
Generalization
Subtype
Specialization
A normal form wherein the partial dependency is being eliminated.
1NF
2NF
3NF
BCNF
This statement is used to edit data in a table.
CHANGE
EDIT
UPDATE
ALTER
Which of the following SQL commands is not an example of Data Manipulation Language?
SELECT
COUNT
FROM
RENAME
A normal form where all underlying simple domains contain atomic values only.
1NF
2NF
3NF
BCNF
It is a graphical user interface that allows you to issue SQL commands to interact with the server and any databases you create.
MySQL Community Server
MySQL Workbench
Oracle Database Express Edition
SQL Server Management Studio
It is used to connect to any of the SQL Server components.
Solutions Explorer Window
Object Explorer Window
Query Editor Window
Properties Window
It is the key field that serves as the unique identifier of a specific tuple in a relation.
Foreign Key
Primary Key
Candidate Key
Unique attribute
Which statement removes the records of the teachers under the IT department?
DELETE FROM Teachers BETWEEN Department = 'IT';
DELETE FROM Teachers LIKE Department = 'IT';
ERASE FROM Teachers IN Department = 'IT';
DELETE FROM Teachers WHERE Department = 'IT';
Which of the following is not an objective of normalization?
Each table represent a single entity.
No data item will be unnecessary stored in more than one table.
Each row contains multiple values.
Each table has no data anomalies.
Which of the following statements deletes a database named preDB?
CLEAR DATABASE preDB:
ERASE DB preDB;
DELETE DB preDB:
DROP DATABASE preDB;
Which statement removes the record of the employees under the Marketing department?
DELETE FROM Employees BETWEEN Department = 'Marketing';
ERASE FROM Employees IN Department = 'Marketing';
DELETE FROM Employees LIKE Department = 'Marketing';
DELETE FROM Employees WHERE Department = 'Marketing';
Which of the following statements deletes the Age column from the Students table?
ALTER TABLE Students DROP COLUMN Age:
ALTER TABLE Students DROP COLUMN Age;
DROP COLUMN Age ALTER TABLE Students:
DROP COLUMN Age ALTER TABLE Students:
Which of the following is NOT a basic scenario as to how data can be modified?
Inserting new rows into a table
Inserting new columns into a table
Deleting rows from a table
Updating existing data in specific rows and columns in a table
Which of the following is NOT the importance of Normalization
Correct duplicate data and database anomalies.
Prevent unwanted deletions of data.
Optimize storage space.
Checking and proper referencing of foreign key
Which of the following statements is NOT TRUE about SQL?
SQL can execute queries against a database.
SQL can create stored procedures in a database.
SQL can create new table in a database.
SQL can set permission on tables and views only.
Which statement creates a database named preDB?
CREATE DATABASE preDB:
CREATE DATABASE preDB;
CREATE DB preDB:
CREATE DB preDB;
Which retrieves the unique values in the Color column of the Car table?
SELECT DISTINCT Color FROM Car:
SELECT UNIQUE Color FROM Car:
SELECT DISTINCT Color FROM Car;
SELECT UNIQUE Color FROM Car;
What does the CREATE TABLE statement do in the provided SQL command?
Inserts data into an existing table
Deletes a table from the database
Defines a new table structure in the database
Retrieves data from the table
In the CREATE TABLE statement, what is the purpose of the PRIMARY KEY constraint on StudID?
To allow duplicate values in the StudID column
To ensure that StudID uniquely identifies each row and cannot be NULL
To link the StudID column with another table
To automatically populate StudID with default values
What does the identity(1,1) clause in the StudID column do?
Sets StudID to increment by 1 for each new row, starting at 1
Makes the StudID column a foreign key
Ensures that StudID can accept NULL values
Specifies a default value of 1 for the StudID column
What is the purpose of the INSERT INTO statement in the given commands?
To create a new table named tblStudents
To delete rows from the tblStudents table
To add a new row of data to the tblStudents table
To update existing rows in the tblStudents table
What does the SELECT * FROM tblStudents; command do?
Retrieves all rows and columns from the tblStudents table
Deletes all data from the tblStudents table
Updates specific rows in the tblStudents table
Creates a backup of the tblStudents table
What is the date value that can be inserted into the bday column using the INSERT INTO statement?
2000-01-01
1900-03-28
2023-13-01
12-1800-15
Which of the following SQL statements is used to create a new table in the database?
INSERT INTO
CREATE TABLE
SELECT * FROM
ALTER TABLE
What does the PRIMARY KEY constraint ensure in a CREATE TABLE statement?
Allows duplicate and NULL values in the column
Ensures that each row in the table has a unique and non-NULL value for the column
Restricts data modifications in the table
Automatically adds foreign key constraints
Which of the following is the correct syntax to insert a row of data into a table?
ADD ROW INTO table_name VALUES(value1, value2, value3);
INSERT INTO table_name(value1, value2, value3);
INSERT INTO table_name(column1, column2) VALUES(value1, value2);
ADD DATA TO table_name(column1, column2) VALUES(value1, value2);
Which of the following SQL commands is used to retrieve all rows and columns from a table named Customers?
GET ALL FROM Customers;
SELECT ALL COLUMNS FROM Customers;
SELECT FROM Customers;
SHOW TABLE Customers
In the INSERT INTO command, what must match between the inserted values and the table structure?
The data types only
The column names and the data types
The table name only
The primary key values
How do you select specific columns, such as FirstName and LastName, from a table named Users?
GET FirstName, LastName FROM Users;
SELECT (FirstName, LastName) FROM Users;
SELECT FirstName, LastName FROM Users
SELECT ALL FirstName AND LastName FROM Users
What is the correct syntax to specify a primary key for the column StudentID in a CREATE TABLE statement?
StudentID INT UNIQUE PRIMARY;
StudentID INT PRIMARY KEY;
PRIMARY KEY StudentID INT;
StudentID PRIMARY INT KEY;
When using the INSERT INTO statement, what happens if you omit the column names but provide the values?
The command will insert the values into all columns automatically in alphabetical order
The command will insert the values based on the default order of columns in the table
The command will fail with an error
The command will prompt the user to specify the column names
When using the INSERT INTO statement, what happens if you omit the column names but provide the values?
The command will insert the values into all columns automatically in alphabetical order
The command will insert the values based on the default order of columns in the table
The command will fail with an error
The command will prompt the user to specify the column names
Which of the following SQL statements will create a table with three columns: ID, Name, and Age?
CREATE TABLE Persons(ID INT, Name VARCHAR(50), Age);
CREATE Persons(ID INT PRIMARY, Name CHAR(50), Age INT);
CREATE TABLE Persons(ID INT, Name VARCHAR(50), Age INT);
TABLE Persons(ID INT PRIMARY KEY, Name CHAR(50), Age);
Normalization prevents unwanted modification of data.
TRUE
FALSE
The ER model supported with additional semantic concepts is called Enhanced Entity-Relationship model.
TRUE
FALSE
To reduce this complexity of modeling we have to make improvements to the existing ER model to make it able to handle the complex application in a better way.
TRUE
FALSE
One of the main concepts of representing EER model is through superclasses.
TRUE
FALSE
The main objective of normalization is to develop a conceptual data model to create an accurate representation of data, its relationship, and constraints.
TRUE
FALSE
Elimination of partial dependencies are rules about disallowing multi-valued attributes.
TRUE
FALSE
Elimination of transitive dependency is a rule that refers to the situation where in a column in the table refers to a non-key column instead of referring to the primary key of a table.
TRUE
FALSE
In the Third Normal Form every non-key attribute that is transitively dependent on the primary key should be removed in the original table.
TRUE
FALSE
The Second Normal Form is accomplished by eliminating partial dependencies.
TRUE
FALSE
A relation is in the fifth normal form if and only if every join dependency in the relation is a consequence of the candidate keys of the relation.
TRUE
FALSE
A relation is in the second normal form (2NF) every non-key attribute is fully dependent on the primary key.
TRUE
FALSE
Partial functional dependency indicates that if A and B are attributes of a table, B is partially dependent on A if there are some attributes that can be removed from A and dependency still holds.
TRUE
FALSE
To represent a total participation, a double line is drawn in between the superclass.
TRUE
FALSE
Enhanced Entity Relationship model optimizes storage space.
TRUE
FALSE
Normalization eliminates the delay and complexity of checking databases when new types of data need to be introduced.
TRUE
FALSE
