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.
Whta is the advantage of the database management approach? The advantage of the database management approach is data is integrated and can be accessed by multiple programs.
Which types of data supported by MySQL for Time and Date formats? MySQL supports a number of time and date column formats: Some of them are 1) DATE 2) DATETIME 3) TIM
While using extract datasets it is required to have a special workarea for interface False. It is not required to have a special workarea for interface
What is Hierarchical DBMS In HDBMS, data is structured in a tree like manner. There is a parent-child relationship between data items and the data model is very suitable for re
It can be easily defined as: The database must not have any unmatched foreign key values. The term "unmatched foreign key value" means a foreign key value for which there doe
Aggregation : One limitation of the E-R diagram is that they do not permit representation of relationships between relationships. In such a case the relationship along with its ent
What subschema expresses ? A subschema expresses the external view. (External schemas are called also called as subschemas)
Consider the following relational database: STUDENT (name, student#, class, major) COURSE (course name, course#, credit hours, department) SECTION (section identifier, course#, sem
Complete replication: It implies maintaining of a whole copy of the database at every site. Thus, the reliability & availability and performance for query response are maximized.
Differentiate between strict two-phase and rigorous two-phase with conversion protocol Ans: Strict two-phase locking holds all its exclusive that is write locks until commit t
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