Examine the data in the EMPLOYEES table. 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

题目

Examine the data in the EMPLOYEES table. 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 EK_DIR 8000 120 Revi 20 110 SA_DIR 6500 On the EMPLOYEES table, EMPLOYEE_ID is the primary key. MGR_ID is the ID of managers and refers to the EMPLOYEE_ID. The JOB_ID column is a NOT NULL column. Evaluate this DELETE statement: DELETE employee_id, salary, job_id FROM employees WHERE dept_id = 90; Why does the DELETE statement fail when you execute it?（）

  • A、There is no row with dept_id 90 in the EMPLOYEES table.
  • B、You cannot delete the JOB_ID column because it is a NOT NULL column.
  • C、You cannot specify column names in the DELETE clause of the DELETE statement.
  • D、You cannot delete the EMPLOYEE_ID column because it is the primary key of the table.
相似考题

1.Methods and techniques used to examine cost and technical data are called feasibility studies. The economic aspects of a feasibility study include interest rates, present worth factors, operating costs, depreciation and _____.A . Capitalization costs.B . Technical skill requirements.C . Technology forecasting.D . Strategic marketing intelligence.E . All of the above.

2.Examine the following RMAN script:Which statement describes the purpose of the script?()A. The data file is checked for physical corruption and backed up if found clean.B. The backup of data file 5 is performed and the interactive messages during the backup are suppressed.C. The existing backup for the data file is checked and the backup is performed if there are changes in the data file after the last backup.D. The backup of data file 5 is performed and all SQL statements that are executed during RMAN compilation and their results are displayed

3.View the exhibit and examine the output.Which statement can be an inference from the output?()A. The FRA disk group has an asynchronous I/O bottleneckB. The least number of I/Os are performed on the last data file in the listC. The number of times that the backup or restore process directed the OS to wait until an I/O was complete is the highest for the last data file in the listD. The number of times that the backup or restore process made an OS call to poll for I/O completion in Nonblocking mode is the least for the FRA disk group

4.The context clue used in the sentence “Many United Nations’ employe.es are polyglots. Ms. Mary, for example, speaks five languages” is ___.

