单选题Examine the following query output: You issue the following command to import tables into the hr schema: $ > impdp hr/hr directory = dumpdir dumpfile = hr_new.dmp schemas=hr TRANSFORM=DISABLE_ARCHIVE_LOGGING: Y Which statement is true?（）A All database

题目
单选题
Examine the following query output: You issue the following command to import tables into the hr schema: $ > impdp hr/hr directory = dumpdir dumpfile = hr_new.dmp schemas=hr TRANSFORM=DISABLE_ARCHIVE_LOGGING: Y Which statement is true?（）
A

All database operations performed by the impdp command are logged.

B

Only CREATE INDEX and CREATE TABLE statements generated by the import are logged.

C

Only CREATE TABLE and ALTER TABLE statements generated by the import are logged.

D

None of the operations against the master table used by Oracle Data Pump to coordinate its activities are logged.

相似考题

1.Your multitenant container database (CDB) contains a pluggable database, HR_PDB. The default permanent tablespace in HR_PDB is USERDATA. The container database (CDB) is open and you connect RMAN.You want to issue the following RMAN command:RMAN > BACKUP TABLESPACE hr_pdb:userdata;Which task should you perform before issuing the command?（）A. Place the root container in ARHCHIVELOG mode.B. Take the user data tablespace offline.C. Place the root container in the nomount stage.D. Ensure that HR_PDB is open.

2.You need to import all definitions of objects belonging to the TS_EMPLOYEES tablespace by using the export file expdat.dmp. Which import statement is correct？（）A、imp hr/hr TABLES=（ts_employees） rows=yB、imp system/manager FROMUSER=hr file=expdat.dmpC、imp hr/hr TRANSPORT_TABLESPACE=y file=expdat.dmpD、imp system/manager TRANSPORT_TABLESPACE=y TABLESPACE=ts_employees

3. You have created a database link， devdb.us.oracle.com， between the databases PRODDB and DEVDB. You want to import schema objects of the HR user using Oracle Data Pump from thedevelopment database， DEVDB， to the production database， PRODDB. You execute the following command on the target database server：  $impdp system/manager directory = DB_DATA dumpfile = schemas.dat schemas = hr  flashback_time = 2004-02-03 09：00  The command fails， displaying the following error： ORA-39001： invalid argument value  ORA-39000： bad dump file specification  ORA-31640： unable to open dump file “/home/oracle/schema/schemas.dat” for read ORA-27037： unable to obtain file status What would you do to overcome the error（）A、remove the dumpfile option in the commandB、remove the flashback_time option in the commandC、remove the dumpfile option and add the network_link = devdb.us.oracle.com option in the command（Replace thedumpfile option with the network_link = devdb.us.oracle.com）D、add the user， SYSTEM， to the schemas option in the commandE、remove the schemas option and add the network_link = devdb.us.oracle.com option in the command F、add network_link = devdb.us.oracle.com option in the command

4. 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 betweenPRODDB and DEVDB. You execute the following command on the PRODDB database server：$ impdp system/manager directory = DB_DATAdumpfile = schemas.datschemas = hr flashback_time = "TO_TIMESTAMP（’25-08-2007 14：35：00’， ’DD-MM-YYYY HH24：MI：SS’）"The command fails displaying the following error：ORA-39001： invalid argument valueORA-39000： bad dump file specification ORA-31640： unable to open dump file "/home/oracle/schema/schemas.dat" for read ORA-27037： unable toobtain file status What would you do to overcome the error（）A、Add the user， SYSTEM， to the schemas option.B、Add the network_link = devdb.us.oracle.com option.C、Change the dumpfile option to schema.dat@devdb.us.oracle.com.D、Replace the schemas option with the network_link = devdb.us.oracle.comE、Replace the dumpfile option with the network_link = devdb.us.oracle.com

