Crowdly
Add to Chrome
Check your knowledge: DevOps Tests
Looking for Check your knowledge: DevOps Tests test answers and solutions? Browse our comprehensive collection of verified answers for Check your knowledge: DevOps Tests at softserve.academy.
Get instant access to accurate answers and detailed explanations for your course questions. Our community-driven platform helps students succeed!
How many clustered indexes can you create on a table?
What is true for ‘View’ in SQL?
1. It can help in providing security
2. It can be used for hiding complexity
3. If there are more than one table involved in the view, we cannot perform (Data Manipulation Language) DML queries
4. When you drop the base table. View becomes inactive.
Select the correct option:
What will be the output for the below query?
SELECT Name from AV1 where Name LIKE '%______%';
Note: The above operation contains 6 underscores (‘_’).
What happens when a scalar subquery returns more than one value?
When we use both AND and OR operations in the WHERE clause …
Suppose there are seven records in a table. One column in this table is an identity column. Now the client wants to insert a record after the identity value 7 with its identity value starting from 10. Is it possible?