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.
Illustrates the way to assign an address to an element of a pointer array? Answer: We can assign a memory address to an element of an array of pointers by usin
Define the Fully Functional dependency.
You have been given a setup of tables with data and inquired to make a new database to store them. What are you looking for, when you observe the data values in the tables?
Explain what are new in the BO 5.1?
What is Redundant Array of Inexpensive Disks and what are various types of RAID configurations?
Describe the term Java bean?
Write down the security level employed in BO?
Which member function places a new node on the end of the linked list? Answer: appendNode(): This member function places a new node on the end of t
Explain terms Data Cache in Sybase. Answer: It is the memory area where data which is required for the current queries running is bought by Disk upon to memory for
Explain what is meant by the repository and what does it consists of?
18,76,764
1925671 Asked
3,689
Active Tutors
1440740
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!