- ocp考试
- ocp 11g认证考试题：1Z0-051-069题
ocp 11g认证考试题：1Z0-051-069题，完整题库请点击这里联系老师咨询了解69. You need to generate a list of all customer last names with their credit limits from the CUSTOMERStable. Those customers who do not have a credit limit should appear last in the list.Which two queries would ...
- ocp 11g认证考试题：1Z0-051-068题
ocp 11g认证考试题：1Z0-051-068题，完整题库请点击这里联系老师咨询了解68. Which statement is true regarding the default behavior of the ORDER BY clause?A. In a character sort, the values are case- sensitive.B. NULL values are not considered at all by the sort operation.C. Only tho...
- ocp 11g认证考试题：1Z0-051-067题
ocp 11g认证考试题：1Z0-051-067题，完整题库请点击这里联系老师咨询了解67. Which two statements are true regarding the ORDER BY clause? (Choose two.)A. It is executed first in the query execution.B. It must be the last clause in the SELECT statement.C. It cannot be used in a SELECT...
- ocp 11g认证考试题：1Z0-051-066题
ocp 11g认证考试题：1Z0-051-066题，完整题库请点击这里联系老师咨询了解66. View the Exhibit and examine the data in the COSTS table.You need to generate a report that displays the IDs of all products in the COSTS table whose unit price isat least 25% more than the unit cost. The de...
- ocp 11g认证考试题：1Z0-051-065题
ocp 11g认证考试题：1Z0-051-065题，完整题库请点击这里联系老师咨询了解65. View the Exhibit and examine the structure of the CUSTOMERS table.You have been asked to produce a report on the CUSTOMERS table showing the customers detailssorted in descending order of the city and in the...
- ocp 11g认证考试题：1Z0-051-064题
ocp 11g认证考试题：1Z0-051-064题，完整题库请点击这里联系老师咨询了解64. View the E xhibit and examine the data in the PROMO_CATEGORY and PROMO_COST columns of the PROMOTIONS table.Evaluate the following two queries:SQL>SELECT DISTINCT promo_category to_char(promo_cost)"code"F...
- ocp 11g认证考试题：1Z0-051-063题
ocp 11g认证考试题：1Z0-051-063题，完整题库请点击这里联系老师咨询了解63. View the E xhibit and examine the structure of the PRODUCTS table.You want to display only those product names with their list prices where the list price is at least doublethe minimum price. The report shou...
- ocp 11g认证考试题：1Z0-051-062题
ocp 11g认证考试题：1Z0-051-062题，完整题库请点击这里联系老师咨询了解62. View the E xhibit and examine the structure of the CUSTOMERS table.You want to generate a report showing the last names and credit limits of all customers whose last namesstart with A, B, or C, and credit li...
- ocp 11g认证考试题：1Z0-051-061题
ocp 11g认证考试题：1Z0-051-061题，完整题库请点击这里联系老师咨询了解61. View the Exhibit and examine the structure of the PROMOTIONS table.You need to generate a report of all promos from the PROMOTIONS table based on the followingconditions:1. The promo name should not begin wi...
- ocp 11g认证考试题：1Z0-051-060题
ocp 11g认证考试题：1Z0-051-060题，完整题库请点击这里联系老师咨询了解60. View the Exhibit and examine the structure of CUSTOMERS table.Evaluate the following query:SQL>SELECT cust_id, cust_cityFROM customersWHERE cust_first_name NOT LIKE 'A_%g_%' ANDcust_credit_limit BETWEEN 5...
- ocp 11g认证考试题：1Z0-051-059题
ocp 11g认证考试题：1Z0-051-059题，完整题库请点击这里联系老师咨询了解59. View the Exhibit and examine the data in the PRODUCTS table.You need to display product names from the PRODUCTS table that belong to the 'Software/Other 'category with minimum prices as either $2000 or $4000...
- ocp 11g认证考试题：1Z0-051-058题
ocp 11g认证考试题：1Z0-051-058题，完整题库请点击这里联系老师咨询了解58. The PART_CODE column in the SPARES table contains the following list of values:PART_CODEA%_WQ123A%BWQ123AB_WQ123Evaluate the following query:SQL> SELECT part_codeFROM sparesWHERE part_code LIKE '%\%_WQ12%...
- ocp 11g认证考试题：1Z0-051-057题
ocp 11g认证考试题：1Z0-051-057题，完整题库请点击这里联系老师咨询了解57. The CUSTOMERS table has the following structure:name Null TypeCUST_ID NOT NULL NUMBERCUST_FIRST_NAME NOT NULL VARCHAR2(20)CUST_LAST_NAME NOT NULL VARCHAR2(30)CUST_INCOME_LEVEL VARCHAR2(30)CUST_CREDIT_LIMIT N...
- ocp 11g认证考试题：1Z0-051-056题
ocp 11g认证考试题：1Z0-051-056题，完整题库请点击这里联系老师咨询了解56. View the Exhibit and examine the structure of the PROMOTIONS table.Using the PROMOTIONS table, you need to find out the names and cost of all the promos done on 'TV'and 'internet' that ended in the time inte...
- ocp 11g认证考试题：1Z0-051-055题
ocp 11g认证考试题：1Z0-051-055题，完整题库请点击这里联系老师咨询了解55. Evaluate the following two queries:SQL> SELECT cust_last_name, cust_cityFROM customersWHERE cust_credit_limit IN (1000, 2000, 3000);SQL> SELECT cust_last_name, cust_cityFROM customersWHERE cust_credit_...
- ocp 11g认证考试题：1Z0-051-054题
ocp 11g认证考试题：1Z0-051-054题，完整题库请点击这里联系老师咨询了解54. View the Exhibit and examine the structure of the CUSTOMERS table.Evaluate the query statement:SQL> SELECT cust_last_name, cust_city, cust_credit_limitFROM customersWHERE cust_last_name BETWEEN 'A' AND 'C...
- ocp 11g认证考试题：1Z0-051-053题
ocp 11g认证考试题：1Z0-051-053题，完整题库请点击这里联系老师咨询了解53. View the Exhibit and examine the data in the PROMOTIONS table.PROMO_BEGIN_DATE is stored in the default date format, dd-mon-rr.You need to produce a report that provides the name, cost, and start date of all...
- ocp 11g认证考试题：1Z0-051-052题
ocp 11g认证考试题，完整题库请点击这里联系老师咨询了解52. View the Exhibit and examine the structure of the PRODUCTS table.Using the PRODUCTS table, you issue the following query to generate the names, current list price,and discounted list price for all those products whose list...
- ocp 11g认证考试051题库解析：第51题
ocp 11g认证考试051题库解析：第51题，完整题库请点击这里联系老师咨询了解。51. Which statement is true regarding synonyms?A. Synonyms can be created only for a table. 不只是表，schema objectB. Synonyms are used to reference only those tables that are owned by another user.C. A publ...
- ocp 11g认证考试051题库解析：第50题
ocp 11g认证考试051题库解析：第50题，完整题库请点击这里联系老师咨询了解。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 would be dropped.B....
- ocp 11g认证考试051题库解析：第49题
ocp 11g认证考试051题库解析：第49题，完整题库请点击这里联系老师咨询了解。49. The ORDERS table belongs to the user OE. OE has granted the SELECT privilege on the ORDERStable to the user HR.Which statement would create a synonym ORD so that HR can execute the following query succes...
- ocp 11g认证考试051题库解析：第48题
ocp 11g认证考试051题库解析：第48题，完整题库请点击这里联系老师咨询了解。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 index by using the...
- ocp 11g认证考试051题库解析：第47题
ocp 11g认证考试051题库解析：第47题，完整题库请点击这里联系老师咨询了解。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 arecomposite PRIMARY KEY in the ORD_ITEMS table...
- ocp 11g认证考试051题库解析：第46题
ocp 11g认证考试051题库解析：第46题，完整题库请点击这里联系老师咨询了解。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 column in a table ...
- ocp 11g认证考试051题库解析：第45题
ocp 11g认证考试051题库解析：第45题，完整题库请点击这里联系老师咨询了解。45. Which two statements are true about sequences created in a single instance database? (Choosetwo.)A. The numbers generated by a sequence can be used only for one table.B. DELETE would remove a sequence fr...
- ocp 11g认证考试051题库解析：第44题
ocp 11g认证考试051题库解析：第44题，完整题库请点击这里联系老师咨询了解。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;SELECT ord_seq.nextval...
- ocp 11g认证考试051题库解析：第43题
ocp 11g认证考试051题库解析：第43题，完整题库请点击这里联系老师咨询了解。43. Evaluate the following CREATE SEQUENCE statement:CREATE SEQUENCE seq1START WITH 100INCREMENT BY 10MAXVALUE 200CYCLENOCACHE;The SEQ1 sequence has generated numbers up to the maximum limit of 200. You issu...
- ocp 11g认证考试051题库解析：第42题
ocp 11g认证考试051题库解析：第42题，完整题库请点击这里联系老师咨询了解。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 indexes existing o...
- ocp 11g认证考试051题库解析：第41题
ocp 11g认证考试051题库解析：第41题，完整题库请点击这里联系老师咨询了解。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 DISTINCT keyword ca...
- ocp 11g认证考试051题库解析：第40题
ocp 11g认证考试051题库解析：第40题，完整题库请点击这里联系老师咨询了解。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_prodAS SELECT p.prod_id, cust_i...
