Start Discovering Solved Questions and Your Course Assignments
TextBooks Included
Solved Assignments
Asked Questions
Answered Questions
what is log shippinglog shipping is the method of automating the backup of database and transaction log files on a production sql server and then
can a stored procedure call itself or recursive stored procedure how much level sp nesting is possibleyes because transact-sql supports recursion you
what is sql server agentsql server agent plays a significant role in the day-to-day tasks of a database administrator dba it is often overlooked as
iiilayered software architectures can be used to reduce coupling between the functions of a system that are closer to the machine and those that are
what are the authentication modes in sql server how can it be changedwindows mode and mixed mode - sql and windows to alter authentication mode in
what is sql profilersql profiler is a graphical tool that permits system administrators to monitor events in an instance of microsoft sql server you
whats the difference between a primary key and a unique keyboth primary key and unique key enforces uniqueness of the column on which they are
what is oltp online transaction processingin oltp - online transaction processing systems relational database design use the discipline of data
what are the difference between clustered and a non-clustered indexa clustered index is a special type of index that reorders the way records in the
what is datawarehousing subject-oriented meaning that the data in the database is organized so that all the data elements relating to the similar
what is identityidentity or autonumber is a column that automatically produces numeric values a start and increment value can be set but most dba
what is a linked serverlinked servers is a method in sql server by which we can add other sql server to a group and query both the sql server dbs
what is indexan index is a physical structure having pointers to the data indices are created in an existing table to locate rows more quickly and
what is nested triggera trigger can also having insert update and delete logic within itself so when the trigger is fired because of data
what is triggera trigger is a sql procedure that initiates an action when an event insert delete or update occurs triggers are kept in and managed by
what is stored procedurea stored procedure is a named group of sql statements that have been previously formed and kept in the server database stored
what is de-normalizationde-normalization is the method of attempting to optimize the performance of a database by adding redundant data it is
what is normalizationdatabase normalization is a data design and organization method applied to data structures based on rules that help building
what is rdbmsrelational data base management systems rdbms are database management systems that maintain data records and indices in tables
demonstrate your knowledge of plsql programming by writing and thoroughly testing triggers and stored procedures associated with an e-commerce
Demonstrate your knowledge of PL/SQL programming by writing and thoroughly testing triggers and stored procedures associated with an e-commerce application that provides security logs for all transa
what is busy waitingthe repeated implementation of a loop of code while waiting for an event to happen is known as busy-waiting the cpu is not
what is meant by arm-stickinessif one or a few processes have a high access rate to data on single track of a storage disk then they might be
what is the resident set and working set of a processresident set is that portion of the process image that is actually in real-memory at a certain
what is the translation lookaside buffer tlbin a cached system the base addresses of the last few referenced pages is maintained in registers known