Explain the way to audit the SQL sent to the server
Explain the way to audit the SQL sent to the server.
Expert
This does not appear to be well documented; therefore here is a quick means of auditing the SQL text which is sent to the server. Note that it simply audits the SQL sent to the server. Therefore, if your user process executes a big stored procedure, all you will observe here is a call to the stored procedure. No one of the SQL which is executed as part of the stored procedure will be listed.
Initially, you need to have installed Sybase security (that involves installing the sybsecurity database and loading this using the script as $SYBASE/scripts/installsecurity). And read the Sybase Security Administration Manual, you may wish for to enable a threshold procedure to toggle between couples of audit tables. Be aware, that the default configuration option "delay auditing when device full”, which is set to 1. It means that the server will suspend all normal SQL operations when the audit database becomes full and the so logs in and gets rid of several data. You might want to seem changing it to 0 unless yours is a above all sensitive installation.
Is it possible that Table Partitioning Require User-Defined Segments in the Sybase?
Write down some of the differences between the data query and the knowledge query.
Explain about the stored-procedures and its advantages.
Define the term File Manager and Storage Manager in relational database management system.
What are the main tasks of a Server?
Explain the Slice and Dice attribute in the Business Objects?
Briefly describe time series algorithm in data mining?
Describe briefly the alternative terminology which is employed in the relational model?
Describe the difference between the bulk-logged recovery models, full, and SQL Server 2000 simple?
Elucidate briefly the term metadata reporter?
18,76,764
1938438 Asked
3,689
Active Tutors
1418950
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!