-
For a general cargo ship, is not the necessary certificate/document that the PSCO will examine（）
A . Survey Report File
B . Minimum Safe Manning document
C . Certificates of Competency
D . International Oil Pollution Preventio
-
Examine the following command: CREATE TABLE (prod_id number(4), Prod_name varchar2 (20), Category_id number(30), Quantity_on_hand number (3) INVISIBLE); Which three statements are true about using an invisible column in the PRODUCTS table?（）
A . The %ROWTYPE attribute declarations in PL/SQL to access a row will not display the invisible column in the output.
B . The DESCRIBE commands in SQL *Plus will not display the invisible column in the output.
C . Referential integrity constraint cannot be set on the invisible column.
D . The invisible column cannot be made visible and can only be marked as unused.
E . A primary key constraint can be added on the invisible column.
-
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.
-
Examine these two statements:Which three are true about the MRKT tablespace?（）
A . The MRKT tablespace is created as a small file tablespace, because the file size is less than the minimum required for big file files.
B . The MRKT tablespace may be dropped if it has no contents.
C . Users who were using the old default tablespace will have their default tablespaces changed to the MRKT tablespace.
D . No more data files can be added to the tablespace.
E . The relative file number of the tablespace is not stored in rowids for the table rows that are stored in the MRKT tablespace.
-
Examine the command that is used to create a table： SQL> CREATE TABLE orders（oid NUMBER（6） PRIMARY KEY， odate DATE， ccode NUMBER（6）， oamt NUMBER（10，2）） TABLESPACE users； Which two statements are true about the effect of the above command） （）
A . A CHECK constraint is created on the OID column.
B . A NOT NULL constraint is created on the OID column.
C . The ORDERS table is the only object created in the USERS tablespace.
D . The ORDERS table and a unique index are created in the USERS tablespace.
E . The ORDERS table is created in the USERS tablespace and a unique index is created on the OIDcolumn in the SYSTEM tablespace.
-
Examine the following ALTER command: SQL> ALTER DISKGROUP dgroup1 UNDROP DISKS; What is the purpose of the command?（）
A . It cancels all pending disk drops within the disk group.
B . It restores disks that are being dropped as the result of a DROP DISKGROUP operation
C . It mounts disks in the disk group for which the drop-disk operation has already been co pleted
D . It restores all the dropped disks in the disk group for which the drop-disk operation has already been completed
E . It adds previously dropped disks back into the disk grou
-
Examine the CREATE DISKGROUP command used to create a disk group： SQL> CREATE DISKGROUP misc EXTERNAL REDUNDANCY DISK ’ORCL： FRA3’ NAME misc1， ’ORCL： FRA4’ NAME misc2； In which situation would you use this method of disk group creation？（）
A . When two-way disk mirroring is required for the allocation units
B . When three-way disk mirroring is required for the allocation units
C . When using hardware mirroring or RAID
D . When disk mirroring is required for the Automatic Storage Management （ASM） disk
-
Examine the command that is used to create a table： SQL> CREATE TABLE orders（oid NUMBER（6） PRIMARY KEY， odate DATE， ccode NUMBER （6）， oamtNUMBER（10，2）） TABLESPACE users； Which two statements are true about the effect of the above command（）
A . A CHECK constraint is created on the OID column.
B . A NOT NULL constraint is created on the OID column.
C . The ORDERS table is the only object created in the USERS tablespace.
D . The ORDERS table and a unique index are created in the USERS tablespace.
E . The ORDERS table is created in the USERS tablespace and a unique index is created on the OID columnin the SYSTEM tablespace.
-
Examine these statements: CREATE ROLE registrar GRANT UPDATE ON dtudent_grades TO registrar; GRANT registrar to user1, user2, user3; What does this set of SQL statements do? （）
A . The set of statements contains an error and does not work.
B . It creates a role called REGISTRAR, adds the MODIFY privilege on the STUDENT_GRADES object to the role, and gives the REGISTRAR role to three users.
C . It creates a role called REGISTRAR, adds the UPDATE privilege on the STUDENT_GRADES object to the role, and gives the REGISTRAR role to three users.
D . It creates a role called REGISTRAR, adds the UPDATE privilege on the STUDENT_GRADES object to the role, and creates three users with the role.
E . It creates a role called REGISTRAR, adds the UPDATE privilege on three users, and gives the REGISTRAR role to the STUDENT_GRADES object.
F . It creates a role called STUDENT_GRADES, adds the UPDATE privilege on three users, and gives the UPDATE role to the registrar.
-
Examine the following ALTER command： SQL> ALTER DISKGROUP dgroup1 UNDROP DISKS； What is the purpose of the command？（）
A . It cancels all pending disk drops within the disk group.
B . It restores disks that are being dropped as the result of a DROP DISKGROUP operation
C . It mounts disks in the disk group for which the drop-disk operation has already been co pleted
D . It restores all the dropped disks in the disk group for which the drop-disk operation has already been completed
E . It adds previously dropped disks back into the disk grou
-
Examine the statement: Create synonym emp for hr. employees; What happens when you issue the statement? （）
A . An error is generated.
B . You will have two identical tables in the HR schema with different names.
C . You create a table called employees in the HR schema based on you EMP table.
D . You create an alternative name for the employees table in the HR schema in your own schema.
-
Block comparison or block contrast is to examine one thing thoroughly and then examine the other. In this way, the aspects examined in the two things should be identical and in the same order.
-
Examine the structure of the STUDENTS table:You need to create a report of the 10 students who achieved the highest ranking in the course INT SQL and who completed the course in the year 1999.Which SQL statement accomplishes this task？（）
<img src='https://img2.soutiyun.com/ask/uploadfile/2019-03-27/7fe8306013ab0f36b81d7271dc0c8478.jpg' />
A.<img src='https://img2.soutiyun.com/ask/uploadfile/2019-02-04/cfff1591b450909431e9f7ae7dc05f14.jpg' />
B.<img src='https://img2.soutiyun.com/ask/uploadfile/2019-02-04/c75e1c68e2e140258467ca466b7e474d.jpg' />
C.<img src='https://img2.soutiyun.com/ask/uploadfile/2019-02-04/c87a2c32bbbd462ee3f4b85cd7438fec.jpg' />
D.<img src='https://img2.soutiyun.com/ask/uploadfile/2019-02-04/659c7750c67c9d05542c4c9f4dd01ed9.jpg' />
-
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？（）
<img src='https://img2.soutiyun.com/ask/uploadfile/2019-03-27/e0e7e26248da659a6662e982bf95acc3.jpg' />
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.
-
View the Exhibit to examine the Automatic Database Diagnostic Monitor （ADDM) tasks.Which statement describes the consequence？（）
<img src='https://img2.soutiyun.com/shangxueba/ask/64230001-64233000/64231578/d39131b84ca6a8d8b08830b9d4753c7b.jpg' />
<img src='https://img2.soutiyun.com/shangxueba/ask/64230001-64233000/64231578/4c44618d517b4d4d3a08325cfb73e2e3.jpg' />
A. The ADDM task is filtered to suppress the Segment Advisor suggestions for the SCOTT schema.
B. The ADDM task is filtered to produce the Segment Advisor suggestions for the SCOTT schema only.
C. The PL/SQL block produces an error because the my_instance_analysis_mode_task task has not been reset to its initial state.
D. All subsequent ADDM tasks including my_instance_analysis_mode_task are filtered to suppress the Segment Advisor suggestions for the SCOTT schema.
-
Examine the structure of the EMPLOYEES and DEPARTMENTS tables:EMPLOYEESEMPLOYEE_ID NUMBERDEPARTMENT_ID NUMBERMANAGER_ID NUMBERLAST_NAME VARCHAR2(25)DEPARTMENTSDEPARTMENT_ID NUMBERMANAGER_ID NUMBERDEPARTMENT_NAME VARCHAR2(35)LOCATION_ID NUMBERYou want to create a report displaying employee last names, department names, and locations. Which query should you use？（）
A.SELECT e.last_name, d. department_name, d.location_id FROM employees e NATURAL JOIN departments D USING department_id ;
B.SELECT last_name, department_name, location_id FROM employees NATURAL JOIN departments WHERE e.department_id =d.department_id;
C.SELECT e.last_name, d.department_name, d.location_id FROM employees e NATURAL JOIN departments d;
D.SELECT e.last_name, d.department_name, d.location_id FROM employees e JOIN departments d USING (department_id );
-
Examine the description of the MARKS table:SUBJ1 and SUBJ2 indicate the marks obtained by a student in two subjects.Examine this SELECT statement based on the MARKS table:What is the result of the SELECT statement？（）
<img src='https://img2.soutiyun.com/ask/uploadfile/2019-03-27/1179420481e271350f195c64f9e527b9.jpg' />
<img src='https://img2.soutiyun.com/ask/uploadfile/2019-03-27/a88968eec9764c2a8638e3aee2b1e23d.jpg' />
A. The statement executes successfully and returns the student ID and sum of all marks for each student who obtained more than the average mark in each subject.
B. The statement returns an error at the SELECT clause.
C. The statement returns an error at the WHERE clause.
D. The statement returns an error at the ORDER BY clause.
-
The following parameter are set for your Oracle 12c database instance:OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES=FALSEOPTIMIZER_USE_SQL_PLAN_BASELINES=TRUEYou want to manage the SQL plan evolution task manually. Examine the following steps:1. Set the evolve task parameters.2. Create the evolve task by using the DBMS_SPM.CREATE_EVOLVE_TASK function.3. Implement the recommendations in the task by using the DBMS_SPM.IMPLEMENT_EVOLVE_TASKfunction.4. Execute the evolve task by using the DBMS_SPM.EXECUTE_EVOLVE_TASK function.5. Report the task outcome by using the DBMS_SPM.REPORT_EVOLVE_TASK function.Identify the correct sequence of steps:（）
A.2，4，5
B.2，1，4，3，5
C.1，2，3，4，5
D.1，2，4，5
-
Examine the structure of the EMPLOYEES table:Column name Data type RemarksEMPLOYEE_ID NUMBER NOT NULL, Primary KeyEMP_NAME VARCHAR2(30)JOB_ID VARCHAR2(20) NOT NULLSAL NUMBERMGR_ID NUMBER References EMPLOYEE_ID columnDEPARTMENT_ID NUMBER Foreign key to DEPARTMENT_ID columnof the DEPARTMENTS tableYou need to create a view called EMP_VU that allows the users to insert rows through the view. Which SQL statement, when used to create the EMP_VU view, allows the users to insert rows？（）
A.CREATE VIEW emp_vu AS SELECT employee_id, emp_name, department_id FROM employees WHERE mgr_id IN (102, 120);
B.CREATE VIEW emp_vu AS SELECT employee_id, emp_name, job_id, department_id FROM employees WHERE mgr_id IN (102, 120);
C.CREATE VIEW emp_vu AS SELECT department_id, SUM(sal) TOTALSAL FROM employees WHERE mgr_id IN (102, 120) GROUP BY department_id;
D.CREATE VIEW emp_vu AS SELECT employee_id, emp_name, job_id, DISTINCT department_id FROM employees;
-
View the Exhibit and examine the steps that you executed to create a database resource plan.Subsequently, you execute the following procedure which results in an error:SQL＞ EXECUTE dbms_resources_manager.validate_pending_area ();What could be the reason？（）
<img src='https://img2.soutiyun.com/shangxueba/ask/17133001-17136000/17135247/2c9611256b04bdd5ba39c52e4e7dd450.png' />
A. The pending area is automatically submitted after the plan creation
B. The procedure must be executed before creating the resources plan directive
C. The SYS_GROUP resource consumer group is not included in the resource plan directive
D. The OTHER_GROUPS resources consumer group is not included in the resource plan directive
-
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？（）<img src='https://img2.soutiyun.com/shangxueba/ask/18264001-18267000/18266966/2018080111484519157.jpg' />
A. SELECT last_name, department_name FROM employees NATURAL JOIN departments;
B. SELECT last_name, department_name FROM employees JOIN departments ;
C. SELECT last_name, department_name FROM employees e JOIN departments d ON (e.department_id = d.department_id);
D. SELECT last_name, department_name FROM employees e RIGHT OUTER JOIN departments d ON (e.department_id = d.department_id);
E. SELECT last_name, department_name FROM employees FULL JOIN departments ON (e.department_id = d.department_id);
F . SELECT last_name, department_name FROM employees e LEFT OUTER JOIN departments d ON (e.department_id = d.department_id)
-
Examine the structure of the EMPLOYEES table:Column name Data type RemarksEMPLOYEE_ID NUMBER NOT NULL, Primary KeyLAST_NAME VARCNAR2(30)FIRST_NAME VARCNAR2(30)JOB_ID NUMBERSAL NUMBERMGR_ID NUMBER References EMPLOYEE_ID columnDEPARTMENT_ID NUMBERYou 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？（）
A. CREATE INDEX NAME _IDX (first_name, last_name);
B. CREATE INDEX NAME _IDX (first_name, AND last_name)
C. CREATE INDEX NAME_IDX ON (First_name, last_name);
D. CREATE INDEX NAME_IDX ON employees (First_name, AND last_name);
E. CREATE INDEX NAME_IDX ON employees (First_name, last_name);
F. CREATE INDEX NAME_IDX FOR employees (First_name, last_name);
-
Examine the following ALTER command:SQL＞ ALTER DISKGROUP dgroup1 UNDROP DISKS;What is the purpose of the command？（）
A. It cancels all pending disk drops within the disk group
B. It restores disks that are being dropped as the result of a DROP DISKGROUP operation
C. It mounts disks in the disk group for which the drop-disk operation has already been completed
D. It restores all the dropped disks in the disk group for which the drop-disk operation has already been completed
E. It adds previously dropped disks back into the disk group
