⟩ Explain IF you are remotely logged on to a Solaris machine, What command would you execute?
mt f /dev/rmt/0 status
mt f /dev/rmt/0 status
Suppose Given FREDs login is assigned EC2. When he uses a stored procedurebound to EC3 his scheduling priority isA. highB. mediumC. lowD. unable to be determined
Explain When you run optdiag command on a allpages-locked table with 1000pages, what will be value of "Forwarded row count"?A. 1000B. 500C. 0D. 1
Parallel sorting can be used for (Choose 3)A. Sort Merge joinsB. slow bcpC. ReformattingD. Creating indexesE. reorg compact
Do you know What is the maximum number of key columns allowed in an index?A.16B. 31C. 32D. 63
Do you know The reorg command may be used to (Choose 2)A. Compact a table that uses datarows locking.B. Reclaim unused space in a table that uses allpages locking.C. Reclaim unused space in an index that uses datapages locking.D. Rebuild a table that uses allpages locking.
Explain When does the optimizer consider a hash based table scan on an APL table?A. if it is a heap tableB. if it is has a clustered indexC. If it is a table with a clustered index and a non clustered indexD. If it is a partitioned table with a clustered index
Explain Which of the following are true of the Datarows Locking Scheme? (Choose2)A. Index pages are locked.B. No transaction locks are held on index pages.C. Server uses page locks and row locks, but not table locks.D. Server uses table locks and row locks, but not page locks.
Explain Which of the following steps is NOT always necessary for performing atuning benchmark?A. record a baseline measurementB. change one variable, holding all others constantC. make a new measurementD. restart Adaptive Server
Which of the following operations require "quiesce database"?A. altering the database to a new sizeB. performing non-Sybase unmirroring and backup operations.C. truncating the transaction logD. dumping the database using Sybase Backup Server.
Which of the following can NOT have an assigned execution classA. databaseB. A stored procedureC. An applicationD. A login