The "abstract plan language" is: A. A language used to tell the optimizer how to process a query. - A. A language used to tell the optimizer how to process a query. - Sybase Certification Exams Interview Questions and Answers

CoolInterview.com - World's Largest Collection of Interview Questions & Answers, FAQs, queries, sample papers, exam papers, dumps, what, why, how, where, when questions

OneStopTesting.com - Testing EBooks, Tutorials, Articles, Jobs, Training Institutes etc.
OneStopGate.com - Gate EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopMBA.com - MBA EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopIAS.com - IAS EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopSAP.com - SAP EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopGRE.com - of GRE EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.

Sponsored Links

Interview Questions

INTERVIEW QUESTIONS

CERTIFICATION EXAMS

SYBASE CERTIFICATION EXAMS

DETAILS

Question: The "abstract plan language" is:
A. A language used to tell the optimizer how to process a query.
B. The internal command language used by sp_sysmon.
C. A new type of command language for creating very complicated queries.
D. The language used internally by the server for planning the most efficient use of memory.

Answer: A. A language used to tell the optimizer how to process a query.

Category	Sybase Certification Exams Interview Questions & Answers - Exam Mode / Learning Mode
Rating	(0.3) By 7429 users
Added on	7/29/2015
Views	67591
Rate it!

Question: The "abstract plan language" is:
A. A language used to tell the optimizer how to process a query.
B. The internal command language used by sp_sysmon.
C. A new type of command language for creating very complicated queries.
D. The language used internally by the server for planning the most efficient use of memory.

Answer:

A. A language used to tell the optimizer how to process a query. Source: CoolInterview.com

If you have the better answer, then send it to us. We will display your answer after the approval.

Rules to Post Answers in CoolInterview.com:-

There should not be any Spelling Mistakes.

There should not be any Gramatical Errors.

Answers must not contain any bad words.

Answers should not be the repeat of same answer, already approved.

