The （）of employees in this company has doubled...

第1题

[] Observe the structure of the table employees: The table contains 8475 records. One of the employees wants to know the names of all employees of the company. For this, he fires the following query: SELECT * FROM EMPLOYEES ORDER BY emp_fname; Since the operation performed on executing the query cannot fit into memory, it requires disk space to complete the operation. Which of the following types of segments will Oracle allocate to complete the operation and to provide the required result?（） Observe the structure of the table employees: The table contains 8475 records. One of the employees wants to know the names of all employees of the company. For this, he fires the following query: SELECT * FROM EMPLOYEES ORDER BY emp_fname; Since the operation performed on executing t

A、A. Rollback segment B、B. Temporary segment C、C. Data segment D、D. Index segment

点击查看答案

第2题

[单选题] Examine the structure of the EMPLOYEES, DEPARTMENTS, and TAX tables. For which situation would you use a nonequijoin query?（）

A、To find the tax percentage for each of the employees. B、To list the name, job id, and manager name for all the employees. C、To find the name, salary, and department name of employees who are not working with Smith. D、To find the number of employees working for the Administrative department and earning less then 4000. E、To display name, salary, manager ID, and department name of all the employees, even if the employees do not have a department ID assigned.

点击查看答案

第3题

[单选题] You added a PHONE_NUMBER column of NUMBER data type to an existing EMPLOYEES table. The EMPLOYEES table already contains records of 100 employees. Now, you want to enter the phone numbers of each of the 100 employees into the table. Some of the employees may not have a phone number available. Which data manipulation operation do you perform?（）

A、MERGE B、INSERT C、UPDATE D、ADD E、ENTER F、You cannot enter the phone numbers for the existing employee records.

点击查看答案

第4题

[单选题] You added a PHONE_NUMBER column of NUMBER data type to an existing EMPLOYEES table. The EMPLOYEES table already contains records of 100 employees. Now, you want to enter the phone numbers of each of the 100 employees into the table. Some of the employees may not have a phone number available. Which data manipulation operation do you perform?（）

A、MERGE B、INSERT C、UPDATE D、ADD E、ENTER F、You cannot enter the phone numbers for the existing employee records.

点击查看答案

第5题

[单选题] You added a PHONE_NUMBER column of NUMBER data type to an existing EMPLOYEES table. The EMPLOYEES table already contains records of 100 employees. Now, you want to enter the phone numbers of each of the 100 employees into the table. Some of the employees may not have a phone number available. Which data manipulation operation do you perform? （）

A、MERGE B、INSERT C、UPDATE D、ADD E、ENTER F、You cannot enter the phone numbers for the existing employee records.

点击查看答案

第6题

[] Click the Exhibit button to examine the structures of the EMPLOYEES, DEPARTMENTS, and TAX tables. For which situation would you use a nonequijoin query?（） Click the Exhibit button to examine the structures of the EMPLOYEES, DEPARTMENTS, and TAX tables. For which situation would you use a nonequijoin query?（）

A、A.to find the tax percentage for each of the employees B、B.to list the name, job_id, and manager name for all the employees C、C.to find the name, salary, and the department name of employees who are not working with Smith D、D.to find the number of employees working for the Administrative department and earning less than 4000 E、E.to display name, salary, manager ID, and department name of all the employees, even if the employees do not have a department ID assigned

点击查看答案

第7题

[] Click the Exhibit button to examine the structures of the EMPLOYEES, DEPARTMENTS, and TAX tables. For which situation would you use a nonequijoin query?（） Click the Exhibit button to examine the structures of the EMPLOYEES, DEPARTMENTS, and TAX tables. For which situation would you use a nonequijoin query?（）

A、A.to find the tax percentage for each of the employees B、B.to list the name, job_id, and manager name for all the employees C、C.to find the name, salary, and the department name of employees who are not working with Smith D、D.to find the number of employees working for the Administrative department and earning less than 4000 E、E.to display name, salary, manager ID, and department name of all the employees, even if the employees do not have a department ID assigned

点击查看答案

第8题

[多选题] Exhibit The COMMISSION column shows the monthly commission earned by the employee. Which two tasks would require subqueries or joins in order to be performed in a single step? （）

A、listing the employees who earn the same amount of commission as employee 3 B、finding the total commission earned by the employees in department 10 C、finding the number of employees who earn a commission that is higher than the average commission of the company D、listing the departments whose average commission is more that 600 E、listing the employees who do not earn commission and who are working for department 20 in descending order of the employee ID F、listing the employees whose annual commission is more than 6000

点击查看答案

第9题

[] Examine the structure of the EMPLOYEES, DEPARTMENTS, and TAX tables. EMPLOYEES NOT NULL, Primary EMPLOYEE_ID NUMBER Key VARCHAR2 EMP_NAME (30) VARCHAR2 JOB_ID (20) SALARY NUMBER References MGR_ID NUMBER EMPLOYEE_ID column DEPARTMENT_ID NUMBER Foreign key to DEPARTMENT_ID column of the DEPARTMENTS table DEPARTMENTS NOT NULL, DEPARTMENT_ID NUMBER Primary Key VARCHAR2 DEPARTMENT_NAME |30| References MGR_ID column MGR_ID NUMBER of the EMPLOYEES table TAX MIN_SALARY NUMBER MAX_SALARY NUMBER TAX_PERCENT NUMBER For which situation would you use a nonequijoin query?（） Examine the structure of the EMPLOYEES, DEPARTMENTS, and TAX tables. EMPLOYEES NOT NULL, Primary EMPLOYEE_ID NUMBER Key VARCHAR2 EMP_NAME (30) VARCHAR2 JO

A、A. To find the tax percentage for each of the employees. B、B. To list the name, job id, and manager name for all the employees. C、C. To find the name, salary, and department name of employees who are not working with Smith. D、D. To find the number of employees working for the Administrative department and earning less then 4000. E、E. To display name, salary, manager ID, and department name of all the employees, even if the employees do not have a department ID assigned.

点击查看答案

第10题

[多选题] Click the Exhibit button and examine the data from the EMP table. The COMMISSION column shows the monthly commission earned by the employee. Which two tasks would require subqueries or joins in order to be performed in a single step? （）

A、listing the employees who earn the same amount of commission as employee 3 B、finding the total commission earned by the employees in department 10 C、finding the number of employees who earn a commission that is higher than the average commission of the company D、listing the departments whose average commission is more than 600 E、listing the employees who do not earn commission and who are working for department 20 in descending order of the employee ID F、listing the employees whose annual commission is more than 6000

点击查看答案

The （）of employees in this company has doubled.

请使用微信扫码支付