Already have an account? Get multiple benefits of using own account!
Login in your account..!
Remember me
Don't have an account? Create your account in less than a minutes,
Forgot password? how can I recover my password now!
Enter right registered email to receive password!
What are the DBMS languages? Briefly explain?
Data Definition language (DDL):A database schema is specified through a set of definitions expressed through a special language called data definition language. For instance, the subsequent statement in the SQL describes the account table
Create table account (account_number char(10), balance integer)
Execution of the above DDL statement creates the account table. DDL permits a user to specify storage structure and access techniques used through the database system as well as specify certain consistency constraints such as balance of an account should on fall below Rs1000.
Data Manipulation language (DML): A data-manipulation language (DML) is a language which enables users to access or manipulate data as organized through the appropriate data model.
There are basically two types:
1) Procedural DMLs needs a user to specify what data are required and how to get those data. 2) Declarative DMLs (also referred to as nonprocedural DMLs) need a user to specify what data are required without specifying how to get those data.
10A.53 Code an Oracle Database trigger to enforce the constraint that an employee can never change his or her department. 10A.54 Code an Oracle Database trigger to allow the
What is object containment? References among objects can be used to model dissimilar real-world concepts.
What is the difference among a database schema and a database state? The collection of information stored in database at particular moment in time is known as database state a
A relation instance indicates as r is a collection of tuples for a given relational schema at a exact point of time. A relation state r of the relation schema R (A 1 ,A 2 ,.....
Explain data independence ? Data independence is the capacity to modify the schema at one stage of a database system without having to change the schema at the further level.
Describe the tools that are available for managing MySQL Server. Given below are the tools to manage MySQL server: mysqld - MySQL server daemon. This is used to begain t
Write short notes on data ware housing? Data ware housing applications needs the transformation of data from many sources into a cohesive reliable step set of data configured a
1. Which relational algebra operations do not need the participating tables to be union-compatible? Ans: Join is the relational algebra operations that do not need the particip
Hi there, Have an issue with my Database. I have: TblOrderDetails and FmOrderDetails TblCircuit and FmCircuit Whenever I add data into the Form, it will update the table as expect
Introduction In large projects, we can have many different companies working together. Generally, the project or contract is awarded to one company (Principal Contractor), which
Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!
whatsapp: +91-977-207-8620
Phone: +91-977-207-8620
Email: [email protected]
All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd