Introduction to Database System In SQL, which command is used to add a column/integrity constraint to a table MODIFY TABLE INSERT COLUMN ADD COLUMN ALTER TABLE MODIFY TABLE INSERT COLUMN ADD COLUMN ALTER TABLE ANSWER DOWNLOAD EXAMIANS APP
Introduction to Database System You have run an SQL statement that asked the DBMS to display data in a table named USER_TABLES. The results include columns of data labeled "TableName," "NumberOfColumns" and "PrimaryKey." You are looking at ________ . A report metadata indexes user data A report metadata indexes user data ANSWER DOWNLOAD EXAMIANS APP
Introduction to Database System A ____ Contains the smallest unit of meaningful data, so you might call it the basic building block for a data file. Fields Records Database File structure Fields Records Database File structure ANSWER DOWNLOAD EXAMIANS APP
Introduction to Database System One data dictionary software package is called None of these TOTAL any of the above ACCESS DB/DC dictionary None of these TOTAL any of the above ACCESS DB/DC dictionary ANSWER DOWNLOAD EXAMIANS APP
Introduction to Database System Which type of entity has its relationship to another entity determined by an attribute in that other entity called a discriminator? Instance entity Archetype entity Supertype entity Subtype entity Instance entity Archetype entity Supertype entity Subtype entity ANSWER DOWNLOAD EXAMIANS APP
Introduction to Database System A _____ means that one record in a particular record type can be related to many records in another record type and vice-versa. None of these Many-to-one relationship Many-to-many relationship One-to-many relationship One-to-one relationship None of these Many-to-one relationship Many-to-many relationship One-to-many relationship One-to-one relationship ANSWER DOWNLOAD EXAMIANS APP