Kinds of SQL commands
Briefly explains the three kinds of SQL commands?
Expert
Data definition language commands are employed to alter, create, and drop tables. Data manipulation commands are employed to modify, insert, query, and update data in the database. Data control language commands assist the DBA to control the database.
Elucidate briefly what is the mapping variables and mapping parameters?
Explain what is meant by the term stored procedures?
Briefly describe the ETL procedure in data warehousing?
Explain and compare a procedure and a trigger?
What do you understand by the term SQL view in DBMS? Briefly describe the utilization of views?
Specify the different Multidimensional analysis methods which are available in the Business Objects?
When is a functional dependency F considers as to be minimal?
Write a short note on the difference between the disjoint and overlap rule.
Elucidate briefly power center repository?
State difference between Passive and Active transformation?
18,76,764
1926420 Asked
3,689
Active Tutors
1458854
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!