©JOSHCLAY 2024/2025. YEAR PUBLISHED 2024.
DB SQL Exam Questions and Answers
100% Solved | Graded A+
The ________ is the structure that contains descriptions of objects such as
tables and views created by users. - ✔✔schema
________ is a set of commands used to control a database, including
security. - ✔✔DCL
________ is a set of commands used to update and query a database. -
✔✔DML
DDL is typically used during which phase of the development process? -
✔✔Physical design
The main concept of relational databases was published in 1970 by: -
✔✔E.F.Codd.
Relational databases are heavily based on the mathematical concept of: -
✔✔Set Theory.
The command for creating a database is: - ✔✔create schema.
,©JOSHCLAY 2024/2025. YEAR PUBLISHED 2024.
The SQL command ________ defines a logical table from one or more
tables or views. - ✔✔create view
Any create command may be reversed by using a(n) ________ command.
- ✔✔drop
The first in a series of steps to follow when creating a table is to: -
✔✔identify each attribute and its characteristics.
The SQL command ________ adds one or more new columns to a table. -
✔✔alter table
INSERT INTO is an example of ________ code. - ✔✔DML
What does the following SQL command do? insert into Customer_T values
(001,'John Smith','231 West St','Boston','MA','02115') - ✔✔Adds a new
record to the Customer_T
Given a table named store with 5 fields: store_id, address, city, state,
zipcode, why would the following insert command not work? insert into
store values ('234 Park Street') - ✔✔You must specify the fields to insert if
you are only inserting some of the fields.
Which of the following is a technique for optimizing the internal
performance of the relational data model? - ✔✔Clustering data
, ©JOSHCLAY 2024/2025. YEAR PUBLISHED 2024.
Indexes are created in most RDBMSs to: - ✔✔provide rapid random and
sequential access to base-table data.
In an SQL statement, which of the following parts states the conditions for
row selection? - ✔✔Where
The first part of an SQL query to be read is the ________ statement. -
✔✔FROM
The last part of an SQL query to be read is the ________ statement. -
✔✔ORDER BY
- ✔✔
What does the following SQL statement do? Select * From Customer
Where Cust_Type = "Best" - ✔✔Selects all the fields from the Customer
table for each row with a customer labeled "Best"
What result will the following SQL statement produce? Select
Avg(standard_price) as average from Product_V - ✔✔The average
Standard_Price of all products in Product_V
Which of the following questions is answered by the SQL statement?
Select Count (Product_Description) from Product_T - ✔✔How many
products have product descriptions in the Product Table?
DB SQL Exam Questions and Answers
100% Solved | Graded A+
The ________ is the structure that contains descriptions of objects such as
tables and views created by users. - ✔✔schema
________ is a set of commands used to control a database, including
security. - ✔✔DCL
________ is a set of commands used to update and query a database. -
✔✔DML
DDL is typically used during which phase of the development process? -
✔✔Physical design
The main concept of relational databases was published in 1970 by: -
✔✔E.F.Codd.
Relational databases are heavily based on the mathematical concept of: -
✔✔Set Theory.
The command for creating a database is: - ✔✔create schema.
,©JOSHCLAY 2024/2025. YEAR PUBLISHED 2024.
The SQL command ________ defines a logical table from one or more
tables or views. - ✔✔create view
Any create command may be reversed by using a(n) ________ command.
- ✔✔drop
The first in a series of steps to follow when creating a table is to: -
✔✔identify each attribute and its characteristics.
The SQL command ________ adds one or more new columns to a table. -
✔✔alter table
INSERT INTO is an example of ________ code. - ✔✔DML
What does the following SQL command do? insert into Customer_T values
(001,'John Smith','231 West St','Boston','MA','02115') - ✔✔Adds a new
record to the Customer_T
Given a table named store with 5 fields: store_id, address, city, state,
zipcode, why would the following insert command not work? insert into
store values ('234 Park Street') - ✔✔You must specify the fields to insert if
you are only inserting some of the fields.
Which of the following is a technique for optimizing the internal
performance of the relational data model? - ✔✔Clustering data
, ©JOSHCLAY 2024/2025. YEAR PUBLISHED 2024.
Indexes are created in most RDBMSs to: - ✔✔provide rapid random and
sequential access to base-table data.
In an SQL statement, which of the following parts states the conditions for
row selection? - ✔✔Where
The first part of an SQL query to be read is the ________ statement. -
✔✔FROM
The last part of an SQL query to be read is the ________ statement. -
✔✔ORDER BY
- ✔✔
What does the following SQL statement do? Select * From Customer
Where Cust_Type = "Best" - ✔✔Selects all the fields from the Customer
table for each row with a customer labeled "Best"
What result will the following SQL statement produce? Select
Avg(standard_price) as average from Product_V - ✔✔The average
Standard_Price of all products in Product_V
Which of the following questions is answered by the SQL statement?
Select Count (Product_Description) from Product_T - ✔✔How many
products have product descriptions in the Product Table?
