C_SASEAA_15 Cert4Prep.com

							                       SAP
             CODE: C_SASEAA_15
           Exam Name: SAP Adaptive Server Enterprise 15
                    Administrator Associate




   http://www.cert4prep.com/C_SASEAA_15.html


          Type                          Demo




http://www.cert4prep.com/C_SASEAA_15.html                 Page 1
           Question: 1

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

A. dbccdb

B. model

C. sybsecurity

D. sybsystemprocs

E. tempdb




                                                                        Answer: B, E

           Question: 2

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

A. Copy a database to several different devices

B. Copy a database from several devices to a single device

C. Copy an entire device from one location to another

D. Copy only system tables from one device to another




                                                                          Answer: C

           Question: 3



        http://www.cert4prep.com/C_SASEAA_15.html                                                 Page 2
How is a deadlock victim determined?

A. By the users permission settings

B. By the largest spid number of the processes involved

C. By the amount of elapsed time since the task was submitted

D. By the amount of the CPU time spent on the task




                                                                         Answer: D

         Question: 4

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

A. sp_configure

B. sp_helpconfig

C. sp_cacheconfig

D. sp_monitorconfig




                                                                         Answer: D

         Question: 5

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

A. Named cache must be configured

B. Large buffer pool must be configured

C. Workspace segments must be configured




        http://www.cert4prep.com/C_SASEAA_15.html                                      Page 3
D. Number of worker processes must be configured greater than 2




                                                                           Answer: B

         Question: 6

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

A. $SYBASE

B. $SYBASE_ASE

C. $DSQUERY

D. $DSLISTEN




                                                                           Answer: D

         Question: 7

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

A. sysdatabases

B. sysusages

C. sysdevices

D. syslogs




                                                                           Answer: B



        http://www.cert4prep.com/C_SASEAA_15.html                                                 Page 4
         Question: 8

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

A. can write a single database dump across multiple devices

B. makes a full backup copy of the database

C. truncates the transaction log

D. makes a full backup copy of the transaction log

E. drops the database because it is no longer necessary




                                                                Answer: A, B, D




        http://www.cert4prep.com/C_SASEAA_15.html                                  Page 5
                         SAP
            CODE: C_SASEAA_15
           Exam Name: SAP Adaptive Server Enterprise 15
                    Administrator Associate




   http://www.cert4prep.com/C_SASEAA_15.html




http://www.cert4prep.com/C_SASEAA_15.html                 Page 6