CS331PRACTICE1
A database is maintained and queried using the data mapping language (DML).
FALSE
A referential integrity constraint specifies that the existence of an attribute in one tabledepends upon the existence of a foreign key in the same or another table
FALSE
A subquery in which processing the inner query depends on data from the outer query is called a codependent query
FALSE
EXISTS takes a value of false if the subquery returns an intermediate result set.
FALSE
IF-THEN-ELSE logical processing cannot be accomplished within an SQL statement
FALSE
Subqueries can only be used in the WHERE clause
FALSE
The CREATE SCHEMA DDL command is used to create a table.
FALSE
The DELETE TABLE DDL command is used to remove a table from the database.
FALSE
The following command would work fine: insert into budget values 121,222,111;
FALSE
When creating a table, it is not important to consider foreign key—primary key mates.
FALSE
A correlated subquery is executed once for each iteration through the outer loop.
TRUE
A database table is defined using the data definition language (DDL).
TRUE
An insert command does not need to have the fields listed.
TRUE
Figuring out what attributes you want in your query before you write the query will help withquery writing.
TRUE
The ALTER TABLE command is used to change a table definition
TRUE
The SQL command used to populate tables is the INSERT command.
TRUE
The UNION clause is used to combine the output from multiple queries into a single resulttable.
TRUE
The following SQL statement is an example of a correlated subquery. select first_name, last_name, total_salesfrom salesman s1where total_sales > all(select total_sales from salesman s2where s1.salesman_id != s2.salesman_id);
TRUE
When EXISTS or NOT EXISTS is used in a subquery, the select list of the subquery willusually just select all columns as a placeholder because it doesn't matter which columns arereturned.
TRUE
When creating tables, it's important to decide which columns will allow null values before thetable is created.
TRUE
