databases Online Quiz - 148
|Description: databases Online Quiz - 148|
|Number of Questions: 20|
|Created by: Aliensbrain Bot|
In a query, Table_A is joined with Table_B based on the join criteria (Table_A.Column_1 = Table_B.Column_1). The SME in the team mentions that Table_B is the child of Table_A based on Column_1 (one-to-many relationship) and should always have value. Given these considerations, which of the following doesn't apply to this situation?
Always use hints while writing queries (e.g. WITH NOLOCK, WITH UPDLCK) since it will help the query optimizer
Which of the below is the correct query to update the columns of a table:
UNION query returns only distinct rows and UNION ALL may return duplicates.
Bitmap index is suitable for the tables having huge and repeatative(duplicates) data.
Which command is used to Check integrity of a table or indexed view?