搜题

【单选题】

An employee cannot access the company database. You check the connection variables:<br /> <img src="https://nimg.ppkao.com/2018-08/tangxueping/2018080117475999780.jpg?sign=392cff1069108cab3f50076dccea680d&t=62d237c0" /><br /> What is a valid explanation for why one of the users is unable to connect to the database?（）

A、Bob has max_user_connections set to zero, which blocks all his connections

B、Joe has exceeded the max_user_connections global limit

C、All users are blocked because max_user_connections is accumulated over the host account information

D、Kay is already connected elsewhere and attempting to log in again

E、Connect_timeout is too small to allow a connection to occur

查看正确答案

更多“ An employee cannot access the company database. You check the connection variables:<br /> <img src="https://nimg.ppkao.com/2018-08/tangxueping/2018080117475999780.jpg?sign=392cff1069108cab3f50076dccea680d&t=62d237c0" /><br /> What is a valid explanation for why one of the users is unable to connect to the database?（）”相关的问题

第1题

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

点击查看答案

第2题

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

点击查看答案

第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题

[单选题] Examine the structure of the EMPLOYEES table: You issue these statements: At the end of this transaction, what is true?（）

A、You have no rows in the table. B、You have an employee with the name of James. C、You cannot roll back to the same savepoint more than once. D、Your last update fails to update any rows because employee ID 180 was already eleted.

点击查看答案

第5题

[单选题] Click the Exhibit button and examine the data in the EMPLOYEES table. 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.

点击查看答案

第6题

[] Examine the data in the EMPLOYEES table. 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: Why does the DELETE statement fail when you execute it?（） Examine the data in the EMPLOYEES table. 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: Why does the DELETE statement fail when you execute it?（）

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

点击查看答案

第7题

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

点击查看答案

第8题

[单选题] Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2(25) LAST_NAME VARCHAR2(25) HIRE_DATE DATE You issue these statements: CREATE table new_emp ( employee_id NUMBER, name VARCHAR2(30)); INSERT INTO new_emp SELECT employee_id , last_name from employees; Savepoint s1; UPDATE new_emp set name = UPPER(name); Savepoint s2; Delete from new_emp; Rollback to s2; Delete from new_emp where employee_id =180; UPDATE new_emp set name = 'James'; Rollback to s2; UPDATE new_emp set name = 'James' WHERE employee_id =180; Rollback; At the end of this transaction, what is true?（）

A、You have no rows in the table. B、You have an employee with the name of James. C、You cannot roll back to the same savepoint more than once. D、Your last update fails to update any rows because employee ID 180 was already deleted.

点击查看答案

第9题

[单选题] Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2(25) LAST_NAME VARCHAR2(25) HIRE_DATE DATE You issue these statements: CREATE table new_emp ( employee_id NUMBER, name VARCHAR2(30)); INSERT INTO new_emp SELECT employee_id , last_name from employees; Savepoint s1; UPDATE new_emp set name = UPPER(name); Savepoint s2; Delete from new_emp; Rollback to s2; Delete from new_emp where employee_id =180; UPDATE new_emp set name = 'James'; Rollback to s2; UPDATE new_emp set name = 'James' WHERE employee_id =180; Rollback; At the end of this transaction, what is true?（）

A、You have no rows in the table. B、You have an employee with the name of James. C、You cannot roll back to the same savepoint more than once. D、Your last update fails to update any rows because employee ID 180 was already deleted.

点击查看答案

第10题

[单选题] Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2(25) LAST_NAME VARCHAR2(25) HIRE_DATE DATE You issue these statements: CREATE table new_emp ( employe_id NUMBER, name VARCGAR2(30)); INSERT INTO new_emp SELECT employee_id, last_name from employees; Savepoint s1; UPDATE new_emp set name = UPPER(name); Savepoint s2; Delete from new_emp; Rollback to s2; Delete from new_emp where employee_id=180; UPDATE new_emp set name = 'James'; Rollback to s2; UPDATE new_emp sey name = 'James' Where employee_id=180; Rollback; At the end of this transaction, what is true?（）

A、You have no rows in the table. B、You have an employee with the name of James. C、You cannot roll back to the same savepoint more than once. D、Your last update fails to update any rows because employee ID 180 was already deleted.

点击查看答案

账号：登录

TOP

请使用微信扫码支付

订单号：
遇到问题请联系在线客服