Introduction to Database System A large computer information system maintains many different computer files. Which amongst them is called a perpetual file? Specialized file Log file Master file Update file Specialized file Log file Master file Update file ANSWER DOWNLOAD EXAMIANS APP
Introduction to Database System In SQL, the CREATE TABLESPACE is used None of these to create a place in the database for storage of scheme objects, rollback segments, and naming the data files to comprise the tablespace to create a database trigger to add/rename data files, to change storage All of these None of these to create a place in the database for storage of scheme objects, rollback segments, and naming the data files to comprise the tablespace to create a database trigger to add/rename data files, to change storage All of these ANSWER DOWNLOAD EXAMIANS APP
Introduction to Database System A key: identifies a row. must always be composed of two or more columns. can only be one column. identifies a column. identifies a row. must always be composed of two or more columns. can only be one column. identifies a column. ANSWER DOWNLOAD EXAMIANS APP
Introduction to Database System In SQL, which command is used to select data in rows and column from one or more tables? SELECT None of these CHOOSE BROWSE LIST SELECT None of these CHOOSE BROWSE LIST 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 SELECT UNIQUE SELECT DIFFERENT None of these SELECT DISTINCT All of these SELECT UNIQUE SELECT DIFFERENT None of these SELECT DISTINCT All of these ANSWER DOWNLOAD EXAMIANS APP
Introduction to Database System Queries to a database All of these are written in English both (a) and (b) None of these can use aggregate functions like SUM and COUNT All of these are written in English both (a) and (b) None of these can use aggregate functions like SUM and COUNT ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS