junerux-CSDN博客

原创 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