Oracle 12c: SQL
3rd Edition
ISBN: 9781305251038
Author: Joan Casteel
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Concept explainers
Question
error_outline
This textbook solution is under construction.
Students have asked these similar questions
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 commands can you use to modify an index?
MODIFY INDEX
ALTER TABLE
none of the above
ALTER SESSION
ALTER INDEX
Which of the following data dictionary objects should be used to view information about the constraints in a database? ( refer to the tables in the JustLee Books database). a. USER_TABLES b. USER_RULES c. USER_COLUMNS d. USER_CONSTRAINTS e. None of the above objects should be used
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.arrow_forwardWhich object in the data dictionary enables you to verify DEFAULT column settings? DEFAULT_COLUMNS DEF_TAB_COLUMNS USER_TAB_COLUMNS None of the abovearrow_forwardWrite, 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.arrow_forward
- Which of the following is a correct statement? You can restore the data deleted with the DROP COLUMN clause, but not the data deleted with the SET UNUSED clause. You can’t create empty tables—all tables must contain at least three rows of data. A table can contain a maximum of 1000 columns. The maximum length of a table name is 265 characters.arrow_forwardWhich of the following statements is correct? A table can contain a maximum of only one column marked as unused. You can delete a table by removing all columns in the table. Using the SET UNUSED clause allows you to free up storage space used by a column. None of the above statements are correct.arrow_forwardIn the formula below, which references will update when copied? =$C$3+$E7 a. Row 3 b. Row 7 c. Column C d. Column Earrow_forward
- Which of the following functions can be used to substitute a value for a NULL value? (refer to the tables in the JustLee Books database.)a. NVLb. TRUNCc. NVL2d. SUBSTRe. both a and df. both a and carrow_forwardWhich of the following statements is correct? (refer to the tables in the JustLee Books database) a. A table can contain a maximum of only one column marked as unused. b. You can delete a table by removing all columns in the table. c. Using the SET UNUSED clause allows you to free up storage space used by a column. d. None of the above statements are correct.arrow_forwardWhich of the following is a correct statement? ( refer to the tables in the JustLee Books database) a. You can restore the data deleted with the DROP COLUMN clause, but not the data deleted with the SET UNUSED clause. b. You can’t create empty tables—all tables must contain at least three rows of data. c. A table can contain a maximum of 1000 columns. d. The maximum length of a table name is 265 characters.arrow_forward
- what would you be looking for with the following query? filetype:txt administrator:500:arrow_forward. Which of the following is not a valid statement? (refer to the tables in the JustLee Books database) a. You can change the name of a table only if it doesn’t contain any data.b. You can change the length of a column that doesn’t contain any data.c. You can delete a column that doesn’t contain any data.d. You can add a column to a table.arrow_forwardMy update button does not work, when i press edit to update data. i get an unidentified index. Plz help! EDIT_PRODUCT.PHP <?php // Get the product data $category_id = $_POST['category_id']; $code = $_POST['code']; $name = $_POST['name']; $price = $_POST['price']; $product_id = $_POST['productID']; // Validate inputs if (empty($code) || empty($name) || empty($price)) { $error = "Invalid product data. Check all fields are try again."; include('error.php'); } else { // If valid, add the product to the database require_once('database.php'); $query = "UPDATE products SET categoryID = $category_id, productCode = $code, productName = $name, listPrice = $price WHERE productID = $product_id"; $db->exec($query); // Display the Product List page include('index.php'); } EDIT_PRODUCT_FORM.PHP <?php // get post values $product_id = $_POST['product_id']; // This is the drop down menu next to 'Category:' require('database.php'); $query = 'SELECT * FROM categories ORDER BY…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Programming with Microsoft Visual Basic 2017Computer ScienceISBN:9781337102124Author:Diane ZakPublisher:Cengage LearningA Guide to SQLComputer ScienceISBN:9781111527273Author:Philip J. PrattPublisher:Course Technology Ptr
Programming with Microsoft Visual Basic 2017
Computer Science
ISBN:9781337102124
Author:Diane Zak
Publisher:Cengage Learning
A Guide to SQL
Computer Science
ISBN:9781111527273
Author:Philip J. Pratt
Publisher:Course Technology Ptr
dml in sql with examples; Author: Education 4u;https://www.youtube.com/watch?v=WvOseanUdk4;License: Standard YouTube License, CC-BY