Start Discovering Solved Questions and Your Course Assignments
TextBooks Included
Active Tutors
Asked Questions
Answered Questions
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
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
describe domain constraintsdomain constraints contain entity integrity and referential integrity the domain is a set of values that might be assigned
explain the systems development life cyclethis is the traditional method to develop maintain and replace information systems that contains the
explain the differences between structured data and unstructured datastructured data are facts concerning objects and events the most significant
what is olaponline analytical processing olap is a business intelligence bi reporting system olap gives the user with the capability to sum count
what is a dataseta dataset is an in-memory database that is disconnected from any regular database but has all the significant characteristics of a
what disadvantage of odbc does ole db overcomeby breaking the features and the methods of a dbms into com objects ole db characteristic overcomes a
what are the three types of data sources used with odbcan odbc file data source is a file that can be shared between database users an odbc system