网友您好, 请在下方输入框内输入要搜索的题目:
题目内容
(请给出正确答案)
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
参考答案
更多 “ 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 tablespaceB、Use ALTER TABLE MOVE to transfer the existing data to a new encrypted tablespaceC、Use CREATE TABLE AS SELECT to transfer the existing data to a new encrypted tablespaceD、Enable row movement for each table to be encrypted and then use ALTER TABLESPACE to encrypt the tablespaceE、Encrypt the USER_DATA tablespace using the ALTER TABLESPACE statement so that all the data in the tablespace is automatically encrypted” 相关考题
考题
You are using Recovery Manager (RMAN) for backup and recovery operations with a recovery catalog. You have been taken database backups every evening. On November 15, 2007, at 11:30 AM, you were informed that the USER_DATA tablespace was accidentally dropped.On investigation, you found that the tablespace existed until 11:00 AM, and important transactions were done after that. So you decided to perform incomplete recovery until 11:00 AM. All the archive logs needed to perform recovery are intact. In NOMOUNT state you restored the control file that has information about the USER_DATA tablespace from the latest backup. Then you mounted the database. Identify the next set of commands that are required to accomplish the task? ()A. AB. BC. CD. D
考题
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 tablespaceB. Use ALTER TABLE MOVE to transfer the existing data to a new encrypted tablespaceC. Use CREATE TABLE AS SELECT to transfer the existing data to a new encrypted tablespaceD. Enable row movement for each table to be encrypted and then use ALTER TABLESPACE to encrypt the tablespaceE. Encrypt the USER_DATA tablespace using the ALTER TABLESPACE statement so that all the data in the tablespace is automatically encrypted
考题
You are the administrator of a SQL Server 2000 computer. The server contains a database that stores financial data. You want to use Data Transformation Services packages to import numeric data from other SQL server computers. The precision and scale values of this data are not defined consistently on the other servers.You want to prevent any loss of data during the import operations. What should you do?A.Use the ALTER COLUMN clause of the ALTER TABLE statement to change data types in the source tables. Change the data types so that they will use the lowest precision and scale values of the data that will be transferred.B.Use the ALTER COLUMN clause of the ALTER TABLE statement to change data types in the destination tables. Change the data types to reflect the highest precision and scale values involved in data transfer.C.Set a flag on each DTS transformation to require an exact match between source and destination columns.D.Set the maximum error count for each DTS transformation task equal to the number of rows of data you are importing. Use an exception file to store any rows of data that generate errors.E.Write Microsoft ActiveX script. for each DTS transformation. Use the script. to recast data types to the destinations precision and scale values.
考题
You want the size of the tablespace to increase when it is full. Which option would you use?()A、use automatic extent allocationB、disable threshold for the tablespaceC、use freelists to manage the free spaceD、use automatic segment space managementE、create the tablespace as a bigfile tablespaceF、use the RESIZE clause while creating the tablespaceG、enable AUTOEXTEND for at least one of the data files in the tablespace
考题
You are using flat files as the data source for one of your data warehousing applications. To optimize the application performance, you plan to move the data from the flat files to clustered tables in an Oracle database.While migrating the data, you want to have minimal impact on the database performance and optimize the dataload operation. Which method would you use to load data into the Oracle database()A、Use the external table population.B、Use the Oracle Data Pump export and import utility.C、Use the conventional path data load of the SQL*Loader utility.D、Use the INSERT INTO...SELECT command to load the data
考题
You are creating a locally managed tablespace to meet the following requirements: All the extents should be of the same size. The data should be spread across two data files. A bitmap should be used to record the free space within the allocated extents. Which three options would you choose?()A、set PCTFREE and PCTUSED to 50B、specify extent allocation as UniformC、specify extent allocation as AutomaticD、create the tablespace as bigfile tablespaceE、create the tablespace as smallfile tablespaceF、set segment space management to AutomaticG、use the RESIZE clause while creating the tablespace
考题
While designing the database for one of your online transaction processing (OLTP) applications, you want to achieve the following: a) high availability of data b) faster primary key access to the table data c) compact storage for the table Which type of tables would you use to achieve these objectives?()A、heap tablesB、object tablesC、partitioned tablesD、indexorganized tables (IOTs)
考题
In which case would you use a FULL OUTER JOIN?()A、Both tables have NULL values.B、You want all unmatched data from one table.C、You want all matched data from both tables.D、You want all unmatched data from both tables.E、One of the tables has more data than the other.F、You want all matched and unmatched data from only one table.
考题
You want to migrate your application from the development environment to the production environment. While doing the task, you want the database objects owned by the user DEVUSER in the development environment to be moved to the user APPS in the production environment. Which option of Oracle Data Pump Import would you use to achieve this objective?()A、ownerB、touserC、includeD、schemasE、fromuserF、transformG、remap_schemaH、remap_datafileI、reuse_datafilesJ、remap_tablespace
考题
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.
考题
You want to convert your existing non-ASM files to ASM files for the database PROD. Which method or command would you use to accomplish this task?() A、 Data Pump Export and ImportB、 conventional export and importC、 the CONVERT command of RMAND、 the BACKUP AS COPY. command of RMAN
考题
You want to drop the TBS1 tablespace from your database. You also want to delete the corresponding data files automatically, and not have to do it manually. What should you do?()A、Use the DROP DATAFILE command.B、Use the DROP TABLESPACE command.C、Ensure that all database files are Oracle Managed Files before using the DROP TABLESPACE command.D、Ensure that the DB_FILE_CREATE_DEST initialization parameter is set before using the DROP TABLESPACE command.
考题
You are using flat files as the data source for one of your data warehousing applications. To optimizethe application performance, you plan to move the data from the flat files toclustered tablesin an Oracle database. While migrating the data, you want to have minimal impact on the database performance and optimize thedata load operation. Which method would you use to load data into the Oracle database()A、Use the external table population.B、Use the Oracle Data Pump export and import utility.C、Use the conventional path data load of the SQL*Loader utility.D、Use the INSERT INTO...SELECT command to load the data.
考题
You are working as a DBA on the decision support system. There is a business requirement to track and store all transactions for at least three years for a few tables in the database. Automatic undo management is enabled in the database. Which configuration should you use to accomplish this task?()A、 Enable Flashback Data Archive for the tables.B、 Specify undo retention guarantee for the database.C、 Enable supplemental logging for the database.D、 Query V$UNDOSTAT to determine the amount of undo that will be generated and create an undo tablespace for that size.E、 Create Flashback Data Archive on the tablespace on which the tables are stored.
考题
You are using flat files as the data source for one of your data warehousing applications. You plan to move the data from the flat file structures to an Oracle database to optimize the application performance. In your database you have clustered tables. While migrating the data, you want to have minimal impact on the database performance and optimize the data load operation. Which method would you use to load data into Oracle database?()A、use the external table populationB、use the Oracle Data Pump export and import utilityC、use the conventional path data load of SQL*Loader utilityD、use the direct path data load of Oracle export and import utility
考题
You find pockets of empty space in the USER_DATA tablespace due to a lot of DML operations on the objects in the USER_DATAtablespace. The pockets of empty spaces are too small to be reused individually. This is leading to wastage of space. You decide to perform the shrink operation to reclaim the wasted space. Which advisor will you use to determine the objects in the USER_DATA tablespace that are good candidates for the shrink operation?()A、 SQL Tuning AdvisorB、 SQL Access AdvisorC、 Undo AdvisorD、 Segment Advisor
考题
You lost a data file that belongs to an index tablespace in your database, which operates in ARCHIVELOG mode. Loss of the data file resulted in increased response time on your queries. Which two options would you use to solve this problem? ()A、 Restore the lost data file from the backup, and then flash back the database.B、 Restore the data file pertaining to index tablespace, and then recover the tablespace.C、 Restore all the data files, and then perform an incomplete recovery to get the tablespace back.D、 Restore all the data files, and then perform an incomplete recovery using the backup control file.E、 Drop and re-create the index tablespace, and then re-create all of the indexes in that tablespace.
考题
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.
考题
You want to check all the data blocks being written to the datafiles by analyzing the data on each block every time the DBWn process writes. Which action will you perform to check the data blocks?()A、 Set the value of the DB_BLOCK_CHECKING initialization parameter to TRUEB、 Use the ANALYZE utility.C、 Use the DBVERIFY utility.D、 Use the DBMS_REPAIR package.
考题
You want to put a specific tablespace called MY_DATA in hot backup mode so you can back it up. What command would you use?() A、 alter tablespace MY_DATA begin backupB、 alter tablespace MY_DATA start backupC、 alter tablespace MY_DATA backup beginD、 alter MY_DATA begin backupE、 You cannot back up individual tablespaces
考题
单选题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.
考题
单选题You want to migrate your application from the development environment to the production environment. While doing the task, you want the database objects owned by the user DEVUSER in the development environment to be moved to the user APPS in the production environment. Which option of Oracle Data Pump Import would you use to achieve this objective?()A
ownerB
touserC
includeD
schemasE
fromuserF
transformG
remap_schemaH
remap_datafileI
reuse_datafilesJ
remap_tablespace
考题
多选题Identify three situations in which you would NOT be able to drop a tablespace. ()Awhen the tablespace is onlineBwhen the tablespace has segments with data in itCwhen the tablespace is a default permanent tablespace for the databaseDwhen the tablespace contains a table that is currently being used by transactionsEwhen the tablespace contains undo data that is needed to rollback an uncommitted transaction
考题
单选题In which case would you use a FULL OUTER JOIN?()A
Both tables have NULL values.B
You want all unmatched data from one table.C
You want all matched data from both tables.D
You want all unmatched data from both tables.E
One of the tables has more data than the other.F
You want all matched and unmatched data from only one table.
考题
多选题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?()AUse Data Pump to transfer the existing data to a new encrypted tablespaceBUse ALTER TABLE MOVE to transfer the existing data to a new encrypted tablespaceCUse CREATE TABLE AS SELECT to transfer the existing data to a new encrypted tablespaceDEnable row movement for each table to be encrypted and then use ALTER TABLESPACE to encrypt the tablespaceEEncrypt the USER_DATA tablespace using the ALTER TABLESPACE statement so that all the data in the tablespace is automatically encrypted
考题
单选题You find pockets of empty space in the USER_DATA tablespace due to a lot of DML operations on the objects in the USER_DATAtablespace. The pockets of empty spaces are too small to be reused individually. This is leading to wastage of space. You decide to perform the shrink operation to reclaim the wasted space. Which advisor will you use to determine the objects in the USER_DATA tablespace that are good candidates for the shrink operation?()A
SQL Tuning AdvisorB
SQL Access AdvisorC
Undo AdvisorD
Segment Advisor
考题
单选题You want to convert your existing non-ASM files to ASM files for the database PROD. Which method or command would you use to accomplish this task?()A
Data Pump Export and ImportB
conventional export and importC
the CONVERT command of RMAND
the BACKUP AS COPY. command of RMAN
热门标签
最新试卷