Online Access Free C_SASEAA_15 Practice Test

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 but the operating system file will be created
• B.The command will fail without any adverse affects to the server
• 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

What conditions must be met before altering the partition strategy of a table from round-robin to a range partitioned table?

• A.Table must be unpartitioned before changing partition strategy
• B.Table data must be truncated
• C.Additional partitions must be added to the round-robin table
• D.Table indexes must be dropped

Which command can be used with "static options" to list all the static server configuration options?

• A.sp_monitorconfig
• B.sp_poolconfig
• C.sp_dboption
• D.sp_configure
• E.sp_helpconfig

Which of the following are TRUE about using the load database command? (Choose three.)

• A.the database must be exactly the same size as the database dump
• B.the database must not be in use
• C.the database must have been created with the for load option
• D.the database must be at least as large as the size of the database dump
• E.the database must not be marked as suspect
• F.the database need not exist because load database will create the database

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

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