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.
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.
Which ASE features can be used to determine the temporary database assigned to a session other than your own ? (Choose 2 )
A. The global variable @@tempdbid
B. The built-in function tempdb_ id()
C. The command bcc pravailabletempdb
D. sp_tempdb,with the how ?subcommand
E. sp_tempdb, with the who ?subcommand
F. sp_helpdb
A checkpoint command writes_______to disk
A. Just log pages
B. Only committed changes
C. Committed and uncommitted changes
D. Only pages that passed the wash marker
The DBTABLE structure?(Choose 3)
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.
When setting up dbcc checkstorage,you must
A. Turn on parallelism
B. Decrease the number of locks
C. Increase the transaction log for the target database
D. Set the database in dbo use only
On an 8K page size server,what is the minimum size of a data cache with an 8K i/o buffer and a 64 i/o buffer pool?
A. 4.5M
B. 5M
C. 8M
D. 9M
E. 36M
For a 100 MB database in a 8K page server, which of the following is true?
A. There is 1 allocation page
B. There are 50 allocation pages
C. There are 200 allocation pages
D. There are 200 extents
Which statement about allocation pages is FALSE ?
A. Allocation pages help identify free extents within each allocation unit
B. The first logical page of a database is always an allocation page
C. There is one allocation page for every 8 pages within a database
D. There is one allocation page for every 256 pages within a database
Which of the following is FALSE about the date and time datatypes ?
A. A date column cannot allow nulls
B. The earliest supported date is Jan 1, 0001
C. The date datatype is implicitly convertible to the datetime datatype
D. Time is now an ASE keyword