Introduction to Database System In SQL, which of the following is not a data Manipulation Language Commands? DELETE UPDATE SELECT CREATE DELETE UPDATE SELECT CREATE ANSWER DOWNLOAD EXAMIANS APP
Introduction to Database System The physical location of a record is determined by a mathematical formula that transforms a file key into a record location in a sequential file an indexed file a tree file a hashed file None of these a sequential file an indexed file a tree file a hashed file None of these ANSWER DOWNLOAD EXAMIANS APP
Introduction to Database System In SQL, which command is used to add a column/integrity constraint to a table MODIFY TABLE ALTER TABLE ADD COLUMN INSERT COLUMN MODIFY TABLE ALTER TABLE ADD COLUMN INSERT COLUMN ANSWER DOWNLOAD EXAMIANS APP
Introduction to Database System Which of the following indicates the maximum number of entities that can be involved in a relationship? Maximum cardinality Minimum cardinality ERD Greater Entity Count (GEC) Maximum cardinality Minimum cardinality ERD Greater Entity Count (GEC) ANSWER DOWNLOAD EXAMIANS APP
Introduction to Database System A computer file can be best described as a random collection of data items a general collection of data items a single data item an orderly collection of data items None of these a random collection of data items a general collection of data items a single data item an orderly collection of data items None of these 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 ________ . metadata user data indexes A report metadata user data indexes A report ANSWER DOWNLOAD EXAMIANS APP