Introduction to Database System What is the language used by most of the DBMSs for helping their users to access data? Query language High level language 4GL SQL Query language High level language 4GL SQL 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 tree file None of these a sequential file an indexed file a hashed file a tree file None of these a sequential file an indexed file a hashed file ANSWER DOWNLOAD EXAMIANS APP
Introduction to Database System Which of the following command(s) is(are) used to recompile a stored procedure in SQL? None of the listed here ALTER PROCEDURE MODIFY PROCEDURE COMPILE PROCEDURE None of the listed here ALTER PROCEDURE MODIFY PROCEDURE COMPILE PROCEDURE ANSWER DOWNLOAD EXAMIANS APP
Introduction to Database System Structured Query Language (SQL) is an internationally recognized standard language that is understood by all commercial database management system products. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to Database System A _____ means that one record in a particular record type may be related to more than one record of another record type. Many-to-one relationship One-to-many relationship One-to-one relationship Many-to many relationship Many-to-one relationship One-to-many relationship One-to-one relationship Many-to many relationship ANSWER DOWNLOAD EXAMIANS APP
Introduction to Database System A list consists of last names, first names, addresses, and pin codes if all people in the list have the same last and the same pin code, a useful key would be the pin code All of these a compound key consisting of the first name and the last name None of these the last name the pin code All of these a compound key consisting of the first name and the last name None of these the last name ANSWER DOWNLOAD EXAMIANS APP