Sybase Database Administrator

1. What does ASE stand for in Sybase?

A) Advanced Server Engine B) Adaptive Server Enterprise C) Asynchronous Server Engine D) Automated Sybase Engine

2. Which command is used to back up a Sybase database?

A) dump database B) save database C) backup db D) archive database

3. What is the default port number for Sybase ASE?

A) 3306 B) 1521 C) 5000 D) 5432

4. Which file stores transaction logs in Sybase?

A) .dat B) .log C) .bak D) .trn

5. What is used in Sybase to group database objects and provide permissions?

A) Triggers B) Roles C) Views D) Events

6. What command shows current user connections in Sybase?

A) show processlist B) sp_who C) sp_users D) list connections

7. What is the command to create a new user in Sybase ASE?

A) create login B) add user C) new user D) insert login

8. What is a key advantage of Sybase’s data cache configuration?

A) Avoids using RAM B) Allows per-database memory tuning C) Reduces disk space D) Ignores tempdb usage

9. What does the sp_helpdb command display?

A) Active jobs B) All stored procedures C) Database size and devices D) Indexes in a table

10. How do you recover a transaction log in Sybase?

A) restore transaction B) dump log C) load transaction D) recover log

11. What is the system database used to store user information in Sybase?

A) model B) tempdb C) master D) sybsystemdb

12. Which command is used to remove a login from Sybase?

A) drop user B) delete login C) sp_droplogin D) remove login

13. What is the function of tempdb in Sybase?

A) Store backups B) Temporary storage for queries and transactions C) Store logins D) Manage system processes

14. Which stored procedure provides server configuration details?

A) sp_configure B) sp_whoami C) sp_status D) sp_serverinfo

15. What is the role of the model database?

A) Stores backups B) Template for creating new databases C) Tracks failed logins D) Archives old data

16. What does kill command do in Sybase?

A) Deletes a login B) Terminates a session or process C) Drops a table D) Disables a procedure

17. Which command helps recompile stored procedures?

A) alter proc B) update stats C) sp_recompile D) rebuild

18. How do you check for blocking sessions in Sybase?

A) sp_lock B) show locks C) block trace D) check_waits

19. Which Sybase utility is used for loading data in bulk?

A) bcp B) bload C) sqlcmd D) loadfast

20. What is the sysobjects table used for?

A) Stores triggers B) Contains system log entries C) Stores all objects (tables, views, etc.) D) Caches user sessions

21. What kind of joins are supported in Sybase ASE?

A) Inner joins only B) Left and right joins only C) Inner, outer, cross joins D) No joins

22. Which command is used to create a backup of the transaction log?

A) save transaction B) dump log C) backup log D) archive log

23. How can you find index information for a table in Sybase?

A) sp_helpindex B) sp_indexes C) get_index_info D) sp_showindexes

24. What does sp_monitor do?

A) Monitors login attempts B) Provides performance statistics C) Shows schema usage D) Tracks firewall rules

25. How can Sybase ASE be integrated with high availability systems?

A) Using RAID B) By clustering C) With Sybase ASE High Availability Option D) With MS Excel

Sybase Database Administrator

🌟 Job Ready - 100% Scorers