DBMS में, 'MERGE' ___________ का SQL स्टेटमेंट है।

In DBMS, 'MERGE' is the SQL statement of ___________.

[A] DDL

[B] DML

[C] DAL

[D] DSL

Correct Answer : DML

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

Which statement is not true?

[A] SQL is rational whereas No-SQL is non-rational.

[B] SQL follows BASE Model whereas No-SQL follows ACID Model.

[C] SQL database are vertically scalable whereas No-SQL database are horizontally scalable.

[D] No-SQL databases are preferable to store hierarchical data in comparison SQL databases.

Correct Answer : SQL follows BASE Model whereas No-SQL follows ACID Model.

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

Which of the following is not an SQL Statement?

[A] SELECT Statement

[B] UPDATE Statement

[C] TRUNCATE TABLE Statement

[D] FROM Statement

Correct Answer : FROM Statement

SQL SELECT कथन में निम्नलिखित में से कौन सा खंड दी गई शर्तों के अनुसार पंक्तियों को फ़िल्टर करने के लिए उपयोग किया जाता है?

Which of the following clauses in SQL SELECT statement is used to filter the rows s per the given conditions ?

[A] WHERE

[B] ORDER BY

[C] FROM

[D] GROUP BY

Correct Answer : WHERE

निम्नलिखित में से कौन सा SQL कथन किसी तालिका में नया कॉलम जोड़ने के लिए उपयोग किया जाता है?

Which of the following SQL statements is used to add a new column in a table ?

[A] CHANGE TABLE

[B] UPDATE TABLE

[C] TRUNCATE TABLE

[D] ALTER TABLE

Correct Answer : ALTER TABLE

निम्नलिखित में से कौन सा एक DDL SQL कमांड है?

Which of the following is a DDL SQL command ?

[A] INSERT

[B] CREATE

[C] DELETE

[D] UPDATE

Correct Answer : CREATE

निम्नलिखित में से कौन सा रिलेशनल डेटाबेस प्रबंधन प्रणाली नहीं है?

Which of the following is not a relational database management system?

[A] Oracle

[B] SQL-Server

[C] MangoDB

[D] MySQL

Correct Answer : MySQL

_________ क्लॉज़ एक अतिरिक्त फ़िल्टर है जो SQL स्टेटमेंट में सेट परिणाम पर लागू होता है।

The __________ clause is an additional filter that is applied to the result set in a SQL statement.

[A] Group by

[B] Order by

[C] Having

[D] Select

Correct Answer : Having

एसक्यूएल का पूर्ण रूप क्या है?

What is the full form of SQL?

[A] Structured Queuing Language

[B] Structured Query Language

[C] Structured Queuing Lexicon

[D] Simple Query Language

Correct Answer : Structured Query Language

निम्नलिखित में से कौन सा NoSQL डेटाबेस प्रकार है?

Which of the following is a NoSQL Database type?

[A] For Loop

[B] Do While Loop

[C] Do Until Loop

[D] Continue For

Correct Answer : Continue For

मौजूदा दृश्य पर हमारी क्वेरी को सफलतापूर्वक निष्पादित करने की क्या आवश्यकता है?

What is the need for our query to execute successfully on an existing view?

[A] The specified table must contain data

[B] We should have a SELECT privilege only on the specified table

[C] The specified table must be in the same database or schema

[D] We must have a SELECT privilege on the view

Correct Answer : We must have a SELECT privilege on the view

डीएमएल का फुल फॉर्म क्या है?

What is full form of DML?

[A] Data Multiplication Language

[B] Data Manipulation Language

[C] Data Modify Language

[D] Data Mapping Language

Correct Answer : Data Multiplication Language

डीडीएल का फुल फॉर्म क्या है?

What is full form of DDL?

[A] Data Describe Language

[B] Definition Data Language

[C] Data Definition Language

[D] Data Distinct Language

Correct Answer : Data Definition Language