What is the maximum number of triggers, can apply to a single table?
Maximim number of triggers that can be applied to a single table is 12
Breaking of relationships is allowed once referential integrity on a database is enforced
Breaking of relationships is prevented once referential integrity on a database is enforced
A column defined as UNIQUE can contain Nulls while a column defined as PRIMARY KEY can't contain Nulls
Because a table can have only one primary key
What is the default return value of a function?
The default return value from a function is int. In other words, unless explicitly specified the default return value by compiler would be integer value from function.
Which among the following keys are used to identify each row of the table uniquely?
Primary key helps us to identify a row uniquely in a relation
What is the difference between oracle,sql and sql server?
Multiple users can share a local temporary table
Multiple users can't share a local temporary table
Can’t update primary table’s primary key if row being modified has related rows in secondary table once referential integrity is enforced
We'll send you weekly updates from Sawaal
Copyright © 2016 Sawaal.com | All Rights Reserved