q27 ?Which of the following terms refers to commands that are used to create or modify database tablesdata manipulation language (DML) .adata definition language (DDL) b Odata control language (DCL) .c Odata formatting language (DFL) .d O

?Which of the following terms refers to commands that are used to create or modify database tables data manipulation language (DML) .a O data definition language (DDL) .b O data control language (DCL) .cO data formatting language (DFL) .d O

Programming with Microsoft Visual Basic 2017

8th Edition

ISBN:9781337102124

Author:Diane Zak

Publisher:Diane Zak

Chapter11: Sql Server Databases

Section: Chapter Questions

Problem 1RQ

See similar textbooks

Related questions

Q: What mean the line Code da.Fill(dt) Note da = sqIDataAdapter %3D dt dataTable %3D cmd sqlCommand…

A: According to the guidelines we are restricted to involve with only the first question. - The…

Q: Which of the following can be used to determine whether an index exists?a. DESCRIBE indexname;b. the…

A: An index’s information can be obtained from the views called “USER_INDEXES” and “USER_IND_COLUMNS”.…

Q: Which of the following is an in-memory copy of data pulled from one or more database tables?a. Table…

A: Answer: a. Table adapter

Q: Launch MSSQL program from YOUR computer and ensure command line interface is active. Create a…

A: SQL Server is nothing but database server by Microsoft and the Microsoft relational database…

Q: Which of the following is an inmemory copy of data pulled from one or more database tables? 1. Table…

A: Which of the following is an inmemory copy of data pulled from one or more database tables?1. Table…

Q: Jennífer Smith STUDENT ID: 2340999 EMAIL: jenny@gmail.com PHONE: (330) 902-1111 8400 Market Ave…

A: An XML document begins with the following syntax. <?xml version="1.0" encoding="UTF-8"?>…

Q: Launch MSSQL program from YOUR computer and ensure command line interface is active. Create a…

Q: Which of the following is the best choice for storing and retrieving massive volumes of data in…

A: NoSQL Database is a non-social Data Management System, that doesn't need a decent composition. It…

Q: Each tablespace in an Oracle database consists of one or more files called a. Files b. name space c.…

A: The answer is as follows:-

Q: |1. which one(s) of the following change(s) the name of a database? a) sp_rename d) alter name c)…

A: (Q1)a and cit changes the namer of the database. (Q2) A,B&D these are the attributes which are…

Q: B2. Given the following table "Book" (assume that the name of the database is "exam"). Pages Title…

A: Database using mySQL if one is using xampp server approach admin area of MySQL for creating…

Q: Question 1. Which of the following statements is INCORRECT? S1: Data elements in the database can be…

A: To select which statement is incorrect regarding data dictionary.

Q: b) The following is the HTML code of a form: Student id: Student address: The form is…

A: Answer: <html> <body> <form action = "student.php" method = "post">…

Q: Given the following two pages OrderList.php show.php Show Order Details PHP code HTML source code…

A: Required:

Q: Create a new dataframe named cc2 to store the results of the SQL query you build for this question.…

A: CREATE TABLE CLIENTS( CID numeric(8) primary key, CName varchar(25) not null, Gender…

Q: Which of the following is not a type of MS Access database object? a. Table b. Form c. Worksheets d.…

A: MS Access database:- Microsoft Access is the only application software you need to create apps,…

Q: A University Try to complete the tasks below. Create a MYSQL Database named ' Create a MYSQL User…

Q: 2.2 Basic Database Functions Your database server only needs to support one database. Therefore, all…

A: Below are the answers for both the commands:

Q: Which of the following is false about SQL? Select one: a. SQL can update records in a database b.…

A: SQL is short for Structured Query Language. It is used to create, manipulate and manage database. It…

Q: BNew Database Open Database Write Changes Revert Changes Open Project Save Project Attach Database X…

A: We need to write a sql query that display the student name, course number, credits, and grades by…

Q: Microsoft Access Database Help. Part 1: Create Table Your task is to create 3 tables i.e. (Student…

A: Creating following tables with specified conditions in Microsoft access db Note: Dear user,…

Q: Which of the following statement is not correct? O none. O A Database is a collection of related…

A: Data Base Management System: DBMS is a software that is used to store, manage and use database…

Q: 1. which one(s) of the following change(s) the name of a database? a) sp_rename b) sp_renamedb c)…