更多“单选题Examine the following query output: You issue the following command to import tables into the hr schema: $ impdp hr/hr directory = dumpdir dumpfile = hr_new.dmp schemas=hr TRANSFORM=DISABLE_ARCHIVE_LOGGING: Y Which statement is true?（）A All database o”相关问题

  • 第1题：

    All the database users are presently connected to the database instance and working. The HR userhas opened three database sessions and executed the following command in one of his sessions： SQL> UPDATE persons SET ccode=’U031’ WHERE ccode=’U029’； 123 rows updated.  SQL> DELETE FROM persons WHERE exp=’Y’； 3 rows deleted.  The SYS user opens a new session after HR executed the above commands.  Which sessions can seethe effect of the UPDATE and DELETE commands （）

    • A、all sessions of the HR user only
    • B、all sessions of the HR user and the SYS user
    • C、the session of the HR user that executed the commands
    • D、all the sessions for which the database users have access privilege to the PERSONS table

    正确答案:C

  • 第2题：

    Examine the following steps performed on a database instance： 1. The DBA grants the CREATE TABLE system privilege to the SKD user with ADMIN OPTION. 2. The SKD user creates a table. 3. The SKD user grants the CREATE TABLE system privilege to the HR user. 4. The HR user creates a table. 5. The DBA revokes the CREATE TABLE system privilege from SKD.  Which statement is true after step 5 isperformed（）

    • A、The table created by SKD is not accessible and SKD cannot create new tables.
    • B、The tables created by SKD and HR remain， but both cannot create new tables.
    • C、The table created by HR remains and HR still has the CREATE TABLE system privilege.
    • D、The table created by HR remains and HR can grant the CREATE TABLE system privilege to other users.

    正确答案:C

  • 第3题：

    Examine the following query output: You issue the following command to import tables into the hr schema: $ > impdp hr/hr directory = dumpdir dumpfile = hr_new.dmp schemas=hr TRANSFORM=DISABLE_ARCHIVE_LOGGING: Y Which statement is true?（）

    • A、All database operations performed by the impdp command are logged.
    • B、Only CREATE INDEX and CREATE TABLE statements generated by the import are logged.
    • C、Only CREATE TABLE and ALTER TABLE statements generated by the import are logged.
    • D、None of the operations against the master table used by Oracle Data Pump to coordinate its activities are logged.

    正确答案:A

  • 第4题：

    What is true about this statement used during import？（） imp hr/hr tables= （employee， departments） file=hr.dmp ignore=y

    • A、It ignores duplicates.
    • B、It prevents character set translation on import.
    • C、It allows rows to be inserted into a table that already exists.
    • D、It ignores storage parameters in the DML executed during import.

    正确答案:C

  • 第5题：

    单选题
    Examine the statement:Create synonym emp for hr. employees;What happens when you issue the statement?（）
    A

    An error is generated.

    B

    You will have two identical tables in the HR schema with different names.

    C

    You create a table called employees in the HR schema based on you EMP table.

    D

    You create an alternative name for the employees table in the HR schema in your own schema.


    正确答案： B
    解析： 暂无解析

  • 第6题：

    单选题
    Examine the following steps performed on a database instance：  1：The DBA grants the CREATE TABLE system privilege to the SKD user with ADMIN OPTION.  2：The SKD usercreates a table.  3：The SKD user grants theCREATETABLE system privilege to the HR user.  4：The HR user creates a table.  5：The DBA revokes the CREATE TABLE system privilege from SKD.  Which statement is true after step 5 is performed（）
    A

    The table created by SKD isnot accessibleand SKD cannot create new tables.

    B

    The tables created by SKD and HR remain， but both cannot create new tables.

    C

    The table created by HR remains and HR still has the CREATE TABLE system privilege.

    D

    The table created by HR remains and HR can grant the CREATE TABLE system privilege to other users.


    正确答案： C
    解析： 暂无解析

  • 第7题：

    单选题
    You have created a database link， devdb.us.oracle.com， between the databases PRODDB and DEVDB. You want to import schema objects of the HR user using Oracle Data Pump from thedevelopment database， DEVDB， to the production database， PRODDB. You execute the following command on the target database server：  $impdp system/manager directory = DB_DATA dumpfile = schemas.dat schemas = hr  flashback_time = 2004-02-03 09：00  The command fails， displaying the following error： ORA-39001： invalid argument value  ORA-39000： bad dump file specification  ORA-31640： unable to open dump file “/home/oracle/schema/schemas.dat” for read ORA-27037： unable to obtain file status What would you do to overcome the error（）
    A

    remove the dumpfile option in the command

    B

    remove the flashback_time option in the command

    C

    remove the dumpfile option and add the network_link = devdb.us.oracle.com option in the command（Replace thedumpfile option with the network_link = devdb.us.oracle.com）

    D

    add the user， SYSTEM， to the schemas option in the command

    E

    remove the schemas option and add the network_link = devdb.us.oracle.com option in the command 

    F

    add network_link = devdb.us.oracle.com option in the command


    正确答案： D
    解析： 暂无解析

  • 第8题：

    单选题
    All the database users are presently connected to the database instance and working. The HR user hasopened three database sessions and executed the following command in one of his sessions：SQL> UPDATE persons SET ccode=’U031’ WHERE ccode=’U029’； 123 rows updated.SQL> DELETE FROM persons WHERE exp=’Y’；3 rows deleted. The SYS user opens a new session after HR executed the above commands.  Which sessions can see theeffect of the UPDATE and DELETE commands（）
    A

    All sessions of the HR user only

    B

    All sessions of the HR user and the SYS user

    C

    The session of the HR user that executed the commands

    D

    All the sessions for which the database users have access privilege to the PERSONS table


    正确答案： C
    解析： 暂无解析

  • 第9题：

    多选题
    On your Oracle 12c database, you invoked SQL *Loader to load data into the EMPLOYEES table in the HR schema by issuing the following command: $> sqlldr hr/hr@pdb table=employees Which two statements are true regarding the command?（）
    A

    It succeeds with default settings if the EMPLOYEES table belonging to HR is already defined in the database.

    B

    It fails because no SQL *Loader data file location is specified.

    C

    It fails if the HR user does not have the CREATE ANY DIRECTORY privilege.

    D

    It fails because no SQL *Loader control file location is specified.


    正确答案： D,B
    解析： 暂无解析

  • 第10题：

    单选题
    Your multitenant container database (CDB) contains a pluggable database, HR_PDB. The default permanent tablespace in HR_PDB is USERDATA. The container database (CDB) is open and you connect RMAN. You want to issue the following RMAN command: RMAN > BACKUP TABLESPACE hr_pdb:userdata; Which task should you perform before issuing the command?（）
    A

    Place the root container in ARHCHIVELOG mode.

    B

    Take the user data tablespace offline.

    C

    Place the root container in the nomount stage.

    D

    Ensure that HR_PDB is open.


    正确答案： C
    解析： 暂无解析

  • 第11题：

    单选题
    The ORDERS table belongs to the user OE. OE has granted the SELECT privilege on the ORDERS table to the user HR.Which statement would create a synonym ORD so that HR can execute the following query successfully?（）
    A

    CREATE SYNONYM ord FOR orders; This command is issued by OE 

    B

    CREATE PUBLIC SYNONYM ord FOR orders; This command is issued by OE 

    C

    CREATE SYNONYM ord FOR oe.orders; This command is issued by the database administrator 

    D

    CREATE PUBLIC SYNONYM ord FOR oe.orders; This command is issued by the database administrator 


    正确答案： A
    解析： 暂无解析

  • 第12题：

    单选题
    What is true about this statement used during import？（） imp hr/hr tables= （employee， departments） file=hr.dmp ignore=y
    A

    It ignores duplicates.

    B

    It prevents character set translation on import.

    C

    It allows rows to be inserted into a table that already exists.

    D

    It ignores storage parameters in the DML executed during import.


    正确答案： A
    解析： 暂无解析

  • 第13题：

    On your Oracle 12c database, you invoked SQL *Loader to load data into the EMPLOYEES table in the HR schema by issuing the following command: $> sqlldr hr/hr@pdb table=employees Which two statements are true regarding the command?（）

    • A、It succeeds with default settings if the EMPLOYEES table belonging to HR is already defined in the database.
    • B、It fails because no SQL *Loader data file location is specified.
    • C、It fails if the HR user does not have the CREATE ANY DIRECTORY privilege.
    • D、It fails because no SQL *Loader control file location is specified.

    正确答案:A,C

  • 第14题：

    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.

    正确答案:B

  • 第15题：

    You are connecting to an Oracle database server from a client by using the following connect string：   SQL> CONNECT hr/hr@pdserver.us.oracle.com：1521/proddb   Which naming method is being used in this case？（）

    • A、Local Naming
    • B、Easy Connect
    • C、External Naming
    • D、Directory Naming

    正确答案:B

  • 第16题：

    Examine the statement: Create synonym emp for hr. employees; What happens when you issue the statement? （）

    • A、An error is generated.
    • B、You will have two identical tables in the HR schema with different names.
    • C、You create a table called employees in the HR schema based on you EMP table.
    • D、You create an alternative name for the employees table in the HR schema in your own schema.

    正确答案:D

  • 第17题：

    单选题
    You need to import all definitions of objects belonging to the TS_EMPLOYEES tablespace by using the export file expdat.dmp. Which import statement is correct？（）
    A

    imp hr/hr TABLES=（ts_employees） rows=y

    B

    imp system/manager FROMUSER=hr file=expdat.dmp

    C

    imp hr/hr TRANSPORT_TABLESPACE=y file=expdat.dmp

    D

    imp system/manager TRANSPORT_TABLESPACE=y TABLESPACE=ts_employees


    正确答案： C
    解析： 暂无解析

  • 第18题：

    单选题
    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.


    正确答案： C
    解析： 暂无解析

  • 第19题：

    多选题
    On your Oracle 12c database, you invoked SQL *Loader to load data into the EMPLOYEES table in the HR schema by issuing the following command: $> sqlldr hr/hr@pdb table=employees Which two statements are true regarding the command?（）
    A

    It succeeds with default settings if the EMPLOYEES table belonging to HR is already defined in the database.

    B

    It fails because no SQL *Loader data file location is specified.

    C

    It fails if the HR user does not have the CREATE ANY DIRECTORY privilege.

    D

    It fails because no SQL *Loader control file location is specified.


    正确答案： C,B
    解析： 暂无解析

  • 第20题：

    单选题
    Examine the following steps performed on a database instance： 1. The DBA grants the CREATE TABLE system privilege to the SKD user with ADMIN OPTION. 2. The SKD user creates a table. 3. The SKD user grants the CREATE TABLE system privilege to the HR user. 4. The HR user creates a table. 5. The DBA revokes the CREATE TABLE system privilege from SKD.  Which statement is true after step 5 isperformed（）
    A

    The table created by SKD is not accessible and SKD cannot create new tables.

    B

    The tables created by SKD and HR remain， but both cannot create new tables.

    C

    The table created by HR remains and HR still has the CREATE TABLE system privilege.

    D

    The table created by HR remains and HR can grant the CREATE TABLE system privilege to other users.


    正确答案： C
    解析： 暂无解析

  • 第21题：

    单选题
    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 betweenPRODDB and DEVDB. You execute the following command on the PRODDB database server：$ impdp system/manager directory = DB_DATAdumpfile = schemas.datschemas = hr flashback_time = "TO_TIMESTAMP（’25-08-2007 14：35：00’， ’DD-MM-YYYY HH24：MI：SS’）"The command fails displaying the following error：ORA-39001： invalid argument valueORA-39000： bad dump file specification ORA-31640： unable to open dump file "/home/oracle/schema/schemas.dat" for read ORA-27037： unable toobtain file status What would you do to overcome the error（）
    A

    Add the user， SYSTEM， to the schemas option.

    B

    Add the network_link = devdb.us.oracle.com option.

    C

    Change the dumpfile option to schema.dat@devdb.us.oracle.com.

    D

    Replace the schemas option with the network_link = devdb.us.oracle.com

    E

    Replace the dumpfile option with the network_link = devdb.us.oracle.com


    正确答案： C
    解析： 暂无解析

  • 第22题：

    单选题
    Examine the following query output: You issue the following command to import tables into the hr schema: $ > impdp hr/hr directory = dumpdir dumpfile = hr_new.dmp schemas=hr TRANSFORM=DISABLE_ARCHIVE_LOGGING: Y Which statement is true?（）
    A

    All database operations performed by the impdp command are logged.

    B

    Only CREATE INDEX and CREATE TABLE statements generated by the import are logged.

    C

    Only CREATE TABLE and ALTER TABLE statements generated by the import are logged.

    D

    None of the operations against the master table used by Oracle Data Pump to coordinate its activities are logged.


    正确答案： C
    解析： 暂无解析

  • 第23题：

    单选题
    Examine the following query output: You issue the following command to import tables into the hr schema: $ > impdp hr/hr directory = dumpdir dumpfile = hr_new.dmp schemas=hr TRANSFORM=DISABLE_ARCHIVE_LOGGING: Y Which statement is true?（）
    A

    All database operations performed by the impdp command are logged.

    B

    Only CREATE INDEX and CREATE TABLE statements generated by the import are logged.

    C

    Only CREATE TABLE and ALTER TABLE statements generated by the import are logged.

    D

    None of the operations against the master table used by Oracle Data Pump to coordinate its activities are logged.


    正确答案： A
    解析： 暂无解析

  • 第24题：

    单选题
    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 betweenPRODDB and DEVDB. You execute the following command on the PRODDB database server：$ impdp system/manager directory = DB_DATAdumpfile = schemas.datschemas = hr flashback_time = "TO_TIMESTAMP（’25-08-2007 14：35：00’， ’DD-MM-YYYY HH24：MI：SS’）"The command fails displaying the following error：ORA-39001： invalid argument valueORA-39000： bad dump file specification ORA-31640： unable to open dump file "/home/oracle/schema/schemas.dat" for read ORA-27037： unable toobtain file status What would you do to overcome the error（）
    A

    Add the user， SYSTEM， to the schemas option.

    B

    Add the network_link = devdb.us.oracle.com option.

    C

    Change the dumpfile option to schema.dat@devdb.us.oracle.com.

    D

    Replace the schemas option with the network_link = devdb.us.oracle.com

    E

    Replace the dumpfile option with the network_link = devdb.us.oracle.com


    正确答案： A
    解析： 暂无解析

相关内容