CertBus.com
510-022 Q&As Sybase adaptive server Enterprise administrator professsional Pass Sybase 510-022 Exam with 100% Guarantee Free Download Real Questions & Answers PDF and VCE file from: http://www.CertBus.com/510-022.html 100% Passing Guarantee 100% Money Back Assurance
Following Questions and Answers are all new published by Sybase Official Exam Center
Instant Download After Purchase 100% Money Back Guarantee 365 Days Free Update 80000+ Satisfied Customers
Vendor: Sybase
Exam Code: 510-022
Exam Name: Sybase adaptive server Enterprise administrator professsional
Version: Demo
100% Real Q&As | 100 Real Pass | CertBus.com Exam Name: Exam Type: Exam Code:
Sybase adaptive server enterprise administrator professional Sybase 510-022 Total Questions:
114
Question: 1 Which of the following pages is NOT found on an allocation unit? A. Data B. Index C. OAM D. GAM E. Control F. None of the above Answer: E Question: 2 The first page on a device fragment must? (Choose 2) A. Be listed in the lstart column of sysusages. B. Be listed in the low column of sysdevices. C. Be an OAM page. D. Be an allocation page. E. Have a logical page number that is a multiple of 1024. Answer: A, D Question: 3 How many allocation pages are created in a 4 MB database (assuming 4K page size)? A. 2 B. 4 C. 8 D. 16 Answer: B Question: 4 Consider the following page header: PAGE HEADER: pageno=720 nextpg=0 prevpg=0 objid=64000228 timestamp=0000 000022b5 nextrno=5 level=0 indid=0 freeoff=150 minlen=6 How many data rows are currently on this page? A. 0 B. 3 C. 4 D. 5 E. 6 F. Unknown Answer: F Question: 5 Which SQL statement finds the first page of sysgams" A. Select first from sysobjects where id = object_id("sysgams") Page 1 of 24
Contact Us: www.CertBus.com Get Success in Passing Your Certification Exam at first attempt
100% Real Q&As | 100 Real Pass | CertBus.com Exam Name: Exam Type: Exam Code:
Sybase adaptive server enterprise administrator professional Sybase 510-022 Total Questions:
114
B. Select first from sysindexes where id = object_id("sysgams") C. Select first from syscolumns where id = object_id("sysgams") D. Select first from sysgams Answer: B Question: 6 All of the following are causes of fragmentation in a table EXCEPT A. No clustered index B. Page splits C. Row LEVEL LOCKING D. Too many indexes Answer: D Question: 7 Given the following information from an allocation page, which of the following is NOT true? OAMPG:5121 Extent ID 5336 Object ID is 1264004503 Index ID is 2 Allocation bitmap: 0xff A. None of the pages of this extent are in use. B. The OAM page for this table is page 5121. C. This table has a nonclustered index. D. The first page of this extent is 5336. Answer: A Question: 8 How are OAM pages linked? A. Each OAM page is linked to its allocation page. B. Linear page chain for APL; not linked for DOL. C. No more than one OAM page per object, so no chain. D. OAM pages are circularly linked. Answer: D Question: 9 Which of the following is the minimum size for object allocation for ASE 12.5 with a logical page size of 16K? A. 16K B. 32K C. 64K D. 128K Answer: D Question: 10 How would you locate the first OAM page for a given table?
Page 2 of 24
Contact Us: www.CertBus.com Get Success in Passing Your Certification Exam at first attempt
100% Real Q&As | 100 Real Pass | CertBus.com Exam Name: Exam Type: Exam Code:
Sybase adaptive server enterprise administrator professional Sybase 510-022 Total Questions:
114
A. Has no fixed addresses B. Listed in sysindexes. C. Listed in sysobjects D. Listed in the GAM page Answer: B Question: 11 Which of the following dbcc commands can be run with a fix option? A. dbcc checkalloc. B. dbcc checkcatalog C. dbcc checkdb. D. dbcc checkstorage. E. dbcc checkverify. Answer: A Question: 12 What dboption must be true to fix allocation errors on a system table? A. dbo only B. No free space acctng. C. Select into/bulkcopy/pllsort D. Single user E. trunc log on chkpt Answer: D Question: 13 The dbcc checkverify command should be run ? A. Only once, to aid in configuring the dbccdb. B. Prior to creation of a new index, to ensure the table's page linkage is accurate. C. Prior to most dbcc commands, to ensure the database is in the proper state. D. Immediately following the dbcc checkstorage command. E. Immediately following any non-logged action. Answer: D Question: 14 When should dbcc reindex be used? A. After the sort order in ASE has been changed B. When a new language has been installed in ASE. C. When corruptions have been found in text/image page chains. D. When corruptions have been found in indexes on system tables. Answer: A Question: 15 For a database with its log on a separate device, which of the following dbcc commands show the percentage of free log space? (Choose 2) A. dbcc checkalloc Page 3 of 24
Contact Us: www.CertBus.com Get Success in Passing Your Certification Exam at first attempt
100% Real Q&As | 100 Real Pass | CertBus.com Exam Name: Exam Type: Exam Code:
Sybase adaptive server enterprise administrator professional Sybase 510-022 Total Questions:
114
B. dbcc checkcatalog C. dbcc checkdb D. dbcc checkstorage E. dbcc checktable Answer: B, D Question: 16 Which of the following attributes are NOT set using sp_dbcc_updateconfig? A. Maximum number of worker processes to use. B. Size of the named cache to use. C. Sizes of the of the workspaces to use. D. Size of the extent IO buffer pool to use. Answer: B Question: 17 Which of the following are true about the mount/unmount commands? A. Mount detaches the database and its devices from ASE. B. Only 1 database can be unmounted in a single unmount command. C. The master database cannot be unmounted. D. The mount/unmount commands require sybase_ts_role. Answer: C Question: 18 If a user-defined tempdb is unavailable at login the user will be placed in the system tempdb if ? A. The binding was created using the soft option. B. The binding was created using the hard option. C. User tempdb belongs to a group. D. The system tempdb is over 1 GB in size. Answer: A Question: 19 Which of the following statements about named caches are true in ASE? (Choose 4) A. Named caches can be created dynamically. B. Named caches can be dropped dynamically. C. Named caches can be made larger dynamically. D. Named caches can be made smaller dynamically. E. Named cache partitions can be changed dynamically. F. Named cache replacement policies can be changed dynamically. Answer: C, D, E, F Question: 20 Which of the following statements about the async log service async log service (DB option) Database optionsasync log service is true? A. async log service is a server-wide configuration parameter. B. async log service can be enabled only in an ASE server with at least 4 engines. Page 4 of 24
Contact Us: www.CertBus.com Get Success in Passing Your Certification Exam at first attempt
100% Real Q&As | 100 Real Pass | CertBus.com Exam Name: Exam Type: Exam Code:
Sybase adaptive server enterprise administrator professional Sybase 510-022 Total Questions:
114
C. async log service is designed to improve ASE performance by performing transaction log I/O using the largest available buffer pool. D. When enable, the async log service functionality is perfomed by additional, dedicated ASE system processes. Answer: B, D Question: 21 Which of the following are true of multiple temporary databases (tempdbs)? (Choose 2) A. Only the system tempdb is overwritten with the model database when ASE boots. B. All temporary databases must reside on the master device. C. The selection of a temporary database may be dynamically change during a session. D. A temporary database chosen for a session remains in effect for the duration of that session. E. Users bound to the default group will be assigned to a temporary database using a round-robin selection policy. Answer: B, D Question: 22 Specifying a sample size for your statistics applies to: A. Create index B. sp_flushstats C. Update statistics D. Update index statistics Answer: D Question: 23 Automatic recovery starts processing each transaction log from the ? A. Most recent checkpoint B. Most recent dump transaction C. Oldest committed transaction D. Oldest committed transaction Answer: A Question: 24 Which of the following is NOT an ASE step in the dump transaction process? A. Determine truncation point and end of inactive portion. B. Write out to dump device from first page of log to dump point in accordance with dump tran options. C. Update sysindexes.first with the new first page for syslogs. D. Udate master.. sysdatabases. logptr with the new first page of the log. E. Deallocates and truncates the inactive portion of the page where the truncation point resides. Answer: E Question: 25 Which of the following commands will not perform a checkpoint on the database? A. dump database Page 5 of 24
Contact Us: www.CertBus.com Get Success in Passing Your Certification Exam at first attempt
100% Real Q&As | 100 Real Pass | CertBus.com Exam Name: Exam Type: Exam Code:
Sybase adaptive server enterprise administrator professional Sybase 510-022 Total Questions:
114
B. dump tran C. dump tran...with no_truncate D. dump tran... with truncate_only Answer: C Question: 26 The Undo pass recovery phase scans A. From the beginning of the log to the oldest active transaction's row id. B. From the checkpoint record to the end of the log. C. From the checkpoint record's row id for the oldest active transaction to the end of the log. D. From the secondary truncation point row id to the end of the log. E. From the end of the log to the oldest incomplete transaction's row id. Answer: E Question: 27 What functionality does Recovery Fault Isolation (RFI) provide? (Choose 2) A. List databases with suspect pages. B. Recover a suspect database C. Restore a database without dropping D. Bring suspected pages online for all users after they have been repaired. Answer: A, D Question: 28 What happens to the data and timestamp on a page when a data change is rolled back? A. Undo data and timestamp changes. B. Log CLR, undo data and timestamp chanes. C. Log CLR, undo data change and put a new timestamp on page. D. Log CLR, undo data change and keep previous timestamp. Answer: C Question: 29 Which stored prcedure will set Recovery Fault Isolation for a database? A. sp_suspect_threshold B. sp_suspect_db C. sp_dboption D. sp_suspect_granularity E. sp_forceonline_db Answer: D Question: 30 Which of the following statements about ASE recovery are true? (Choose 3) A. Recovery is run when ASE is booted B. Recovery writes dirty data pages to disk. C. Recovery is run when a checkpoint occurs. D. Recovery reconciles data page with log pages. Page 6 of 24
Contact Us: www.CertBus.com Get Success in Passing Your Certification Exam at first attempt
100% Real Q&As | 100 Real Pass | CertBus.com Exam Name: Exam Type: Exam Code:
Sybase adaptive server enterprise administrator professional Sybase 510-022 Total Questions:
114
E. Recovery is run as part of the ump database command. Answer: A, D Question: 31 Which command can be used to extend the master device? A. Disk init B. Disk reint C. Disk refit D. Disk resize Answer: D Question: 32 Compensation Log Records are written to the transaction log when A. A transaction needs to be undone. B. A transaction needs to be redone. C. A checkpoint is performed. D. A dump transaction is performed. E. A commit is performed. Answer: A Question: 33 What does an index id of 128 mean? A. A clustered index and its table B. A heap table C. A nonclustered index. D. A text or image column. Answer: C Question: 34 What is the purpose of the row offset table in a DOL index page? A. Locate index entries in key order. B. Locate index entries in row-length order. C. Locate index entries. grouped by degree of suffix compression D. Locate start of multiple rows stored for a repeated key. Answer: A Question: 35 If there are 8 duplicate key values referenced by a single APL index page, how many times is that key stored on that index page? A. 1 B. 2 C. 4 D. 7 E. 8
Page 7 of 24
Contact Us: www.CertBus.com Get Success in Passing Your Certification Exam at first attempt
100% Real Q&As | 100 Real Pass | CertBus.com Exam Name: Exam Type: Exam Code:
Sybase adaptive server enterprise administrator professional Sybase 510-022 Total Questions:
114
Answer: E Question: 36 A particular nonclustered index consists of one index root page, two intermediate index levels and the index leaf leve. What is the value of the index level for a leaf page? A. -1 B. 0 C. 3 D. 4 E. Either 1,2 or 3, depending on whether an intermediate index level has just been added to the index. Answer: B Question: 37 The sp_fixindex stored procedure? (Choose 2) A. Requires the database be in single-user mode to run. B. Replaces the dbcc indexalloc command for indexes on user tables. C. Replaces the eorg rebuild command for indexes on user tables. D. Rebuild of an index on a system table. E. Adds and detetes entries directly to/from an index's B-tree. Answer: A, D Question: 38 What is the most likely response to a corrupt user index? A. dbcc checkalloc. B. dbcc checkstorage C. drop index. D. sp_fixindex Answer: C Question: 39 Which of the following commands will not delete statics? A. Delete statistics B. Alter table drop column. C. Drop table. D. Drop index. E. Alter table modify column. Answer: D Question: 40 Which of the following commands can be used to find out when update statistics was last executed? (Choose 2) A. Optdiag B. Update statistics C. Delete statistics D. Select * from systatistics Page 8 of 24
Contact Us: www.CertBus.com Get Success in Passing Your Certification Exam at first attempt
100% Real Q&As | 100 Real Pass | CertBus.com Exam Name: Exam Type: Exam Code:
Sybase adaptive server enterprise administrator professional Sybase 510-022 Total Questions:
114
E. Select * from systabstats Answer: A, D Question: 41 Which of the following statements are true about this extract from a histogram? 5 0.00526000 6 0.00526000 7 0.00179000 8 0.12260000 9 0.00526000 10 0.00526000
<= <= < = <= <=
"T20051" "T23041" "T27400" "T27400" "T29382" "T31228"
A. Step 8 is a frequency count cell. B. Step 10 describes the percentage of nulls in the column. C. This column has a unique index on it. D. Values greater than T23041 and less than T27400 make up 12.26% of the table. E. Values greater than T27400 and less than T31228 make up 1.052% of the table. Answer: A, E Question: 42 Which of the following statements about optimizer statistics are TRUE? (Choose 3) A. It is possible to build statistics on unindexed columns. B. It is possible to build statistics on text/image columns. C. Dropping a table drops statistics for the column(s) used. D. Dropping an index drops statistics for the column(s) used. E. By default, histogram statistics are built only for leading columns of indexes. Answer: A, B, D Question: 43 The optdiag utility can NOT be used to A. Alter index statistics B. Display table statistics C. Flush table/index statistics. D. Simulate histogram statistics. Answer: D Question: 44 Which of the following factors affect whether ASE will use large i/o when reading a table? (Choose 3) A. How well the pages of the tables fill its extents. B. Whether ASE has been built with a page size greater than 2kb C. The current data cache hit rate in the cache to which the table is bound. D. How well the logical clustering of the table matches its physical clustering. E. At least one large I/O pool is configured in the cache to which the table is bound. F. At least two large I/O pools are configured in the cache to which the table is bound. Answer: A, D, E Page 9 of 24
Contact Us: www.CertBus.com Get Success in Passing Your Certification Exam at first attempt
100% Real Q&As | 100 Real Pass | CertBus.com Exam Name: Exam Type: Exam Code:
Sybase adaptive server enterprise administrator professional Sybase 510-022 Total Questions:
114
Question: 45 Byte #32 on the first GAM page stores the value '0xc4'. Which of the following statements are true? (Choose 3) A. 3 allocation units have at least one unused extent B. 5 allocation units have at least one unused extent. C. Allocation page 0 reports at least one unused extent. D. Allocation page 256 reports at least one unused extent. E. Allocation page 512 reports at least one unused extent. Answer: A, D Question: 46 When setting the value for the configuration option "number of open objects", you must consider which object types? (Choose 3) A. User tables B. Cursors C. Views D. Temporary tables E. Derived tables Answer: B, C, E Question: 47 Consider a named data cache with two buffer pools of sizes 2MB and 8MB each on a server using 4K page size. How many cache partitions are possible for this cache? A. 2 B. 4 C. 8 D. Cannot partition Answer: A Question: 48 Which of the following would generally be true for a cache to benefit from Relaxed LRU? (Choose 2) A. Cache has a very high hit rate. B. Cache has many objects bound to it. C. Cache is defined as 'logonly' D. Server has 1 or 2 CPUs. Answer: A, C Question: 49 When performance suffers due to spinlock contention on a named cache, the SA can A. Create a large I/O pool. B. Partition the cache. C. Use MRU replacement. D. Expand metadata caches.
Page 10 of 24
Contact Us: www.CertBus.com Get Success in Passing Your Certification Exam at first attempt
Why Select/Choose CertBus.com? Millions of interested professionals can touch the destination of success in exams by certbus.com. products which would be available, affordable, updated and of really best quality to overcome the difficulties of any course outlines. Questions and Answers material is updated in highly outclass manner on regular basis and material is released periodically and is available in testing centers with whom we are maintaining our relationship to get latest material. • 7000+ Real Questions and Answers • 6000+ Free demo downloads available • 50+ Preparation Labs • 20+ Representatives Providing 24/7 Support
To Read the Whole Q&As, please purchase the Complete Version from Our website.
Trying our product ! ★ 100% Guaranteed Success ★ 100% Money Back Guarantee ★ 365 Days Free Update ★ Instant Download After Purchase ★ 24x7 Customer Support ★ Average 99.9% Success Rate ★ More than 69,000 Satisfied Customers Worldwide ★ Multi-Platform capabilities - Windows, Mac, Android, iPhone, iPod, iPad, Kindle
Need Help Please provide as much detail as possible so we can best assist you. To update a previously submitted ticket:
Guarantee & Policy | Privacy & Policy | Terms & Conditions Any charges made through this site will appear as Global Simulators Limited. All trademarks are the property of their respective owners. Copyright © 2004-2015, All Rights Reserved.
