QUESTION 116


--------------------------------------------------------------------------------

The CUSTOMERS table has these columns:

CUSTOMERS table

CUSTOMER_ID NUMBER (4) NOT NULL

CUSTOMER_NAME VARCHAR2 (100) NOT NULL

STREET_ADDRESS VARCHAR2 (150)

CITY_ADDRESS VARHCAR2 (50)

STATE_ADDRESS VARCHAR2 (50)

PROVINCE_ADDRESS VARCHAR2 (50)

COUNTRY_ADDRESS VARCHAR2 (50)

POSTAL_CODE VARCHAR2 (12)

CUSTOMER_PHONE VARCHAR2 (20)


The CUSTOMER_ID column is the primary key for the table. You need to determine how dispersed your customer base is. Which expression finds the number of different countries represented in the CUSTOMERS table?

  A.
COUNT(UPPER(country_address))

B.
COUNT(DIFF(UPPER(country_address)))

C.
COUNT(UNIQUE(UPPER(country_address)))

D.
COUNT DISTINTC UPPER(country_address)

E.
COUNT(DISTINTC (UPPER(country_address))


SQL> create table aa(a1 char(2));

表已创建。

SQL> insert into aa values ('aa');

已创建 1 行。

SQL> insert into aa values ('aa');

已创建 1 行。

SQL> insert into aa values ('ab');

已创建 1 行。

SQL> insert into aa values ('ac');

已创建 1 行。

SQL> commit;

提交完成。

SQL> select count(*) from aa;

  COUNT(*)
----------
         4

SQL> select count(distinct a1) from aa;

COUNT(DISTINCTA1)
-----------------
                3

SQL> select count(unique a1) from aa;

COUNT(UNIQUEA1)
---------------
              3

SQL> select count(unique upper(a1)) from aa;

COUNT(UNIQUEUPPER(A1))
----------------------
                     3

SG只是列考点吧。不是所有的都会写出来的

sg上怎么会没有呢，绝对有

QUOTE:

---

原帖由 bjyplbx 于 2007-11-28 02:37 发表
sg上怎么会没有呢，绝对有

---

请指出页码？

QUOTE:

---

原帖由 hotiice 于 2007-11-28 08:40 发表

请指出页码？

---

这个优点太难了吧

QUOTE:

---

原帖由 lucky_lau 于 2007-11-28 11:55 发表


这个优点太难了吧

---

不太难，如果有电子版，用查找功能就行了

商业培训和考试, 本意是衡量你的经验值和知识宽度的. 怎么用学历学位考试的名词---超纲?  My God

Introduction to Oracle9i: SQL® Printer View Exam Number: 1Z0-007 Associated Certifications: Oracle9i DBA OCA Application Developer R.6i OCP Application Developer R.9i OCA Exam Price: $95.00 USD Exam Registration Register Duration: 120 minutes Number of Questions: 52 Passing Score: 71% Passing score subject to change. View Details Recommended Training and Preparation Additional Information & Resources Exam Topics Fraudulent Activity Policy BACK TO TOP Recommended Training and Preparation Introduction to Oracle9i: SQL or Oracle Database 10g: Introduction to SQL Introduction to Oracle9i: SQL Self-Study CD Course (NETg Oracle) Self-Study CD-ROMs are an excellent tool to help you prepare for your exam. SSCDs reinforce the course material and allow you to focus on sections that you need to review. Note: the SSCDs do not count towards your course requirements for certification and should be used as a study aid only. BACK TO TOP Additional Information & Resources Practice Exams Oracle authorized practice exam from Self Test Software. 1Z0-007 Introduction to Oracle9i: SQL Oracle authorized practice exam from Transcender: Cert-1Z0-007 : DBCert: Introduction to 9i: SQL Candidate Guides Oracle9i DBA Certification Exam Candidate Guide Application Developer 6i OCP Candidate Guide Application Developer 9i Candidate Guide Exam Retake Policy Exam Topics Writing Basic SQL Select Statements [  ] List the capabilities of SQL SELECT statements [  ] Execute a basic SELECT statement [  ] Differentiate between SQL statements and iSQL*Plus commands Restricting and Sorting Data [  ] Limit the rows retrieved by a query [  ] Sort the rows retrieved by a query Single-Row Functions [  ] Describe various types of functions available in SQL [  ] Use character, number, and date functions in SELECT statements [  ] Use conversion functions Displaying Data from Multiple Tables [  ] Write SELECT statements to access data from more than one table using equality and nonequality joins [  ] View data that generally does not meet a join condition by using outer joins [  ] Join a table to itself using a self-join Aggregating Data using Group Functions [  ] Identify the available group functions [  ] Use group functions [  ] Group data using the GROUP BY clause [  ] Include or exclude grouped rows by using the HAVING clause Subqueries [  ] Describe the types of problems that subqueries can solve [  ] Define subqueries [  ] List the types of subqueries [  ] Write single-row and multiple-row subqueries Producing Readable Output with iSQL*Plus [  ] Produce queries that require a substitution variable [  ] Produce more readable output [  ] Create and execute script files Manipulating Data [  ] Describe each DML statement [  ] Insert rows into a table [  ] Update rows in a table [  ] Delete rows from a table [  ] Merge rows in a table [  ] Control transactions Creating and Managing Tables [  ] Describe the main database objects [  ] Create tables [  ] Describe the datatypes that can be used when specifying column definition [  ] Alter table definitions [  ] Drop, rename and truncate tables Including Constraints [  ] Describe constraints [  ] Create and maintain constraints Creating Views [  ] Describe a view [  ] Create, alter the definition, and drop a view [  ] Retrieve data through a view [  ] Insert, update and delete data through a view Creating Other Database Objects [  ] Create, maintain and use sequences [  ] Create and maintain indexes [  ] Create private and public synonyms BACK TO TOP Oracle Certification Program Fraudulent Activity Policy Oracle reserves the right to take action against any candidate involved in fraudulent activities, including, but not limited to, fraudulent use of vouchers, promotional codes, reselling exam discounts and vouchers, cheating on an exam, alteration of score reports, alteration of completion certificates, violation of exam retake policies or other activities deemed fraudulent by Oracle. If Oracle determines, in its sole discretion, that fraudulent activity has taken place, it reserves the right to take action up to and including, but not limited to, decertification of a candidate's OCA, OCP and/or OCM credentials, temporary, indefinite or permanent ban of a candidate from Oracle certification programs, notification to a candidate's employer, and notification to law enforcement agencies. Candidates found committing fraudulent activities forfeit all fees previously paid to Oracle, or to Oracle's authorized vendors, and may be required to pay additional fees for services rendered. View the Oracle Certification Program Candidate Agreement which requires your agreement before the start of each exam.

[ 本帖最后由 hotiice 于 2007-11-28 16:09 编辑 ]

版主，想问个很笨的问题，能告诉我什么是你说的sg吗？那是什么东东？