Q 50. Explain SQL Having statement? Ans : HAVING is used to specify a condition for a group or an aggregate function used in the sele...
Showing posts with label DBMS. Show all posts
Showing posts with label DBMS. Show all posts
Saturday
Define SQL Order by the statement?
Q 49. Define SQL Order by the statement? Ans : The ORDER BY statement in SQL is used to sort the fetched data in either ascending or ...
What are ACID properties?
Q 48. What are ACID properties? Ans : A transaction is a single logical unit of work that accesses and possibly modifies the contents ...
What is the need for group functions in SQL?
Q 47. What is the need for group functions in SQL? Ans : In database management, group functions, also known as aggregate functions, ...
Are NULL values the same as zero or a blank space?
Q 46. Are NULL values the same as zero or a blank space? Ans : In SQL, zero or blank space can be compared with another zero or blank...
How can you fetch common records from two tables?
Q 45. How can you fetch common records from two tables? Ans : The below statement could be used to get data from multiple tables, so, ...
How to find the available constraint information in the table?
Q 44. How to find the available constraint information in the table? Ans : In SQL Server the data dictionary is a set of database tabl...
What are Nested Triggers?
Q 44. What are Nested Triggers? Ans : A trigger can also contain INSERT, UPDATE, and DELETE logic within itself, so when the trigger i...
What is ETL in SQL?
Q 43. What is ETL in SQL? Ans : ETL is a process in Data Warehousing. It stands for Extract, Transform, and Load. It is a process in w...
What is the SQL query to display the current date?
Q 42. What is the SQL query to display the current date? Ans : CURRENT_DATE returns to the current date. This function returns the sam...
How to find the available constraint information in the table?
Q 41. How to find the available constraint information in the table? Ans : In SQL Server the data dictionary is a set of database tabl...
How to copy tables in SQL?
Q 40. How to copy tables in SQL? Ans : Sometimes, in SQL, we need to create an exact copy of an already defined (or created) table. My...
What is a Live Lock?
Q 39. What is a Live Lock ? Ans : Livelock occurs when two or more processes continually repeat the same interaction in response to ch...
How do we avoid getting duplicate entries in a query without using the distinct keyword ?
Q 38. How do we avoid getting duplicate entries in a query without using the distinct keyword ? Ans : DISTINCT is useful in certain ci...
The difference between NVL and NVL2 functions?
Q 37. The difference between NVL and NVL2 functions ? Ans : These functions work with any data type and pertain to the use of null val...
Wednesday
What is Case WHEN in SQL?
Q 36. What is Case WHEN in SQL? Control statements form an important part of most languages since they control the execution of other ...
What is the difference between COALESCE() & ISNULL()?
Q 35. What is the difference between COALESCE() & ISNULL()? Ans : COALESCE(): COALESCE function in SQL returns the first non-NULL...
Name the operator which is used in the query for appending two strings?
Q 34. Name the operator which is used in the query for appending two strings ? Ans : In SQL for appending two strings, the ” Concentra...
Can we disable a trigger? If yes, how?
Q 33. Can we disable a trigger? If yes, how? Ans : Yes, we can disable a trigger in PL/SQL. If consider temporarily disabling a trigge...
What is SQL injection?
Q 32. What is SQL injection? Ans : SQL injection is a technique used to exploit user data through web page inputs by injecting SQL com...
Popular Posts
-
Indian Army MNS B.Sc Nursing Previous Papers Download PDF Indian Army B.Sc Nursing Previous Question Papers PDF Download: St... -
Mathematical symbols , गणितीय चिन्ह / प्रतीक 1) + = जोड़ (sum) 2) - = घटाव (subtraction) 3) × ... -
Indian army tradesman question paper set - 01 download pdf ,model paper, Sample question paper ,based on Indian army tradesman previous y... -
"कनक कनक ते सौगुनी, मादकता अधिकाय, वा खाए बौरात, नर या पाए बौराय" इन पंक्तियों में कौन सा अलंकार है一 उपमा अलंकार यमक अलंकार अनु... -
अनेक शब्दों के लिए एक शब्द , Anek shabdo ke liye ek shabd वाक्यांश के लिए एक शब्द जो कभी बूढ़ा न हो (jo kabhe... -
WhatsApp Group links for Indian Army ,CISF ,BSF ,ITBP, SSC GD , CRPF, NIA, GK PDF, Math , Hindi , Reasoning PDF and Job Updates and Ne... -
Indian Army Soldier GD Sample And Previous Year Papers PDF 2022-2023 Indian army Soldier GD Sample Model practice set question paper - 01,... -
CISF Head Constable Arihant Book pdf CISF Practice set - 1 Free PDF सीआईएसएफ अभ्यास सेट - 1 मुक्त पीडीएफ Click here to D... -
अनेक शब्दों के लिए एक शब्द, Anek shabdo ke liye ek shabd जिसके समान कोई दूसरा न हो(jiske saman koi dusra na ho ) = अद्वितीय द...
-
SSC Constable (GD) 2023-24 CRPF , CISF , BSF, SSB , NIA , ITBP , SSF and Assam Rifles
