Advertisements	Sybase Certification Exams Interview Questions
COOLINTERVIEW.COM CERTIFICATION EXAMS INTERVIEW QUESTIONS SYBASE CERTIFICATION EXAMS INTERVIEW QUESTIONS QUESTIONS LISTING
	Sybase Certification Exams Interview Questions & Answers Below we have listed all the Sybase Certification Exams Interview Questions and answers. Feel free to comment on any Sybase Certification Exams Interview Questions or answer by the comment feature available on the page. To buy an eBook containing 30,000 Interview Questions, with Answers, Click Here. View All Sybase Certification Exams Interview Questions & Answers - Exam Mode / Learning Mode
Sybase Certification Exams Interview Questions & Answers
Sybase is a computer software company that develops and sells database management system (DBMS) and middleware products. The company was founded in 1984, and the headquarters offices are in Emeryville, CA. Sybase was the first enterprise DBMS for the Linux operating system. Sybase is an enterprise software and services company that produces software to manage and analyze information in relational databases. Sybase is a standalone subsidiary of SAP.

Subcategories for Sybase Certification Exams Interview Questions & Answers :-

Following are sub categories for which Interview Questions & Answers are available under Sybase Certification Exams Interview Questions & Answers. Please select the appropriate sub-category:-

Adaptive Server Administrator Associate Certification Exam Interview Questions & Answers (0) Exam Mode | Learning Mode

Adaptive Server Administrator Professional Certification Exam Interview Questions & Answers (0) Exam Mode | Learning Mode

Adaptive Server Enterprise SQL Developer Associate Certification Exam Interview Questions & Answers (0) Exam Mode | Learning Mode

Adaptive Server Enterprise SQL Developer Professional Certification Exam Interview Questions & Answers (0) Exam Mode | Learning Mode

PowerBuilder Developer Professional Certification Exam Interview Questions & Answers (0) Exam Mode | Learning Mode

PowerDesigner Data Modeling Professional Certification Exam Interview Questions & Answers (0) Exam Mode | Learning Mode

Replication Server Administrator Professional Certification Exam Interview Questions & Answers (0) Exam Mode | Learning Mode

SQL Anywhere Developer Professional Certification Exam Interview Questions & Answers (0) Exam Mode | Learning Mode

Sybase IQ Administrator Professional Certification Exam Interview Questions & Answers (0) Exam Mode | Learning Mode

Previous 1 2 3 4 5 6 7 8 Next

