單項選擇題

What does the FORCE option for creating a view do?（）

A. creates a view with constraints
B. creates a view even if the underlying parent table has constraints
C. creates a view in another schema even if you don't have privileges
D. creates a view regardless of whether or not the base tables exist

你可能感興趣的試題

單項選擇題

Examine the structure of the EMPLOYEES table:

You need to update the records of employees 103 and 115. The UPDATE statement you specify should update the rows with the values specified below:

Which UPDATE statement meets the requirements?（）

A.
B.
C.
D.
E.

單項選擇題

Examine the description of the CUSTOMERS table:
CUSTOMER_ID NUMBER(4) NOT NULL
CUSTOMER_NAME VARCHAR2(100) NOT NULL
STREET_ADDRESS VARCHAR2(150)
CITY_ADDRESS VARCHAR2(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.
Which statement returns the city address and the number of customers in the cities Los Angeles or San Francisco?（）

A. SELECT city_address, COUNT(*) FROM customers WHERE city _ address IN ('Los Angeles','San Fransisco');
B. SELECT city_address, COUNT (*) FROM customers WHERE city address IN ( 'Los Angeles', 'San Fransisco') GROUP BY city_address;
C. SELECT city_address, COUNT(customer_id) FROM customers WHERE city_address IN ( 'Los Angeles', 'San Fransisco') GROUP BY city_address, customer_ id;
D. SELECT city_address, COUNT (customer_id) FROM customers GROUP BY city_ address IN ('Los Angeles','San Fransisco');

日韩欧美亚洲 _ 欧美亚洲一区 _ 日本亚洲欧美 _ 亚洲精品欧美 国产白袜脚足J棉袜在线观看_亚洲熟妇av一区二区三区_久久天天躁狠狠躁夜_精品众筹模特私拍在线

What does the FORCE option for creating a view do?（）

你可能感興趣的試題

Examine the structure of the EMPLOYEES table: You need to update the records of employees 103 and 115. The UPDATE statement you specify should update the rows with the values specified below: Which UPDATE statement meets the requirements?（）

日韩欧美亚洲 _ 欧美亚洲一区 _ 日本亚洲欧美 _ 亚洲精品欧美国产白袜脚足J棉袜在线观看_亚洲熟妇av一区二区三区_久久天天躁狠狠躁夜_精品众筹模特私拍在线

Examine the structure of the EMPLOYEES table:

You need to update the records of employees 103 and 115. The UPDATE statement you specify should update the rows with the values specified below:

Which UPDATE statement meets the requirements?（）