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
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
举一反三
- 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
- 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
- Which of the following statements is incorrect about the concept of virtual local area networks?()
- 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