Basic Interview Questions and Answers for SQL - 1
Ads
Introduction:
A common database language called SQL is used to access and modify database data. SQL was created in the 1970s by IBM computer scientists. In databases like MySQL, Oracle, PostgreSQL, etc., SQL can create, update, delete, and retrieve data by running queries. In general, SQL is a query language for interacting with databases. Do you want to know how to answer SQL interview questions? Learn SQL basic interview questions through Nithra jobs.
1. What does SQL stand for? Structured Query Language
2. SQL statement is used to extract data from a database? SELECT
3. What is the SQL keyword for unique? DISTINCT keyword
4. What are the SQL aggregate functions? avg, count, sum, min, max, etc
5. what is the SQL keyword is used to sort the result-set? The ORDER BY keyword
6. What is the correct statement for inserting data into database? INSERT INTO
7. Data types in SQL Server are organized into how many categories? 6
8. A column of type __________ may contain rows of different data types. sql_variant
9. SQL Server has mainly how many types of views? two
10. BLOB in SQL stands for? binary large object
11. SQL database follows what is the following principles? ACID Model
12. What is the data type of SQL is used to store a JSON object? nvarchar(max)
13. How many Primary keys can be created on a table? one primary key
14. Codename for SQL Server 2012 is __________. Denali
15. ______________ is monetary data type in SQL Server. Smallmoney
16. The UNION SQL clause can be used with _____________. SELECT clause only
17. What is the proprietary extension of SQL for Microsoft SQL Server? Transact-SQL
18. SQL function is used to count the number of rows in a SQL query? COUNT(*)
19. SQL Server lets you define how many types of secondary XML indexes? 3
20. What is a primary key in SQL? Identifies
21. What is the command to undo a transaction in SQL? SQL RollBack
22. What is the not a type of join in T-SQL? Self-join
23. SQL Server lets you define how many types of secondary XML indexes? 3
24. SQL Server provides how many Xquery methods? 5
25. Create a Database Maintenance Plan that creates a ________ backup within SQL Server. full backup
Conclusion:
This SQL question and answer aims to help beginners learn both the basic and advanced topics associated with SQL languages. This article will provide you with an adequate grasp of the SQL language.