DBMS Interviewfragen und Antworten
Test your skills through the online practice test: DBMS Quiz Online Practice Test
Verwandte Vergleiche
Frage 26. What’s the difference between “UNION” and “UNION ALL”?
UNION SQL syntax is used to select information from two tables. But it selects only distinct
records from both the table, while UNION ALL selects all records from both the tables.
Ist das hilfreich?
Kommentar hinzufugen
Kommentare ansehen
Frage 27. What are cursors and what are the situations you will use them?
SQL statements are good for set at a time operation. So it is good at handling set of data. But
there are scenarios where we want to update row depending on certain criteria. we will loop
through all rows and update data accordingly. There’s where cursors come in to picture.
Ist das hilfreich?
Kommentar hinzufugen
Kommentare ansehen
Frage 28. What is " Group by " clause?
“Group by” clause group similar data so that aggregate values can be derived.
Ist das hilfreich?
Kommentar hinzufugen
Kommentare ansehen
Frage 29. What is the difference between “HAVING” and “WHERE” clause?
“HAVING” clause is used to specify filtering criteria for “GROUP BY”, while “WHERE” clause applies on normal SQL.
Ist das hilfreich?
Kommentar hinzufugen
Kommentare ansehen
Frage 30. What is a Sub-Query?
A query nested inside a SELECT statement is known as a subquery and is an alternative to
complex join statements. A subquery combines data from multiple tables and returns results
that are inserted into the WHERE condition of the main query. A subquery is always enclosed within parentheses and returns a column. A subquery can also be referred to as an inner query and the main query as an outer query. JOIN gives better performance than a subquery when you have to check for the existence of records.
For example, to retrieve all EmployeeID and CustomerID records from the ORDERS table that have the EmployeeID greater than the average of the EmployeeID field, you can create a nested query, as shown:
SELECT DISTINCT EmployeeID, CustomerID FROM ORDERS WHERE EmployeeID > (SELECT AVG(EmployeeID) FROM ORDERS)
Ist das hilfreich?
Kommentar hinzufugen
Kommentare ansehen
Am hilfreichsten laut Nutzern:
- What is database or database management systems (DBMS)?
- What is SQL?
- What's the difference between file and database? Can files qualify as a database?
- What are E-R diagrams?
- What’s difference between DBMS and RDBMS?