ITPub博客

（56）View the Exhibit and examine the structure of the PROMOTIONS table.Using the PROMOTIONS table, you need to find out the names and cost of all the promos done on 'TV' and 'internet' that ended in the time interval 15th March 00 to 15th October 00.Which two queries would give the required...

（55）Evaluate the following two queries:SELECT cust_last_name, cust_cityFROM customersWHERE cust_credit_limit IN (1000, 2000, 3000);SELECT cust_last_name, cust_cityFROM customersWHERE cust_credit_li...

（52）View the Exhibit and examine the structure of the PRODUCTS table.Using the PRODUCTS table, you issue the following query to generate the names, current list price, and discounted list price for all those productswhose list price falls below $10 after a discount of 25% is applied on it....

（53）View the Exhibit and examine the data in the PROMOTIONS table. PROMO_BEGIN_DATE is stored in the default date format, dd-mon-rr.You need to produce a report that provides the name, cost, and start date of all promos in the POST category that were launched before January 1, 2000.Which SQ...

（57）The CUSTOMERS table has the following structure:name                         Null            &nbsp...

（54）View the Exhibit and examine the structure of the CUSTOMERS table. Evaluate the query statement:SELECT cust_last_name, cust_city, cust_credit_limitFROM customersWHERE cust_last_name BETWEEN 'A' AND 'C'AND cust_credit_limit BE...

2014.05.131. Oracle事务控制问题：http://www.itpub.net/thread-1866500-1-1.htmlORACLE 事务控制问题ORACLE 事务控制问题

（50）SLS is a private synonym for the SH.SALES table. The user SH issues the following command: DROP SYNONYM sls;Which statement is true regarding the above SQL statement?A. Only the synonym would be dropped.B. The synonym would be dropped and the corresponding table would become invalid...

（47）View the Exhibit and examine the structure of ORD and ORD_ITEMS tables.The ORD_NO column is PRIMARY KEY in the ORD table and the ORD_NO and ITEM_NO columns are composite PRIMARY KEY in the ORD_ITEMS table.Which two CREATE INDEX statements are valid? (Choose two.)A. ...

（49）The ORDERS table belongs to the user OE. OE has granted the SELECT privilege on the ORDERS table to the user HR.Which statement would create a synonym ORD so that HR can execute the following query successfully?（choose two)SELECT * FROM ord;A. This com...

（45） Which two statements are true about sequences created in a single instance database? (Choose two.)A. The numbers generated by a sequence can be used only for one table.B. DELETE <sequencename> would remove a sequence from the database.C. CURRVAL is used to refer to the last sequenc...

（44）View the Exhibit and examine the structure of the ORD table.Evaluate the following SQL statements that are executed in a user session in the specified order:CREATE SEQUENCE ord_seq;SELECT ord_seq.nextval FROM dual;INSERT INTO ord VALUES ...

（43）Evaluate the following CREATE SEQUENCE statement:CREATE SEQUENCE seq1START WITH 100INCREMENT BY 10MAXVALUE 200 CYCLE NOCACHE;The SEQ1 sequence has generated numbers up to the maximum limit of 200. You issue ...

（41）Which two statements are true regarding views? (Choose two.)A. A subquery that defines a view cannot include the GROUP BY clause.B. A view that is created with the subquery having the DISTINCT keyword can be updated.C. A view that is created with the subquery having the pseudo colum...

（48）Which two statements are true regarding indexes? (Choose two.)A. They can be created on tables and clusters.B They can be created on tables and simple views.C. You can create only one index by using the same columns.D. You can create more than one index by using the same columns...

（46）Which statements are correct regarding indexes? (Choose all that apply.)A. When a table is dropped, the corresponding indexes are automatically dropped.B. A FOREIGN KEY constraint on a column in a table automatically creates a nonunique index.C. A nondeferrable PRIMARY KEY or UNIQUE...

（42）Which three statements are true regarding views? (Choose three.)A. Views can be created only from tables.B. Views can be created from tables or other views.C. Only simple views can use indexes existing on the underlying tables.D. Both simple and complex views can use indexes exi...

（32）Which CREATE TABLE statement is valid?A.CREATE TABLE ord_details(  ord_no   NUMBER(2) PRIMARY KEY,  item_no  NUMBER(3) PRIMARY KEY,  ord_date DATE N...

（38）Which two statements are true regarding views? (Choose two.)A. A simple view in which column aliases have been used cannot be updated.B. Rows cannot be deleted through a view if the view definition contains the DISTINCT keyword.C. Rows added through a view are deleted from the table...

（36）Examine the following SQL commands:CREATE TABLE products(  prod_id      NUMBER(3) CONSTRAINT p_ck CHECK (prod_id > 0),  prod_name CHAR(30),  prod_qty &nbs...