CMPTR
3rd Edition
ISBN: 9781337681872
Author: PINARD
Publisher: Cengage
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Question
error_outline
This textbook solution is under construction.
Students have asked these similar questions
Which view is used to filter and look at the data in a table, without changing the structure of the file?
A.Report
B.Data
C.Dashboard
D.Model
which DML keyword is used to make change to existing records in a table?
a) Insert
b) Select
c) Update
d) Delete
136.
Which statement is true regarding external tables?
a.
The default REJECT LIMIT for external tables is UNLIMITED
b.
The data and metadata for an external table are stored outside the database
c.
ORACLE_LOADER and ORACLE_DATAPUMP have exactly the same functionality when used with an external table
d.
The CREATE TABLE AS SELECT statement can be used to unload data into regular table in the database from an external table
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
- What is the format of the SET clause that changes the value in a column to null in an UPDATE command?arrow_forwardIf you are using Access 2016, do the following. Add a field to the Client table named AvailableCredit. Set the field to currency. Create a data macro associated with the After Update event for the Client table. When a user updates the Balance field, the macro should subtract the new balance from the credit limit and place that value in the AvailableCredit field. Create a data macro associated with the After Delete event for the OrderLine table. When a user deletes a record because it is complete or cancelled, the macro should look up the order number in the WorkOrders table and delete it there as well. Use the For Each Record in the WorkOrders table. Hint: You can use the OLD keyword in the Where Condition: [Old].[OrderNum] = [WorkOrders].[OrderNum]. Test the data macro by deleting a record from the OrderLine table and ensuring that the record also is deleted from the WorkOrders table.arrow_forwardTo copy data from one table and paste it into another, what command should you use to do so?arrow_forward
- CREATE TABLE keyvalue ( id SERIAL, key VARCHAR(128) UNIQUE, value VARCHAR(128) UNIQUE, created_at TIMESTAMPTZ NOT NULL DEFAULT NOW(), updated_at TIMESTAMPTZ NOT NULL DEFAULT NOW(), PRIMARY KEY(id) ); Add a stored procedure so that every time a record is updated, the updated_at variable is automatically set to the current timearrow_forwardA specific command is required in order to copy data inside tables as well as copy data across tables.arrow_forwardCreate a form to insert/update/delete medicine details into the database. in c# (. Pharmacy Store)arrow_forward
- What index would you recommend, and what command would you use? SELECT P_CODE, P_DESCRIPT, P_QOH, P_PRICE, V_CODE FROM PRODUCT WHERE V_CODE = '21344' ORDER BY P_CODE;arrow_forwardWhat command should be used to copy and paste data from one table to another?arrow_forwardWhich command should you use to copy data from one table and have it added to an existing table?arrow_forward
arrow_back_ios
arrow_forward_ios
Recommended textbooks for you
A Guide to SQLComputer ScienceISBN:9781111527273Author:Philip J. PrattPublisher:Course Technology Ptr
- Np Ms Office 365/Excel 2016 I NtermedComputer ScienceISBN:9781337508841Author:CareyPublisher:Cengage
A Guide to SQL
Computer Science
ISBN:9781111527273
Author:Philip J. Pratt
Publisher:Course Technology Ptr
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:9781337508841
Author:Carey
Publisher:Cengage
dml in sql with examples; Author: Education 4u;https://www.youtube.com/watch?v=WvOseanUdk4;License: Standard YouTube License, CC-BY