参考答案和解析
正确答案:C
更多“Examine the data in the EMPLOYE”相关问题

  • 第1题：

    View the Exhibit and examine the Data Pump architecture. Identify the numbered components.()

    A. 1 - Oracle Loader, 2 - Oracle Data Pump, 3 - Direct Path API

    B. 1 - Oracle Data Pump, 2 - Direct Path API, 3 - Oracle Loader

    C. 1 - Direct Path API, 2 - Oracle Loader, 3 - Oracle Data Pump

    D. 1 - Oracle Loader, 2 - Direct Path API, 3 - Oracle Data Pump


    参考答案：A

  • 第2题：

    Examine the following RMAN script:RMAN> run {debug on;allocate channel c1 type disk;backup datafile 5;}Which statement describes the purpose of the script?()

    A. The data file is checked for physical corruption and backed up if found clean.

    B. The backup of data file 5 is performed and the interactive messages during the backup are suppressed.

    C. The existing backup for the data file is checked and the backup is performed if there are changes in the data file after the last backup.

    D. The backup of data file 5 is performed and all SQL statements that are executed during RMAN compilation and their results are displayed


    参考答案：D

  • 第3题：

    Exhibit:Examine the data in the EMPLOYEES table.Examine the subquery:SELECT last_nameFROM employeesWHERE salary IN (SELECT MAX(salary)FROM employeesGROUP BY department_id);Which statement is true?()

    A. The SELECT statement is syntactically accurate.

    B. The SELECT statement does not work because there is no HAVING clause.

    C. The SELECT statement does not work because the column specified in the GROUP BY clause is not in the SELECT list.

    D. The SELECT statement does not work because the GROUP BY clause should be in the main query and not in the subquery.


    参考答案：A

  • 第4题：

    Examine the data in the EMPLOYEES and EMP_HIST tables:The EMP_HIST table is updated at the end of every year. The employee ID, name, job ID, and salary of each existing employee are modified with the latest data. New employee details are added to the table.Which statement accomplishes this task?（）

    A.

    B.

    C.

    D.


    参考答案：B

  • 第5题：

    Your multitenant container database (CDB) is running in ARCHIVELOG mode. You connect to the CDB RMAN.Examine the following command and its output:You execute the following command:RMAN > BACKUP DATABASE PLUS ARCHIVELOG;Which data files will be backed up?（）

    A. Data files that belong to only the root container

    B. Data files that belong to the root container and all the pluggable databases (PDBs)

    C. Data files that belong to only the root container and PDB$SEED

    D. Data files that belong to the root container and all the PDBs excluding PDB$SEED


    参考答案：B

  • 第6题：

    You are the administrator of a SQL Server 2000 computer. The server contains database named Sales. Users report that they cannot add new data to the database. You examine the properties of the database. The database is configured as shown in the Sales Properties exhibit.

    You examine drive E. The hard disk is configured as shown in the Local Disk Properties exhibit.

    You want the users to be able to add data, and you want to minimize administrative overhead. What should you do?

    A．Increase the maximum file size of Sales_Data to 1,500MB.

    B．Use the DBCC SHRINKDATABASE statement.

    C．Set automatic file growth to 10 percent.

    D．Create another data file named Sales_Data2 in a new SECONDARY filegroup.


    正确答案：A
    解析：Explanation: By examining the first exhibit we see that the database has reached its maximum size of 1001 MB. The data file is located on drive E and the second exhibit shows us that there is enough free space on that disk to increase the maximum size of the data file to 1,500 MB.

    Incorrect Answers:
    B: DBCC SHRINKDATABASE could possibly shrink the database and new records could be added for a while, but it would just be a temporary solution.

    C: The database is already set to automatic file growth, but it has reached the maximum size.

    D: The primary file has reached it maximum size. A secondary filegroup would help if it was set to the default file group. New data would still be added to the primary filegroup which is at its maximum size.

  • 第7题：

    Examine the following options，which Spanning Tree Protocol （STP） protection mechanism disables aswitch port if the port receives a Bridge Protocol Data Unit （BPDU）？（）

    • A、Uplink Fast
    • B、Port Fast
    • C、BPDU Guard
    • D、Root Guard

    正确答案:C

  • 第8题：

    Examine the following statement that is used to modify the constraint on the SALES table： SQL> ALTER TABLE SALES MODIFY CONSTRAINT pk DISABLE VALIDATE； Which three statements are true regarding the above command（）

    • A、The constraint remains valid.
    • B、The index on the constraint is dropped.
    • C、It allows the loading of data into the table using SQL*Loader.
    • D、New data conforms to the constraint， but existing data is not checked
    • E、It allows the data manipulation on the table using INSERT/UPDATE/DELETE SQL statements.

    正确答案:A,B,C

  • 第9题：

    单选题
    View the Exhibit and examine the output of the query in different times when the following command runs in an RMAN sessions: RMAN> BACKUP DATABASE FILESPERSET 2; The database has seven data files. Why is the %_COMPLETE refreshed to 13.59 in the third output after reaching 88.77?（）
    A

    Because the progress is reported for each data file

    B

    Because the progress is reported for each backup set

    C

    Because other RMAN sessions have issued the same BACKUP command

    D

    Because new data files have been added to the database while the RMAN backup is in progress


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

  • 第10题：

    多选题
    Examine the following statement that is used to modify the constraint on the SALES table： SQL> ALTER TABLE SALES MODIFY CONSTRAINT pk DISABLE VALIDATE； Which three statements are true regarding the above command（）
    A

    The constraint remains valid.

    B

    The index on the constraint is dropped.

    C

    It allows the loading of data into the table using SQL*Loader.

    D

    New data conforms to the constraint， but existing data is not checked

    E

    It allows the data manipulation on the table using INSERT/UPDATE/DELETE SQL statements.


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

  • 第11题：

    单选题
    Examine the following RMAN script：   RMAN> run { debug on；  allocate channel c1 type disk； backup datafile 5； }   Which statement describes the purpose of the script？（）
    A

     The data file is checked for physical corruption and backed up if found clean.

    B

     The backup of data file 5 is performed and the interactive messages during the backup are suppressed.

    C

     The existing backup for the data file is checked and the backup is performed if there are changes in the data file after the last backup.

    D

     The backup of data file 5 is performed and all SQL statements that are executed during RMAN compilation and their results are displayed


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

  • 第12题：

    单选题
    Examine the following command: ALTER DISKGROUP data MOUNT FORCE; In which scenario can you use the above command to mount the disk group? （）
    A

    when ASM disk goes offline

    B

    when one or more ASM files are dropped

    C

    when some disks in a disk group are offline

    D

    when some disks in a failure group for a disk group are rebalancing


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

  • 第13题：

    Examine the following command that is executed for the TRANSPORT table in the SH schema:Which statement describes the significance of this command?()

    A. It collects statistics into the pending area in the data dictionary

    B. It creates a virtual hidden column in the CUSTOMERS_OBE table

    C. It collects statistics with AUTO_SAMPLE_SIZE for ESTIMATE_PERCENT

    D. It creates a histogram to hold skewed information about the data in the columns


    参考答案：B

  • 第14题：

    Examine the data from the ORDERS and CUSTOMERS tables.Evaluate the SQL statement:What is the result when the query is executed?()

    A.

    B.

    C.

    D. The query fails because the subquery returns more than one row.

    E. The query fails because the outer query and the inner query are using different tables.


    参考答案：D

  • 第15题：

    Examine the following scenario:The target database instance is running. The most recent backup available for the target database was taken two days ago. Log files switches have occurred in last two days. The target database is duplicated on the same host, using the Recovery Manager (RMAN) duplicate command as follows:Which statement is true about the duplicate database in this scenario?（）

    A. It contains data till the last backup

    B. It contains all data from target database until the current time

    C. It contains all data from only the committed transactions in the target database

    D. It contains all data except that which is used by the transactions in the current online redo file of target database


    参考答案：D

  • 第16题：

    Examine the data from the ORDERS and CUSTOMERS table.Which SQL statement retrieves the order ID, customer ID, and order total for the orders that are placed on the same day that Martin places his orders?（）

    A.

    B.

    C.

    D.


    参考答案：B

  • 第17题：

    Click the Exhibit button and examine the data in the EMPLOYEES table.Examine the subquery:SELECT last_nameFROM employeesWHERE salary IN (SELECT MAX(salary)FROM employeesGROUP BY department_id);Which statement is true?（）

    A.The SELECT statement is syntactically accurate.

    B.The SELECT statement does not work because there is no HAVING clause.

    C.The SELECT statement does not work because the column specified in the GROUP BY clause is not in the SELECT list.

    D.The SELECT statement does not work because the GROUP BY clause should be in the main query and not in the subquery.


    参考答案：A

  • 第18题：

    Click the Exhibit button and examine the data from the ORDERS and CUSTOMERS tables.Evaluate the SQL statement:SELECT *FROM ordersWHERE cust_id = (SELECT cust_idFROM customersWHERE cust_name = ‘Smith‘);What is the result when the query is executed?（）

    A.A

    B.B

    C.C

    D.D

    E.E


    参考答案：A

  • 第19题：

    Your multitenant container database (CDB) is running in ARCHIVELOG mode. You connect to the CDB RMAN. Examine the following command and its output: You execute the following command: RMAN > BACKUP DATABASE PLUS ARCHIVELOG; Which data files will be backed up?（）

    • A、Data files that belong to only the root container
    • B、Data files that belong to the root container and all the pluggable databases (PDBs)
    • C、Data files that belong to only the root container and PDB$SEED
    • D、Data files that belong to the root container and all the PDBs excluding PDB$SEED

    正确答案:B

  • 第20题：

    多选题
    Examine the following statement that is used to modify the primary key constraint on the SALES table： SQL> ALTER TABLE SALES MODIFY CONSTRAINT pk DISABLE VALIDATE； Which three statements aretrue regarding the above command（）
    A

    The constraint remains valid.

    B

    The index on the constraint is dropped.

    C

    It allows the loading of data into the table using SQL *Loader.

    D

    New data conforms to the constraint， but existing data is not checked.

    E

    It allows the data manipulation on the table using INSERT/UPDATE/DELETE SQL statements.


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

  • 第21题：

    多选题
    Examine the list of variables and their data types：  AME DATA Type  TS， TS1 TIMESTAMP  TSZ TIMESTAMP WITH TIME ZONE  TLZ TIMESTAMP WITH LOCAL TIME ZONE  IYM INTERVAL YEAR TO MONTH  IDS， IDSI INTERVAL YEAR To SECOND   Which three expressions using the new data and time data types are valid？（）
    A

    IDS* 2

    B

    TS + IYM

    C

    TS –TSI

    D

    IDS – TS

    E

    IDS + IYM


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

  • 第22题：

    单选题
    Examine the RMAN command： SWITCH DATAFILE ’/DISK3/user_data01.dbf’； Which command do you need to issue before you issue the above command， so that RMAN finds the file in the restored location of ’DISK2/user_data01.dbf’？ （）
    A

    RESTORE DATAFILE ’/DISK2/user_data01.dbf’

    B

    RESTORE DATAFILE ’/DISK3/user_data01.dbf’

    C

    SET NEWNAME FOR ’/DISK3/user_data01.dbf’ TO’/DISK2/user_data01.dbf’

    D

    SET NEWNAME FOR ’/DISK2/user_data01.dbf’ TO’/DISK3/user_data01.dbf’


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

  • 第23题：

    单选题
    Your network consists of a single Active Directory domain. All servers run Windows Server 2003 Service Pack 2 (SP2). All client computers run Windows XP Professional Service Pack 3 (SP3). You have a file server that contains two volumes named C and D. Volume C contains a folder named User1data. User1 is the owner of all files in the User1data folder. You copy the User1data folder to volume D. You examine the ownership of the User1data folder on volume D and discover that your user account is listed as the owner. You need to ensure that User1 is the owner of the User1data folder on volume D. What should you do? （）
    A

    Modify the Advanced Security settings for the User1data folder.

    B

    Modify the Advanced Attributes settings for the User1data folder.

    C

    Delete the User1data folder on volume

    D

    From Windows Explorer, move the User1data folder from volume C to volume


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

  • 第24题：

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


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

相关内容