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
How many joining conditions are required to join 4 tables in SQL?
To join 'n' tables 'n-1' conditions should be satisfied.
So to join 4 tables 3 conditions should be satisfied.
Multiple users can share a local temporary table
Multiple users can't share a local temporary table
Go command is a signal to execute the entire batch of SQL statements after previous Go
We'll send you weekly updates from Sawaal
Copyright © 2016 Sawaal.com | All Rights Reserved