C_SASEAA_15 Exam Questions

Which of the following are NOT captured by query plan metrics? (Choose two.)

Permissions on a table can be granted by all of the following EXCEPT: (Choose two.)

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

Which database option must be set to run dbcc checkalloc in fix mode?

How large can a table, column and index name be?

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

Which of the following is NOT true about groups?

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

Which of the following is TRUE regarding semantic partitioning? (Choose three.)

Maximum database size for 2K pages is?

Which command is used to display the current server EBF level?

Using the 'sp_who' output, how can you identify a system process?

What is the value of @@trancount after the execution of a rollback transaction in a nested transaction?

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

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

What is the command used to dynamically increase the size of a database device?

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

What happens when a row is inserted into a list partitioned table but the key value is not within the list?

Which of the following statements are NOT true about database dumps? (Choose two.)

Which of the following clients enables the use of the GUI Plan Viewer?

Which of the following will allow the system administrator to view database permissions for any given user?

Which of the following system databases will be built during an ASE installation? (Choose four.)

Given the following partial histogram from optdiag, what percentage of the rows for this column have a value of 500.00?

In the create database syntax, when is the 'with override' necessary?

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

Which of the following can NOT be done by a dbo? (Choose two.)

Which of the following commands allow you to specify the partition? (Choose three.)

Which of the following has permissions precedence?

Which of the following are TRUE about user defined caches? (Choose two.)

Given that the following commands are successfully executed: use mydb go select * into #myusers from sysusers go In which database does #myusers exist?

Based on the command "dump database pubs2 to pubs2.dmp with compression = 6", which commands could be used to load it? (Choose two.)

During the installation, which of the following databases are created on the master device? (Choose two.)

When using ASE device mirroring, what does the administrator have the ability to perform?

How is a deadlock victim determined?

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

Which of the following is TRUE regarding the execution of dbcc checkstorage?

Which environment variable will be used if a server name is not provided in the runserver file?

Which system table contains a row for every transaction log fragment?

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

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

Which of the following are TRUE about lock promotion? (Choose three.)

Which of the following is the default partitioning strategy?

For a full-merge join which of the following are TRUE? (Choose two.)

Cursors can now be declared as which of the following? (Choose four.)

Which of the following tables do NOT store metadata in the metadata cache? (Choose two.)

What is the maximum value of vdevno that may be assigned to a device?

Which of the following can NOT be used to automatically enable the configuration option 'allow updates to system tables' at boot time?

Which of the following can be used to identify frequently executed queries?

Which subcommand can be used to generate a server configuration file containing the currently configured, but not necessary active, configured values?

Which command can be used to check the maximum number of locks used since ASE server was started?