Introduction to Database System In SQL, which command is used to add a column/integrity constraint to a table ADD COLUMN ALTER TABLE MODIFY TABLE INSERT COLUMN ADD COLUMN ALTER TABLE MODIFY TABLE INSERT COLUMN ANSWER DOWNLOAD EXAMIANS APP
Introduction to Database System Which of the following refers to an entity in which the identifier of one entity includes the identifier of another entity? Weak entity ID-dependent entity ID-independent entity Strong entity Weak entity ID-dependent entity ID-independent entity Strong entity ANSWER DOWNLOAD EXAMIANS APP
Introduction to Database System Which command is used to remove a table from the database in SQL? UNATTACH TABLE ERASE TABLE DROP TABLE DELETE TABLE UNATTACH TABLE ERASE TABLE DROP TABLE DELETE TABLE ANSWER DOWNLOAD EXAMIANS APP
Introduction to Database System In SQL, which command is used to select only one copy of each set of duplicable rows All of these SELECT UNIQUE SELECT DIFFERENT None of these SELECT DISTINCT All of these SELECT UNIQUE SELECT DIFFERENT None of these SELECT DISTINCT ANSWER DOWNLOAD EXAMIANS APP
Introduction to Database System A good query system can be accessed only by data processing professionals can accept English language commands both (a) and (b) None of these allows non-programmers to access information stored in a database can be accessed only by data processing professionals can accept English language commands both (a) and (b) None of these allows non-programmers to access information stored in a database ANSWER DOWNLOAD EXAMIANS APP
Introduction to Database System If a piece of data is stored in two places in the database, then both (a) and (b) it can be more easily accessed None of these storage space is wasted changing the data is one spot will cause data inconsistency both (a) and (b) it can be more easily accessed None of these storage space is wasted changing the data is one spot will cause data inconsistency ANSWER DOWNLOAD EXAMIANS APP