Free 510-020 Exam braindumps download (510-020 exam dumps Free)

QUESTION: 21

When you create a database how many segments are created?

Answer(s): D

Show Answer Next Question

QUESTION: 22

Which of the following is/are true about an ASE database?

It can never be expanded; it must be dropped and recreated larger
It can be expanded, but the data must be copied out first
Only the log portion of the database can be expanded
Only the data portion can be expanded
Data and log portions can be expanded

Answer(s): E

Show Answer Next Question

QUESTION: 23

ASE provides resource limits to help system administrators prevent queries and transactions from monopolizing server resources.
Which three scenarios can this feature prevent? (Choose three.)

An individual login or application exceeding estimated or actual I/O costs
A query returning a high number of rows
A query/transaction exceeding a given elapsed time
A query performing more than 6 table joins
A stored procedure inserting a high number of rows into a temporary table

Answer(s): A,B,C

Show Answer Next Question

QUESTION: 24

Which of the following statements are true of table statistics? (Choose 2)

Creating statistics on unindexed columns can improve the performance of some queries.
Truncating a table deletes the column-level statistics in sysstatistics.
Dropping an index will drop statistics on its column(s).
Histograms are kept on a per-column basis.

Answer(s): A,D

Show Answer Next Question