A: Note as per our guidelines we are supposed to answer?️ only one question. Kindly repost other…

Q: What are the four basic types of operations for a database application? a. Insert, Select, Update,…

A: What are the four basic types of operations for a database application? a. Insert, Select,…

Q: Which of the keys below are not supported by a relational database? a. Foreign keys b.…

A: Answer : the given question is from database : so here what is relational database? it is a type…

Q: Which of the following is a task performed by the driver according to the ODBC standard? Select…

A: Answer in step2

Q: Write down DML commands to add 1 record into each table you have created in picture below. All…

A: DML(Data Manipulation Language) commands are used to create a table, insert records into the table,…

Q: 19. Which of the followings could be defined as a field in a database?. A. Muhammad Adib Najmi B. SP…

A: BELOW i have answered:

Q: Which of the statements below is incorrect? A database system is a group of applications that allow…

A: GIVEN: Which of the statements below is incorrect? A database system is a group of applications…

Q: Write a query against the Sales.Orders table that returns orders placed in June 2015. 2)Write a…

A: Since you have asked multiple questions, so we have provided answer for first three questions. If…

Q: QUESTION 10 An application that includes data about countries, cities, hotels, ... etc. which…

A: Each and every organization contains a certain amount of data that needs to be stored for future use…

Q: 2. Click the Execute button or press F5 to see the new database in the Object Explorer. 3. Create…

A: The solution to the problem is given below Step 1: Click on New Query option then create new…

Q: Which of the following statement is not correct? O Database System is Suitable for Small…

A: Data Base Management System: DBMS is a software that is used to store, manage and use database…

Q: a) Create a new database as test.db. Create the tables with the following schema using DDL commands.…

A: Note: As per our guidelines we can able to solve only one big question at a time. So, please repost…

Q: You will create a web application to store inventory for products. Choose your business name, logo,…

A: Create a DbContext class and DbSet to map model classes to a database Seed data for your product ...…

Q: What is the division of data saved in a row of a table in a database

A: In a database, data is saved in a row in a table: In most cases, data is kept as rows in a table.

Q: 1.Which keyword is used to create a database? 2.The file created by the server to bu

A: 1. CREATE DATABASE is used to to create a database for example CREATE DATABASE Rajnish; Rajnish…

Q: Create the following tables in a database named "roster". Make sure that your database and tables…

A: I will provide the picture of solution in step 2

Q: How would you add PK to a table, without dropping it, for which no PK was declared with Create.

A: You can add primary key using alter table command. Below is the syntax , set it accordingly .

Q: Which data view in a database is seen by the end-user? O physical view O logical view none of the…

A: The data in the database can be seen by making use of two types of views, physical view and logical…

Q: Question I: These questions are based on Human Resources (HR) database given in site…

A: import pandas as pd A - Question :- departments = pd.read_csv('DEPARTMENTS.csv')…

