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 hashed file a tree file None of these an indexed file a sequential file a hashed file a tree file None of these an indexed file a sequential file 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 ________ . user data A report indexes metadata user data A report indexes metadata ANSWER DOWNLOAD EXAMIANS APP
Introduction to Database System Which of the following contains a complete record of all activity that affected the contents of a database during a certain period of time? data manipulation language None of these query language report writer transaction log data manipulation language None of these query language report writer transaction log ANSWER DOWNLOAD EXAMIANS APP
Introduction to Database System In SQL, the CREATE TABLESPACE is used to create a place in the database for storage of scheme objects, rollback segments, and naming the data files to comprise the tablespace All of these None of these to create a database trigger to add/rename data files, to change storage to create a place in the database for storage of scheme objects, rollback segments, and naming the data files to comprise the tablespace All of these None of these to create a database trigger to add/rename data files, to change storage ANSWER DOWNLOAD EXAMIANS APP
Introduction to Database System A database has a built-in capability to create, process and administer itself. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to Database System In a relation, the rows are sometimes called "records". False True False True ANSWER DOWNLOAD EXAMIANS APP