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 is DDL? Make a list of commands with short description used in DDL
Ans: Data Definition Language that is abbreviated as DDL is a computer language for defining data structures. The phrase was first introduced in relation to the Codasyl database model in which the schema of the database was written in a Data Definition Language explaining the records, fields, and "sets" making up the user Data Model.
List of DDL commands:
(a) To define a table/ relation
CREATE TABLE ------
(b) To eliminate table/relation definition
DROP TABLE ----
(iii) To alter the definition of an existing table
ALTER TABLE-------
Determine the steps of path in association network You can analyse use of paths in association network in the following steps: Examine every operation and see what asso
What is database utility? Database utility is the interface among the ABAP/4 Dictionary and the underlying the SAP system.
State The position of object at any moment is called state. An object can have many states depend upon time. After receiving some input instructions, the object can change its
Consider the relation schemas as follows. works (person name, company name, salary); lives (person name, street, city); located in(company name, city); managers (person name
Use the IRIS dataset that comes with Weka to compare the classification performance of the following algorithms. 1. NaiveBayesSimple 2. MultiLayerPerceptron J48 (
Ask Write the SQL code that will create the table structure for a table named EMP _1. This table is a subset of the EMPLOYEE table. The basic EMP_1 table structure is summarized in
In case of entity integrity, the primary key may be declared? In a case of entity integrity primary key may be not Null.
What is difference between primary index and secondary index? Primary Index a) It is an ordered file whose records are of fixed length along with two fields. b) Only base
What is the difference between SQL Server 2000 complete and differential backups? A complete backup makes a copy of the whole database. A differential backup creates a copy of
Database Administrator One of the main perpose for having the database management system is to have control of both data or programs accessing that data. The person having li
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: +1-415-670-9521
Phone: +1-415-670-9521
Email: [email protected]
All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd