可学答题网 > 问答 > 1Z0-007题库
目录: 标题| 题干| 答案| 搜索| 相关
问题

The CUSTOMERS table has these columns


The CUSTOMERS table has these columns: The CUSTOMER_ID column is the primary key for the table.Which two statements find the number of customers? ()

  • A SELECT TOTAL(*) FROM customers;
  • B SELECT COUNT(*) FROM customers;
  • C SELECT TOTAL(customer_id) FROM customers;
  • D SELECT COUNT(customer_id) FROM customers;
  • E SELECT COUNT(customers) FROM customers;
  • F SELECT TOTAL(customer_name) FROM customer
参考答案
参考解析:
分类:1Z0-007题库
相关推荐

1、The EMPLOYEE tables has these columns

The EMPLOYEE tables has these columns:LAST_NAME VARCHAR2(35)SALARY NUMBER(8,2)COMMISSION_PCT NUMBER(5,2)You want to display the name and annual salar...

2、The EMPLOYEE tables has these columns

The EMPLOYEE tables has these columns:You want to display the name and annual salary multiplied by the commission_pct for all employees. For re...

3、The CUSTOMERS table has these columns

The CUSTOMERS table has these columns:CUSTOMER_ID NUMBER(4) NOT NULLCUSTOMER_NAME VARCHAR2(100) NOT NULLSTREET_ADDRESS VARCHAR2(150)CITY_ADDRESS VARCHAR...

4、The ORDERS table has these columns:

The ORDERS table has these columns:The ORDERS table tracks the Order number, the order total, and the customer to whom the Order belongs. Whic...

5、The EMP table has these columns: Man

The EMP table has these columns:Management wants a list of names of employees who have been with the company for more than five years. Which...

6、The EMPLOYEES table has these columns:

The EMPLOYEES table has these columns:LAST_NAME VARCHAR2(35) SALARYNUMBER(8,2) HIRE_DATE DATEManagement wants to add a default value to the SALARY...