sql面试题问答题_SQL面试问答

sql面试题问答题

SQL interview questions are asked in almost all interviews because database operations are very common in applications. SQL stands for Structured Query Language, which is a domain-specific programming language used for database communications and relational database management.

几乎所有采访中都会询问SQL采访问题，因为数据库操作在应用程序中非常常见。 SQL代表结构化查询语言，这是一种特定于域的编程语言，用于数据库通信和关系数据库管理。

SQL consists of standard commands for database interactions such as SELECT, INSERT, CREATE, DELETE, UPDATE, DROP etc. With these, it allows the user to retrieve and upload data from databases, create and delete table elements, and implement dynamic database interactions between servers and programs.

SQL由用于数据库交互的标准命令组成，例如SELECT，INSERT，CREATE，DELETE，UPDATE，DROP等。使用这些命令，用户可以从数据库中检索和上载数据，创建和删除表元素以及实现之间的动态数据库交互。服务器和程序。

SQL面试题 (SQL Interview Questions)

Listed below are various SQL interview questions and answers that reaffirms your knowledge about SQL and provide new insights and learning about the language. Go through these SQL interview questions to refresh your knowledge before any interview.

下面列出的是各种SQL访谈问题和答案，它们重申了您对SQL的知识，并提供了有关该语言的新见解和学习。 在进行任何面试之前，请仔细阅读这些SQL面试问题以刷新您的知识。

1. 什么是SQL？ (What is SQL?)

2. SQL is a domain-specific programming language that allows you to query and manipulate data within database management systems arranged in an optimized manner and categorization. This is possible through implementing commands in SQL that allows you to read, write, select and delete entries or even columns of the same attribute or tables. SQL also provides a very efficient way of creating a dynamic accessway between your programs, websites, or mobile apps to a database. For example, by inputting your login details on a user website, these log information is passed on to a database by SQL for verification and user restriction.

   SQL是特定于域的编程语言，允许您查询和操作以优化方式和分类安排的数据库管理系统中的数据。 这可以通过在SQL中实现命令来实现，该命令允许您读取，写入，选择和删除条目或相同属性或表的列。 SQL还提供了一种非常有效的方式来创建程序，网站或移动应用程序与数据库之间的动态访问方式。 例如，通过在用户网站上输入您的登录详细信息，这些日志信息将通过SQL传递到数据库，以进行验证和用户限制。

3. 数据库和关系数据库之间有什么区别？ (What is the difference between a Database and a Relational Database?)

4. Database or Database Management System(DBMS) and Relational Database Management System(DBMS) are both used by SQL to store data and structures. However, each type of Database Management System is preferred with respect to different uses. 

   SQL都使用数据库或数据库管理系统（DBMS）和关系数据库管理系统（DBMS）来存储数据和结构。 但是，就不同用途而言，每种类型的数据库管理系统都是首选的。

   The main difference between the two is that DBMS saves your information as files whereas RDMS saves your information in tabular form. Also, as the keyword Relational implies, RDMS allows different tables to have relationships with one another using Primary Keys, Foreign Keys etc. This creates a dynamic chain of hierarchy between tables which also offers helpful restriction on the tables.

   两者之间的主要区别是DBMS将您的信息保存为文件，而RDMS将您的信息保存为表格形式。 同样，正如关键字Relational所暗示的那样，RDMS允许使用主键，外键等使不同的表之间具有相互关系。这在表之间创建了动态的层次结构链，这也为表提供了有用的限制。

   DBMS sorts out its tables through a hierarchal manner or navigational manner. This is useful when it comes to storing data in tables that are independent of one another and you don’t wish to change other tables while a table is being filled or edited.

   DBMS通过分层方式或导航方式整理其表。 当要将数据存储在彼此独立的表中并且您不希望在填充或编辑表时更改其他表时，这很有用。

5. SQL的基本结构是什么？ (What is the Basic Structure of an SQL?)

6. SQL is framed upon the structure of relational operations. It is based on certain modifications and enhancements.

   SQL基于关系操作的结构。 它基于某些修改和增强。

   A very basic SQL query form is:

   一个非常基本SQL查询形式是：

   select A1, A2, ..., An
   
   from R1, R2, ..., Rm
   
   where P

   Here An are attributes, Rm is the relations within the database and P is the predicate or filter.

   这里An是属性，Rm是数据库内的关系，P是谓词或过滤器。

7. 什么是SQL命令的不同类别？ (What are different categories of SQL commands?)

8. SQL command falls into following four categories:

   SQL命令分为以下四类：

• DML (Data Manipulation Language) which provides data manipulation features
  DML（数据处理语言），提供数据处理功能
• DDL (Data Definition Language) which is used to manipulate database structures
  DDL（数据定义语言），用于处理数据库结构
• TCL (Transaction Control Language) that takes in charge data transaction verification and error handling
  TCL（交易控制语言）负责数据交易验证和错误处理
• DCL (Data Control Language) are security statements that feature user restrictions and data access permissions to promote security of your data.
  DCL（数据控制语言）是具有用户限制和数据访问权限的安全性声明，以提高数据的安全性。

• SQL的作用是什么？ ( What is SQL used for?)

• SQL is used and is popular for server-side programmers for its ability to process a large number of entries in a database in a very fast and easy manner. This opens up to large improvements in data retrieval and manipulation. To expound on this, SQL provides th