the process id of last background command
the exit status of the last command
the exit status of the last background command
the process id of the current shell
the name of the command being executed
第1题:
A. show ip ospf [process - id] interface
B. show ip ospf neighbor
C. show ip ospf [process - id]
D. show ip ospf [process - id area - id] database
第2题:
Which statement is true regarding the Archiver (ARCn) process,archived log files,and recovery? ()
第3题:
Click the Exhibit button and examine the data in the EMPLOYEES and DEPARTMENTS tables.You want to retrieve all employees, whether or not they have matching departments in the departments table. Which query would you use?()
第4题:
Examine the structure of the EMPLOYEES and DEPARTMENTS tables: EMPLOYEES EMPLOYEE_ID NUMBER DEPARTMENT_ID NUMBER MANAGER_ID NUMBER LAST_NAME VARCHAR2(25) DEPARTMENTS DEPARTMENT_ID NUMBER MANAGER_ID NUMBER DEPARTMENT_NAME VARCHAR2(35) LOCATION_ID NUMBER You want to create a report displaying employee last names, department names, and locations. Which query should you use?()
第5题:
Examine the structure of the EMPLOYEES table: Column name Data type Remarks EMPLOYEE_ID NUMBER NOT NULL, Primary Key LAST_NAME VARCNAR2(30) FIRST_NAME VARCNAR2(30) JOB_ID NUMBER SAL NUMBER MGR_ID NUMBER References EMPLOYEE_ID column DEPARTMENT_ID NUMBER You need to create an index called NAME_IDX on the first name and last name fields of the EMPLOYEES table. Which SQL statement would you use to perform this task? ()
第6题:
Examine the structure of the EMPLOYEES and DEPARTMENTS tables: EMPLOYEES EMPLOYEE_ID NUMBER DEPARTMENT_ID NUMBER MANAGER_ID NUMBER LAST_NAME VARCHAR2(25) DEPARTMENTS DEPARTMENT_ID NUMBER MANAGER_ID NUMBER DEPARTMENT_NAME VARCHAR2(35) LOCATION_ID NUMBER You want to create a report displaying employee last names, department names, and locations. Which query should you use to create an equi-join?()
第7题:
SELECT last_name, department_name, location_id FROM employees , department ;
SELECT employees.last_name, departments.department_name, departments.location_id FROM employees e, departments D WHERE e.department_id = d.department_id;
SELECT e.last_name, d.department_name, d.location_id FROM employees e, departments D WHERE manager_id = manager_id;
SELECT e.last_name, d.department_name, d.location_id FROM employees e, departments D WHERE e.department_id = d.department_id;
第8题:
router-id 1.2.3.4
router-id 2011::1
router-id Loopback0
router-id FF02::5
第9题:
UPDATE employees SET first_name = 'John' SET last_name = 'Smith' WHERE employee_id = 180;
UPDATE employees SET first_name = 'John', SET last_name = 'Smoth' WHERE employee_id = 180;
UPDATE employee SET first_name = 'John' AND last_name = 'Smith' WHERE employee_id = 180;
UPDATE employee SET first_name = 'John', last_name = 'Smith' WHERE employee_id = 180;
第10题:
the process id of last background command
the exit status of the last command
the exit status of the last background command
the process id of the current shell
the name of the command being executed
第11题:
show ip ospf [process - id] interface
show ip ospf neighbor
show ip ospf [process - id]
show ip ospf [process - id area - id] database
第12题:
A database backup, combined with archived redo log files, guarantees that all committed data can be recovered to the point of failure.
During recovery the ARCn background process copies its redo entries identified for recovery by the control file to the data files.
After each write to an archived log, the mandatory background process ARCn writes its log sequence number and the first and last SCN number within the log sequence to the control file.
At database recover time, and archived redo log is uniquely identified for recovery use by its redo thread number and destination ID number retrieved from the control file.
第13题:
The administrator wants to verify the current state of the OSPF database loading process. Which show command should the administrator use?()
第14题:
The command echo $! will produce what output?()
第15题:
The EMPLOYEES table contains these columns: EMPLOYEE_ID NUMBER(4) LAST_NAME VARCHAR2 (25) JOB_ID VARCHAR2(10) You want to search for strings that contain 'SA_' in the JOB_ID column. Which SQL statement do you use?()
第16题:
Examine the description of the EMPLOYEES table: EMP_ID NUMBER(4) NOT NULL LAST_NAME VARCHAR2(30) NOT NULL FIRST_NAME VARCHAR2(30) DEPT_ID NUMBER(2) Which statement produces the number of different departments that have employees with last name Smith?()
第17题:
Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2(25) LAST_NAME VARCHAR2(25) HIRE_DATE DATE Which UPDATE statement is valid?()
第18题:
LIST command
CROSSCHECK command
REPORT command
SHOW command
第19题:
SELECT employee_id, last_name, job_id FROM employees WHERE job_id LIKE '%SA/_%' ESCAPE '/';
SELECT employee_id, last_name, job_id FROM employees WHERE job_id LIKE '%SA_';
SELECT employee_id, last_name, job_id FROM employees WHERE job_id LIKE '%SA_' ESCAPE /;
SELECT employee_id, last_name, job_id FROM employees WHERE job_id = '%SA_';
第20题:
SELECT last_name, department_name FROM employees , departments(+);
SELECT last_name, department_name FROM employees JOIN departments(+);
SELECT last_name, department_name ON (e. department_ id = d. departments_id); FROM employees(+) e JOIN departments d
SELECT last_name, department_name FROM employees e RIGHT OUTER JOIN departments d ON (e.department_id = d.department_id);
SELECT last_name, department_name FROM employees(+) , departments ON (e. department _ id = d. department _id);
SELECT last_name, department_name FROM employees e LEFT OUTER JOIN departments d ON (e. department _ id = d. department _id);
第21题:
SELECT last_name, department_name FROM employees NATURAL JOIN departments;
SELECT last_name, department_name FROM employees JOIN departments ;
SELECT last_name, department_name FROM employees e JOIN departments d ON (e.department_id = d.department_id);
SELECT last_name, department_name FROM employees e RIGHT OUTER JOIN departments d ON (e.department_id = d.department_id);
SELECT last_name, department_name FROM employees FULL JOIN departments ON (e.department_id = d.department_id);
SELECT last_name, department_name FROM employees e LEFT OUTER JOIN departments d ON (e.department_id = d.department_id);
第22题:
SELECT e.last_name, d. department_name, d.location_id FROM employees e NATURAL JOIN departments D USING department_id ;
SELECT last_name, department_name, location_id FROM employees NATURAL JOIN departments WHERE e.department_id =d.department_id;
SELECT e.last_name, d.department_name, d.location_id FROM employees e NATURAL JOIN departments d;
SELECT e.last_name, d.department_name, d.location_id FROM employees e JOIN departments d USING (department_id );
第23题:
SELECT COUNT (*) FROM employees WHERE last _name='smith';
SELECT COUNT (dept_id) FROM employees WHERE last _name='smith';
SELECT DISTINCT (COUNT (dept_id) FROM employees WHERE last _name='smith';
SELECT COUNT (DISTINCT dept_id) FROM employees WHERE last _name='smith';
SELECT UNIQE (dept_id) FROM employees WHERE last _name='smith';
第24题:
CREATE INDEX NAME _IDX (first_name, last_name);
CREATE INDEX NAME _IDX (first_name, AND last_name)
CREATE INDEX NAME_IDX ON (First_name, last_name);
CREATE INDEX NAME_IDX ON employees (First_name, AND last_name);
CREATE INDEX NAME_IDX ON employees (First_name, last_name);
CREATE INDEX NAME_IDX FOR employees (First_name, last_name);