Sybase Adaptive Server Enterprise (ASE)
From Sybase Wiki
- How to include environment variables in LINUX/UNIX shell?
- What are new features in SYBASE ASE 15.7 from 12.5?
- What are new utilities in SYBASE ASE 15.7 from earlier version?
- Which are important sybase environment variables?
- What are valid logical page size of SYBASE ASE Server?
- How can we start the sybase server?
- How can we shutdown the Sybase ASE server?
- How can we shutdown the Sybase Backup server?
- How to log in Sybase ASE server ?
- What are system required databases for Sybase ASE 12.X & 15.x?
- How to check the Sybase Server Name
- Top ten table usage wise in a database?
- Nice difference between Sybase and Oracle - Sybase outperforms Oracle.
- How to check the Version of Sybase Server Running?
- New Features in Sybase ASE 15.x ?
- How can you trace your path of error log,SYBASE ASE Server name,Back up Server name etc?
- How to start adaptive server in single-user mode?
- Step by Step instruction to learn SYBASE ASE ?
- How to install SYBASE ASE in console mode ?
- How to install and built SYBASE ASE server in UBUNTU Linux ?
- How to built SYBASE ASE server from resource file?
- How to built SYBASE backup server from resource file?
- Which default processes are running after building new ASE server ?
- How to rename SYBASE ASE and BACKUP SERVER ?
- What are new/changed configuration parameters from previous version in SYBASE ASE 15.7 ?
- What are static and dynamic parameters and what is diffenence between syscurconfigs and sysconfigures?
- Configuring Auditing in the Sybase ASE?
- Configuring the DBCC DB in Sybase ASE?
- How can we configure java in ASE later ASEv15.0.3 ?
- How can we perform upgrade from 12.5 to 15.x (Major Upgrade)?
- How can we perform upgrade from 15.5 to 15.7 (Minor Upgrade)?
- How can we enable remote ASE server access?
- Which are most frequently used configuration parameter ?
- What is interface file and how can it interpret?
- How can we perform the ESD upgrade for a Sybase ASE Server?
Devices & Database
- How to initialize database device ?
- What is segment and how to create segment?
- How to create database ?
- How to create in-memory database (IMDB) ?
- Which System table is updated, whenever a new database is created ?
- What is dsync and its imporatace ?
- What is directio and its imporatance ?
- How to drop devices ?
- What is default device and how to make new default device ?
- Global and Local Indexes ?
- How can increase size of device ?
- What is database options ?
- Which system tables are most critical system tables in master database?
Login/User Management (DB Security)
- What are ,by default, assign role for '''sa''' login,after building server ?
- What are system defined roles and what are their privilege?
- What is the role required for user management?
- How can we add login in the server and user in a database?
- Whats the diff between role and group and which one is better?
- How to lock login?
- What is sybase security model for any user/login?
- What is guest user in database and why we require guest user?
- Explain syslogins syssrvroles, sysloginroles and sysroles and whts the linkup among all?
- Diffrence between 12.5 syslogins and 15.7 syslogins?
- Can we change the password of other login, if yes, how?
- What is the diffrence between syslogins and sysusers?
- Why do we require aliases?
- Query - Find out currently log-in user in server?
- Query - Find out no. of session per user?
- Query - Find out session host detail?
- Query - Find out no. of active user per connection?
Backup & Recovery (DB Dump & Load)
- How to add dump device for any database ?
- How to take dump of any database ?
- How to take stripped back up in SYBASE ASE?
- How to take stripped compresed back up in SYBASE ASE?
- If tempdb is getting fill?
- If tempdb is completley filled up?
- Refreshing the UAT data server?
- How to generate definition of a table with ddlgen ?
- How to perform bcp out ?
- How to perform bcp in?
- Tables which we need to take bcp out on daily basis
- What is the difference between sysstats and systabstats table?
- How to view and update statistics of a table ?
Engines and MultiProcessing
Sort Order/Char sets/ Langauges
Monitoring and Diagnostic (MDA)tables
- What are MDA Tables?
- How many new MDA tables are added from previous version to SYBASE ASE 15.7?
- Which role/configuration param is required to assign/enable for executing MDA table ?
- List of configuration parameters which affects output of MDA table ?
- List of MDA tables and its description?
- List of MDA tables and its column description?
- How can we use MDA Tables?
- Query - How to get start date of server(monState)?
- Query - Which currently executing queries are consuming the most CPU ?
- Query - How to identify hot tables?
- Query - How to identify most I/O intensive statement?
- Query - How to monitor table activity?
- Query - How to find out SQLText without dbcc traceon ?
- Query - How to find out showplan for pertaining SPID ?
- Query - Find out application information for pertaining SPID ?
- Query - How to get date/time when last checkpoint is perform,in databases ?
- Query - How to get last database backup information (start time,BackupInProgress and LastTranLogDumpTime) ?
- Query - How to get suspended processes count due to transaction log full?
Performance and Tuning
- What are the basics of performance tuning?
- What is locking and how many types of locking in SYBASE ASE?
- Scenarios considered for performance tuning?
- Performance Tuning - Scenario Based Part 1?
- Performance Tuning - Scenario Based Part 2?
- Blocking in the Sybase Dataserver
- How can we check for the long running trans?
- How can we print Deadlock information in errorlog?
- If user database log is completely full?
- How can we take striped & compressed backup in ASE?
- What is the local and global indexes?
- How to recover password of ''sa'' ?
- What is the difference between sysstats and systabstats table?
- What is suid mismatch?
- What is update Statistics and how is it useful ?
- How to use sybdiag utility in SYBASE ASE 15.7 ?
- What is optimization goal in query processing?
- How to change sort order in SYBASE ASE?
- How to drop from master device and assign new device to tempdb ?
- How to bind user defined tempdb with application ?
- How to bind user defined tempdb with login ?
- How to bind user defined tempdb with named cache ?
- How to get fragmentation statistics for a table?
- How can we see the sql text?
- Steps for checking Health of Dataserver?
- How can we check the Sybase services up and running fine?
- How can we change the sort order of a sybase server?
- What is the difference between syskeys and sysconstraints?
- What is the difference between login and user?
- What are the local and global indexes
- New SQL functionality in Sybase 15.7 version
- Daily maint Jobs for A Database
- Weekly Maint Jobs for a Database
- Global and Local Indexes
- Sybase ASE Interview frequently asked Questions and Answers ?
- Basic Unix/Linux Interview Questions and Answers for running SYBASE ASE?
- Sybase ASE tutorial
Share you feedback at firstname.lastname@example.org.