|
Question 1.
Overflow pages are used to manage duplicate entries in
A. APL clustered indexes
B. APL non clustered indexes
C. DOL clustered indexes
D. DOL non clustered indexes
Answer: A
Question 2.
Which of the following are true of a DOL Placement Index? (Choose two)
A. Structurally the same as a clustered index
B. Force new rows to be inserted in key order
C. Similar in structure to a non-clustered index
D. Does not force inserts to be in key order
Answer: C, D
Question 3.
What is the minimum number of pages in a DOL index?
A. 0
B. 1
C. 2
D. 4
Answer: C
Question 4.
Automatic recovery uses ________ when comparing the log records to the database
A. Procedure cache
B. Default data cache
C. The named cache assigned to the database
D. The named cache assigned to the transaction log
Answer: B
Question 5.
In a parallel sort, consumer processes do all of the following EXCEPT:
A. Perform the sort
B. Write the index to the target segment
C. Read data from the source table
D. Require a minimum of 2 processes
Answer: C
Question 6.
Which of the following statements about the ASE transaction log are TRUE? (Choose three)
A. The transaction log can be truncated up to the oldest checkpoint
B. Consecutive dumps of the transaction log must overlap log pages
C. The size of a transaction log dump is proportional to the amount truncated
D. The transaction log can be truncated up to the oldest committed transaction
E. A database can be brought online for read only access after loading a transaction dump,
without preventing further loads
Answer: C, D
Question 7.
Given the following data from syslogs, how many user transaction are present?
Xactid op
---------- ---
0xa91400000400 0
0xa91400000400 4
0xa91400000400 30
0xa91400000700 0
0xa91400000700 5
0xa91400000700 30
0xa91400000b00 0
0xa91400000b00 9
0xa91400000b00 9
0xa91400001000 17
0xa91400000b00 30
A. 1
B. 2
C. 3
D. 4
E. 5
Answer: C
Question 8.
The DBTABLE structure?(Choose three)
A. Is persistent across ASE reboots
B. Is stored in memory
C. Is stored on disk in page 24 of every database
D. Is flushed to disk during checkpoints
E. Contains the highest timestamp for a database
Answer: B, C, D
Question 9.
What is the function of the Allocation Pages? (choose 2)
A. Keeps track of the allocation units in which there are extents for a given database object.
B. Keeps track of which extents in an allocation unit assigned by objects
C. Keep track of which allocation units in a database have extents available
D. Keeps track of the OAM pages for each object.
Answer: B, D
Question 10.
Which SQL statement finds the first page of sysgams:
A. select first from sysobjects where id = object_id("sysgams")
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 11.
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 12.
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 13.
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 14.
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 15.
How would you locate the first OAM page for a given table?
A. has no fixed addresses
B. listed in sysindexes
C. listed in sysobjects
D. listed in the GAM page
Answer: B
Question 16.
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 17.
What dboption must be trunk 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 18.
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 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 aommand
E. Immediately following any non-logged action.
Answer: D
Question 19.
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 20.
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
B. dbcc checkcatalog.
C. Dbcc checkdb
D. Dbcc checkstorage
E. Dbcc checktable
Answer: B, D
|
Question 1. Which processors use hyperthreading? (Select two.) A. Intel single core processors B. AMD dual core processors C. AMD quad core processors D. Inteldual core processors Answer: A, D Question 2. How many memory channels are there in a 2 processor DDR3-based server? A. 2 channels B. 3channels C. 4channels D. 6 channels Answer: D Question 3. On Intel Xeon 5500 Series (Nehalem) based servers, where is the memory controller located? A. processor socket B. processor core C. HyperTransport Bus D. Front Side Bus Answer: B Question 4. Which components are under the control of Dynamic Power Management on Intel Xeon 5500 Series (Nehalem) based servers? (Select two.) A. chipset B. PCI-e cards C. hard drives D. CPU E. fans Answer: A, D Question 5. A server has four disks, each 146GB in size. They are configured as RAID 5. What is the logical drive size presented to the operating system? A. 292GB B. 438GB C. 584GB D. 730GB Answer: B Question 6. Which operating system has support for the ZFS filesystem? A. Sun Solaris B. Windows Server 2008 R2x64 Enterprise Edition C. Novell NetWare 6.5 D. Novell SLES 10 Answer: A Question 7. Which type of internal slot has been added to HP ProLiant G6-based servers for use by hypervisors? A. Extreme Digital (xD) B. Secure Digital (SD) C. Compact Flash (CF) D. PCI-express (PCIe) Answer: B Question 8. For the Intel x5570Series processors in the HP ProLiant SL2x170z G6, what does the letter "x" preceding the processor model number indicate? A. extreme performance B. lowerwattage C. turbo boost performance D. highperformance/wattage Answer: D Question 9. In which log are Array POST errors recorded? A. Windows Event Log B. Integrated Management Log C. IPMI Log D. Onboard Administrator Log Answer: B Question 10. What information does the ADU provide? (Select three.) A. firmwareversion B. OEM hard drive vendor C. RAID stripe size D. HardwareErrorLogs E. SmartArray driver version Answer: A, C, D
Copyright © 2004 CertsBraindumps.com Inc. All rights reserved.