The database administrator of your company created a public ..

第1题

The database administrator of your company created a public synonym called HR for the HUMAN_RESOURCES table of the GENERAL schema, because many users frequently use this table. As a user of the database, you created a table called HR in your schema. What happens when you execute this query?SELECT *FROM HR;（）

A. You obtain the results retrieved from the public synonym HR created by the database administrator.

B. You obtain the results retrieved from the HR table that belongs to your schema.

C. You get an error message because you cannot retrieve from a table that has the same name as a public synonym.

D. You obtain the results retrieved from both the public synonym HR and the HR table that belongs to your schema, as a Cartesian product.

E. You obtain the results retrieved from both the public synonym HR and the HR table that belongs to your schema, as a FULL JOIN.

点击查看答案

第2题

Let R = ( A, B, C, D ), S = ( B, D ), the schema of relation ( R ÷ S ) is :

A、( A, B )

B、( A, C )

C、( B, D )

D、( B, C)

点击查看答案

第3题

The issued share capital of Alpha, a limited liability company, is as follows: $ Ordinary shares of 10c each 1,000,000 8% Redeemable preference shares of 50c each 500,000 In the year ended 31 October 20X2, the company has paid the preference dividend for the year and an interim dividend of 2c per share on the ordinary shares. A final ordinary dividend of 3c per share was proposed, before the reporting date. What would be recognised for dividends in the equity section of the statement of financial position at 31 October 20X2?

A、$580,000

B、$90,000

C、$130,000

D、$200,000

点击查看答案

第4题

The following information relates to Eva Co's sales tax for the month of March 20X3： $ Sales (including sales tax) 109,250 Purchases (net of sales tax) 64,000 Sales tax is charged at a flat rate of 15%. Eva Co's sales tax account showed an opening credit balance of $4,540 at the beginning of the month and a closing debit balance of $2,720 at the end of the month. What was the total sales tax paid to regulatory authorities during the month of March 20X3?

A、$6,470.00

B、$11,910.00

C、$14,047.50

D、$13,162.17

点击查看答案

第5题

Geographical location plays a part in access to

A、economics

B、markets

C、people

D、politics

点击查看答案

第6题

Generally, the meter of The Raven is trochaic octameter–eight trochaic feet per line, each foot having one stressed syllable followed by one unstressed syllable.

点击查看答案

第7题

The mercantilists would have objected to:

A、Export promotion policies initiated by the government

B、The use of tariffs or quotas to restrict imports

C、Trade policies designed to accumulate gold and other precious metals

D、International trade based on open markets

点击查看答案

第8题

Does the competition with Google partly drive Apple to enter the auto industry? ( )

A、Yes.

B、No.

C、Not given

D、Not clear.

点击查看答案

第9题

User Mary has a view called EMP_DEPT_LOC_VU that was created based on the EMPLOYEES, DEPARTMENTS, and LOCATIONS tables. She has the privilege to create a public synonym, and would like to create a synonym for this view that can be used by all users of the database.Which SQL statement can Mary use to accomplish that task?（）

A. CREATE PUBLIC SYNONYM EDL_VU ON emp_dept_loc_vu

B. CREATE PUBLIC SYNONYM EDL:VU FOR mary (emp_dept_loc_vu);

C. CREATE PUBLIC SYNONYM EDL_VU FOR emp _dept_loc_vu;

D. CREATE SYNONYM EDL_VU ON emp_dept_loc_vu FOR EACH USER;

E. CREATE SYNONYM EDL_VU FOR EACH USER ON emp_dept_loc_vu

F. CREATE PUBLIC SYNONYM EDL_VU ON emp_dept_loc_vu FOR ALL USERS;

点击查看答案