-
编辑 删除
047-133
133. Which three statements are true? (Choose three.)A. Only one LONG column can be used per table.B. A TIMESTAMP data type column stores only time values with fractionalseconds.C. The BLOB data type ...
-
编辑 删除
047-133
133. Which three statements are true? (Choose three.)A. Only one LONG column can be used per table.B. A TIMESTAMP data type column stores only time values with fractionalseconds.C. The BLOB data type ...
-
编辑 删除
047-132
132. View the Exhibit and examine the structure for the ORDERS and ORDER_ITEMStables.You want to display ORDER_ID, PRODUCT_ID, and TOTAL (UNIT_PRICEmultiplied by QUANTITY) for all the orders placed in...
-
编辑 删除
047-131
131. Which view would you use to display the column names and DEFAULT valuesfor a table?A. DBA_TABLESB. DBA_COLUMNSC. USER_COLUMNSD. USER_TAB_COLUMNSAnswer: DSELECT COLUMN_NAME,DECODE(DATA_TYPE,'DATE'...
-
编辑 删除
047-130
130. Which three statements are true regarding single-row functions? (Choosethree.)A. They can accept only one argument.B. They can be nested up to only two levels.C. They can return multiple values o...
-
编辑 删除
047-127
127. Which statements are true regarding the usage of the WITH clause incomplex correlated subqueries?(Choose all that apply.)A. It can be used only with the SELECT clause.B. The WITH clause can hold ...
-
编辑 删除
047-125
125. Which three statements are true regarding the WHERE and HAVING clausesin a SQL statement?(Choose three.)A. The HAVING clause conditions can have aggregate functions.B. The HAVING clause condition...
-
编辑 删除
047-124
124. View the Exhibit and examine the description of the EMPLOYEES table.Evaluate the following SQL statement:SELECT employee_id, last_name, job_id, manager_id, LEVELFROM employees START WITH employee...
-
编辑 删除
047-123
123. View the Exhibit and examine the structure of the ORDERS and ORDER_ITEMStables.In the ORDERS table, ORDER_ID is the PRIMARY KEY and ORDER_DATE hasthe DEFAULT value as SYSDATE.Evaluate the followi...
-
编辑 删除
047-122
122. Which two statements best describe the benefits of using the WITH clause?(Choose two.)A. It enables users to store the results of a query permanently.B. It enables users to store the query block ...
-
编辑 删除
047-120
120. Which two statements are true regarding constraints? (Choose two.)A. A foreign key cannot contain NULL values.B. A column with the UNIQUE constraint can contain NULL.C. A constraint is enforced o...
-
编辑 删除
047-119
119. View the Exhibit and examine the data in the PRODUCT_INFORMATION table.Which two tasks would require subqueries? (Choose two.)A. displaying the minimum list price for each product statusB. displa...
-
编辑 删除
047-118
118. Which statement correctly differentiates a system privilege from anobject privilege?A. System privileges can be granted only by the DBA where as object privilegescan be granted by DBAs or the own...
-
编辑 删除
047-117
117. View the Exhibit and examine the structure of ORDERS and CUSTOMERStables.Evaluate the following UPDATE statement:UPDATE (SELECT order_date, order_total, customer_id FROM orders)SETorder_date = '2...
-
编辑 删除
047-116
116. Given below is the list of meta. character syntaxes and their descriptionsin random order:Meta. character syntax Description1) ^ a) Matches character not in the list2) [^...] b) Matches character...
-
编辑 删除
047-115
115. View the Exhibit and examine the details of the PRODUCT_INFORMATIONtable.You have the requirement to display PRODUCT_NAME and LIST_PRICE fromthe table where the CATEGORY_ID column has values 12 o...
-
编辑 删除
047-114
114. Which statements are true? (Choose all that apply.)A. The data dictionary is created and maintained by the databaseadministrator.B. The data dictionary views can consist of joins of dictionary ba...
-
编辑 删除
047-113
113. Evaluate the SQL statements:CREATE TABLE new_order(orderno NUMBER(4),booking_date TIMESTAMP WITH LOCAL TIME ZONE);The database is located in San Francisco where the time zone is -8:00.The user is...
-
编辑 删除
047-112
112. View the Exhibit and examine the details of the EMPLOYEES table.Evaluate the following SQL statements:Statement 1:SELECT employee_id, last_name, job_id, manager_idFROM employees START WITH employ...
-
编辑 删除
047-111
111. View the Exhibit and examine the data in the EMPLOYEES tables.Evaluate the following SQL statement:SELECT employee_id, department_idFROM employees WHERE department_id= 50 ORDER BY department_idUN...
