-
Examine the following command： ALTER DISKGROUP data MOUNT FORCE； In which scenario can you use the above command to mount the disk group？（）
A . when ASM disk goes offline
B . when one or more ASM files are dropped
C . when some disks in a disk group are offline
D . when some disks in a failure group for a disk group are rebalancing
-
Click the Exhibit button and examine the data in the EMPLOYEES table.
Which three subqueries work? （）
https://assets.asklib.com/images/image2/2018080114403417445.jpg
A . SELECT * FROM employees where salary > (SELECT MIN(salary) FROM employees GROUP BY department_id);
B . SELECT * FROM employees WHERE salary = (SELECT AVG(salary) FROM employees GROUP BY department_id);
C . SELECT distinct department_id FROM employees WHERE salary > ANY (SELECT AVG(salary) FROM employees GROUP BY department_id);
D . SELECT department_id FROM employees WHERE salary > ALL (SELECT AVG(salary) FROM employees GROUP BY department_id);
E . SELECT last_name FROM employees WHERE salary > ANY (SELECT MAX(salary) FROM employees GROUP BY department_id);
F . SELECT department_id FROM employees WHERE salary > ALL (SELECT AVG(salary) FROM employees GROUP BY AVG(SALARY))
-
Examine the query and its output executed In an RDBMS Instance:Which three statements are true about the users (other than sys) in the output?（）
A . The C # # B_ADMIN user can perform all backup and recovery operations using RMAN only.
B . The C # # C_ADMIN user can perform the data guard operation with Data Guard Broker.
C . The C # # A_ADMIN user can perform wallet operations.
D . The C # # D_ADMIN user can perform backup and recovery operations for Automatic Storage Management (ASM).
E . The C # # B_ADMIN user can perform all backup and recovery operations using RMAN or SQL* Plus.
-
Examine the data in the EMPLOYEES table:
https://assets.asklib.com/images/image2/2018080117313142970.jpg
Which three subqueries work? （）
A . SELECT * FROM employees where salary > (SELECT MIN(salary) FROM employees GROUP BY department _ id);
B . SELECT * FROM employees WHERE salary = (SELECT AVG(salary) FROM employees GROUP BY department _ id);
C . SELECT distinct department_id FROM employees Where salary > ANY (SELECT AVG(salary) FROM employees GROUP BY department _ id);
D . SELECT department_id FROM employees WHERE SALARY > ALL (SELECT AVG(salary) FROM employees GROUP BY department _ id);
E . SELECT last_name FROM employees Where salary > ANY (SELECT MAX(salary) FROM employees GROUP BY department _ id);
F . SELECT department_id FROM employees WHERE salary > ALL (SELECT AVG(salary) FROM employees GROUP BY ANG (SALARY))
-
Examine the following command: ALTER DISKGROUP data MOUNT FORCE; In which scenario can you use the above command to mount the disk group? （）
A . when ASM disk goes offline
B . when one or more ASM files are dropped
C . when some disks in a disk group are offline
D . when some disks in a failure group for a disk group are rebalancing
-
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.
-
Prior to running the hydraulic pump, examine the system carefully and ensure that the lever of control valves is in （） position.
A . neutral
B . end
C . opening
D . closure
-
View the Exhibit and examine the Data Pump architecture. Identify the numbered components.（）https://assets.asklib.com/images/image2/2018080214125062228.jpg
A . 1 - Oracle Loader, 2 - Oracle Data Pump, 3 - Direct Path API
B . 1 - Oracle Data Pump, 2 - Direct Path API, 3 - Oracle Loader
C . 1 - Direct Path API, 2 - Oracle Loader, 3 - Oracle Data Pump
D . 1 - Oracle Loader, 2 - Direct Path API, 3 - Oracle Data Pum
-
Examine the data in the EMPLOYEES table: LAST_NAME DEPARTMENT_ID SALARY Getz 10 3000 Davis 20 1500 Bill 20 2200 Davis 30 5000 ... Which three subqueries work? （）
A . SELECT * FROM employees where salary > (SELECT MIN(salary) FROM employees GROUP BY department _ id);
B . SELECT * FROM employees WHERE salary = (SELECT AVG(salary) FROM employees GROUP BY department _ id);
C . SELECT distinct department_id FROM employees Where salary > ANY (SELECT AVG(salary) FROM employees GROUP BY department _ id);
D . SELECT department_id FROM employees WHERE SALARY > ALL (SELECT AVG(salary) FROM employees GROUP BY department _ id);
E . SELECT last_name FROM employees Where salary > ANY (SELECT MAX(salary) FROM employees GROUP BY department _ id);
F . SELECT department_id FROM employees WHERE salary > ALL (SELECT AVG(salary) FROM employees GROUP BY ANG (SALARY))
-
View the Exhibit and examine the data in the PRODUCT INFORMATION table.
https://assets.asklib.com/images/image2/2018080114285063300.jpg
Which two tasks would require subqueries？ （）
A . displaying the minimum list price for each product status
B . displaying all supplier IDs whose average list price is more than 500
C . displaying the number of products whose list prices are more than the average list price
D . displaying all the products whose minimum list prices are more than the average list price of products having the product status orderable
E . displaying the total number of products supplied by supplier 102071 and having product status OBSOLETE
-
Examine the RMAN command： SWITCH DATAFILE ’/DISK3/user_data01.dbf’； Which command do you need to issue before you issue the above command， so that RMAN finds the file in the restored location of ’DISK2/user_data01.dbf’？ （）
A . RESTORE DATAFILE ’/DISK2/user_data01.dbf’
B . RESTORE DATAFILE ’/DISK3/user_data01.dbf’
C . SET NEWNAME FOR ’/DISK3/user_data01.dbf’ TO’/DISK2/user_data01.dbf’
D . SET NEWNAME FOR ’/DISK2/user_data01.dbf’ TO’/DISK3/user_data01.dbf&rsquo
-
Examine the command： ALTER DATABASE ADD SUPPLEMENTAL LOG DATA （PRIMARY KEY） COLUMNS； What does the command accomplish？（）
A . Creates an additional copy of the database online redo log files.
B . Stores the primary key column values of each row involved in a DML operation in the online redo log files.
C . Stores the primary key column values of each row involved in a DML operation in the supplemental log files.
D . Stores the old and new primary key column values of each row involved in a DML operation only when the primary key is modified in the online redo log files.
-
You are identifying dictionary objects in the Oracle database. Which of the following is a view in the data dictionary?（）
A . V$DATABASE
B . DBA_TABLES
C . SYSAUD$
D . EMP
-
Paraphrase the underlined word in the following sentence. It’s a good idea to examine a textbook before the course begins.
-
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.
-
The data architect needs to propagate data across the landscape in real time. This requires the leveraging of the followingDMBOK knowledge areas
A、data architecture data quality and content and document management.
B、data architecture,data governance and metadata management.
C、data architecture integration and interoperability data storage and operations.
D、data architecture data modelling and design and data security.
E、data architecture,metadata management and data security.
-
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.
-
Examine the data in the EMPLOYEES table:LAST_NAME DEPARTMENT_ID SALARYGetz 10 3000Davis 20 1500Bill 20 2200Davis 30 5000...Which three subqueries work？ （）
A. SELECT * FROM employees where salary ＞ (SELECT MIN(salary) FROM employees GROUP BY department _ id);
B. SELECT * FROM employees WHERE salary = (SELECT AVG(salary) FROM employees GROUP BY department _ id);
C. SELECT distinct department_id FROM employees Where salary ＞ ANY (SELECT AVG(salary) FROM employees GROUP BY department _ id);
D. SELECT department_id FROM employees WHERE SALARY ＞ ALL (SELECT AVG(salary) FROM employees GROUP BY department _ id);
E. SELECT last_name FROM employees Where salary ＞ ANY (SELECT MAX(salary) FROM employees GROUP BY department _ id);
F. SELECT department_id FROM employees WHERE salary ＞ ALL (SELECT AVG(salary) FROM employees GROUP BY ANG (SALARY));
-
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.
-
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)
-
We need to examine present events in the_____of history.
A．pretext
B．context
C．text
D．texture
-
View the Exhibit and examine the output of the query in different times when the following command runs in an RMAN sessions:RMAN＞ BACKUP DATABASE FILESPERSET 2;The database has seven data files.Why is the %_COMPLETE refreshed to 13.59 in the third output afterreaching 88.77？（）
A. Because the progress is reported for each data file
B. Because the progress is reported for each backup set
C. Because other RMAN sessions have issued the same BACKUP command
D. Because new data files have been added to the database while the RMAN backup is in progress
-
Examine the data of the EMPLOYEES table.EMPLOYEES （EMPLOYEE_ID is the primary key. MGR_ID is the ID of managers and refers to the EMPLOYEE_ID)Evaluate this SQL statement:What is its output？（）
<img src='https://img2.soutiyun.com/shangxueba/ask/17133001-17136000/17135449/6bce46904716f2e8357f4849d2a3423d.jpg' />
<img src='https://img2.soutiyun.com/shangxueba/ask/17133001-17136000/17135449/c5c76fa6bab26c6735c868df586306cf.jpg' />
A.<img src='https://img2.soutiyun.com/shangxueba/ask/17133001-17136000/17135449/0f921b8c15106e9d6cc8e36a50134106.jpg' />
B.<img src='https://img2.soutiyun.com/shangxueba/ask/17133001-17136000/17135449/d072515564553d90b433296aa71e021a.jpg' />
C.<img src='https://img2.soutiyun.com/shangxueba/ask/17133001-17136000/17135449/b4721c6b94a9b61c92cdbe82aabc3ae1.jpg' />
D.<img src='https://img2.soutiyun.com/shangxueba/ask/17133001-17136000/17135449/b27c35e83798de4bbbccaef22fa31b48.jpg' />
E. The SQL statement produces an error.
