|
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. Your company's network just finished going through a SAS 70 audit. This audit reported that overall, your network is secure, but there are some areas that needs improvement. The major area was SNMP security. The audit company recommended turning off SNMP, but that is not an option since you have so many remote nodes to keep track of. What step could you take to help secure SNMP on your network? A. Change the default community string names B. Block all internal MAC address from using SNMP C. Block access to UDP port 171 D. Block access to TCP port 171 Answer: A Question 2. At what layer of the OSI model do routers function on? A. 3 B. 4 C. 5 D. 1 Answer: A Question 3. An "idle" system is also referred to as what? A. Zombie B. PC not being used C. Bot D. PC not connected to the Internet Answer: A Question 4. What operating system would respond to the following command? A. Mac OS X B. Windows XP C. Windows 95 D. FreeBSD Answer: D Question 5. Why are Linux/Unix based computers better to use than Windows computers for idle scanning? A. Windows computers will not respond to idle scans B. Linux/Unix computers are constantly talking C. Linux/Unix computers are easier to compromise D. Windows computers are constantly talking Answer: D Question 6. How many bits is Source Port Number in TCP Header packet? A. 48 B. 32 C. 64 D. 16 Answer: D Question 7. Why are Linux/Unix based computers better to use than Windows computers for idle scanning? A. Windows computers are constantly talking B. Linux/Unix computers are constantly talking C. Linux/Unix computers are easier to compromise D. Windows computers will not respond to idle scans Answer: A Question 8. Simon is a former employee of Trinitron XML Inc. He feels he was wrongly terminated and wants to hack into his former company's network. Since Simon remembers some of the server names, he attempts to run the axfr and ixfr commands using DIG. What is Simon trying to accomplish here? A. Enumerate all the users in the domain B. Perform DNS poisoning C. Send DOS commands to crash the DNS servers D. Perform a zone transfer Answer: D Question 9. You are carrying out the last round of testing for your new website before it goes live. The website has many dynamic pages and connects to a SQL backend that accesses your product inventory in a database. You come across a web security site that recommends inputting the following code into a search field on web pages to check for vulnerabilities: When you type this and click on search, you receive a pop-up window that says: "This is a test." What is the result of this test? A. Your website is vulnerable to web bugs B. Your website is vulnerable to CSS C. Your website is not vulnerable D. Your website is vulnerable to SQL injection Answer: B Question 10. After attending a CEH security seminar, you make a list of changes you would like to perform on your network to increase its security. One of the first things you change is to switch the RestrictAnonymous setting from 0 to 1 on your servers. This, as you were told, would prevent anonymous users from establishing a null session on the server. Using Userinfo tool mentioned at the seminar, you succeed in establishing a null session with one of the servers. Why is that? A. RestrictAnonymous must be set to "2" for complete security B. RestrictAnonymous must be set to "3" for complete security C. There is no way to always prevent an anonymous null session from establishing D. RestrictAnonymous must be set to "10" for complete security Answer: A
Copyright © 2004 CertsBraindumps.com Inc. All rights reserved.