- 博客(61)
- 资源 (5)
- 收藏
- 关注
原创 OCP-1Z0-051-2015-61题
QUESTION NO: 61You created an ORDERS table with the following description:Exhibit:You inserted some rows in the table. After some time, you want to alter the table by creating thePRIMARY
2015-12-10 16:48:22
340
原创 OCP-1Z0-051-2015-60题
QUESTION NO: 60View the Exhibit and examine the structure of the CUSTOMERS and CUST_HISTORY tables.The CUSTOMERS table contains the current location of all currently active customers. TheCUS
2015-12-10 16:36:30
367
原创 OCP-1Z0-051-2015-59题
QUESTION NO: 59Evaluate the following two queries:Exhibit:Which statement is true regarding the above two queries?A. Performance would improve in query 2 only if there are null values in
2015-12-10 16:29:25
306
原创 OCP-1Z0-051-2015-58题
QUESTION NO: 58You are currently located in Singapore and have connected to a remote database in Chicago.You issue the following command:Exhibit:PROMOTIONS is the public synonym for the pu
2015-12-10 16:18:36
375
原创 OCP-1Z0-051-2015-57题
QUESTION NO: 57Examine the structure of the MARKS table:Exhibit:Which two statements would execute successfully? (Choose two.)A. SELECT student_name,subject1FROM marksWHERE subject1 >
2015-12-10 16:05:46
298
原创 OCP-1Z0-051-2015-56题
QUESTION NO: 56Examine these statements:CREATE ROLE registrar;GRANT UPDATE ON student_grades TO registrar;GRANT registrar to user1, user2, user3;What does this set of SQL statements do?A.
2015-12-10 15:57:21
261
原创 OCP-1Z0-051-2015-55题
You work as a database administrator at ABC.com. You study the exhibit carefully.Exhibit:Which two SQL statements would execute successfully? (Choose two.)A.UPDATE promotionsSET promo_cost =
2015-12-10 15:31:58
284
原创 OCP-1Z0-051-2015-54题
QUESTION NO: 54Which statements are correct regarding indexes? (Choose all that apply.)A. For each data manipulation language (DML) operation performed, the corresponding indexesare automaticall
2015-12-10 15:23:11
416
原创 OCP-1Z0-051-2015-53题
QUESTION NO: 53The PRODUCTS table has the following structure:nvl如果 不为空即是自己,nvl2如果prod_expiry_date 不为空即是prod_expiry_date +15nvl如果prod_expiry_date 为空即是prod_expiry_date+15,nvl2如果prod_expiry_da
2015-12-10 14:59:06
362
原创 OCP-1Z0-051-2015-52题
QUESTION NO: 52View the Exhibit and evaluate structures of the SALES, PRODUCTS, and COSTS tables.Which statement is true regarding the above compound query?A. It shows products that have
2015-12-10 14:50:36
242
原创 OCP-1Z0-051-2015-51题
QUESTION NO: 51Examine the structure of the EMPLOYEES table:Which UPDATE statement is valid?A.UPDATE employeesSET first_name = ‘John’SET last_name = ‘Smith’WHERE employee_id = 180;
2015-12-10 14:42:36
307
原创 OCP-1Z0-051-2015-50题
QUESTION NO: 50View the Exhibits and examine the structures of the PROMOTIONS and SALES tables.Which statement is true regarding the output of the above query?A. It gives details of prod
2015-12-10 14:34:46
285
原创 OCP-1Z0-051-2015-49题
QUESTION NO: 49Examine the structure of the EMPLOYEES and NEW_EMPLOYEES tables:Which DELETE statement is valid?A. DELETE FROM employeesWHERE employee_id = (SELECT employee_id FROM employees)
2015-12-10 11:44:28
258
原创 OCP-1Z0-051-2015-48题
QUESTION NO: 48Which two statements are true regarding views? (Choose two.)A. A sub query that defines a view cannot include the GROUP BY clauseB. A view is created with the sub query having the
2015-12-10 11:41:18
251
原创 OCP-1Z0-051-2015-47题
QUESTION NO: 47Which three are true? (Choose three.)A. A MERGE statement is used to merge the data of one table with data from another.39B. A MERGE statement replaces the data of one table wit
2015-12-10 11:20:54
306
原创 OCP-1Z0-051-2015-46题
QUESTION NO: 46Which three statements are true regarding the data types in Oracle Database 10g/11g? (Choosethree.)A. The BLOB data type column is used to store binary data in an operating system
2015-12-10 11:13:01
360
原创 OCP-1Z0-051-2015-45题
QUESTION NO: 45You work as a database administrator at ABC.com. You study the exhibit carefully.Exhibit:You want to create a SALE_PROD view by executing the following SQL statements:
2015-12-09 17:55:51
242
原创 OCP-1Z0-051-2015-44题
QUESTION NO: 44See the Exhibits and examine the structures of PRODUCTS, SALES and CUSTOMERS table:You issue the following query:Which statement is true regarding the outcome of this quer
2015-12-09 16:12:20
322
原创 OCP-1Z0-051-2015-43题
QUESTION NO: 43Exhibit contains the structure of PRODUCTS table:Evaluate the following query:What would be the outcome of executing the above SQL statement?A. It produces an errorB. It s
2015-12-09 15:11:53
294
原创 OCP-1Z0-051-2015-42题
QUESTION NO: 42You issue 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 in the table are
2015-12-09 14:56:38
383
原创 OCP-1Z0-051-2015-41题
QUESTION NO: 41See the structure of the PROGRAMS table:Which two SQL statements would execute successfully? (Choose two.)A. SELECT NVL(ADD_MONTHS(END_DATE,1),SYSDATE)FROM programs;B. S
2015-12-08 18:33:01
306
原创 OCP-1Z0-051-2015-40题
Which two are true about aggregate functions? (Choose two.)A. You can use aggregate functions in any clause of a SELECT statement.B. You can use aggregate functions only in the column list of the
2015-12-08 18:10:20
422
原创 OCP-1Z0-051-2015-39题
You need to calculate the number of days from 1st Jan 2007 till date:Dates are stored in the default format of dd-mm-rr.Which two SQL statements would give the required output? (Choose two.)A. S
2015-11-09 17:49:48
270
原创 OCP-1Z0-051-2015-38题
See the Exhibit and Examine the structure of the CUSTOMERS table:Using the CUSTOMERS table, you need to generate a report that shows an increase in the creditlimit by 15% for all customers. Cust
2015-11-09 16:35:36
694
原创 OCP-1Z0-051-2015-37题
See the exhibit and examine the structure of the CUSTOMERS and GRADES tables:You need to display names and grades of customers who have the highest credit limit.Which two SQL statements would ac
2015-11-09 15:42:28
308
原创 OCP-1Z0-051-2015-36题
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 ord_detai
2015-07-22 17:59:15
325
原创 OCP-1Z0-051-2015-35题
Examine the description of the EMP_DETAILS table given below:Exhibit:Which two statements are true regarding SQL statements that can be executed on theEMP_DETAIL table? (Choose two.)A. An EM
2015-07-22 17:25:39
380
原创 OCP-1Z0-051-2015-34题
Which two statements are true regarding the COUNT function? (Choose two.)A. COUNT(*) returns the number of rows including duplicate rows and rows containing NULL value in any of the columnsB. COUN
2015-07-22 17:05:30
484
原创 OCP-1Z0-051-2015-33题
Which are /SQL*Plus commands? (Choose all that apply.)A. INSERTB. UPDATEC. SELECTD. DESCRIBEE. DELETEF. RENAMEAnswer: DExplanation:Describe is a valid iSQL*Plus/ SQL*Plus command.I
2015-07-16 17:47:26
312
原创 OCP-1Z0-051-2015-32题
View the Exhibit and examine the structure of the PROMOTIONS table.You have to generate a report that displays the promo name and start date for all promos thatstarted after the last promo i
2015-07-01 18:37:05
261
原创 OCP-1Z0-051-2015-31题
QUESTION NO: 31Which two statements about sub queries are true? (Choose two.)关于子查询A. A sub query should retrieve only one row.B. A sub query can retrieve zero or more rows.C. A sub query can b
2015-07-01 18:25:48
460
原创 OCP-1Z0-051-2015-30题
View the Exhibit and examine the description for the CUSTOMERS table.You want to update the CUST_CREDIT_LIMIT column to NULL for all the customers, whereCUST_INCOME_LEVEL has NULL in the CUSTOME
2015-07-01 17:55:01
386
原创 OCP-1Z0-051-2015-29题
View the Exhibit and examine the structure of the CUSTOMERS table.NEW_CUSTOMERS is a new table with the columns CUST_ID, CUST_NAME and CUST_CITYthat have the same data types and size as the co
2015-07-01 17:41:32
404
原创 OCP-1Z0-051-2015-28题
QUESTION NO: 28Which two statements are true regarding working with dates? (Choose two.)日期格式A. The default internal storage of dates is in the numeric formatB. The RR date format automatically c
2015-07-01 17:17:11
373
原创 OCP-1Z0-051-2015-27题
QUESTION NO: 27Which statement is true regarding the UNION operator?A. The number of columns selected in all SELECT statements need to be the same在所有SELECT语句中选择的列的数量必须相同。正确B. Names of all co
2015-07-01 16:58:36
1384
原创 OCP-1Z0-051-2015-26题
QUESTION NO: 26Which two statements are true regarding single row functions? (Choose two.)A. They can be nested only to two levelsB. They always return a single result row for every row of a que
2015-06-28 18:49:24
390
原创 OCP-1Z0-051-2015-25题
Evaluate the following SQL query;select trunc(round(156.00,-1)-1) from dual;What would be the outcome?A. 200B. 16C. 160D. 150E. 100Answer: CExplanation:Function PurposeROUND
2015-06-28 18:30:01
287
原创 OCP-1Z0-051-2015-24题
QUESTION NO: 24Examine the statement:Create synonym emp for hr.employees;What happens when you issue the statement?A. An error is generated.B. You will have two identical tables in the HR sc
2015-06-28 18:16:22
254
原创 OCP-1Z0-051-2015-23题
Evaluate this SQL statement:SELECT e.emp_name, d.dept_nameFROM employees eJOIN departments dUSING (department_id)WHERE d.department_id NOT IN (10,40)ORDER BY dept_name;The statement fail
2015-06-28 15:30:21
334
原创 OCP-1Z0-051-2015-22题
The ORDERS TABLE belongs to the user OE. OE has granted the SELECT privilege on theORDERS table to the user HR.Which statement would create a synonym ORD so that HR can execute the following query
2015-06-25 18:37:24
212
oracle 数据库常用数据字典梳理.docx
2020-08-14
p6880880_112000_Linux-x86-64.zip
2020-08-14
联想E470声卡驱动audio[r0dac20w].exe
2019-11-29
OPatch patch of version 11.2.0.3.19 for Oracle_AIX平台
2018-05-10
Oracle Interim Patch Installer version 11.2.0.3.19
2018-05-10
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人