SQL Interview Questions and Answers in Hindi and English

Hello aspirant in this article you can find your query related to SQL interview questions and answers, SQL MCQ questions and answers pdf download, SQL questions and answers for interview, SQL mcq interview questions

SQL database interview questions, SQL multiple choice questions with answers pdf, SQL questions and answers for practice pdf, SQL multiple choice questions and answers for freshers

SQL MCQ questions and answers pdf

SQL database mcq questions and answers, SQL basic interview questions, SQL mcq question knowledge, SQL multiple choice questions answers, SQL mcq questions for interview, SQL MCQ questions and answers pdf, SQL interview questions and answers in Hindi and English, SQL objective type questions and answers

SQL interview questions and answers

SQL interview questions and answers in English, SQL MCQ questions and answers pdf, SQL multiple choice questions and answers, SQL multiple choice questions answers, SQL objective type questions and answers, SQL mcq questions for interview

1. What does SQL stand for?

SQL का मतलब क्या है?

1. SQL stands for Sample Query Language
2. SQL stands for Sample Query List
3. SQL stands for Structured Query Language
4. SQL stands for Structured Query List

 

2. What does SQL is used to perform operations on?

SQL का प्रयोग किस पर कार्य करने के लिए किया जाता है?

1. Insert Records
2. Update Records
3. Both A and B
4. None of the above

 

3. What does this SQL database language design to?

यह SQL डेटाबेस भाषा किस लिए डिज़ाइन करती है?

1. Maintain the data in network database management systems.
2. Maintain the data in relational database management systems.
3. Maintain the data in hierarchal database management systems.
4. Maintain the data in object-oriented database management systems.

 

4. Which statement is not true about SQL?

SQL के बारे में कौन सा कथन सत्य नहीं है?

1. It helps develop relational database functions, events, and views.
2. Sample data can also be described with the aid of this tool.
3. Using SQL in relational databases is all about inserting, updating, and deleting data.
4. A SQL user can also set restrictions and permissions for a table column, a view, and a stored procedure.

 

5. SQL became the standard of?

SQL का मानक बन गया?

1. ASCII
2. ANSI
3. ISO
4. Both B and C

 

6. SQL contains which component in its process?

SQL में इसकी प्रक्रिया में कौन सा घटक होता है?

1. Query Dispatchers
2. SQL Query Engines
3. Optimization Engines
4. All of the above

 

7. What is the work of CREATE command?

CREATE कमांड का क्या काम होता है?

1. Inserting records or data into the database tables is accomplished with this command.
2. It enables you to create new databases, tables, table views, and other objects using this command.
3. Using this command, you can remove or erase recorded information from a database table.
4. A single or multiple rows can be accessed using this command from one or more tables of a database.

 

8. Determine the correct SQL command?

सही SQL कमांड निर्धारित करें?

1. CREATE
2. DELETE
3. UPDATE
4. All of the above

 

9. What is the work of UPDATE command?

UPDATE कमांड का क्या काम है?

1. Using this command, you can remove or erase recorded information from a database table.
2. It enables you to create new databases, tables, table views, and other objects using this command.
3. Database data can be updated or changed using this command.
4. A single or multiple rows can be accessed using this command from one or more tables of a database.

 

10. What is the work of SELECT command?

सेलेक्ट कमांड का काम क्या है?

1. Database objects such as tables, table views, and other objects can be deleted using this command.
2. It enables you to create new databases, tables, table views, and other objects using this command.
3. One or more rows from one or more tables of the database can be accessed with this command. Using the WHERE clause with this command is also possible.
4. Database objects such as tables, table views, and other objects can be deleted using this command.

SQL Interview Questions and Answers

11. What is the work of DELETE command?

DELETE कमांड का काम क्या है?

1. Database objects such as tables, table views, and other objects can be deleted using this command.
2. Database data can be updated or changed using this command.
3. Using the WHERE clause with this command is also possible.
4. Using this command, you can remove or erase recorded information from a database table.

 

12. What is the work of DROP command?

DROP कमांड का क्या काम है?

