Get the App
SLTechnology News&Howtos  ›  Database  › 

Analysis of 1Z0-052 in Chinese and English (3)

Shulou Source: shulou.com Published: 2022-06-01 15:35:11 10月03日 Update

Which two operations can be performed on an external table? (Choose two.)

A. Create a view on the table

B. Create an index on the table

C. Create a synonym on the table

D. Add a virtual column to the table

E. Update the table using the UPDATE statement

F. Delete rows in the table using the DELETE command

What two operations can be performed on external tables? (Choose two)

A. Create a view on a table

B. Create an index on a table

C. Creating synonyms on tables

D. Add a dummy column to the table

E. Update tables with UPDATE statements

F. Delete a line using the Delete command

AC is correct.

Knowledge Points:

External table (external table)

is an operating system file, whose data can only be changed by modifying the data file

Read-only files, query operations and connections

No DML operations can be run on it, insert, update, delete, etc. cannot be used, and indexes cannot be established.

External tables can load and unload data in data pump format

Tags: Data file index A. operating system two synonyms command format knowledge knowledge point system view statement B.ctor. Apple Docker Huawei Linux macOS MariaDB Microsoft MySQL NVidia OPPO Reno Xiaomi Shulou Technology OPPO Reno Linux Docker