Online Access Free C_SASEAA_15 Practice Test

What is the system stored procedure used to display metadata cache usage statistics?

• A.sp_monitorconfig
• B.sp_configure
• C.sp_helpconfig
• D.sp_cacheconfig

What will be the result if the 'disk init' command is run to create a database device and no "vdevno" is specified?

• A.The command will fail without any adverse affects to the server
• B.The command will fail but the operating system file will be created
• C.The command will function properly because the server no longer uses 'vdevno'
• D.The command will create the device with a vdevno assigned by the server

Which of the following is NOT true about groups?

• A.Must be enabled once created
• B.A user can only be a member of one user-defined group
• C.Database-specific
• D.Cannot contain other groups

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

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

Which table identifies the process that has the oldest active transaction and how long that transaction has been open?

• A.master..sysprocesses
• B.master..syslocks
• C.master..syslogshold
• D.master..syslogins
• E.master..systransactions