Sort By : Latest First | Oldest First | By Rating

	Question	Rating	View Answer
	All of the following execution class associations exist in the ASE when user FRED, running application ctisql, logs in. Which one will be applied to FREDs session? A. sp_bindexeclass ctisql, AP, NULL, EC1 B. sp_bindexeclass ctisql, AP, FRED, EC2 C. sp_bindexeclass FRED, LG, NULL, EC1 D. sp_bindexeclass FRED, LG, ctisql, EC2 E. It depends on the order of the creation of the bindings		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
	Transaction Isolation Level 2 is directly supported in the following lock scheme(s): A. Allpages B. Allpages, Datapages C. Allpages, Datapages, Datarows D. Datapages, Datarows		View Answer
	When an engine looks for a task to run, what is the order in which it searches the priority run queues? A. It is user defined B. high, medium and low C. low, medium and high D. longest queue to shortest queue		View Answer
	A decision support (DSS) application is communicating with the ASE server. The server configuration has been tuned to support the needs of the DSS application and the following configuration parameters have been set: default network packet size = 8192 maximum network packet size = 8192 additional network memory = 75776 The DSS application is connecting to the server using the value of "default network packet size" parameter as its requested packet size. A new online transaction processing (OLTP) application is added to the server. A typical insert or update statement from the OLTP application is less than 200 bytes. Without impacting the performance of the existing DSS application, which two changes should be made to improve the network performance of the OLTP application? (Choose 2.) A. Decrease the size of the "default network packet size" parameter to 512. B. Decrease the size of the "max network packet size" parameter to 4096. C. Increase the value of the "additional network memory" parameter to 151552 (or 2 * 75776). D. Modify the DSS client to connect to the server using the value of the "max network packet size" parameter as its requested packet size. E. Modify the DSS client to connect to the server using the value of the "additional network memory" parameter as its requested packet size.		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.		View Answer
	Given the following statement: create clustered index idx1 on titles(title_id) on new_segment Where: The titles table has 3 partitions The target segment new_segment spans 10 devices The max parallel degree parameter is 25 The session-level parallel_degree parameter is set to 2 How will the index be created? A. With a parallel sort with 2 producers and 1 consumer B. The statement will fail. C. With a serial sort. D. With a parallel sort with 2 producers and 2 consumers		View Answer
	Given: number of worker processes = 10, max parallel degree = 5, max scan parallel degree = 4. A table has 3 partitions. The first partition has 70 pages, the second partition has 70 pages the third partition has 10 pages. Which of the following statements are true about the table? (Choose 2) A. the partition skew is less than 2.0 B. the partition skew is greater than 2.0 C. queries against the table cannot be optimized for partition-based parallel access because max parallel degree is greater than the number of partitions D. queries against the table can be optimized for partition-based parallel access because the average number of pages per partition is greater than 20 E. queries against the table cannot be optimized for partition-based parallel access because each partition does not have at least 20 pages		View Answer
	What is the maximum row size for DOL tables? A. 1024 bytes of data. B. 1958 bytes of data. C. 1962 bytes of data. D. 2000 bytes of data.		View Answer
	Which two are advantages of use max_rows_per_page to reduce the row density? (Choose 2.) A. It may decrease the disk space used. B. It may decrease the contention. C. It may decrease the number of page splits. D. It may decrease the number of page I/Os. E. It may help to decrease row movement of frequently updated varchar columns.		View Answer
	What is the degree of parallelism used in a nested-loop join? A. the product of the worker processes that access individual tables in the join B. the sum of the worker processes that access individual tables in the join C. a nested-loop join is always performed using a serial scan D. two (1 coordinating process and 1 worker process)		View Answer
	How many predefined execution classes are there in ASE? A. 4 B. 3 C. 2 D. 1		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
	The titles table has 50,000 rows and a nonclustered index on the price column. Which of the following queries use less logical I/Os? A. select "Min" = min(price), "Max" = max(price) from titles B. select "Min" = (select min(price) from titles), "Max" = (select max(price) from titles) C. They will both use the same number of I/Os		View Answer
	Given: A table named books: title char(100), title_id char(15), type char(15), price money not null The books table has an index created as follows: create index price_index1 on books(price desc) Which of the following queries would be covered and not require access to the data pages? (Choose 5) A. select count(*) from books B. select sum(price) from books C. select type, sum(price) from books group by type D. select price from books E. select price from books order by price ASC F. select price from books order by price DESC		View Answer
	Which ASE commands or utilities can be used to examine partition skew? (Choose 2) A. sp_helpdb B. sp_helpartition C. sp_help D. optdiag E. reorg		View Answer
	A company needs to connect 5000 concurrent sessions to an Adaptive Server Enterprise server. The errorlog at startup of the ASE server shows the following: 00:00000:00000:1998/04/01 08:37:00.01 kernel Network and device connection limit is 1014. The DBA uses sp_configure to set "number of user connections" to 5000. What is the minimum number of engines, configured with sp_configure "max online engines", that must be used for this server to allow the 5000 connections to simultaneously occur? A. 1 engine B. 5 engines C. 6 engines D. 4 engines E. 10 engines		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
	An application uses stored procedures to perform updates, inserts and deletes for an OLTP application. Some update stored procedures optimize with a join order of table_A -> table_B. Other stored procedures optimize with a join order of table_B -> table_A. Which solution needs to be added within the stored procedures to guarantee that deadlocks are reduced or eliminated by always making the join order table_A -> table_B? A. Non-correlated subqueries to force outside-in processing B. SET FORCEPLAN ON C. (index tableorder 1) - an index hint applied to table_A D. SET SHOWPLAN ON E. Define join-ordered Views on the affected tables		View Answer
	A query and any views in a query can reference how many user tables? A. 12 B. 16 C. 32 D. 50 E. 192		View Answer

Previous 1 2 3 4 5 6 7 8 Next

SEARCH INTERVIEW QUESTIONS: