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

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

相似考题

1.Examine the data in the EMPLOYEES and DEPARTMENTS tables:Also examine the SQL statements that create the EMPLOYEES and DEPARTMENTS tables:On the EMPLOYEES table, EMPLOYEE_ID is the primary key.MGR_ID is the ID of managers and refers to the EMPLOYEE_ID.DEPT_ID is foreign key to DEPARTMENT_ID column of the DEPARTMENTS table.On the DEPARTMENTS table, DEPARTMENT_ID is the primary key.Examine this DELETE statement:What happens when you execute the DELETE statement?（）A. Only the row with department ID 40 is deleted in the DEPARTMENTS table.B. The statement fails because there are child records in the EMPLOYEES table with department ID 40.C. The row with department ID 40 is deleted in the DEPARTMENTS table. Also the rows with employee IDs 110 and 106 are deleted from the EMPLOYEES table.D. The row with department ID 40 is deleted in the DEPARTMENTS table. Also the rows with employee IDs 106 and 110 and the employees working under employee 110 are deleted from the EMPLOYEES table.E. The row with department ID 40 is deleted in the DEPARTMENTS table. Also all the rows in the EMPLOYEES table are deleted.F. The statement fails because there are no columns specifies in the DELETE clause of the DELETE statement.

2.What type of constraint is used to ensure that each row inserted into the EMPLOYEE table with a value in the WORKDEPT column has a row with a corresponding value in the DEPTNO column of the DEPARTMENT table?（）A.A check constraint on the EMPLOYEE tableB.A unique constraint on the EMPLOYEE table WORKDEPT columnC.A foreign key reference from the DEPARTMENT tables DEPTNO column to the WORKDEPT column of the EMPLOYEE tableD.A foreign key reference from the EMPLOYEE tables WORKDEPT column to the DEPTNO column of the DEPARTMENT table

3.What type of constraint is used to ensure that each row inserted into the EMPLOYEE table with a value in the WORKDEPT column has a row with a corresponding value in the DEPTNO column of the DEPARTMENT table?（）A、A check constraint on the EMPLOYEE tableB、A unique constraint on the EMPLOYEE table WORKDEPT columnC、A foreign key reference from the DEPARTMENT tables DEPTNO column to the WORKDEPT column of the EMPLOYEE tableD、A foreign key reference from the EMPLOYEE tables WORKDEPT column to the DEPTNO column of the DEPARTMENT table

4.Examine the data in the EMPLOYEES and DEPARTMENTS tables:EMPLOYEESEMP_NAME DEPT_ID MGR_ID JOB_ID SALARYEMPLOYEE_ID101 Smith 20 120 SA_REP 4000102 Martin 10 105 CLERK 2500103 Chris 20 120 IT_ADMIN 4200104 John 30 108 HR_CLERK 2500105 Diana 30 108 IT_ADMIN 5000106 Smith 40 110 AD_ASST 3000108 Jennifer 30 110 HR_DIR 6500110 Bob 40 EX_DIR 8000120 Ravi 20 110 SA*DIR 6500DEPARTMENTSDEPARTMENT_ID DEPARTMENT_NAME10 Admin20 Education30 IT40 Human ResourcesAlso examine the SQL statements that create the EMPLOYEES and DEPARTMENTS tables:CREATE TABLE departments(department_id NUMBER PRIMARY KEY,department _ name VARCHAR2(30));CREATE TABLE employees(EMPLOYEE_ID NUMBER PRIMARY KEY,EMP_NAME VARCHAR2(20),DEPT_ID NUMBER REFERENCESdepartments(department_id),MGR_ID NUMBER REFERENCESemployees(employee id),MGR_ID NUMBER REFERENCESemployees(employee id),JOB_ID VARCHAR2(15).SALARY NUMBER);ON the EMPLOYEES,On the EMPLOYEES table, EMPLOYEE_ID is the primary key.MGR_ID is the ID of managers and refers to the EMPLOYEE_ID. DEPT_ID is foreign key to DEPARTMENT_ID column of the DEPARTMENTS table. On the DEPARTMENTS table, DEPARTMENT_ID is the primary key.Examine this DELETE statement:DELETEFROM departmentsWHERE department id = 40;What happens when you execute the DELETE statement?（）

