单选题请观察PRODUCT表和SUPPLIER表的结构: PRODUCT PRODUCT_ID NUMBER NOT NULL, Primary Key PRODUCT_NAME VARCHAR2 (25) SUPPLIER_ID NUMBER ( SUPPLIER表的SUPPLIER_ID的外键) LIST_PRICE NUMBER (7,2) COST NUMBER (7,2) QTY_IN_STOCK NUMBER QTY_ON_ORDER NUMBER REORDER_LEVEL NUMBER REORDER_QTY NUMBER SUPPLIER SUPPLIER_ID NUMBER NOT NULL, Primary Key SUPPLIER_NAME VARCHAR2 (25) ADDRESS VARCHAR2 (30) CITY VARCHAR2 (25) REGION VARCHAR2 (10) POSTAL_CODE VARCHAR2 (11) 请评估以下语句: ALTER TABLE suppliers DISABLE CONSTRAINT supplier_id_pk CASCADE; 该语句用于执行什么任务()A删除引用SUPPLIERS表的所有约束条件B删除对FOREIGNKEY表的FOREIGNKEY约束条件C删除引用PRODUCTS表的所有约束条件D禁用所有依赖于PRODUCTS表的SUPPLIER_ID列的完整性约束条件E禁用所有依赖于SUPPLIERS表的SUPPLIER_ID列的完整性约束条件

单选题
请观察PRODUCT表和SUPPLIER表的结构: PRODUCT PRODUCT_ID NUMBER NOT NULL, Primary Key PRODUCT_NAME VARCHAR2 (25) SUPPLIER_ID NUMBER ( SUPPLIER表的SUPPLIER_ID的外键) LIST_PRICE NUMBER (7,2) COST NUMBER (7,2) QTY_IN_STOCK NUMBER QTY_ON_ORDER NUMBER REORDER_LEVEL NUMBER REORDER_QTY NUMBER SUPPLIER SUPPLIER_ID NUMBER NOT NULL, Primary Key SUPPLIER_NAME VARCHAR2 (25) ADDRESS VARCHAR2 (30) CITY VARCHAR2 (25) REGION VARCHAR2 (10) POSTAL_CODE VARCHAR2 (11) 请评估以下语句: ALTER TABLE suppliers DISABLE CONSTRAINT supplier_id_pk CASCADE; 该语句用于执行什么任务()
A

删除引用SUPPLIERS表的所有约束条件

B

删除对FOREIGNKEY表的FOREIGNKEY约束条件

C

删除引用PRODUCTS表的所有约束条件

D

禁用所有依赖于PRODUCTS表的SUPPLIER_ID列的完整性约束条件

E

禁用所有依赖于SUPPLIERS表的SUPPLIER_ID列的完整性约束条件


参考解析

解析: 暂无解析

相关考题:

FROM product IN db.Product JOIN category IN db.Category ON product.CategoryId equals category.CategoryId SELECT NEW { product.ProductId, product.CategoryId, CategoryName = category.Name},请选择关于这段代码错误的说法是( )。A、所选的数据来自同一数据库的两个不同的数据表B、选出三列数据的列字段的名称分别为ProductId,CategoryId,CategoryNameC、Category 数据表中含有CategoryId和CategoryName两个列字段D、Product 数据表中含有ProductId和CategoryId两个列字段

The journal entry a company uses to record the estimated accrued product warranty liability is ( ) A. debit Product Warranty Expense; credit Product Warranty PayableB. debit Product Warranty Payable; credit CashC. debit Product Warranty Expense; credit CashD. debit Product Warranty Payable; credit Product Warranty Expense

The PRODUCTS table has these columns:PRODUCT_ID NUMBER(4)PRODUCT_NAME VARCHAR2(45)PRICE NUMBER(8,2)Evaluate this SQL statement:SELECT *FROM PRODUCTSORDER BY price, product _ name;What is true about the SQL statement? ()A. The results are not sorted.B. The results are sorted numerically.C. The results are sorted alphabetically.D. The results are sorted numerically and then alphabetically.

