BUAN 6320: Chapter 08 questions and answers, Graded A+/ User 2024/25 Exam PREDICTOR PAPER

BUAN 6320: Chapter 08 questions and answers, Graded A+ You cannot have an invalid entry in the foreign key column; at the same time, you cannot delete a vendor row as long as a product row references that vendor. This is known as _____. - -"referential integrity " _____ is a cursor attribute that returns TRUE if the last FETCH returned a row, and FALSE if not. - - %found The Oracle string concatenation function is _____. - -|| When a user issues the DELETE FROM tablename command without specifying a WHERE condition, _____. - -all rows will be deleted All changes in a table structure are made using the _____ TABLE command, followed by a keyword that produces the specific changes a user wants to make. - -alter _____ is the process the DBMS uses to verify that only registered users access the database. - - authentification In MS Access, a designer can use the _____ data type to define a column in his table that will be automatically populated with unique numeric values. - -AutoNumber The tables on which a view, or a virtual table derived from a SELECT query, are based are called _____ tables. - -base U.S. state abbreviations are always two characters, so _____(2) is a logical choice for the data type representing a state column. - -char The _____ constraint is used to validate data when an attribute value is