TestPassPort 1z0-052 試験Q&A (101)

102. You want to import schema objects of the HR user using Oracle Data Pump from the development database, DEVDB, to the production database, PRODDB. A database link devdb.us.oracle.com is created between PRODDB and DEVDB. You execute the following command on the PRODDB database server: $ impdp system/manager directory = DB_DATA dumpfile = schemas.dat schemas […]

TestPassPort 1z0-052 試験Q&A (100)

101. You want to move all objects of the APPS user in the test database to the DB_USER schema of the production database. Which option of IMPDP would you use to accomplish this task? A.FULL B.SCHEMAS C.TRANSFORM D.REMAP_SCHEMA E.REMAP_TABLESPACE Answer: D 高い品質と高価値 1Z0-052 試験の解答 TestPassPort 実践試験の 11g 1Z0-052 は最も標準的な技術を正確的に書き入れ、認証した専門家と作者の出版した新製品だけを使います. 一回だけで成功することを保証します. 11g 1Z0-052(Oracle Database 11g: Administrator […]

TestPassPort 1z0-052 試験Q&A (99)

100. In which situations does the Oracle Data Pump use external tables and not the direct path load while exporting a table? (Choose all that apply.) A.if a table is not in a cluster B.if a table has an active trigger C.if a table has an encrypted column D.if a table has a column of […]

TestPassPort 1z0-052 試験Q&A (98)

99. Which two statements are true regarding Oracle Data Pump? (Choose two.) A.EXPDP and IMPDP are the client components of Oracle Data Pump. B.DBMS_DATAPUMP PL/SQL packages can be used independently of the Data Pump clients. C.Oracle Data Pump export and import operations can be performed only by users with the SYSDBA privilege. D.Oracle Data Pump […]

TestPassPort 1z0-052 試験Q&A (97)

98. Which two statements are true regarding the usage of the SQL*Loader utility? (Choose two.) 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 […]

TestPassPort 1z0-052 試験Q&A (96)

97. Which statement is true about loading data using the conventional path of SQL*Loader? A.Redo is not generated while performing conventional path loads. B.Only PRIMARY KEY, UNIQUE KEY, and NOT NULL constraints are checked. C.No exclusive locks are acquired when the conventional path loads are performed. D.Instead of performing transactions, SQL*Loader directly writes data blocks […]

TestPassPort 1z0-052 試験Q&A (95)

96. 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. Answer: […]

TestPassPort 1z0-052 試験Q&A (94)

95. You have a large amount of historical data in a flat file. Some analysts in your organization need to query this data in the file. The file is too large to load the data in it into your current database. Which is the most effective method to access this data in your database? A.Use […]

TestPassPort 1z0-052 試験Q&A (93)

94. You plan to move data from a flat file to a table in your database. You decide to use SQL*Loader direct path load method to perform this task. The table in which you plan to load data is an important table having various integrity constraints defined on it. Which constraints will remain enabled by […]

TestPassPort 1z0-052 試験Q&A (92)

93. 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 […]