-
编辑 删除
047-109
109. Which two statements are true regarding roles? (Choose two.)A. A role can be granted to itself.B. A role can be granted to PUBLIC.C. A user can be granted only one role at any point of time.D. Th...
-
编辑 删除
047-108
108. View the Exhibit and examine the details for the CATEGORIES_TAB table.Evaluate the following incomplete SQL statement:SELECT category_name,category_descriptionFROM categories_tabYou want to displ...
-
编辑 删除
047-107
107. Which statement is true regarding the SESSION_PRIVS dictionary view?A. It contains the current object privileges available in the user session.B. It contains the current system privileges availab...
-
编辑 删除
047-106
106. Which statement is true regarding the CUBE operator in the GROUP BYclause of a SQL statement?A. It produces only aggregates for the groups specified in the GROUP BYclause.B. It finds all the NULL...
-
编辑 删除
047-104
104. The user SCOTT who is the owner of ORDERS and ORDER_ITEMS tables issuesthe following GRANT command:GRANT ALL ON orders, order_items TO PUBLIC;What correction needs to be done to the above stateme...
-
编辑 删除
042-103
103. View the Exhibit and examine the structure of EMPLOYEES and JOB_HISTORYtables.The EMPLOYEES table maintains the most recent information regardingsalary, department, and job for all the employees....
-
编辑 删除
047-102
102. Evaluate the following command:CREATE TABLE employees(employee_id NUMBER(2) PRIMARY KEY,last_name VARCHAR2(25) NOT NULL,department_id NUMBER(2),job_id VARCHAR2(8),salary NUMBER(10,2));You issue t...
-
编辑 删除
047-102
102. Evaluate the following command:CREATE TABLE employees(employee_id NUMBER(2) PRIMARY KEY,last_name VARCHAR2(25) NOT NULL,department_id NUMBER(2),job_id VARCHAR2(8),salary NUMBER(10,2));You issue t...
-
编辑 删除
047-101
101. Which statement is true regarding synonyms?A. Synonyms can be created for tables but not views.B. Synonyms are used to reference only those tables that are owned by anotheruser.C. A public synony...
-
编辑 删除
047-100
100. Which two statements are true regarding the GROUP BY clause in a SQLstatement? (Choose two.)A. You can use column alias in the GROUP BY clause.B. Using the WHERE clause after the GROUP BY clause ...
-
编辑 删除
047-098
98. View the Exhibit and examine the data in EMP and DEPT tables.In the DEPT table, DEPTNO is the PRIMARY KEY.In the EMP table, EMPNO is the PRIMARY KEY and DEPTNO is the FOREIGN KEYreferencing the DE...
-
编辑 删除
047-097
97. View the Exhibit and examine the description for EMPLOYEES andDEPARTMENTS tables.Evaluate the following SQL statement:SELECT e.department_id, e.job_id, d.location_id, sum(e.salary) totalFROM emplo...
-
编辑 删除
047-096
96. View the Exhibit and examine the structure of ORDERS and ORDER_ITEMStables.ORDER_ID is the primary key in the ORDERS table. It is also the foreignkey in the ORDER_ITEMS table where in it is create...
-
编辑 删除
047-094
94. View the Exhibit and examine the description of the EMPLOYEES andDEPARTMENTS tables.You want to display the LAST_NAME for the employees,LAST_NAME for the manager of the employees,and the DEPARTMEN...
-
编辑 删除
047-093
93. The ORDERS table belongs to the user OE. OE has granted the SELECTprivilege on the ORDERS table to the user HR.Which statement would create a synonym ORD so that HR can execute thefollowing query ...
-
编辑 删除
047-083
83. View the Exhibit and examine the structure of the ORDERS table.You have to display ORDER_ID, ORDER_DATE, and CUSTOMER_ID for all thoseorders that were placed after the last order placed by the cus...
-
编辑 删除
047-081
81. View the Exhibit and examine the ORDERS table.The ORDERS table contains data and all orders have been assigned a customerID. Which statement would add a NOT NULL constraint to the CUSTOMER_IDcolum...
-
编辑 删除
047-077
77. View the Exhibit and examine the descriptions for ORDERS and ORDER_ITEMStables.Evaluate the following SQL statement:SELECT o.customer_id, oi.product_id, SUM(oi.unit_price*oi.quantity) "OrderAmount...
-
编辑 删除
047-076
76. View the Exhibit and examine the structure of the ORDERS table.Which UPDATE statement is valid?A. UPDATE orders SET order_date = '12mar2007',order_total IS NULL WHERE order_id = 2455;B. UPDATE ord...
-
编辑 删除
047-075
75. View the Exhibit and examine the structure of the EMPLOYEES table.You want to know the FIRST_NAME and SALARY for all employees who have thesame manager as that of the employee with the first name ...
