Computer Science 1. Data type assignment is optional for each field. Group of answer choices True False 2. The records of a table can be entered manually or imported from other sources. Group of answer choices True False 3. You can import records from another Access database table ONLY. Group of answer choices True False

Computer Science 1. Data type assignment is optional for each field. Group of answer choices True False 2. The records of a table can be entered manually or imported from other sources. Group of answer choices True False 3. You can import records from another Access database table ONLY. Group of answer choices True False

A Guide to SQL

9th Edition

ISBN:9781111527273

Author:Philip J. Pratt

Publisher:Philip J. Pratt

Chapter7: Database Administration

Section: Chapter Questions

Problem 4TD: Write, but do not execute, the commands to grant the following privileges: a. User Ashton must be...

See similar textbooks

Similar questions

Create a MYSQL Database named 'db'Create a MYSQL User named 'dbuser' with a password 'dbpass' Grant Insert, Delete, Update and Select privileges for 'dbuser' on 'db' Create a MYSQL Table on database 'db' and name it as 'students' with the following field and field propertiesField Name Field Type Field Size Additional İnformationStudent No Varchar 6 Primary keyName Varchar 20 Surname Varchar 25 birthdate date
Devise a datasheet in access based on a subject table that allows a user to enter information about a subject. Your subject table should have at least ten (10) fields, including:- A primary key field to identify the record ([aut*-RecordIdentifier]).- A single field alternate key.- AT least one date field.- At least one number field.- The standard fields.- Any other fields that you think are appropriate.
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.
Which of the following represents a field in a table? a record a row a column an entity
5. Web services serve their data to a browser. True False 6. When MVC is applied to a Web service only, the Controller MVC component is present. True False 7. One of the responsibilities of the Controller in MVC is to Select proper Models for Views True False
Acording to the table in the image Database Using MySQL commands, answer the following questions ; (i) Display matrixnum, name from table students and total_marks, grade from table assessments. (ii) Display matrixnum, name from table students, subject_code, sub_name from table subjects and total_marks, grade from table assessments. (iii) Update name Afif to Syed Afif (iv) Insert the following data to table students Matrixnum: S0003 Name: Raudah (v) Delete the data entered in question (iv)
You have a frequent itemset I={football, cricket, swimming, climbing} that contains 4 items. What does it mean when you say that I is a maximal itemset? a. There is no other frequent itemset for the given dataset b. a) There is no superset of I that is a frequent itemset c. The set {cricket, swimming, climbing} is not frequent d. All frequent itemsets have 4 items Look at the command for the Document Database below. What does it do? db.superheroes.insert{ { collection: “people”, forename: “Bruce”, surname: “Banner”, age: 40 } }; a. It deletes a record for Bruce Banner b. a) It inserts a record for Bruce Banner in the collection superheroes c. It inserts the record for Bruce Banner in the collection people d. It creates a new collection for Bruce Banner in the collection people
There are three tables in this database (see image). Write MYSQL code for: (1) Create a trigger “insert_inventory” on table “Inventory”. The trigger is fired after a row is inserted in table “Inventory”. After a row is inserted in table “inventory”, the “itemid”, the insertion time, and the action is inserted in table “Inventory_history”. The action is set to ‘add an item’. The oldprice is set to null. Test your trigger by inserting a row into Inventory and displaying the contents of Inventory_history. (2) Create a trigger “change_quantity” on table “Transaction”. The trigger is fired after a row is inserted in table “Transaction”. After a row is inserted in table “Transaction”, update the “quantity” in table “Inventory”. For example, if 3 iWatch are sold, then the quantity of iWatch in table “Inventory” is decreased by 3. Test your trigger by inserting a row into Transaction and displaying the contents of the relevant row in Inventory. (3) Create a trigger “change_price” on table…
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.
Which of the following is a document database? a. MongoDB b. Base c. Neo4J d. InfluxDB We have an itemset I whose support is 20. Further we know that seven of the sets that contain I also contain j. What is the confidence of the association rule I→j? a. 7/20 b. 20/7 c. 13/20 d. 7/13
Use five classes to organize the above raw data; use class-limits → 41-46, 47-52, 53-58, 59-64, 65-70.a) Create a table with (i) Class-limits; (ii) Class-boundaries; (iii) Class-mid-points (??); (iv)Frequencies (?); (v) Relative ?; (vi) Cumulative ?. [Follow the same pattern as done with Excelin class. If you want, you can create the Table in Excel, then copy and paste into your Word document]b) Plot a Histogramc) Plot a Frequency Polygond) Plot an Ogive
what is DataGridView control ?