DBMS and SQL Quiz 4 DBMS and SQL Quiz 4 How many tables can be linked using a join?123All of the aboveID-dependent entities are required in:Archetype/instance relationships only Multivalued attributes onlyAssociation relationships onlyAll of the above use ID dependent entitiesWhich of the following is true about shared database?It should provide for backup and recovery.It should be accurate and available.It should be secure.All of the above.For which of the following, server-side extension is required?Allow a request from a client to access a HTML-formatted page.Allow a request from a client to access Web pages.Allow a request from a client to access the database.All of the above.A value of an attribute's is always remain literal.TRUEFALSEWhich of the following types of triggers does SQL Server supports?BEFORE onlyAFTER only INSTEAD OF only iNSTEAD OF and AFTER onlyWhich of the following statement is correct about supertype/subtype hierarchy?Each supertype has only one subtype.Each supertype has only one attribute. Each subtype has only one supertype.Each subtype has only one attribute.The most important benefit of stored procedure is that it can be distributed to client computers along with the application.TRUEFALSEWhich of the following is not the correct medium for data acquisition in Business Intelligence (BI) system?Process transactionsProcess data purchased from data vendorsRead and process data from an operational databaseProcess extracts from operational databasesClient-side extensions:add functionality to the browseradd functionality to the networkadd functionality to the firewalladd functionality to the server
