D427 - Database Management Applications
Questions with verified Correct Detailed
Answers latest update 2025
For assistance with your assignments email me
13. SELECT AVG/SUM/MIN/MAX/COUNT(Column_Name) FROM
SALES
WHERE Name = 'Matt'; --- correct precise answer ---
Command to use AVG/SUM/MIN/MAX/COUNT aggregate functions?
14. o One is that the tables to be joined must be listed in the FROM
clause. o Two is that the join attributes in the tables being joined must
be declared
and matched to each other in the WHERE clause ----- correct precise
answer ---
There are two specifications to make in the SELECT statement to
make a join work.
15. SELECT SPNAME
FROM SALESPERSON, CUSTOMER
WHERE SALESPERSON.SPNUM=CUSTOMER.SPNUM--- correct precise
answer ---
Example of JOIN CAUSE.
16. Dr. CODD--- correct precise answer ---
,In 1970, Dr. of IBM published in Communications of the ACM a
paper entitled "A Relational Model of Data for Large Shared Data
Banks." This paper marked the beginning of the field of relational
databases.
17. CREATE TABLE
DROP TABLE--- correct precise answer ---
Commands to create and drop a table?
18. - When you create the column definition (known as a column
constraint).
- When you use the CONSTRAINT keyword (known as a table
constraint). --- correct precise answer ---
The CREATE TABLE command lets you define constraints in two
different places:
19. NOT
WHERE Location NOT IN ('WV', TN' 'CA');
WHERE Total NOT Between '1000', 2000';
WHERE Name NOT LIKE 'Ma%'; --- correct precise answer ---
You can exclude rows with other types of condi- tions by using the
operator.
20. USE
USE MainDatabase--- correct precise answer ---
The command tells the database system which data- base you're
going to be using for the upcoming commands.
, 21. SHOW
SHOW DATABASES - lists all databases in the database system
instance. SHOW TABLES - lists all tables in the default database.
SHOW COLUMNS FROM TableName - lists all columns in the
TableName table of the default database.
SHOW CREATE TABLE TableName - shows the CREATE TABLE
statement for the TableName table of the default database. --- correct
precise answer ---
You can use the statement to provide specified information
about a database.
22. ALTAR TABLE TableName Add ColumnName DataType
ALTAR TABLE TableName DRIP ColumnName
ALTAR TABLE TableName
CHANGE CurrentColumnName NewColumnName NewDataType---
correct precise answer ---
The ALTAR Table adds, deletes, or modifies columns. What is the
syntax for each of these?
23. LIMIT
Select * FROM CITY LIMIT 100;
This will limit it to the first 100 rows. --- correct precise answer ---
Some tables may contain thousands or millions of rows, and selecting
all rows can take a long time. MySQL has a
clause that limits the number of rows returned by a SELECT
statement.
Questions with verified Correct Detailed
Answers latest update 2025
For assistance with your assignments email me
13. SELECT AVG/SUM/MIN/MAX/COUNT(Column_Name) FROM
SALES
WHERE Name = 'Matt'; --- correct precise answer ---
Command to use AVG/SUM/MIN/MAX/COUNT aggregate functions?
14. o One is that the tables to be joined must be listed in the FROM
clause. o Two is that the join attributes in the tables being joined must
be declared
and matched to each other in the WHERE clause ----- correct precise
answer ---
There are two specifications to make in the SELECT statement to
make a join work.
15. SELECT SPNAME
FROM SALESPERSON, CUSTOMER
WHERE SALESPERSON.SPNUM=CUSTOMER.SPNUM--- correct precise
answer ---
Example of JOIN CAUSE.
16. Dr. CODD--- correct precise answer ---
,In 1970, Dr. of IBM published in Communications of the ACM a
paper entitled "A Relational Model of Data for Large Shared Data
Banks." This paper marked the beginning of the field of relational
databases.
17. CREATE TABLE
DROP TABLE--- correct precise answer ---
Commands to create and drop a table?
18. - When you create the column definition (known as a column
constraint).
- When you use the CONSTRAINT keyword (known as a table
constraint). --- correct precise answer ---
The CREATE TABLE command lets you define constraints in two
different places:
19. NOT
WHERE Location NOT IN ('WV', TN' 'CA');
WHERE Total NOT Between '1000', 2000';
WHERE Name NOT LIKE 'Ma%'; --- correct precise answer ---
You can exclude rows with other types of condi- tions by using the
operator.
20. USE
USE MainDatabase--- correct precise answer ---
The command tells the database system which data- base you're
going to be using for the upcoming commands.
, 21. SHOW
SHOW DATABASES - lists all databases in the database system
instance. SHOW TABLES - lists all tables in the default database.
SHOW COLUMNS FROM TableName - lists all columns in the
TableName table of the default database.
SHOW CREATE TABLE TableName - shows the CREATE TABLE
statement for the TableName table of the default database. --- correct
precise answer ---
You can use the statement to provide specified information
about a database.
22. ALTAR TABLE TableName Add ColumnName DataType
ALTAR TABLE TableName DRIP ColumnName
ALTAR TABLE TableName
CHANGE CurrentColumnName NewColumnName NewDataType---
correct precise answer ---
The ALTAR Table adds, deletes, or modifies columns. What is the
syntax for each of these?
23. LIMIT
Select * FROM CITY LIMIT 100;
This will limit it to the first 100 rows. --- correct precise answer ---
Some tables may contain thousands or millions of rows, and selecting
all rows can take a long time. MySQL has a
clause that limits the number of rows returned by a SELECT
statement.
