You configure your database Instance to support shared server connections.Which two memory areas that are part of PGA are stored in SGA instead, for shared server connection?（）
A: User session data
B: Stack space
C: Private SQL area
D: Location of the runtime area for DML and DDL Statements
E: Location of a part of the runtime area for SELECT statement
A: User session data
B: Stack space
C: Private SQL area
D: Location of the runtime area for DML and DDL Statements
E: Location of a part of the runtime area for SELECT statement
举一反三
- You configure your database Instance to support shared server connections.Which two memory areas that are part of PGA are stored in SGA instead, for shared server connection?（） A: AUser session data B: BStack space C: CPrivate SQL area D: DLocation of the runtime area for DML and DDL Statements E: ELocation of a part of the runtime area for SELECT statements
- Which two capabilities are granted with the SUPER privilege?() A.Allowing a client to kill other client connections B.Allowing a client to shut down the server C.Allowing change of the server runtime configuration D.Allowing client accounts to take over the account of another user
- You are a database administrator for your company. You are responsible for a SQL Server 2005 database that has several indexes. You need to write a stored procedure that checks the indexes for fragmentation. Which Transact-SQL statement should you use？（） A: DBCC DBREINDEX B: SELECT * FROM sys.dm_db_index_physical_stats C: DBCC INDEXDEFRAG D: SELECT * FROM sys.indexe
- You are a database administrator for your company. You are responsible for a SQL Server 2005 database that has several indexes. You need to write a stored procedure that checks the indexes for fragmentation. Which Transact-SQL statement should you use？（） A: DBCC DBREINDEX B: SELECT * FROM sys.dm_db_index_physical_stats C: DBCC INDEXDEFRAG D: SELECT * FROM sys.indexes
- （）:A location where data can be temporarily stored. A: Area B: Disk C: Buffer D: File