1Z0-007
单选题The PRODUCTS table has these columns: PRODUCT_ID NUMBER(4) PRODUCT_NAME VARCHAR2(45) PRICE NUMBER(8,2) Evaluate this SQL statement: SELECT * FROM PRODUCTS ORDER BY price, product _ name; What is true about the SQL statement? （）A The results are not sor
题目
The results are not sorted.
The results are sorted numerically.
The results are sorted alphabetically.
The results are sorted numerically and then alphabetically.
相似问题和答案
第1题：
A.Each extra column in the copy with more columns must not have a default value
B.Columns that are common to both versions of the table must be defined in the same order on the master and the slave
C.The slave database cannot have more columns than the master. Only the master database can have more columns
D.Columns that are common to both versions of the table must come first in the table definition, before any additional columns are additional columns are defined on either server
E.The master database cannot have more columns than the slave. Only the slave deatbase can have more columns
第2题：
Examine the SQL statement that creates ORDERS table:CREATE TABLE orders (SER_NO NUMBER UNIQUE, ORDER_ID NUMBER, ORDER_DATE DATE NOT NULL, STATUS VARCHAR2(10) CHECK (status IN (‘CREDIT‘, ‘CASH‘)), PROD_ID NUMBER REFERENCES PRODUCTS(PRODUCT_ID), ORD_TOTAL NUMBER, PRIMARY KEY (order_id, order_date));For which columns would an index be automatically created when you execute the above SQL statement? （）
A. SER_NO
B. ORDER_ID
C. STATUS
D. PROD_ID
E. ORD_TOTAL
F. composite index on ORDER_ID and ORDER_DATE
第3题：
The PRODUCTS table has these columns:PRODUCT_ID NUMBER(4)PRODUCT_NAME VARCHAR2(45)PRICE NUMBER(8,2)Evaluate this SQL statement:SELECT *FROM PRODUCTSORDER BY price, product _ name;What is true about the SQL statement? （）
A. The results are not sorted.
B. The results are sorted numerically.
C. The results are sorted alphabetically.
D. The results are sorted numerically and then alphabetically.
第4题：
In which of the following situations should correlation names be used?（）
- A、A table referenced in the FROM clause has no indexed column.
- B、The table referenced in the FROM clause has more than 200 columns.
- C、Two or more tables in the FROM clause have identical column names.
- D、The FROM clause contains two or more tables in the SELECT statement.
正确答案:C
第5题：
Make a function to print an HTML table of r rows and c cols; fill the cells with up to n consecutive
numbers (if n is greater than the produce of r and c, discard the rest). Ensure that all rows have the
same number of columns.
第6题：
A. Column definitions cannot be altered to add DEFAULT values.
B. A change to the DEFAULT value affects only subsequent insertions to the table.
C. Column definitions cannot be altered at add DEFAULT values for columns with a NUMBER data type.
D. All the rows that have a NULL value for the SALARY column will be updated with the value 5000.
第7题：
The STUDENT_GRADES table has these columns:The registrar has asked for a report on the average grade point average (GPA) for students enrolled during semesters that end in the year 2000. Which statement accomplish this?（）
A.
B.
C.
D.
E.
F.
第8题：
Examine the SQL statements that creates ORDERS table: CREATE TABLE orders(SER_NO NUMBER UNIQUE,ORDER_ID NUMBER,ORDER_DATE DATE NOT NULLSTATUS VARCHARD2(10)CHECK (status IN (‘CREDIT‘,‘CASH‘)),PROD_ID_NUMBERREFERENCES PRODUCTS(PRODUCT_ID),ORD_TOTAL NUMBER,PRIMARY KEY (order id, order date));For which columns would an index be automatically created when you execute the aboveSQL statement? （）
A. SER_NO
B. ORDER_ID
C. STATUS
D. PROD_ID
E. ORD_TOTAL
F. Composite index on ORDER_ID and ORDER_DATE
第9题：
The EMP table contains these columns:EMPLOYEE_ID NUMBER(4)EMPNAME VARCHAR2 (25)SALARY NUMBER(9,2)HIRE_DATE DATEYou query the database with this SQL statement:SELECT empname,hire_date HIREDATE, salaryFROM EMPORDER BY hire_date;How will the results be sorted?（）
A.randomly
B.ascending by date
C.descending by date
D.ascending alphabetically
E.descending alphabetically
第10题：
You need to replicate a table from a master to a slave. The master and slave copies of the table will have different number of columns. Which two conditions must be true?（）
- A、Each extra column in the copy with more columns must not have a default value
- B、Columns that are common to both versions of the table must be defined in the same order on the master and the slave
- C、The slave database cannot have more columns than the master. Only the master database can have more columns
- D、Columns that are common to both versions of the table must come first in the table definition, before any additional columns are additional columns are defined on either server
- E、The master database cannot have more columns than the slave. Only the slave deatbase can have more columns
正确答案:B,D