Examine the SQL statements that creates ORDERS table: CREATE TABLE orders(SER_NO NUMBER UNIQUE,ORDER_ID NUMBER,ORDER_DATE DATE NOT NULLSTATUS VARCHARD2(10)CHECK (status IN (‘CREDIT‘,‘CASH‘)),PROD_ID_NUMBERREFERENCES PRODUCTS(PRODUCT_ID),ORD_TOTAL NUMBER,PRIMARY KEY (order id, order date));For which columns would an index be automatically created when you execute the aboveSQL statement? ()A. SER_NOB. ORDER_IDC. STATUSD. PROD_IDE. ORD_TOTALF. Composite index on ORDER_ID and ORDER_DATE

Examine the SQL statement that creates ORDERS table:CREATE TABLE orders (SER_NO NUMBER UNIQUE, ORDER_ID NUMBER, ORDER_DATE DATE NOT NULL, STATUS VARCHAR2(10) CHECK (status IN (‘CREDIT‘, ‘CASH‘)), PROD_ID NUMBER REFERENCES PRODUCTS(PRODUCT_ID), ORD_TOTAL NUMBER, PRIMARY KEY (order_id, order_date));For which columns would an index be automatically created when you execute the above SQL statement? ()A. SER_NOB. ORDER_IDC. STATUSD. PROD_IDE. ORD_TOTALF. composite index on ORDER_ID and ORDER_DATE

在oracle数据库中,如何删除sales表中产品类型为toys的profits列的列值?() A.delete from sales;B.delete profits from sales where product_type=’TOYS’;C.delete from sales where product_type=’ToYS’;D.update sales set profits=null where product_type=’TOYS’;

That is the existing product range. "product range" means product portfolio.

PO_DETAILS表包含以下列: PO_NUM NUMBER NOT NULL, Primary Key PO_LINE_ID NUMBER NOT NULL, Primary Key PRODUCT_ID NUMBER Foreign Key to PRODUCT_ID column of the PRODUCTS table QUANTITY NUMBER UNIT_PRICE NUMBER(5,2) 请评估以下语句: ALTER TABLE po_details DISABLE CONSTRAINT po_details_pk CASCADE;此语句用于完成什么任务()A、新创建一个对PO_NUM列的PRIMARYKEY约束条件B、删除并重新创建对PO_NUM列的PRIMARYKEY以及FOREIGNKEY的约束条件C、禁用依赖于PO_NUM列的所有FOREIGNKEY约束条件D、禁用对PO_NUM列的约束条件,同时创建PRIMARYKEY索引

Why is the Cisco Integrated Services Router product line A good choice for customers?()A、it is A point product solution that addresses A single needB、it provides customers with an opportunity to increase the number of devices in their networkC、it simplifies purchasing because there is only one model to choose.D、it integrates multiple services into A single platform and reduces operating costs.

数据库中的中的PROFITS表中PRODUCT_NAME与SALE_PERIOD列建立主键。下列哪个语句无法定义这个主键?()A、create table profits(product_name varchar2(10),sale_perion varchar2(10),profit number, constraint pk_profits_01 primary key(product_name,sale_period))B、alter table profits add constraint pk_profits_01 primary key(product_name,sale_period)deferrablC、以上两者都是

请根据PRODUCT_NAME列从PRODUCT表查询中过滤返回的数据。下列()子句包含相应过滤条件的引用。A、HavingB、SelectC、WhereD、From

在SQL Server 2000的查询分析器中,小李用如下的语句创建视图Create view highSelect*from product where unitprice1000with check option则下列说法正确的是()A、创建了这个视图后,就不能向product表中插入unitptice1000的记录了B、检果项unitprice1000只对视图有效,对product表并无限制C、创建了这个视图后,对该视图和表Product就都有unitprice1000的限制D、创建了这个视图后,就不能向该视图中插入unitprice=1000的记录了

