When you issue the DELETE FROM tablename command without spe

When you issue the DELETE FROM tablename command without specifying a WHERE condition, ______ no rows will be deleted the first row will be deleted the last row will be deleted all rows will be deleted The special operator used to check whether a subquery returns any rows is ____. BETWEEN EXISTS LIKE IN The ER diagram represents the conceptual database as viewed by the end user. Connectivities and cardinalities are established by business rules. Normalization is a very important database design ingredient and the highest level is always the most desirable. Repeating groups must be eliminated by making sure that each row defines a single entity. A database language enables the user to create database and table structures to perform basic data management chores. The conditional LIKE must be used in conjunction with wildcard characters. A database language enables the user to perform complex queries designed to transform the raw data into useful information. SQL requires the use of the ADD command to enter data into a table. You cannot insert a row containing a null attribute value using SQL. You can select partial table contents by naming the desired fields and by placing restrictions on the row s to be included in the output.

Solution

14)))))))))))

it deletes all the rows in a table when where clause is not specified.

15))))))

exists is the operator which is helpful in weather a subquery returns any rows or not

1)))))))))))

true

because the er diagram will be helpful in designing the conceptual database which is very helpful for user.

2)))))))))))

true

because the cardinalities describes limits of a particular and valid relationship which is helpful for the bussiness purpose.

3))))))))))))

true

normalization is the process of removing redundancy at the same time making the data consistency.

4)))))))))))))

true

inorder to be the data in the 1st normal form we should fallow the above criteria.

6))))))))) true

we use % ,_ as wild characters

7)))))))))

true

it helpsto collect the data as per the query

8)))))))))

false

add command is used to add the column in the table.

9)))))))))))))

false

we cannot inserrt a column which is not null is specified

 When you issue the DELETE FROM tablename command without specifying a WHERE condition, ______ no rows will be deleted the first row will be deleted the last ro
 When you issue the DELETE FROM tablename command without specifying a WHERE condition, ______ no rows will be deleted the first row will be deleted the last ro

Get Help Now

Submit a Take Down Notice

Tutor
Tutor: Dr Jack
Most rated tutor on our site