网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
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.
参考答案
参考解析
解析：
暂无解析
更多 “单选题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.” 相关考题
考题
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.
考题
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
考题
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
考题
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
考题
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 onlyB、all sessions of the HR user and the SYS userC、the session of the HR user that executed the commandsD、all the sessions for which the database users have access privilege to the PERSONS table
考题
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.
考题
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.
考题
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.
考题
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.
考题
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 NamingB、Easy ConnectC、External NamingD、Directory Naming
考题
What is true about this statement used during import？（） imp hr/hr tables= （employee， departments） file=hr.dmp ignore=yA、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.
考题
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.
考题
单选题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.
考题
单选题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
考题
单选题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.
考题
单选题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.
考题
单选题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
考题
多选题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?（）AIt succeeds with default settings if the EMPLOYEES table belonging to HR is already defined in the database.BIt fails because no SQL *Loader data file location is specified.CIt fails if the HR user does not have the CREATE ANY DIRECTORY privilege.DIt fails because no SQL *Loader control file location is specified.
考题
单选题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 onlyB
All sessions of the HR user and the SYS userC
The session of the HR user that executed the commandsD
All the sessions for which the database users have access privilege to the PERSONS table
考题
单选题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.
考题
多选题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?（）AIt succeeds with default settings if the EMPLOYEES table belonging to HR is already defined in the database.BIt fails because no SQL *Loader data file location is specified.CIt fails if the HR user does not have the CREATE ANY DIRECTORY privilege.DIt fails because no SQL *Loader control file location is specified.
考题
单选题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
考题
单选题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.
考题
单选题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.
考题
单选题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
考题
单选题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.
考题
单选题What is true about this statement used during import？（） imp hr/hr tables= （employee， departments） file=hr.dmp ignore=yA
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.
考题
单选题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
热门标签
最新试卷