C2090-616 無料問題集「IBM DB2 11.1 Fundamentals for LUW」

（A）Deadlock

（B）Lock conversion

（C）Lock escalation

（D）Lock timeout

（A）Only uncommitted read (UR) applications can access the table

（B）No other applications can access the table

（C）This lock is acquired under certain conditions, such as when the table is altered or dropped or an index on the table is dropped

（D）The lock owner and other applications can read, but not update, the locked table

（E）The lock owner can both read and update datA. Other applications can read the table

（A）Table

（B）Schema

（C）View

（D）Alias

（A）To assign one or more users that need to run local DB2 applications and tools on a particular server to the DB2ADMNS or the DB2USERS group

（B）To group a collection of users together so that they can be simultaneously granted and revoked specific authorities and privileges

（C）To define exactly what a specific user can and cannot do within a particular database once they have been authenticated

（D）To group a collection of privileges together so that they can be simultaneously granted to and revoked from multiple users, groups, or other roles

（A）Lock conversion can take place implicitly as a query executes

（B）The same lock modes apply to tables, rows, or blocks

（C）Changing the mode of a lock that is already held is called lock escalation

（D）Lock conversion is not necessary if an X lock is required and an S or U lock is currently held

（A）Query the SYSCAT.TABAUTH view

（B）db2pd with the -auth option

（C）Query the SYSCAT.TABLES view

（D）Query the SYSCAT.DBAUTH view

（E）db2look with the -x option