Answer should be complete in itself.

	Related Questions	View Answer
	The best way to keep a clustered APL table compact when inserting data that is naturally ordered in the same sequence as the index key is to: A. enable MRU buffer replacement on the table B. reduce the identity_gap of the table C. force use of a "safe" nonclustered index D. increase the reservedpagegap for the table E. enable ascinserts on the table	View Answer
	Spinlock contention is high in a named cache. A small database is bound to the named cache. This database fits into the named cache entirely. Cache misses do not occur within this named cache. This named cache is 20 MB in size and uses the strict-policy of buffer replacement. Which two will lower spinlock contention for the named cache? (Choose 2.) A. Set the buffer replacement policy for the specific named cache to "relaxed". B. Increase the number of online engines for this Adaptive Server Enterprise. Larger numbers of engines can spread spinlock contention out across more engines. C. Use the Adaptive Server Enterprise parallel features to process the queries in parallel for this database and lower spinlock contention on the serial process. D. Create a second named cache and bind some objects from the database to a second named cache.	View Answer
	Given FREDs login is assigned EC2. When he uses a stored procedure bound to EC3 his scheduling priority is: A. high B. medium C. low D. unable to be determined	View Answer
	When a row is deleted on a table with datarows locking: A. Rows on the page are moved up so the empty space is at the end of the page. B. The space occupied by the deleted row is not reclaimed immediately. C. The space occupied by the deleted row is filled with zeros. D. The last row on the page is moved into the space created by the deleted row.	View Answer
	Where can the last page of a partition be found for an APL table? A. sysindexes B. root page C. OAM page D. allocation page E. control page	View Answer
	What is the maximum number of tables allowed in a join query? A. 50 User tables and 14 work tables B. 32 User tables and 14 work tables C. 30 User tables and 12 work tables D. 16 User tables and 12 work tables	View Answer
	Which statement is not true about cache partitioning? A. Default data cache can be partitioned B. A named cache with a 16K buffer pool can be partitioned C. Cache partitioning requires a server reboot D. A 2MB named cache can be divided into 8 cache partitions E. Named caches using the relaxed LRU cache replacement strategy can be partitioned	View Answer
	Which of the following operations require "quiesce database"? A. altering the database to a new size B. performing non-Sybase unmirroring and backup operations. C. truncating the transaction log D. dumping the database using Sybase Backup Server.	A. altering the database to a new s - Sybase Certification Exams Interview Questions & Answers"> View Answer
	What is the most important criterion when ASE chooses a parallel query plan? A. total amount of work done B. number of locks C. response time D. number of logical I/Os performed	View Answer
	What type of access method is used when you delete from a partitioned table with a useful clustered index? A. hash based table scan B. partitioned index scan C. serial index scan D. serial table scan	View Answer
	Which are the two ways for boosting the performance of parallel sort during index creation? (Choose 2.) A. "trunc log on chkpt" database option set to true in the target database B. configuring a pool of 16K buffers in the cache used by the sort C. create index...with consumers = N (when index is written to a segment on a RAID device) D. set scan_parallel_degree N (where N = number of target partitions) E. keep tempdb on one contiguous device	View Answer
	Under what conditions can a clustered index be created using the with sorted_data option? (Choose 3) A. when dropping and recreating the clustered index on a table that uses the Allpages locking scheme B. when dropping and recreating the clustered index on a table with a clustered index cluster ratio below 1 C. after using bcp to load data into an unpartitioned empty Allpages table that has no indexes, if the data is already sorted in order of the key D. after using bcp to load data into an unpartitioned empty Data-only locking scheme table that has no indexes, if the data is already sorted in order of the key E. after creating a nonclustered index on the same key that the clustered index will be created on	View Answer
	What type of access method can be used for an unpartitioned APL table with a useful clustered index? A. hash based table scan B. serial table scan C. serial index scan D. clustered index partition scan	View Answer
	When configuring the "additional network memory" parameter, the number of buffers required per connection must be taken into consideration. How many buffers does each connection require? A. 1 B. 2 C. 3 D. 4 E. 5	number of buffers required per co - Sybase Certification Exams Interview Questions & Answers"> View Answer
	What are some ways to reduce last data page lock contention for inserts? (Choose 3) A. alter the table to use the Datarows locking scheme B. alter the table to use the Datapages locking scheme C. partition the table D. create a clustered index on a random key E. increase the server configuration for the number of locks F. increase the server configuration for the deadlock checking period	View Answer
	Assuming that all other user tasks are running with the default execution class, assigning execution class EC3 to a long-running CPU intensive application will have which of the following effects: A. improve the responsiveness of the long-running task, possibly shortening its elapsed time. B. cause the long running task to consume all available CPU time, starving other tasks C. increase the rate at which deadlocks occur. D. substantially decrease the frequency of scheduling the long running task, slowing it down. E. increase the amount of unspent idle time available for future demand.	View Answer
	Where are table/index level statistics stored? A. sysstatistics B. systabstats C. On the leaf level of the index D. The GAM page E. The distribution page	View Answer
	Which of the following statements are true of table statistics: (Choose 2) A. Creating statistics on unindexed columns can improve the performance of some queries. B. Truncating a table deletes the column-level statistics in sysstatistics. C. Dropping an index will drop statistics on its column(s). D. Histograms are kept on a per-column basis	View Answer
	Which of the following statements describes readpast locking? (Choose 2) A. It can be specified at the session, transaction, and table level. B. It allows insert, update, and delete commands to read past any incompatible lock. C. It allows readers to not block writers. D. It allows select and readtext queries to silently skip all rows or pages locked with incompatible locks.	View Answer
	How does the optimizer choose the optimal degree of parallelism for partition based scans? A. It will use the maximum number of available worker processes B. It will use the maximum allowed worker processes based on "max parallel degree" C. It will use the maximum allowed worker processes based on "max scan parallel degree" D. It will use at most one worker process for every partition in the table. E. It will use no more than 3 worker processes.	View Answer

Please Note: We keep on updating better answers to this site. In case you are looking for Jobs, Pls Click Here Vyoms.com - Best Freshers & Experienced Jobs Website.

View All Sybase Certification Exams Interview Questions & Answers - Exam Mode / Learning Mode