Latest Certified Success Dumps Download

CISCO, MICROSOFT, COMPTIA, HP, IBM, ORACLE, VMWARE
C_SASEAA_15 Examination questions (September)

Achieve New Updated (September) SAP C_SASEAA_15 Examination Questions 11-20

September 25, 2015

Ensurepass

 

QUESTION 11

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

 

A.

load database pubs2

from “pubs2.dmp”

with compression = 6

B.

load database pubs2

from “compress::6::pubs2.dmp”

C.

load database pubs2

from “pubs2.dmp”

with compression level 6

D.

load database pubs2

from “pubs2.dmp”

E.

load database pubs2

from “pubs2.dmp”

with compression

 

Answer: AD

 

 

QUESTION 12

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

 

A.

isql

B.

jisql

C.

SQL Advantage

D.

Interactive SQL

 

 

 

 

 

Answer: D

 

 

QUESTION 13

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

 

A.

255

B.

2147483647

C.

value of the configuration setting “number of devices”

D.

value of the configuration setting “number of devices” minus 1

E.

no limit

 

Answer: B

 

 

QUESTION 14

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 15

Which database is most suitable for setting the “dsync” value to FALSE on its file system device?

 

A.

master

B.

sybsystemdb

C.

sybsystemprocs

D.

tempdb

E.

model

 

Answer: D

 

 

 

QUESTION 16

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

 

A.

master

B.

model

C.

sybsyntax

D.

sybsecurity

E.

sybsystemdb

F.

sybsystemprocs

 

Answer: ABEF

 

 

QUESTION 17

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

 

A.

create index

B.

optdiag

C.

update statistics

D.

reorg

E.

sp_modifystats

 

Answer: AC

 

 

QUESTION 18

Given that the following commands are successfully executed:

 

use mydb

 

go

 

select * into #myusers from sysusers

 

 

 

 

go

 

In which database does #myusers exist?

 

A.

master

B.

model

C.

mydb

D.

tempdb

 

Answer: D

 

 

QUESTION 19

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

 

A.

Sort inner table in join order, then merge with left outer table

B.

Tables being joined have useful indexes on join columns

C.

Sort outer table in join order, then merge with the right inner table

D.

Sort both tables, then merge

E.

Tables do not need to be sorted but can be merged using indexes

 

Answer: BE

 

 

QUESTION 20

When rebuilding the master database without backups the disk refit command restores which system tables? (Choose two.)

 

A.

sysdatabases

B.

sysreferences

C.

sysusages

D.

sysdevices

E.

sysconfigures

 

Answer: AC

Free VCE & PDF File for SAP C_SASEAA_15 Real Exam

Instant Access to Free VCE Files: CompTIA | VMware | SAP …
Instant Access to Free PDF Files: CompTIA | VMware | SAP …