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 1-10

September 25, 2015

Ensurepass

 


Exam A

 

QUESTION 1

Which of the following is NOT true about groups?

 

A.

Database-specific

B.

A user can only be a member of one user-defined group

C.

Cannot contain other groups

D.

Must be enabled once created

 

Answer: D

 

 

QUESTION 2

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

 

A.

Additional partitions must be added to the round-robin table

B.

Table must be unpartitioned before changing partition strategy

C.

Table data must be truncated

D.

Table indexes must be dropped

 

Answer: D

 

 

QUESTION 3

Which of the following are TRUE regarding partitions? (Choose two.)

 

A.

Tables may be partitioned logically as well as physically

B.

Global indexes may be created on each partition.

C.

Data in each partition may be processed differently.

D.

Global indexes can be clustered or nonclustered on range, hash, or list partitioned tables.

E.

Each partition must reside on its own segment.

 

Answer: AC

 

 

QUESTION 4

 

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

 

A.

0

B.

1

C.

Equal to the number of begin transaction statements executed

D.

Equal to the number of begin transaction statements minus 1

 

Answer: A

 

 

QUESTION 5

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

 

A.

scrollable

B.

forward_only

C.

backward_only

D.

non-scrollable

E.

insensitive

F.

semi-sensitive

 

Answer: ADEF

 

 

QUESTION 6

Which of the following is the default partitioning strategy?

 

A.

hash

B.

list

C.

range

D.

roundrobin

 

Answer: D

 

 

QUESTION 7

 

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

 

A.

Monitor and Data Analysis Tables

B.

Monitor Server

C.

Query Processing Metrics

D.

sp_sysmon

 

Answer: C

 

 

QUESTION 8

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

 

A.

table owner

B.

database owner

C.

logins with sa_role

D.

logins with sso_role

E.

logins with oper_role

 

Answer: DE

 

 

QUESTION 9

Which of the following are TRUE regarding creating, modifying or dropping buffer pools? (Choose two.)

 

A.

The sum of all the buffers in the pool must be less than or equal to the total memory size of cache

B.

New pools are created using memory from the largest pool unless otherwise specified

C.

The minimum pool size is determined by a configuration parameter

D.

The maximum I/O size for any cache is 8 pages

E.

As long as 1 pool remains in the cache, any pool can be removed

 

Answer: AD

 

 

QUESTION 10

 

Which of the following has permissions precedence?

 

A.

The permission granted most recently

B.

Group

C.

Role

D.

User

 

Answer: C

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 …