单选题ENCRYPT_TS is an encrypted tablespace that contains tables with data. Which statement is true regarding the effect of queries and data manipulation language （DML） statements on the encrypted data in the tables？（）AThe data is decrypted during SORT and J

第1题：

Which two statements are true regarding the USING clause in table joins?（）

• A、It can be used to join a maximum of three tables 
• B、It can be used to restrict the number of columns used in a NATURAL join 
• C、It can be used to access data from tables through equijoins as well as nonequijoins 
• D、It can be used to join tables that have columns with the same name and compatible data types

第2题：

Which four actions are possible during an Online Data file Move operation?（）

• A、Creating and dropping tables in the data file being moved
• B、Performing file shrink of the data file being moved
• C、Querying tables in the data file being moved
• D、Performing Block Media Recovery for a data block in the data file being moved
• E、Flashing back the database
• F、Executing DML statements on objects stored in the data file being moved

第3题：

ENCRYPT_TS is an encrypted tablespace that contains tables with data. Which statement is true regarding the effect of queries and data manipulation language (DML) statements on the encrypted data in the tables?（）

• A、The data is decrypted during SORT and JOIN operations.
• B、The data remains encrypted when it is read into memory.
• C、The data remains encrypted when it is stored in the redo logs.
• D、The data remains encrypted in the UNDO tablespace provided that the UNDO tablespace was created with the encryption option enabled.

第4题：

Which  statements are true regarding the Oracle Data Pump export and import operations（）

• A、You cannot export data from a remote database.
• B、You can rename tables during an import operation.
• C、You can overwrite existing dump files during an export operation.
• D、You can compress the data during export but not the metadata because it is not supported

第5题：

Which two statements are true about simple views？（）

• A、Views can be created as read only.
• B、Views are data segments like tables.
• C、Views can be created on the basis of more than one table.
• D、Data manipulation language （DML） operations cannot be performed on views.

第6题：

Which two statements are true regarding the usage of the SQL*Loader utility（）

• A、You can load data into multiple tables during the same load session.
• B、You can load data from multiple files to a table during the same load session.
• C、You cannot perform selective data loading based on the values available in the records.
• D、You can use an export file generated by the EXPDP utility as an input data file to load the data.
• E、You can load data only if the input file is available on the disk and tape but not in a named pipes.

第7题：

Examine the statement：   SQL> CREATE TABLESPACE user_data  2> EXTENT MANAGEMENT LOCAL  3> SEGMENT SPACE MANAGEMENT AUTO；   Which twp assumptions must be true for this statement to execute successfully？（）

• A、Oracle Managed Files are used for this instance.
• B、The USER_DATA tablespace is managed using FET$/UET$ tables.
• C、The COMPATIBLE initialization parameter must be 9.0.0 or higher.
• D、Space within segments in the USER_DATA tablespace is managed with freelists.

第8题：

Which two statements are true regarding the Oracle Data Pump export and import operations（）

• A、You cannot export data from a remote database.
• B、You can rename tables during an import operation.
• C、You can overwrite existing dump files during an export operation.
• D、You can compress the data during export but not the metadata because it is not supported.

第9题：

第10题：

第11题：

第12题：

第13题：

Which statement is true regarding the INTERSECT operator?（）

• A、It ignores NULL values 
• B、Reversing the order of the intersected tables alters the result 
• C、The names of columns in all SELECT statements must be identical 
• D、The number of columns and data types must be identical for all SELECT statements in the query 

第14题：

Which statements are true regarding SecureFile LOBs？（） 

• A、 The amount of undo retained is user controlled.
• B、 SecureFile LOBs can be used only for nonpartitioned tables.
• C、 Fragmentation is minimized by using variable-sized chunks dynamically.
• D、 SecureFile encryption allows for random reads and writes of the encrypted data.
• E、 It automatically detects duplicate LOB data and conserves space by storing only one copy.

第15题：

Which  statements are correct about temporary tables（）

• A、Indexes and views can be created on temporary tables.
• B、Both the data and the structure of temporary tables can be exported.
• C、Temporary tables are always created in a user’s temporary tablespace.
• D、The data inserted into a temporary table in a session is available to other sessions.
• E、Data manipulation language （DML） locks are never acquired on the data of temporary tables

第16题：

Which two client requests are captured during database replay Capture？（）

• A、 Flashback queries
• B、 Shared server requests
• C、 Login and logoff activities of sessions
• D、 Direct path load of data from external files by using utilities such as SQL *loader
• E、 Data definition language （DDL） and data manipulation language （DML） operations

第17题：

Which two client requests are captured during database replay Capture?（） (Choose two)

• A、Flashback queries
• B、Shared server requests
• C、Login and logoff activities of sessions
• D、Direct path load of data from external files by using utilities such as SQL *loader
• E、Data definition language (DDL) and data manipulation language (DML) operations

第18题：

Your database is in ARCHIVELOG mode. You lost an index tablespace due to a disk failure while the database was open. You have neither a backup of the lost index tablespace nor the scripts containing the CREATE INDEX statements to recreate the indexes. Currently， several users are executing long-running queries on the database. What will happen to the ongoing activity in the database？（）

• A、 The queries that are currently executing will abort and an error message will be returned to the user.
• B、 The queries that are currently executing will execute normally but future queries will not executed.
• C、 Data Manipulation Language （DML） statements cannot be performed on the tables on which the indexes are based.
• D、 The currently executing and future queries will execute normally， but will be slower

第19题：

Which three statements are correct about temporary tables？（）

• A、Indexes and views can be created on temporary tables.
• B、Both the data and the structure of temporary tables can be exported.
• C、Temporary tables are always created in a user’s temporary tablespace.
• D、The data inserted into a temporary table in a session is available to other sessions.
• E、Data manipulation language （DML） locks are never acquired on the data of temporary tables.

第20题：

USER_DATA is a nonencrypted tablespace that contains a set of tables with data. You want to convert all existing data in the USER_DATA tablespace and the new data into the encrypted format. Which methodswould you use to achieve this?（）

• A、Use Data Pump to transfer the existing data to a new encrypted tablespace
• B、Use ALTER TABLE MOVE to transfer the existing data to a new encrypted tablespace
• C、Use CREATE TABLE AS SELECT to transfer the existing data to a new encrypted tablespace
• D、Enable row movement for each table to be encrypted and then use ALTER TABLESPACE to encrypt the tablespace
• E、Encrypt the USER_DATA tablespace using the ALTER TABLESPACE statement so that all the data in the tablespace is automatically encrypted

第21题：

第22题：

第23题：