在oracle数据库中,如何删除sales表中产品类型为toys的profits列的列值?()A、delete from salesB、delete profits from sales where product_type=’TOYS’C、delete from sales where product_type=’ToYS’D、update sales set profits=null where product_type=’TOYS’

Evaluate the CREATE TABLE statement:   CREATE TABLE products   (product_id NUMBER (6)  CONSTRAINT prod_id_pk PRIMARY KEY,  product_name VARCHAR2 (15));   Which statement is true regarding the PROD_ID_PK constraint?()A、 It would be created only if a unique index is manually created first.B、 It would be created and would use an automatically created unique index.C、 It would be created and would use an automatically created nonunique index.D、 It would be created and remains in a disabled state because no index is specified in the command.

Examine the SQL statement that creates ORDERS table: CREATE TABLE orders (SER_NO NUMBER UNIQUE, ORDER_ID NUMBER, ORDER_DATE DATE NOT NULL, STATUS VARCHAR2(10) CHECK (status IN ('CREDIT', 'CASH')), PROD_ID NUMBER REFERENCES PRODUCTS(PRODUCT_ID), ORD_TOTAL NUMBER, PRIMARY KEY (order_id, order_date)); For which columns would an index be automatically created when you execute the above SQL statement? () A、SER_NOB、ORDER_IDC、STATUSD、PROD_IDE、ORD_TOTALF、composite index on ORDER_ID and ORDER_DATE

单选题PO_DETAILS表包含以下列: PO_NUM NUMBER NOT NULL, Primary Key PO_LINE_ID NUMBER NOT NULL, Primary Key PRODUCT_ID NUMBER Foreign Key to PRODUCT_ID column of the PRODUCTS table QUANTITY NUMBER UNIT_PRICE NUMBER(5,2) 请评估以下语句: ALTER TABLE po_details DISABLE CONSTRAINT po_details_pk CASCADE;此语句用于完成什么任务()A新创建一个对PO_NUM列的PRIMARYKEY约束条件B删除并重新创建对PO_NUM列的PRIMARYKEY以及FOREIGNKEY的约束条件C禁用依赖于PO_NUM列的所有FOREIGNKEY约束条件D禁用对PO_NUM列的约束条件,同时创建PRIMARYKEY索引

多选题View the Exhibit and examine the data in the PRODUCT INFORMATION table. Which two tasks would require subqueries? ()Adisplaying the minimum list price for each product statusBdisplaying all supplier IDs whose average list price is more than 500Cdisplaying the number of products whose list prices are more than the average list priceDdisplaying all the products whose minimum list prices are more than the average list price of products having the product status orderableEdisplaying the total number of products supplied by supplier 102071 and having product status OBSOLETE

问答题Practice 7  ● You are supposed to write a letter of compliant about the quality of the product when you found the product and after-sales service you bought recently which fell far below the standard you expect.  ● It is necessary to include the information below in the proposed letter:  ● Why are you writing the letter of compliant?  ● Why are you dissatisfied with the newly purchased product?  ● Giving description of the malfunctioned product you bought recently.  ● Explaining the fact that the after-sales service is very poor.  ● What do you ask the supplier to do?  ● Write 200~250 words on your Answer Sheet.

多选题某公司使用SQLServer作为数据信息存储的平台,其中Sales数据库有一个用于存放产品信息的表Products。现在销售部门的人员临时需要一张商品价格表,要求列出所有产品的名称和其单价,并且以中文显示列名,那么下面SQL语句中可以满足条件的是()ASELECT Product Name AS’产品的名称’,Unit Price AS’单价’FROM ProductsBSELECT Product Name=产品的名称,Unit Price=单价FROM ProductsCSELECT Product Name=“产品的名称”,Uni tPrice=“单价”FROM ProductsDSELECT Product Name’产品的名称’,Unit Price’单价’FROM Products

