Examine the data in the EMPLOYEES and DEPARTMENTS tables: <img src="https://nimg.ppkao.com/2018-08/yiyu/2018080115132467458.jpg?sign=832f133cd2909187e32355a497d62424&t=62d3234d" /> Also examine the SQL statements that create the EMPLOYEES and DEPARTMENTS tables: <img src="https://nimg.ppkao.com/2018-08/yiyu/2018080115134871409.jpg?sign=dd178c1273f0c0e67ec8fa880d9cc0db&t=62d3234d" /> On the EMPLOYEES table, EMPLOYEE_ID is the primary key. MGR_ID is the ID of managers and refers to the EMPLOYEE_ID. DEPT_ID is foreign key to DEPARTMENT_ID column of the DEPARTMENTS table. On the DEPARTMENTS table, DEPARTMENT_ID is the primary key. Examine this DELETE statement: <img src="https://nimg.ppkao.com/2018-08/yiyu/2018080115140366276.jpg?sign=a9dce010ac5e86e0e462d6c84bb54d90&t=62d3234d" /> What happens when you execute the DELETE statement?（）..

第1题

[单选题] Exhibit: Examine the data in the EMPLOYEES table. Examine the subquery: SELECT last_name FROM employees WHERE salary IN (SELECT MAX(salary) FROM employees GROUP BY department_id); Which statement is true?（）

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.

点击查看答案

第2题

[单选题] Examine the following command that is executed for the TRANSPORT table in the SH schema: Which statement describes the significance of this command?（）

A、It collects statistics into the pending area in the data dictionary B、It creates a virtual hidden column in the CUSTOMERS_OBE table C、It collects statistics with AUTO_SAMPLE_SIZE for ESTIMATE_PERCENT D、It creates a histogram to hold skewed information about the data in the columns

点击查看答案

第3题

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

点击查看答案

第4题

[单选题] Click the Exhibit button and examine the data in the EMPLOYEES table. Examine the subquery: SELECT last_name FROM employees WHERE salary IN (SELECT MAX(salary) FROM employees GROUP BY department_id); Which statement is true?（）

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.

点击查看答案

第5题

[单选题] Examine the following scenario: The target database instance is running. The most recent backup available for the target database was taken two days ago. Log files switches have occurred in last two days. The target database is duplicated on the same host, using the Recovery Manager (RMAN) duplicate command as follows: Which statement is true about the duplicate database in this scenario?（）

A、It contains data till the last backup B、It contains all data from target database until the current time C、It contains all data from only the committed transactions in the target database D、It contains all data except that which is used by the transactions in the current online redo file of target database

点击查看答案

第6题

[多选题] Examine the following command that is used to duplicate a database on the same host: Which two statements describe the effect after the database is duplicated successfully? （）

A、The data files of the read-only tablespaces in the target database are not duplicated B、The read-only tablespaces in the target database are still defined in new the database C、The read-only tablespaces in the target database are changed to online after duplication D、The data files of the read-only tablespaces in the target database get duplicated E、The read-only tablespaces in the target database are not defined in the new database

点击查看答案

第7题

[单选题] Examine the following RMAN script: Which statement describes the purpose of the script?（）

A、The data file is checked for physical corruption and backed up if found clean. B、The backup of data file 5 is performed and the interactive messages during the backup are suppressed. C、The existing backup for the data file is checked and the backup is performed if there are changes in the data file after the last backup. D、The backup of data file 5 is performed and all SQL statements that are executed during RMAN compilation and their results are displayed

点击查看答案

第8题

[单选题] Your multitenant container database (CDB) is running in ARCHIVELOG mode. You connect to the CDB RMAN. Examine the following command and its output: You execute the following command: RMAN > BACKUP DATABASE PLUS ARCHIVELOG; Which data files will be backed up?（）

A、Data files that belong to only the root container B、Data files that belong to the root container and all the pluggable databases (PDBs) C、Data files that belong to only the root container and PDB$SEED D、Data files that belong to the root container and all the PDBs excluding PDB$SEED

点击查看答案

第9题

[多选题] Examine the following command that is used to duplicate a database on the same host: RMAN> RUN { ALLOCATE AUXILIARY CHANNEL, aux 1 DEVICE TYPE DISK; DUPLICATE TARGET DATABASE TO auxdb SKIP READONLY; \ } Which two statements describe the effect after the database is duplicated successfully? （）(Choose two)

A、The data files of the read-only tablespaces in the target database are not duplicated B、The read-only tablespaces in the target database are still defined in new the database C、The read-only tablespaces in the target database are changed to online after duplication D、The data files of the read-only tablespaces in the target database get duplicated E、The read-only tablespaces in the target database are not defined in the new database

点击查看答案

第10题

[] Click the Exhibit button and examine the data from the EMP table. The COMMISSION column shows the monthly commission earned by the employee. Which three tasks would require subqueries or joins in order to be performed in a single step?（） Click the Exhibit button and examine the data from the EMP table. The COMMISSION column shows the monthly commission earned by the employee. Which three tasks would require subqueries or joins in order to be performed in a single step?（）

A、A.deleting the records of employees who do not earn commission B、B.increasing the commission of employee 3 by the average commission earned in department 20 C、C.finding the number of employees who do NOT earn commission and are working for department 20 D、D.inserting into the table a new employee 10 who works for department 20 and earns a commission that is equal to the commission earned by employee 3 E、E.creating a table called COMMISSION that has the same structure and data as the columns EMP_ID and COMMISSION of the EMP table F、F.decreasing the commission by 150 for the employees who are working in department 30 and earning a commission of more than 800

点击查看答案

请使用微信扫码支付