Indicate if the statements are TRUE or FALSE. _______ Entity integrity is enforc
ID: 3855663 • 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 be used when a table is required to be joined to itself. _______ You can declare variables inside a stored procedure.Explanation / Answer
1.TRUE
Explanation: by specifying primary key then only all integrites are automatically applied on entity
2.TRUE
Explanation: LIKE is used to compare the values of attributes while conjuction operation applied
3.FALSE
Explanation:Stored procedures help reduce code duplication by means of code isolation and code sharing.
stored function is nothing but a trigger
4.FALSE
Explanation: do not uses indexes in small tables or low sparsity
5.FALSE
Explanation:CHECK used to limit the value range that can be placed in a column
6.FALSE
Explanation:RAID uses number of disks in different levels of RAID implementation
7.TRUE
explanation:because of its non-volatile natue ,Once data enter the Data Warehouse, they are never removed. The Data Warehouse is always growing
8.TRUE
explanation: Security breaches used to get a database whose integrity is either preserved or corrupted.
9.FALSE
Explanation:An alias can be used when a table is required to be joined to itself in a recursive query.
10.TRUE
Explanation:We typically use the variables in stored procedures to hold the immediate results. These variables are local to the stored procedure.