Free Access Oracle.1z1-071.v2022-04-30.q200 Practice Test (Page 41)

Question 196

Examine the data in the CUST_NAME column of the CUSTOMERS table.
CUST_NAME
-------------------
Renske Ladwig
Jason Mallin
Samuel McCain
Allan MCEwen
Irene Mikilineni
Julia Nayer
You need to display customers' second names where the second name starts with "Mc" or
"MC".
Which query gives the required output?

A.SELECT SUBSTR (cust_name, INSTR (cust_name, ' ')+1)FROM customersWHERE INITCAP (SUBSTR(cust_name, INSTR (cust_name, ' ')+1))LIKE 'Mc%';

B.SELECT SUBSTR (cust_name, INSTR (cust_name, ' ')+1)FROM customersWHERE INITCAP (SUBSTR(cust_name, INSTR (cust_name, ' ')+1)) =INITCAP 'MC%';

C.SELECT SUBSTR (cust_name, INSTR (cust_name, ' ')+1)FROM customersWHERE SUBSTR (cust_name, INSTR (cust_name, ' ')+1)LIKE INITCAP ('MC%');

D.SELECT SUBSTR (cust_name, INSTR (cust_name, ' ')+1)FROM customersWHERE INITCAP (SUBSTR(cust_name, INSTR (cust_name, ' ')+1)) ='Mc';

Question 197

Which three statements are true about Data Manipulation Language (DML)?

A.UPDATE statements can have different subqueries to specify the values for each updated column.

B.INSERT INTO...SELECT...FROM statements automatically commit.

C.DML statements require a primary key be defined on a table.

D.DELETE statements can remove multiple rows based on multiple conditions.

E.INSERT statements can insert NULLS explicitly into a column.

Question 198

You execute this command:
ALTER TABLE employees SET UNUSED(department_id)
Which two are true? (Choose two.)

A.No updates can be made to the data in the DEPARTMENT_IDcolumn.

B.A new column with the name DEPARTMENT_IDcan be added to the EMPLOYEEStable.

C.A query can be display data from the DEPARTMENT_IDcolumn.

D.The DEPARTMENT_IDcolumn is set to null for all rows in the table.

E.The DEPARTMENT_IDcolumn can be recovered from the recycle bin.

F.The storage space occupied by the DEPARTMENT_IDcolumn is released only after a COMMITis issued.

Question 199

Which three statements are true about dropping and unused columns in an Oracle database?

A.An UNUSED column's space is remained automatically when the block containing that column is next queried.

B.A column that is set to NNUSED still counts towards the limit of 1000 columns per table.

C.An UNUSED column's space is remained automatically when the row containing that column is next queried.

D.A primary key column referenced by another column as a foreign key can be dropped if using the CASCADE option.

E.Partition key columns cannot be dropped.

F.A DROP COLUMN command can be rolled back.

Question 200

View the exhibit and examine the structure of the SALES, CUSTOMERS, PRODUCTS and TIMES tables.

The PROD_ID column is the foreign key in the SALES table, which references the PRODUCTS table.
Similarly, the CUST_ID and TIME_ID columns are also foreign keys in the SALES table referencing the CUSTOMERS and TIMES tables, respectively.
Evaluate the following CREATE TABLE command:
CREATE TABLE new_sales (prod_id, cust_id, order_date DEFAULT SYSDATE)
AS
SELECT prod_id, cust_id, time_id
FROM sales;
Which statement is true regarding the above command?

A.The NEW_SALES table would not get created because the column names in the CREATE TABLE command and the SELECT clause do not match.

B.The NEW_SALES table would get created and all the FOREIGN KEY constraints defined on the specified columns would be passed to the new table.

C.The NEW_SALES table would not get created because the DEFAULT value cannot be specified in the column definition.

D.The NEW_SALES table would get created and all the NOT NULL constraints defined on the specified columns would be passed to the new table.

Other Version: 1038Oracle.1z1-071.v2025-05-13.q352; 36Oracle.Prepawayete.1z1-071.v2022-01-25.by.lauren.209q.pdf

Latest Upload: 117Oracle.1Z0-1057-23.v2025-09-10.q47; 150Google.Professional-Cloud-Network-Engineer.v2025-09-09.q179; 131SAP.C-S4EWM-2023.v2025-09-08.q83; 162TheSecOpsGroup.CNSP.v2025-09-08.q20; 220CFAInstitute.ESG-Investing.v2025-09-08.q173; 155PECB.ISO-IEC-27001-Lead-Implementer.v2025-09-06.q132; 145Salesforce.Data-Architect.v2025-09-05.q216; 139Adobe.AD0-E605.v2025-09-05.q50; 183Nutanix.NCP-MCI-6.10.v2025-09-05.q55; 114Oracle.1z0-591.v2025-09-05.q104

Question 196

Question 197

Question 198

Question 199

Question 200

Download PDF File