1. One or more rows from one or more tables of the database can be accessed with this command. Using the WHERE clause with this command is also possible.
2. Database objects such as tables, table views, and other objects can be deleted using this command.
3. Using this command, you can remove or erase recorded information from a database table.
4. It enables you to create new databases, tables, table views, and other objects using this command.

 

13. Which statement is not true?

कौन सा कथन सत्य नहीं है?

1. SQL database are vertically scalable whereas No-SQL database are horizontally scalable.
2. SQL follows BASE Model whereas No-SQL follows ACID Model.
3. SQL is rational whereas No-SQL is non-rational.
4. No-SQL databases are preferable to store hierarchical data in comparison SQL databases.

 

14. What is the work of INSERT command?

INSERT कमांड का क्या काम है?

1. Inserting records or data into the database tables is accomplished with this command. In addition to inserting records in single rows, we can insert records in multiple rows as well.
2. It enables you to create new databases, tables, table views, and other objects using this command.
3. One or more rows from one or more tables of the database can be accessed with this command. Using the WHERE clause with this command is also possible.
4. Database objects such as tables, table views, and other objects can be deleted using this command.

 

15. Which statement is true about the SQL?

SQL के बारे में कौन सा कथन सत्य है?

1. SQL databases are vertically scalable.
2. SQL database cannot handle complex queries.
3. SQL follows BASE Model.
4. SQL database does not require object-relational mapping.

 

16. SQL has the advantage of?

SQL का फायदा है?

1. SQL require a lot of programming.
2. SQL is easily portable.
3. SQL follows the standard languages of ANSI and ISO.
4. SQL provides High-Speed Query Processing.

 

17. Which statement is true about the No-SQL?

नो-एसक्यूएल के बारे में कौन सा कथन सत्य है?

1. No-SQL follows ACID Model.
2. No-SQL databases are not preferable for storage of hierarchal data.
3. Dynamic schemas for unstructured data are used in No-SQL databases.
4. No-SQL does require object-relational mapping.

 

18. SQL has the disadvantage of?

SQL का नुकसान है?

1. SQL interface is simple.
2. SQL is cheap.
3. Both A and B.
4. None of the above.

 

19. What is meant by ‘SQL is an interactive language’?

‘एसक्यूएल एक संवादात्मक भाषा है’ का क्या अर्थ है?

1. Learning and understanding SQL is easy
2. In a few seconds, complex queries can also be answered using this language.
3. It can also be used for communicating with the database.
4. All of the above

 

20. What is meant by Partial Database Control?

आंशिक डेटाबेस नियंत्रण का क्या अर्थ है?

1. Users or professionals can’t have the full control over the database.
2. Business rules are hidden.
3. Both A and B
4. None of the above

SQL MCQ questions and answers pdf

21. Which of the following statement is false?

निम्नलिखित में से कौन सा कथन असत्य है?

1. An SQL statement’s syntax is determined by its text line.
2. It is easier to read SQL queries when the keywords are in lowercase.
3. There is no difference between a lower case and upper case keyword in SQL.
4. One or more SQL statements can be placed on a single line of text.

 

22. Which of the following is not an SQL Statement?

निम्न में से कौन एक SQL स्टेटमेंट नहीं है?

1. SELECT Statement
2. TRUNCATE TABLE Statement
3. UPDATE Statement
4. FROM Statement

 

23. Which of the following statement is true?

निम्नलिखित में से कौन सा कथन सत्य है?

1. Relational algebra and tuple relationship calculus are needed for SQL syntax.
2. SQL statements are used for most operations in a database.
3. All of the above
4. None of the above

 

24. What does the SELECT Statement do?

सेलेक्ट स्टेटमेंट क्या करता है?

1. Data is read from the SQL database by this statement and displayed to the database user.
2. By deleting the stored data, this SQL statement deletes the database.
3. The stored data in the SQL database is changed or modified by this SQL statement.
4. A new table in SQL is created using this SQL statement.

 

25. What does the DELETE Statement do?

DELETE स्टेटमेंट क्या करता है?

1. Columns in the SQL database can be created, deleted, or modified with this SQL statement.
2. By deleting the stored data, this SQL statement deletes the database.
3. A new table in SQL is created using this SQL statement.
4. By executing this SQL statement, you remove the table and all the information that it contains, including the structure, views, permissions, and triggers.

 