单选题You are modifying a table named Product in a SQL Server 2005 database. You want to add a new column named FriendlyName to the Product table. A friendly name for each product will be stored in this column. The table currently contains data. The sales department has not yet created a friendly name for each product. FriendlyName is a required value for each product. You want to add this new column by using the least amount of effort. What should you do?()ADefine the new column as NULL.Update the FriendlyName column to the same value as the productName column. Alter the FriendlyName column to be NOT NULL.BDefine the new column as NOT NULL with a default value of ’Undefined.’CDefine the new column as NULL. Use application logic to enforce the data constraint.DDefine the new column as NULL with a default value of ’Undefined.’

多选题Examine the SQL statements that creates ORDERS table: CREATE TABLE orders (SER_NO NUMBER UNIQUE, ORDER_ID NUMBER, ORDER_DATE DATE NOT NULL STATUS VARCHARD2(10) CHECK (status IN ('CREDIT','CASH')), PROD_ID_NUMBER REFERENCES PRODUCTS(PRODUCT_ID), ORD_TOTAL NUMBER, PRIMARY KEY (order id, order date)); For which columns would an index be automatically created when you execute the aboveSQL statement? ()ASER_NOBORDER_IDCSTATUSDPROD_IDEORD_TOTALFComposite index on ORDER_ID and ORDER_DATE

多选题Examine the SQL statement that creates ORDERS table: CREATE TABLE orders (SER_NO NUMBER UNIQUE, ORDER_ID NUMBER, ORDER_DATE DATE NOT NULL, STATUS VARCHAR2(10) CHECK (status IN ('CREDIT', 'CASH')), PROD_ID NUMBER REFERENCES PRODUCTS(PRODUCT_ID), ORD_TOTAL NUMBER, PRIMARY KEY (order_id, order_date)); For which columns would an index be automatically created when you execute the above SQL statement? ()ASER_NOBORDER_IDCSTATUSDPROD_IDEORD_TOTALFcomposite index on ORDER_ID and ORDER_DATE

单选题Evaluate the CREATE TABLE statement:   CREATE TABLE products   (product_id NUMBER (6)  CONSTRAINT prod_id_pk PRIMARY KEY,  product_name VARCHAR2 (15));   Which statement is true regarding the PROD_ID_PK constraint?()A It would be created only if a unique index is manually created first.B It would be created and would use an automatically created unique index.C It would be created and would use an automatically created nonunique index.D It would be created and remains in a disabled state because no index is specified in the command.

多选题Examine the SQL statement that creates ORDERS table: CREATE TABLE orders (SER_NO NUMBER UNIQUE, ORDER_ID NUMBER, ORDER_DATE DATE NOT NULL, STATUS VARCHAR2(10) CHECK (status IN ('CREDIT', 'CASH')), PROD_ID NUMBER REFERENCES PRODUCTS(PRODUCT_ID), ORD_TOTAL NUMBER, PRIMARY KEY (order_id, order_date)); For which columns would an index be automatically created when you execute the above SQL statement? ()ASER_NOBORDER_IDCSTATUSDPROD_IDEORD_TOTALFcomposite index on ORDER_ID and ORDER_DATE

单选题The PRODUCTS table has these columns: PRODUCT_ID NUMBER(4) PRODUCT_NAME VARCHAR2(45) PRICE NUMBER(8,2) Evaluate this SQL statement: SELECT * FROM PRODUCTS ORDER BY price, product _ name; What is true about the SQL statement? ()AThe results are not sorted.BThe results are sorted numerically.CThe results are sorted alphabetically.DThe results are sorted numerically and then alphabetically.

多选题在SQL Server 2000的查询分析器中,小李用如下的语句创建视图Create view highSelect*from product where unitprice1000with check option则下列说法正确的是()A创建了这个视图后,就不能向product表中插入unitptice1000的记录了B检果项unitprice1000只对视图有效,对product表并无限制C创建了这个视图后,对该视图和表Product就都有unitprice1000的限制D创建了这个视图后,就不能向该视图中插入unitprice=1000的记录了

单选题“the product in question” in Line 5 Paragraph 2 means _____ .A“the product in the previous question”B“the product under discussion”C“the product on sale”D“the product in doubt”