Start Discovering Solved Questions and Your Course Assignments
TextBooks Included
Active Tutors
Asked Questions
Answered Questions
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
what is the difference between sql server 2000 clustered and nonclustered indexeswith a clustered index the data are kept in the bottom level of the
what is the difference between sql server 2000 complete and differential backupsa complete backup makes a copy of the whole database a differential
what is deadlock how can it be avoided how can it be resolved once it occursdeadlock happens when two transactions are each waiting on a resource
explain the difference between optimistic locking and pessimistic lockingoptimistic locking supposes no transaction conflict will occur and deals
why is database redesign necessarydatabase redesign is essential for two reasons first redesign is essential both to fix mistakes made during the
what is a cascading updatereferential integrity constraints needs that foreign key values in one table correspond to primary key values in another if