26. What does the UPDATE Statement do?

UPDATE Statement क्या करता है?

1. By deleting the stored data, this SQL statement deletes the database.
2. Columns in the SQL database can be created, deleted, or modified with this SQL statement.
3. The stored data in the SQL database is changed or modified by this SQL statement.
4. A new table in SQL is created using this SQL statement.

 

27. What does the CREATE TABLE Statement do?

CREATE TABLE स्टेटमेंट क्या करता है?

1. The stored data in the SQL database is changed or modified by this SQL statement.
2. Columns in the SQL database can be created, deleted, or modified with this SQL statement.
3. A new table in SQL is created using this SQL statement.
4. By deleting the stored data, this SQL statement deletes the database.

 

28. What does the DROP TABLE Statement do?

DROP TABLE स्टेटमेंट क्या करता है?

1. The table, its structure, views, permissions, and triggers will also be deleted or removed with this SQL statement.
2. A new database will be created through this SQL statement.
3. Columns in the SQL database can be created, deleted, or modified with this SQL statement.
4. A new table in SQL is created using this SQL statement.

 

29. What does the ALTER TABLE Statement do?

ALTER TABLE Statement क्या करता है?

1. A new table in SQL is created using this SQL statement.
2. Columns in the SQL database can be created, deleted, or modified with this SQL statement.
3. By deleting the stored data, this SQL statement deletes the database.
4. The table, its structure, views, permissions, and triggers will also be deleted or removed with this SQL statement.

 

30. What does the CREATE DATABASE Statement do?

CREATE DATABASE स्टेटमेंट क्या करता है?

1. Columns in the SQL database can be created, deleted, or modified with this SQL statement.
2. In the database management system, this SQL statement deletes the existing database, together with all the database tables and views.
3. The table, its structure, views, permissions, and triggers will also be deleted or removed with this SQL statement.
4. A new database will be created through this SQL statement.

SQL Interview Questions and Answers

31. What does the INSERT INTO Statement do?

INSERT INTO स्टेटमेंट क्या करता है?

1. In this SQL statement, the data or records are inserted into an existing database table. One query statement can insert multiple records simultaneously using this statement.
2. By executing this SQL statement, all records in the SQL database will be deleted.
3. In the database management system, this SQL statement deletes the existing database, together with all the database tables and views.
4. A new database will be created through this SQL statement.

 

32. What does the DROP DATABASE Statement do?

DROP DATABASE स्टेटमेंट क्या करता है?

1. A new database will be created through this SQL statement.
2. In the database management system, this SQL statement deletes the existing database, together with all the database tables and views.
3. The table, its structure, views, permissions, and triggers will also be deleted or removed with this SQL statement.
4. In this SQL statement, the data or records are inserted into an existing database table. One query statement can insert multiple records simultaneously using this statement.

 

33. What does the TRUNCATE TABLE Statement do?

TRUNCATE TABLE Statement क्या करता है?

1. In the database management system, this SQL statement deletes the existing database, together with all the database tables and views.
2. The data specified in this table or view is reported in this SQL statement.
3. By executing this SQL statement, all records in the SQL database will be deleted.
4. In this SQL statement, the data or records are inserted into an existing database table. One query statement can insert multiple records simultaneously using this statement.

 

34. What does the DISTINCT Clause do?

DISTINCT क्लॉज क्या करता है?

1. Specify the columns of the table in this SQL clause to return distinct values.
2. The data specified in this table or view is reported in this SQL statement.
3. By executing this SQL statement, all records in the SQL database will be deleted.
4. Changes made in the SQL database transaction are permanently saved using this SQL statement.

 

35. What does the DESCRIBE Statement do?

DESCRIBE स्टेटमेंट क्या करता है?

1. In this SQL statement, the data or records are inserted into an existing database table. One query statement can insert multiple records simultaneously using this statement.
2. Specify the columns of the table in this SQL statement to return distinct values.
3. By executing this SQL statement, all records in the SQL database will be deleted.
4. The data specified in this table or view is reported in this SQL statement.

 

