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 21-30

September 25, 2015

Ensurepass

 

QUESTION 21

 

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 create the device with a vdevno assigned by the server

C.

The command will fail without any adverse affects to the server

D.

The command will function properly because the server no longer uses ‘vdevno’

 

Answer: B

 

 

QUESTION 22

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

 

A.

If other tasks hold locks conflicting with the type of table lock needed, lock escalation occurs.

B.

If other tasks hold locks conflicting with the type of table lock needed, lock escalation does not occur.

C.

Page locks can be promoted to intent locks.

D.

Page locks can be promoted to table locks.

E.

Row locks can be promoted to page locks.

F.

Row locks can be promoted to table locks.

 

Answer: BDF

 

 

QUESTION 23

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: ABD

 

 

QUESTION 24

 

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

 

A.

32 bytes

B.

64 bytes

C.

128 bytes

D.

255 bytes

 

Answer: D

 

 

QUESTION 25

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

 

A.

performs a checkpoint

B.

backs up the transaction log

C.

truncates the transaction log

D.

may dump unallocated pages

E.

cannot be run while anyone is in the database

 

Answer: CE

 

 

QUESTION 26

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

 

A.

When you need to overwrite existing data

B.

When you do not want to overwrite existing data

C.

When you need to separate log and data on the same device

D.

When you need to invoke an abbreviated version of create database

 

Answer: C

 

 

QUESTION 27

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: BE

 

 

QUESTION 28

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

 

A.

write

B.

restore

C.

verify

D.

read

 

Answer: B

 

 

QUESTION 29

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

 

A.

The row is inserted into the first partition.

B.

The row is inserted into the last partition.

C.

The insert fails with an error message.

D.

The insert is discarded without an error message.

 

Answer: C

 

 

QUESTION 30

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

 

A.

Automatic database expansion is turned off by default.

 

 

 

 

B.

Database expansion thresholds are set per segment.

C.

Automatic database expansion is managed by the stored procedure sp_helpdb.

D.

Growby and maxsize policies can be set for database devices and database segments.

 

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 …