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 to add/rename data files, to change storage None of these All of these to create a database trigger to create a place in the database for storage of scheme objects, rollback segments, and naming the data files to comprise the tablespace to add/rename data files, to change storage None of these All of these to create a database trigger ANSWER DOWNLOAD EXAMIANS APP
Introduction to Database System In which of the following can many entity instances of one type be related to many entity instances of another type? One-to-Many Relationship One-to-One Relationship Many-to-Many Relationship Composite Relationship One-to-Many Relationship One-to-One Relationship Many-to-Many Relationship Composite Relationship ANSWER DOWNLOAD EXAMIANS APP
Introduction to Database System A relation in this form is free of all modification anomalies. Domain/key normal form First normal form Second normal form Third normal form Domain/key normal form First normal form Second normal form Third normal form ANSWER DOWNLOAD EXAMIANS APP
Introduction to Database System The data-base environment has all of the following components except: separate files users data-base administrator data base None of these separate files users data-base administrator data base None of these ANSWER DOWNLOAD EXAMIANS APP
Introduction to Database System Each of data files has a _____ that describe the way the data is stored in the file. File structure Fields Database Records File structure Fields Database Records ANSWER DOWNLOAD EXAMIANS APP
Introduction to Database System Which of the following command(s) is(are) used to recompile a stored procedure in SQL? ALTER PROCEDURE None of the listed here COMPILE PROCEDURE MODIFY PROCEDURE ALTER PROCEDURE None of the listed here COMPILE PROCEDURE MODIFY PROCEDURE ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS