Indicate if the statements are TRUE or FALSE. ______ Entity integrity is enforce
ID: 3855672 • Letter: I
Question
Indicate if the statements are TRUE or FALSE. ______ Entity integrity is enforced automatically when the primary key is specified in the CREATE TABLE command sequence. ______The conditional LIKE should be used in conjunction with wildcard characters. _______ A stored function is another name for a stored procedure. _________ Indexes are very useful in small tables or tables with low, sparsity. ________ The CHECK constraint is used to define a condition for the values that the attribute domain cannot have. _________ RAID systems use a single disk to create storage volumes. ________Once data enter the data warehouse, they are never removed. ______ Security breaches can yield a database whose integrity is either preserved or corrupted. ________ An alias cannot An alias cannot be used when a table is required to be joined to itself. _______ You can declare variables inside a stored procedure.Explanation / Answer
Answers:
1.true
2.true
Wildcards are used in conjunction with the comparison operator LIKE
3.false
4.false
Do not use indexes on small tables or tables with low sparsity
5.false
6.false
A RAID system consists of two or more drives working in parallel
7.true
8.true
9.false
In a few circumstances, you may think that its important to join a table to itself, just as you were joining two separate tables. This is alluded to as a self join. In the self join, the consolidated outcome comprises of two lines from a similar table
10.true
To proclaim a variable inside a put away strategy, you utilize the DECLARE proclamation as takes after:
Proclaim variable_name datatype(size) DEFAULT default_value;