36. What does the COMMIT Statement do?

COMMIT स्टेटमेंट क्या करता है?

1. Specify the columns of the table in this SQL statement to return distinct values.
2. Changes made in the SQL database transaction are permanently saved using this SQL statement.
3. The data specified in this table or view is reported in this SQL statement.
4. By running this SQL statement, the transaction will be undone and the operations not yet saved to the SQL database will be undone.

 

37. What does the CREATE INDEX Statement do?

CREATE INDEX स्टेटमेंट क्या करता है?

1. An index is created in a SQL database table with this SQL statement.
2. By running this SQL statement, the transaction will be undone and the operations not yet saved to the SQL database will be undone.
3. Changes made in the SQL database transaction are permanently saved using this SQL statement.
4. The SQL database table’s index is deleted using this SQL statement.

 

38. What does the ROLLBACK Statement do?

ROLLBACK स्टेटमेंट क्या करता है?

1. Specify the columns of the table in this SQL statement to return distinct values.
2. An index is created in a SQL database table with this SQL statement.
3. By running this SQL statement, the transaction will be undone and the operations not yet saved to the SQL database will be undone.
4. Changes made in the SQL database transaction are permanently saved using this SQL statement.

 

39. What does the DROP INDEX Statement do?

DROP INDEX स्टेटमेंट क्या करता है?

1. An index is created in a SQL database table with this SQL statement.
2. The SQL database table’s index is deleted using this SQL statement.
3. By running this SQL statement, the transaction will be undone and the operations not yet saved to the SQL database will be undone.
4. An existing SQL database is selected with this SQL statement. A database must be selected from several existing databases before you can perform operations on the table.

 

40. In how many categories data types has been classified?

डेटा प्रकारों को कितनी श्रेणियों में वर्गीकृत किया गया है?

1. 2
2. 3
3. 4
4. 5

SQL MCQ questions and answers pdf

41. In the database table, data types describe the kind of ___ that it can contain.

डेटाबेस तालिका में, डेटा प्रकार ___ के प्रकार का वर्णन करते हैं जिसमें यह शामिल हो सकता है।

1. Number
2. Data
3. Table
4. None of the above

 

42. Name of the data type categories are,

डेटा प्रकार श्रेणियों के नाम हैं,

1. Date and time Data types
2. Numeric Data types
3. String Data types
4. All of the above

 

43. Which of the following is not MySQL Numeric Data Type?

निम्न में से कौन-सा MySQL न्यूमेरिक डेटा टाइप नहीं है?

1. INTEGER(Size)
2. CHAR(Size)
3. BIT(Size)
4. INT(Size)

 

44. Which of the following is not MySQL String Data Type?

निम्न में से कौन MySQL स्ट्रिंग डेटा प्रकार नहीं है?

1. TEXT(Size)
2. MEDIUMTEXT
3. TINYTEXT
4. LARGETEXT

 

45. Which of the following are not MySQL Date and Time Data Type?

निम्नलिखित में से कौन MySQL दिनांक और समय डेटा प्रकार नहीं हैं?

1. YEAR
2. TIME(fsp)
3. DATE
4. None of the above

 

46. Which of the following is SQL Server Numeric Data Type?

निम्न में से कौन SQL सर्वर न्यूमेरिक डेटा टाइप है?

1. image
2. cursor
3. money
4. nchar

 

47. Which of the following is SQL Server String Data Type?

निम्न में से कौन SQL सर्वर स्ट्रिंग डेटा प्रकार है?

1. ntext
2. varbinary
3. binary(n)
4. All of the above

 

48. Which of the following is SQL Server Date and Time Data Type?

निम्न में से कौन SQL सर्वर दिनांक और समय डेटा प्रकार है?

1. timestamp
2. real
3. sql_variant
4. text

 

49. What is the full form of BLOB?

BLOB का फुल फॉर्म क्या है?

1. Binary Long Objects
2. Binary Large Orientation
3. Binary Large Objects
4. Binary Least Objects

 

50. TINYTEXT can hold the maximum length of ___ characters?

TINYTEXT में ___ वर्णों की अधिकतम लंबाई हो सकती है?