更多“单选题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 ex”相关问题

  • 第1题：

    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

  • 第2题：

    Evaluate the SQL statement:TRUNCATE TABLE DEPT;Which three are true about the SQL statement? （）

    • A、It releases the storage space used by the table.
    • B、It does not release the storage space used by the table.
    • C、You can roll back the deletion of rows after the statement executes.
    • D、You can NOT roll back the deletion of rows after the statement executes.
    • E、An attempt to use DESCRIBE on the DEPT table after the TRUNCATE statement executes will display an error.
    • F、You must be the owner of the table or have DELETE ANY TABLE system privileges to truncate the DEPT table

    正确答案:A,D,F

  • 第3题：

    You executed this command to create a temporary table：  SQL> CREATE GLOBAL TEMPORARY TABLE report_work_area （startdate DATE， enddate DATE， class CHAR（20））ON COMMIT PRESERVE ROWS；  Which statement is true about the rows inserted into the REPORT_WORK_AREA table during atransaction （）

    • A、The rows stay in the table only until session termination.
    • B、The rows stay in the table only until the next transaction starts on the table.
    • C、The rows are visible to all current sessions after the transaction is committed.
    • D、The rows stay available for subsequent sessions after the transaction is committed

    正确答案:A

  • 第4题：

    Examine the data in the EMPLOYEES and DEPARTMENTS tables: EMPLOYEES EMP_NAME DEPT_ID MGR_ID JOB_ID SALARY EMPLOYEE_ID 101 Smith 20 120 SA_REP 4000 102 Martin 10 105 CLERK 2500 103 Chris 20 120 IT_ADMIN 4200 104 John 30 108 HR_CLERK 2500 105 Diana 30 108 IT_ADMIN 5000 106 Smith 40 110 AD_ASST 3000 108 Jennifer 30 110 HR_DIR 6500 110 Bob 40 EX_DIR 8000 120 Ravi 20 110 SA*DIR 6500 DEPARTMENTS DEPARTMENT_ID DEPARTMENT_NAME 10 Admin 20 Education 30 IT 40 Human Resources Also examine the SQL statements that create the EMPLOYEES and DEPARTMENTS tables: CREATE TABLE departments (department_id NUMBER PRIMARY KEY, department _ name VARCHAR2(30)); CREATE TABLE employees (EMPLOYEE_ID NUMBER PRIMARY KEY, EMP_NAME VARCHAR2(20), DEPT_ID NUMBER REFERENCES departments(department_id), MGR_ID NUMBER REFERENCES employees(employee id), MGR_ID NUMBER REFERENCES employees(employee id), JOB_ID VARCHAR2(15). SALARY NUMBER); ON the EMPLOYEES, On the EMPLOYEES table, EMPLOYEE_ID is the primary key. MGR_ID is the ID of managers and refers to the EMPLOYEE_ID. DEPT_ID is foreign key to DEPARTMENT_ID column of the DEPARTMENTS table. On the DEPARTMENTS table, DEPARTMENT_ID is the primary key. Examine this DELETE statement: DELETE FROM departments WHERE department id = 40; What happens when you execute the DELETE statement?（）

    • A、Only the row with department ID 40 is deleted in the DEPARTMENTS table.
    • B、The statement fails because there are child records in the EMPLOYEES table with department ID 40.
    • C、The row with department ID 40 is deleted in the DEPARTMENTS table. Also the rows with employee IDs 110 and 106 are deleted from the EMPLOYEES table.
    • D、The row with department ID 40 is deleted in the DEPARTMENTS table. Also the rows with employee IDs 106 and 110 and the employees working under employee 110 are deleted from the EMPLOYEES table.
    • E、The row with department ID 40 is deleted in the DEPARTMENTS table. Also all the rows in the EMPLOYEES table are deleted.
    • F、The statement fails because there are no columns specifies in the DELETE clause of the DELETE statement.

    正确答案:B

  • 第5题：

    What is the purpose of importing from an export，and specifying that no rows be imported and that the output goes to a log file？（）

    • A、To verify space requirements in the target database before importing.
    • B、To generate the SQL for the DDL operations that would occur during import.
    • C、To check character set compatibility between the export file and the target database.
    • D、To check for integrity constraint violations that would occur in the target database.

    正确答案:C

  • 第6题：

    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

  • 第7题：

    单选题
    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
    解析： 暂无解析

  • 第8题：

    单选题
    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
    解析： 暂无解析

  • 第9题：

    单选题
    You executed this command to create a temporary table：  SQL> CREATE GLOBAL TEMPORARY TABLE report_work_area （startdate DATE， enddate DATE， class CHAR（20））ON COMMIT PRESERVE ROWS；  Which statement is true about the rows inserted into the REPORT_WORK_AREA table during atransaction （）
    A

    The rows stay in the table only until session termination.

    B

    The rows stay in the table only until the next transaction starts on the table.

    C

    The rows are visible to all current sessions after the transaction is committed.

    D

    The rows stay available for subsequent sessions after the transaction is committed


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

  • 第10题：

    单选题
    You executed this command to create a temporary table： SQL> CREATE GLOBAL TEMPORARY TABLE report_work_area （startdate DATE， enddateDATE， class CHAR（20）） ON COMMIT PRESERVE ROWS； Which statement is true about the rows inserted into the REPORT_WORK_AREA table during a transaction（）
    A

    The rows stay in the table only until session termination.

    B

    The rows stay in the table only until the next transaction starts on the table.

    C

    The rows are visible to all current sessions after the transaction is committed.

    D

    The rows stay available for subsequent sessions after the transaction is committed


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

  • 第11题：

    单选题
    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
    解析： 暂无解析

  • 第12题：

    单选题
    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
    解析： 暂无解析

  • 第13题：

    Which three are true?（）

    • A、A MERGE statement is used to merge the data of one table with data from another.
    • B、A MERGE statement replaces the data of one table with that of another.
    • C、A MERGE statement can be used to insert new rows into a table.
    • D、A MERGE statement can be used to update existing rows in a table.

    正确答案:A,C,D

  • 第14题：

    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

  • 第15题：

    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

  • 第16题：

    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

  • 第17题：

    You executed this command to create a temporary table： SQL> CREATE GLOBAL TEMPORARY TABLE report_work_area （startdate DATE， enddateDATE， class CHAR（20）） ON COMMIT PRESERVE ROWS； Which statement is true about the rows inserted into the REPORT_WORK_AREA table during a transaction（）

    • A、The rows stay in the table only until session termination.
    • B、The rows stay in the table only until the next transaction starts on the table.
    • C、The rows are visible to all current sessions after the transaction is committed.
    • D、The rows stay available for subsequent sessions after the transaction is committed

    正确答案:A

  • 第18题：

    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

  • 第19题：

    单选题
    Examine the data in the EMPLOYEES and DEPARTMENTS tables: EMPLOYEES EMP_NAME DEPT_ID MGR_ID JOB_ID SALARY EMPLOYEE_ID 101 Smith 20 120 SA_REP 4000 102 Martin 10 105 CLERK 2500 103 Chris 20 120 IT_ADMIN 4200 104 John 30 108 HR_CLERK 2500 105 Diana 30 108 IT_ADMIN 5000 106 Smith 40 110 AD_ASST 3000 108 Jennifer 30 110 HR_DIR 6500 110 Bob 40 EX_DIR 8000 120 Ravi 20 110 SA*DIR 6500 DEPARTMENTS DEPARTMENT_ID DEPARTMENT_NAME 10 Admin 20 Education 30 IT 40 Human Resources Also examine the SQL statements that create the EMPLOYEES and DEPARTMENTS tables: CREATE TABLE departments (department_id NUMBER PRIMARY KEY, department _ name VARCHAR2(30)); CREATE TABLE employees (EMPLOYEE_ID NUMBER PRIMARY KEY, EMP_NAME VARCHAR2(20), DEPT_ID NUMBER REFERENCES departments(department_id), MGR_ID NUMBER REFERENCES employees(employee id), MGR_ID NUMBER REFERENCES employees(employee id), JOB_ID VARCHAR2(15). SALARY NUMBER); ON the EMPLOYEES, On the EMPLOYEES table, EMPLOYEE_ID is the primary key. MGR_ID is the ID of managers and refers to the EMPLOYEE_ID. DEPT_ID is foreign key to DEPARTMENT_ID column of the DEPARTMENTS table. On the DEPARTMENTS table, DEPARTMENT_ID is the primary key. Examine this DELETE statement: DELETE FROM departments WHERE department id = 40; What happens when you execute the DELETE statement?（）
    A

    Only the row with department ID 40 is deleted in the DEPARTMENTS table.

    B

    The statement fails because there are child records in the EMPLOYEES table with department ID 40.

    C

    The row with department ID 40 is deleted in the DEPARTMENTS table. Also the rows with employee IDs 110 and 106 are deleted from the EMPLOYEES table.

    D

    The row with department ID 40 is deleted in the DEPARTMENTS table. Also the rows with employee IDs 106 and 110 and the employees working under employee 110 are deleted from the EMPLOYEES table.

    E

    The row with department ID 40 is deleted in the DEPARTMENTS table. Also all the rows in the EMPLOYEES table are deleted.

    F

    The statement fails because there are no columns specifies in the DELETE clause of the DELETE statement.


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

  • 第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 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
    解析： 暂无解析

  • 第21题：

    单选题
    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
    解析： 暂无解析

  • 第22题：

    多选题
    Which three are true? （）
    A

    A MERGE statement is used to merge the data of one table with data from another.

    B

    A MERGE statement replaces the data of one table with that of another.

    C

    A MERGE statement can be used to insert new rows into a table.

    D

    A MERGE statement can be used to update existing rows in a table.


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

  • 第23题：

    单选题
    What type of constraint is used to ensure that each row inserted into the EMPLOYEE table with a value in the WORKDEPT column has a row with a corresponding value in the DEPTNO column of the DEPARTMENT table?（）
    A

    A check constraint on the EMPLOYEE table

    B

    A unique constraint on the EMPLOYEE table WORKDEPT column

    C

    A foreign key reference from the DEPARTMENT tables DEPTNO column to the WORKDEPT column of the EMPLOYEE table

    D

    A foreign key reference from the EMPLOYEE tables WORKDEPT column to the DEPTNO column of the DEPARTMENT table


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

  • 第24题：

    单选题
    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
    解析： 暂无解析

相关内容