Bus-S307 Final 96 Correctly Answered Questions Latest Update

Indexes generally slow down access speed in most RDMS. True False {Ans: False}ODBC is an application programming interface that provides a common language for application programs to access and process an SQL database independent of the particular RDBMS that is accessed. True False {Ans: True}An optimistic approach to concurrency control is called: versioning. deadlock resolution. HappyControl. denormalization. {Ans: versioning.}A view can be built to present only the data to which a user requires access. True False {Ans: True}A(n) ________ prevents another transaction from reading and therefore updating a record until it is unlocked. shared lock exclusive lock authorization rule record controller {Ans: exclusive lock}The following code would include: SELECT Customer_T.CustomerID, Order_T.CustomerID, CustomerName, OrderID FROM Customer_T, Order_T WHERE Customer_T.CustomerID = Order_T. CustomerID; only rows that don't match both Customer_T and Order_T Tables. all rows of the Customer_T Table regardless of matches with the Order_T Table. only rows that match both Customer_T and Order_T Tables. all rows of the Order_T Table regardless of matches with the Customer_T Table. {Ans: only rows that match both Customer_T and Order_T Tables.}