1. 254
2. 255
3. 256
4. 257

Also Read: SQL MCQ Questions and Answers pdf download

51. How MySQL determines which one to use, FLOAT or DOUBLE, using the p parameter?

MySQL कैसे निर्धारित करता है कि p पैरामीटर का उपयोग करके किसका उपयोग करना है, FLOAT या DOUBLE?

1. If p comes between 0 to 25, data type becomes FLOAT(). If p comes between 26 to 54, data type becomes DOUBLE().
2. If p comes between 25 to 53, data type becomes FLOAT(). If p comes between 0 to 24, data type becomes DOUBLE().
3. If p comes between 26 to 54, data type becomes FLOAT(). If p comes between 0 to 25, data type becomes DOUBLE().
4. If p comes between 0 to 24, data type becomes FLOAT(). If p comes between 25 to 53, data type becomes DOUBLE().

 

52. What can be the maximum size of char(n) in SQL Server String Data Type?

SQL सर्वर स्ट्रिंग डेटा प्रकार में अधिकतम चार (n) आकार क्या हो सकता है?

1. 6000
2. 8000
3. 10000
4. 12000

 

53. What does BOOL mean in MySQL Numeric Data Types?

MySQL संख्यात्मक डेटा प्रकारों में BOOL का क्या अर्थ है?

1. A Boolean value is specified by this variable. When a value is nonzero, it is considered true, and zero is also considered true.
2. A Boolean value is specified by this variable. When a value is nonzero, it is considered true, and zero is considered false.
3. A Boolean value is specified by this variable. When a value is nonzero, it is considered false, and zero is considered true.
4. A Boolean value is specified by this variable. When a value is nonzero, it is considered false, and zero is also considered false.

 

54. What is the difference between nchar and nvarchar?

nchar और nvarchar में क्या अंतर है?

1. nchar is fixed and nvarchar is variable.
2. nchar has the maximum size of 800 characters and nvarchar has the maximum size of 4000 characters.
3. nchar has the maximum size of 4000 characters and nvarchar has the maximum size of 8000 characters.
4. nchar is variable and nvarchar is fixed.

 

55. Bit is an integer that can be –

बिट एक पूर्णांक है जो हो सकता है –

1. 0
2. Null
3. 1
4. All of the above

 

56. What is the difference between nvarchar and ntext?

nvarchar और ntext में क्या अंतर है?

1. nvarchar is fixed and ntext is variable.
2. nvarchar can be of the maximum size upto 4000 characters and ntext can be of the maximum size upto 1GB of the text data.
3. nvarchar can be of the maximum size upto 4000 characters and ntext can be of the maximum size upto 2GB of the text data.
4. nvarchar is variable and ntext is fixed.

 

57. What is the full form of GUID?

GUID का पूर्ण रूप क्या है?

1. Guided Unique Identifier
2. Globally Unique Interpreter
3. Globally Unique Identifier
4. Guided Unique Interpreter

 

58. What is the difference between VARCHAR and VARCHAR2?

VARCHAR और VARCHAR2 में क्या अंतर है?

1. VARCHAR can store upto 4000 bytes and VARCHAR2 can store upto 8000 bytes.
2. There is no similarity between VARCHAR and VARCHAR2.
3. Both VARCHAR and VARCHAR2 are similar but use of VARCHAR2 is mostly recommended.
4. VARCHAR can store upto 2000 bytes and VARCHAR2 can store upto 4000 bytes.

 

59. What is the similarity between CLOB and NCLOB Oracle Large Object Data Types?

CLOB और NCLOB Oracle बड़े ऑब्जेक्ट डेटा प्रकारों में क्या समानता है?

1. Both CLOB and NCLOB can range upto 2^32-1 bytes or 8GB.
2. Both CLOB and NCLOB can range upto 2^32-1 bytes or 4 GB.
3. Both CLOB and NCLOB are used for multibyte national character set data.
4. Both CLOB and NCLOB are used for singlebyte and multibyte national character set data.

 

60. Using a WHERE clause in a SQL query is used to specify SQL reserved words and characters, known as ____?

