wangjx的专栏

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

33. You want to create an ORD_DETAIL table to store details for an order placed having the following business requirement: 1) The order ID will be unique and cannot have null values. 2) The order

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 colum

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; SE

43. Evaluate the following CREATE SEQUENCE statement: CREATE SEQUENCE seq1 START WITH 100 INCREMENT BY 10 MAXVALUE 200 CYCLE NOCACHE; The SEQ1 sequence has generated numbers up to the ma

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 defi

31. Evaluate the following SQL commands: SQL>CREATE SEQUENCE ord_seq INCREMENT BY 10 START WITH 120 MAXVALUE 9999 NOCYCLE; SQL>CREATE TABLE ord_items (ord_no NUMBER(4)D

29. Which two statements are true regarding constraints? (Choose two.) A. A foreign key cannot contain NULL values. B. The column with a  UNIQUE  constraint can store NULLS . C. A constraint is

27. Which two statements are true regarding tables? (Choose two.) A. A table name can be of any length. B. A table can have any number of columns. C. A column that has a DEFAULT value cannot sto

26. Which is the valid CREATE TABLE statement? A. CREATE TABLE  emp9$#  (emp_no NUMBER (4)); B. CREATE TABLE  9emp$#  (emp_no NUMBER(4)); C. CREATE TABLE  emp*123  (emp_no NUMBER(4)); D. CRE

25. You need to create a table with the following column specifications: 1. Employee ID (numeric data type) for each employee 2. Employee Name (character data type) that stores the employee name 

35. Which two statements are true regarding constraints? (Choose two.) A. A table can have only one primary key and one foreign key. B. A table can have only one primary key but multiple foreign k

36. Examine the following SQL commands:   SQL>CREATE TABLE warehouse ( warehouse_id NUMBER(4), roomno NUMBER(10) CONSTRAINT r_id CHECK(roomno BETWEEN 101 AND 200), location VARCHAR2(25), 

39. Evaluate the following command:  CREATE TABLE employees (employee_id      NUMBER(2) PRIMARY KEY,  last_name        VARCHAR2(25) NOT NULL,  department_id    NUMBER(2)NOT NULL,  job_id    

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 q

40. View the Exhibit to examine the description for the SALES and PRODUCTS tables. You want to create a SALE_PROD view  by executing the following SQL statement: CREATE VIEW sale_prod AS SELECT p

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 would remov

37. You issued the following command to drop the PRODUCTS table: SQL> DROP TABLE products; What is the implication of this command? (Choose all that apply.) A. All data along with the table stru

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 th

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 in

34. You created an ORDERS table with the following description: name                Null            Type ORD_ID              NOT NULL        NUMBER(2) CUST_ID             NOT NULL        NUMBER(

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 NOT NULL); B. CREATE TABLE

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 in

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 DI

23. Examine the structure proposed for the TRANSACTIONS table: name                    Null      Type TRANS_ID               NOT NULL NUMBER(6) CUST_NAME              NOT NULL VARCHAR2(20) CUS

20. Which three statements are true regarding the data types in Oracle Database 10g/11g? (Choose three.) （在Oracle10g和11g中，关于数据类型，哪三个陈述是正确的？）A. Only one LONG column can be used per table. B. A TI

15. View the Exhibit and examine the data in the CUSTOMERS table.  Evaluate the following query: SQL> SELECT cust_name AS "NAME", cust_credit_limit/2 AS MIDPOINT,MIDPOINT+100 AS "MAX LOWER LIMIT"

7. Which two  statements are true regarding the USING and ON clauses in table joins? (Choose two.)A. Both USING and ON clauses can be used for equijoins and nonequijoins. B. A maximum of one p

8. View the Exhibit and examine the structure of the CUSTOMERS table.Which two tasks would require subqueries or joins to be executed in a single statement? (Choose two.)（题意：题目给出了一个Customer

10. View the Exhibit and examine the structure of the PROMOTIONS table.Each promotion has a duration of at least seven days .Your manager has asked you to generate a report, which provides t

9. Which statement is true regarding the INTERSECT operator?A. It ignores NULL values.B. Reversing the order of the intersected tables alters the result.C. The names of columns in all SELE

6. Examine the structure of the SHIPMENTS table:name                    Null       　　TypePO_ID          　　   NOT NULL    NUMBER(3)PO_DATE     　　    NOT NULL    DATESHIPMENT_DATE    NOT

4. Which two statements are true regarding single row functions? (Choose two.)A. They a ccept only a single argument.B. They can be nested only to two levels.C. Arguments can only be colum

17. View the E xhibit and examine the data in the EMPLOYEES table. You want to generate a report showing the total compensation paid to each employee to  date. You issue the following query: W

14. Using the CUSTOMERS table,  you need to generate a report that shows 50% of each credit amount in each income level. The report should NOT show any repeated credit amounts in each income level

2. View the Exhibit to examine the description for the SALES table.Which views can have all DML operations performed on it? (Choose all that apply.) A. CREATE VIEW v3AS SELECT * FROM

18. Examine the structure of the PROMOTIONS table: name            Null       Type PROMO_ID        NOT NULL    NUMBER(6) PROMO_NAME      NOT NULL    VARCHAR2(30) PROMO_CATEGORY NOT NULL    VAR

21. Examine the description of the EMP_DETAILS table given below: name               NULL                 TYPE EMP_ID             NOT NULL             NUMBER EMP_NAME           NOT NULL        

22. You need to create a table for a banking application. One of the columns in the table has the following requirements: 1) You want a column in the table to store the duration of the credit period

19. Evaluate the following query: SELECT INTERVAL '300' MONTH, INTERVAL '54-2' YEAR TO MONTH, INTERVAL '11:12:10.1234567' HOUR TO SECOND FROM dual; What is the correct output of the above query