C-SASEAA-15 試験問題を無料オンラインアクセス

If a transaction places an update lock on a data page, what type of lock will a second
transaction get if it attempts to read the data using a SELECT statement?

• A.Another UPDATE lock
• B.EXCLUSIVE lock
• C.No lock is placed as process will be blocked
• D.SHARED lock

Which system tables contain information regarding segments? (Choose three.)

• A.sysdatabases
• B.sysobjects
• C.sysusages
• D.sysdevices
• E.sysindexes
• F.syspartitions

What must occur following a non-logged transaction before normal dump transactions may resume?

• A.A truncate table on the table in question
• B.A database dump
• C.A transaction log dump with the no_log option
• D.A transaction log dump with the truncate_only option

Which of the following statements is NOT true about automatic database expansion?

• A.Database expansion thresholds are set per segment.
• B.Automatic database expansion is turned off by default.
• C.Growby and maxsize policies can be set for database devices and database segments.
• D.Automatic database expansion is managed by the stored procedure sp_helpdb.

Which commands can be used to specify the number of histogram steps in systatistics? (Choose two.)

• A.optdiag
• B.sp_modifystats
• C.reorg
• D.create index
• E.update statistics