CS331PRACTICE1

Réussis tes devoirs et examens dès maintenant avec Quizwiz!

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


Ensembles d'études connexes

Chapter 59: Concepts of Care for Patients With Diabetes Mellitus

View Set

Ch 8 - DNA: The Chemical Nature of the Gene

View Set

Care for Patients with Problems of the Central Nervous System: The Brain (39).

View Set