Q: 5. The EMPLOYEES database has three tables : EMPLOYEE_DATA (EmployeeID, FirstName, LastName,…

A: The EMPLOYEES has three tables: EMPLOYEE_DATA (EmployeeID, FirstName, DateOfBirth, Gender, Level,…

Q: Create a MYSQL Database named 'db' Create a MYSQL User named 'dbuser' with a password 'dbpass' Grant…

A: Structured Query Language is abbreviated as SQL or also pronounced as See-Qwell. It is developed for…

Q: The information about data in a database is called _______ a. Metadata b. Hyper data c. Tera data d.…

A: The information about data in a database is provided in step2.

Q: Open MS Access, create a database named “orderManagement” and perform the following task: - Create a…

A: Steps to create database: Open Access. select File > New. Select Blank database, or select a…

Question

q27

?Which of the following terms refers to commands that are used to create or modify database tables
data manipulation language (DML) .a
data definition language (DDL) b O
data control language (DCL) .c O
data formatting language (DFL) .d O

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

This is a popular solution!

SEE SOLUTION Check out a sample Q&A here

Solution:

VIEW

Explanation:

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions

Which of the following data dictionary objects should be used to view information about the constraints in a database? USER_TABLES USER_RULES USER_COLUMNS USER_CONSTRAINTS None of the above objects should be used.
Which of the following has no partial or transitive dependencies? unnormalized data 1NF 2NF 3NF
Write, but do not execute, the commands to grant the following privileges: a. User Ashton must be able to retrieve data from the ITEM table. b. Users Kelly and Morgan must be able to add new orders and order lines. c. User James must be able to change the price for all items. d. User Danielson must be able to delete customers. e. All users must be able to retrieve each customers number, name, street, city, state,and postal code. f. f User Pere7 must be able to create an index on the ORDFRS table. g. User Washington must be able to change the structure of the ITEM table. h. User Grinstead must have all privileges on the ORDERS table.
Write, but do not execute, the commands to grant the following privileges: a. User Oliver must be able to retrieve data from the CONDO_UNIT table. b. Users Crandall and Perez must be able to add new owners and condo units to thedatabase. c. Users Johnson and Klein must be able to change the condo fee of any unit. d. All users must be able to retrieve the unit number, condo fee, and owner number forevery condo unit. e. User Klein must be able to add and delete service categories. f. User Adams must be able to create an index on the SERVICE_REQUEST table. g. Users Adams and Klein must be able to change the structure of the CONDO_UNITtable. h. User Klein must have all privileges on the LOCATION, OWNER, and CONDO_UNITtables.
Which of the following is a correct statement? a. A commit is issued implicitly when a user exits SQL Developer or SQLPlus. b. A commit is issued implicitly when a DDL command is executed. c. A commit is issued automatically when a DML command is executed. d. All of the above are correct. e. Both a and b are correct. f. Both a and c are correct.
Which of the following is an in-memory copy of data pulled from one or more database tables?a. Table adapterb. Table relationc. Datasetd. Data record
Which of the keys below are not supported by a relational database? a. Foreign keys b. Composite keys c. Dynamic keys d. Primary keys
Forms offer a front-end to database users to enter data into a table, or multiple tables, and may contain buttons to switch between records, add new records, or search for records. True False Which of the following answers most closely represents a constraint on a table? A. A list of values that are preferred but not required for a row B. A rule for a particular row that limits the values that can exist within it C. A rule for a particular column that limits the values that can exist within it D. A list of values that are preferred but not required for a column
Which of the following can be used to determine whether an index exists?a. DESCRIBE indexname;b. the USER_INDEXES viewc. the INDEXES tabled. the USER_INDEX viewe. all of the abovef. none of the above
Which of the following is an inmemory copy of data pulled from one or more database tables? 1. Table adapter 2. Table relation 3. Dataset 4. Data record
Which of the following are true about primary keys? SELECT ALL THAT APPLY. A) They must reference one or more columns in a single table. B) They are usually implemented using an index. C) They guarantee that no two rows in a table have duplicate primary key values. D) They must be defined for every database table.
EF Core API will create which table for the following context? In other words, what would be the table name in the database? public class SchoolContext : DbContext { public DbSet<Student> StudentList { get; set; } } Question 8 options: a) StudentsList b) Student c) Students d) StudentList

SEE MORE QUESTIONS

Recommended textbooks for you

Programming with Microsoft Visual Basic 2017

Computer Science

ISBN:

9781337102124

Author:

Diane Zak

Publisher:

Cengage Learning

Oracle 12c: SQL

Computer Science

ISBN:

9781305251038

Author:

Joan Casteel

Publisher:

Cengage Learning

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781305627482

Author:

Carlos Coronel, Steven Morris

Publisher:

Cengage Learning

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781285196145

Author:

Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel

Publisher:

Cengage Learning

A Guide to SQL

Computer Science

ISBN:

9781111527273

Author:

Philip J. Pratt

Publisher:

Course Technology Ptr

Programming with Microsoft Visual Basic 2017

Computer Science

ISBN:

9781337102124

Author:

Diane Zak

Publisher:

Cengage Learning

Oracle 12c: SQL

Computer Science

ISBN:

9781305251038

Author:

Joan Casteel

Publisher:

Cengage Learning

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781305627482

Author:

Carlos Coronel, Steven Morris

Publisher:

Cengage Learning

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781285196145

Author:

Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel

Publisher:

Cengage Learning

A Guide to SQL

Computer Science

ISBN:

9781111527273

Author:

Philip J. Pratt

Publisher:

Course Technology Ptr

SEE MORE TEXTBOOKS