SQL क्वेरी में WHERE क्लॉज का उपयोग SQL आरक्षित शब्दों और वर्णों को निर्दिष्ट करने के लिए किया जाता है, जिन्हें ____ के रूप में जाना जाता है?

1. Operators
2. Numbers
3. Data Types
4. Syntax

SQL Interview Questions and Answers

61. Number of operands used by Unary Operator is?

यूनरी ऑपरेटर द्वारा उपयोग किए जाने वाले ऑपरेंड की संख्या है?

1. 1
2. 2
3. 3
4. 4

 

62. SQL Operator can be _______.

SQL ऑपरेटर _______ हो सकता है।

1. Binary
2. Unary
3. Both A and B
4. None of the above

 

63. Numbers of operand used by Binary Operators are?

बाइनरी ऑपरेटरों द्वारा उपयोग किए जाने वाले ऑपरेंड की संख्या हैं?

1. 1
2. 2
3. 3
4. 4

 

64. When an expression includes ___ SQL operator(s), the sequence in which they are evaluated is known as the SQL operator’s precedence.

जब किसी व्यंजक में ___ SQL ऑपरेटर शामिल होते हैं, तो जिस क्रम में उनका मूल्यांकन किया जाता है, उसे SQL ऑपरेटर की प्राथमिकता के रूप में जाना जाता है।

1. 0
2. 1
3. Multiple
4. NULL

 

65. Which one of the syntaxes given below is of Binary Operator?

नीचे दिए गए सिंटेक्स में से कौनसा एक बाइनरी ऑपरेटर का है?

1. Operator SQL _Operand
2. Operand1 SQL _Operator Operand1
3. Operand2 SQL _Operator Operand1
4. Operand1 SQL _Operator Operand2

 

66. Which of the statement is true?

इनमें से कौन सा कथन सत्य है?

1. The precedence-high operators are evaluated first in SQL.
2. The precedence-low operators are evaluated last in SQL.
3. Both A and B
4. None of the above

 

67. Which of the following statement is correct?

निम्नलिखित में से कौन सा कथन सही है?

1. Identity Operator has higher precedence than Multiplication Operator.
2. Comparison Operator has higher precedence than Conjuction Operator.
3. Both A and B
4. None of the above

 

68. Select the correct order of precedence among the following?

निम्नलिखित में से वरीयता के सही क्रम का चयन करें?

1. OR > NOT > + > **
2. ** > + > OR > NOT
3. NOT > OR > ** > +
4. ** > + > NOT > OR

 

69. Which of these are the types of operators?

इनमें से कौन से ऑपरेटर के प्रकार हैं?

1. Arithmetic
2. Set
3. Comparison
4. All of the above

 

70. Which of the following statement is TRUE for SQL Additional Operator?

SQL Additional Operator के लिए निम्न में से कौन सा कथन सत्य है?

1. SELECT operand1-operand2;
2. SELECT operand1>operand2;
3. SELECT operand1+operand2;
4. SELECT operand1*operand2;

SQL MCQ questions and answers pdf

71. Which of the following is NOT the SQL Arithmetic Operator?

निम्न में से कौन SQL Arithmetic Operator नहीं है?

1. Addition
2. Modulus
3. Unary
4. Subtraction

 

72. The numerical values of two ___ of the ___ table can be easily subtracted using SQL Subtraction Operator.

SQL Subtraction Operator का उपयोग करके ___ तालिका के दो ___ के संख्यात्मक मानों को आसानी से घटाया जा सकता है।

1. Rows, different
2. Columns, same
3. Rows, same
4. Columns, different

 

73. SQL Division operator divides the operand on the ____ side by the operand on the ____ side.

SQL डिवीजन ऑपरेटर ऑपरेंड को ____ तरफ ऑपरेंड द्वारा ____ तरफ विभाजित करता है।

1. Left, Left
2. Right, Right
3. Left, Right
4. Right, Left

 

74. Which of the following statement is correct for SQL Multiplication Operator?

निम्नलिखित में से कौन सा कथन SQL Multiplication Operator के लिए सही है?

1. SELECT Operand1+Operand2;
2. SELECT Operand1*Operand2;
3. SELECT Operand1**Operand2;
4. SELECT Operand1<Operand2;

 

75. The SQL Modulus Operator returns the _________.

SQL मापांक ऑपरेटर _________ देता है।

1. Quotient
2. Sum
3. Percentage
4. Reminder

 

76. Using which SQL Comparison Operator can we find the data that matches our query?

किस SQL तुलना ऑपरेटर का उपयोग करके हम अपनी क्वेरी से मेल खाने वाला डेटा ढूंढ सकते हैं?

1. SQL Greater Than Operator (>)
2. SQL Equal Operator (=)
3. SQL Not Equal Operator (!=)
4. SQL Less Than Operator (<)

 

77. Which of the following is not the SQL Comparison Operator?

निम्न में से कौन SQL Comparison Operator नहीं है?

1. SQL Equal Operator (=)
2. SQL Greater Than Operator (>)
3. SQL Less Than Operator (<)
4. All of the above

 

78. Which of the following is not a SQL Logical Operator?

निम्न में से कौन SQL लॉजिकल ऑपरेटर नहीं है?

1. SQL Equal Operator
2. SQL BETWEEN Operator
3. SQL ANY Operator
4. SQL IN Operator

 

79. Which of the following is a SQL Logical Operator?

निम्न में से कौन एक SQL लॉजिकल ऑपरेटर है?

1. SQL LIKE Operator
2. SQL OR Operator
3. SQL ALL Operator
4. All of the above

 

80. Types of SQL Commands are –

SQL कमांड के प्रकार हैं –

1. DDL
2. DCL
3. DML
4. All of the above

SQL Interview Questions and Answers

81. Commands that comes under DDL is/are –

DDL के अंतर्गत आने वाले कमांड हैं/हैं –

1. CREATE
2. TRUNCATE
3. DROP
4. All of the above

 

82. Full form of DDL is –

DDL का फुल फॉर्म है-

1. Data Describe Language
2. Data Distinct Language
3. Data Definition Language
4. Definition Data Language

 

83. Full form of DML is –

DML का फुल फॉर्म है-

1. Data Modify Language
2. Data Manipulation Language
3. Data Multiplication Language
4. Data Mapping Language

 

84. Command that comes under DML is/are –

DML के अंतर्गत आने वाला कमांड है/हैं –

1. GRANT
2. ROLLBACK
3. UPDATE
4. All of the above

 

85. Which of the following is/are TRUE about DDL command?

निम्नलिखित में से कौन डीडीएल कमांड के बारे में सही है/हैं?

1. With the DDL commands, any structural changes can be made to the table, including creation, deletion, and alteration.
2. Our data is stored in a table that is described by the schema, thus DDL commands deal with the schema.
3. Both A. and B.
4. None of the above

 

86. Select the correct statement.

सही कथन का चयन करें।

1. With the DDL commands, any structural changes can be made to the table, including creation, deletion, and alteration.
2. With the DCL commands, any structural changes can be made to the table, including creation, deletion, and alteration.
3. With the DML commands, any structural changes can be made to the table, including creation, deletion, and alteration.
4. With the TCL commands, any structural changes can be made to the table, including creation, deletion, and alteration.

 

87. Command that comes under DCL is/are –

DCL के अंतर्गत आने वाली कमांड है/हैं –

1. REVOKE
2. GRANT
3. Both A. and B.
4. None of the above

 

88. Full form of DCL is –

डीसीएल का फुल फॉर्म है –

1. Data Control Language
2. Data Common Language
3. Data Commit Language
4. Data Concatenate Language

 

89. Full form of TCL is –

टीसीएल का फुल फॉर्म है –

1. Transaction Common Language
2. Transaction Concatenate Language
3. Transaction Commit Language
4. Transaction Control Language

 

90. What is TRUE about SAVEPOINT?

SAVEPOINT के बारे में क्या सच है?

1. A transaction can be rolled back to its last saved state.
2. Following the completion of a transaction, it must be executed to save all the operations performed in the transaction.
3. A specific part of a transaction can be given a name
4. None of the above

SQL MCQ questions and answers pdf

91. Commands that come under TCL is/are –

टीसीएल के अंतर्गत आने वाले कमांड हैं/हैं –

