单选题 Choose ONE. A script abc.sql must be executed to perform a certain task. User HR password HR exists in the target database and the account is unlocked. The TNSNAMES.ORA file is up to date.Examine this command attempted by the user:
$ sqlplus hr/hr@orc1 @abc What will happen and why?
A、The command succeeds and HR will be connected to the orcl database instance, and the abc script will be executed.
B、The command fails because the script must refer to the full path name.
C、The command succeeds and HR will be connected to the orcl database and after logging out to the abc database.
D、The command fails and reports an error because @ is used twice.
单选题 In one of your databases, the user HR has the password HRMGR. You want to connect to a database instance whose listener listens on port 1531 by using this statement:CONNECT HR/HRMGR@orcl No name server is used. Which statement is true about ORCL?
A、
It must be the value of the SERVICE_NAMES parameter on the client side
B、
It must resolve to a valid connect descriptor in the server’s tnsnames.ora file
C、
It must resolve to a valid connect descriptor in the client’s tnsnames.ora file
D、
It must be the name of the database to whose instance HR wishes to connect
E、
It must be the name of the server running the database to whose instance HR wishes to connect
单选题 Examine this command and some partial output: Why does the DB01.abc.com service show unknown status?
A、
The service DB01.abc.com is dynamically registered
B、
The LOCAL_LISTENER database parameter is not set to a service name that refers to LISTENER_1
C、
The service DB01.abc.com is statically registered
D、
The listener is not listening on the default port 1521
E、
The SID_LIST_LISTENER section is not contained in the LISTENER.ORA file
单选题 Choose the best answer.Table HR. EMPLOYEES contains a row where the EMPLOYEE_ID is 109. User ALICE has no privileges to access HR . EMPLOYEES.
User ALICE starts a session.
User HR starts a session and successfully executes these statements:
GRANT DELETE ON employees TO alice;
UPDATE employees SET salary = 24000 WHERE employee_id = 109;
In her existing session ALICE then executes:
DELETE FROM hr.employees WHERE employee_id = 109;
What is the result?
A、The DELETE command will immediately delete the row.
B、The DELETE command will immediately return an error.
C、The DELETE command will wait for HR'S transaction to end then delete the row.
D、
The DELETE command will wait for HR'S transaction to end then return an error.
单选题 Choose the best answer. Examine the description of the EMPLOYEES table: Name Null? Type
- EMPLOYEE_ID NOT NULL NUMBER(38) SALARY NOT NULL NUMBER(38) DEPARTMENT_ID
Which statement increases
each employee's SALARY by the minimum SALARY for their DEPARTMENT_ID?
A、
UPDATE employees e1 SET salary = salary + (SELECT MIN (salary) FROM employees e2) ;
B、
UPDATE employees e1 SET salary = (SELECT e2.salary + MIN(e2. salary) FROM employees e2 WHERE e1. department_id = e2.department_id GROUP BY e2. department_id) ;
C、
UPDATE employees e1 SET salary = salary + (SELECT MIN(e1.salary) FROM employees e2 WHERE e1. department_id = e2. department_id) ;
D、
UPDATE employees e1 SET salary = (SELECT e1.salary + MIN(e2.salary) FROM employees e2 WHERE e1. department_id = e2. department_id) ;
单选题 Choose the best answer.Examine this statement which executes successfully:
INSERT ALL WHEN SAL > 20000
THEN INTO special_sal VALUES (EMP_ID, SAL)
ELSE INTO sal_history VALUES (EMP_ID, HIREDATE, SAL)
INTO mgr_history VALUES (EMP_ID, MGR ,SAL)
SELECT employee_id EMP_ID , hire_date HIREDATE, salary SAL, manager_id MGR FROM employees WHERE employee_id < 125; .
Which is true?
A、
Only if the salary is 20000 or less and the employee id is 125 or higher, insert EMPLOYEE_ID, MANAGER_ID, and SALARY into the MGR_HISTORY table.
B、
Only if the salary is 20000 or less and the employee id is less than 125, insert EMPLOYEE_ID, MANAGER_ID, and SALARY into the MGR_HISTORY table.
C、
Regardless of salary and employee id, insert EMPLOYEE_ID, MANAGER_ID, and SALARY into the MGR_HISTORY table.
D、
Regardless of salary, only if the employee id is less than 125, insert EMPLOYEE_ID, MANAGER_ID, and SALARY into the MGR_HISTORY table.
单选题 Choose the best answer. Why would you use the TNSPING hr command?
A、
to verify if a requested service is available
B、
to determine if the listener for the HR net service name can be reached
C、
to verify if the HR database instance is up
D、
to check and list multiple ORACLE_HOME locations on the server
E、
to validate the network connectivity between a client and the database instance
单选题 Choose the best answer.
Examine the description of the EMPLOYEES table:
Name Null? Type
--------------------------------------------------------------------------
EMPLOYEE_ID NOT NULL NUMBER(38)
SALARY NOT NULL NUMBER (38)
DEPARTMENT_ID NOT NULL NUMBER(38)
Which statement increases each employee's SALARY by the minimum SALARY for their DEPARTMENT_ID?
A、
UPDATE employees e1 SET salary = salary + (SELECT MIN (salary) FROM employees e2) ;
B、
UPDATE employees e1 SET salary =(SELECT e2.salary + MIN(e2. salary) FROM employees e2
WHERE e1. department_id = e2.department_id GROUP BY e2. department_id) ;
C、
UPDATE employees e1 SET salary = salary + (SELECT MIN(e1.salary) FROM employees e2WHERE e1. department_id = e2. department_id) ;
D、
UPDATE employees e1 SET salary =(SELECT e1.salary + MIN(e2.salary) FROM employees e2
WHERE e1. department_id = e2. department_id) ;
2023-02-23
共209道
