Start Discovering Solved Questions and Your Course Assignments
TextBooks Included
Active Tutors
Asked Questions
Answered Questions
for the following business rules identify all entities attributes relationships primary keys cardinalities and constraints where
all edges of a cube are expanding at a rate of 6 centimeters per second how fast is the surface area changing when each edge is a 2 centimeters and b
prototype of a distributed information system for a national car part retail outlet
state about the tables- dbmsdata is stored in columns and rows much like a spreadsheet -main difference is how data is organised every row in a table
explain the term- queryqueries are used to repossess and show specific records in a table they can also be used to show specific fields of specific
illustrate different types of locks in sql serverthere are three kinds of locks in sql serveri shared locks - these are used for operations which
differentiate between a global and a local temporary table- a local temporary table exists only for the duration of a connection or if defined inside
give short note on the following termsdirty pages and etla dirty pages these are buffer pages which comprise modifications which havent been written
what do you understand by acid- acid atomicity consistency isolation durability is a quality sought after in a reliable database heres the relevance
define about the stored procedure- its a set of t-sql statements combined together to perform a single task formed by combining numerous small tasks-
what is collation collation is a kind of sort order there are majorly 3 types of sort orders namelyi dictionary case insensitiveiidictionary - case
what are the various properties of relational tablesrelational tables have 6 properties1 each row is unique2 column values are of the same kind3
what is difference between truncate and delete- truncate cant be rolled back whereas delete can be- truncate keeps the lock on table whereas delete
you want to implement following relationships when designing tables how would you do ita one-to-oneb one-to-manyc many-to-manya one-to-one
what do you mean by an execution plan why is it used how will you view ita an execution plan can be known as a road map which textually or
what is recursion is it possible for a stored procedure to call itself or recursive stored procedure how many levels of sp nesting is
differentiate between a unique key and a primary key- by default clustered index on column are created by primary key while nonclustered index are
give detail description on transactions - using transactions we can group all sql commands into a single unit- transaction begins with some task and
what is the function of sql server agent windows service- its a windows service that handles tasks scheduled within sql server environment these
explain query execution plan- optimizer available in sql server optimizes code to be effectively executed- a query execution plan demonstrates how
what do you understand by a view what does with check option clause for a view do- a view is a virtual table which comprises fields from one or more
what is the difference between a having clause and a where clausehaving clause- having clause is used only with select statement- it is normally used
when is updatestatistics command used- when processing of large data is done this command is used- whenever large number of modification deletions or
use the following database schema 1 patientpatientid name dob 2 doctordoctorid name medlicensenumber phone 3 medicationmedicationid