1. COMMIT
2. SAVEPOINT
3. ROLLBACK
4. All of the above

 

92. Following the completion of a transaction, it must be executed to save all the operations performed in the transaction. Here we are talking about which command?

लेन-देन के पूरा होने के बाद, लेन-देन में किए गए सभी कार्यों को Save करने  के लिए इसे निष्पादित किया जाना चाहिए। यहां हम किस कमांड की बात कर रहे हैं?

1. ROLLBACK
2. COMMIT
3. REVOKE
4. SAVE

 

93. Which of the following statement(s) is/are TRUE about DCL?

निम्नलिखित में से कौन सा/से कथन डीसीएल के बारे में सत्य है/हैं?

1. The DCL commands in SQL allow us to grant privileges to a user on the SQL database and its table(s), or revoke privileges that have already been granted.
2. There will be certain privileges that each user has; consequently, the data can be accessed by them.
3. The DCL commands in SQL allow us to control which users have access to the data stored in SQL tables.
4. All of the above

 

94. Difference between GRAND & REVOKE command is/are?

GRAND और REVOKE कमांड के बीच अंतर है/हैं?

1. The GRANT command can be used to grant a user access to databases and tables whereas The REVOKE command can be used to revoke all access privileges already assigned to the user.
2. A transaction can be rolled back to its last saved state.
3. The REVOKE command can be used to grant a user access to databases and tables whereas The GRANT command can be used to revoke all access privileges already assigned to the user.
4. None of the above

 

95. The table records can be retrieved using which command?

टेबल रिकॉर्ड्स को किस कमांड का उपयोग करके पुनः प्राप्त किया जा सकता है?

1. CREATE
2. SELECT
3. RETRIEVE
4. ALTER

 

96. The records and structure of a table may be removed or deleted from the database using which command?

तालिका के रिकॉर्ड और संरचना को किस कमांड का उपयोग करके डेटाबेस से हटाया जा सकता है?

1. REMOVE
2. TRUNCATE
3. DROP
4. DELETE

 

97. Which command will remove the records from the table, but not affect the structure of the table?

कौन सी कमांड टेबल से रिकॉर्ड्स को हटा देगी, लेकिन टेबल की संरचना को प्रभावित नहीं करेगी?

1. REMOVE
2. DELETE
3. TRUNCATE
4. DROP

 

98. Select the correct statement.

सही कथन का चयन करें।

1. DDL consist of 4 commands
2. DCL consist of 2 commands
3. TCL consist of 5 commands
4. DML consist of 3 commands

 

99. Which of the following is TRUE about SQL Auto Increment?

SQL ऑटो इंक्रीमेंट के बारे में निम्नलिखित में से कौन सा सत्य है?

1. It increments the unique number automatically.
2. It keeps the unique number constant
3. It decrements the unique number automatically.
4. None of the above

 

100. Which of the following is TRUE about TCL?

टीसीएल के बारे में निम्नलिखित में से कौन सा सत्य है?

1. Transactions can be saved to the database and rolled back with the help of TCL commands in SQL.
2. Our data is stored in a table that is described by the schema, thus TCL commands deal with the schema.
3. There will be certain privileges that each user has; consequently, the data can be accessed by them using TCL.
4. SQL TCL commands can be used to perform any kind of retrieval or manipulation of the data present in SQL tables.

SQL Interview Questions and Answers

So friend I hope you enjoy this article related to SQL MCQ questions and answers pdf, SQL question asked in interview, SQL questions and answers, SQL questions and answers mcq, SQL questions for interview

MCQ questions and answers pdf Download

SQL mcq questions pdf, SQL Interview questions and answers, SQL MCQ questions and answers pdf, SQL multiple choice questions and answers

File Name	SQL Interview Questions and Answers pdf
File Size	724 KB
No. of Pages	28
Language	Hindi and English
Download	Click Here

 

Related Searches: SQL basic mcq questions, Mysql mcq questions with answers pdf, SQL commands mcq questions, SQL mcq questions answers, SQL mcq practice questions, SQL mcq questions in Hindi, SQL multiple choice questions and answers for experienced