QUESTION: 282

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

UPDATE statements can have different subqueries to specify the values for each updated column.
INSERT statements can insert NULLS explicitly into a column.
DELETE statements can remove multiple rows based on multiple conditions.
DML statements require a primary key be defined on a table.
INSERT INTO…SELECT…FROM statements automatically commit.

Answer(s): A,C,E

QUESTION: 237

Examine the description of the SALES table:

The SALES table has 55,000 rows.

Examine this statement:

Which two statements are true?

SALES1 has NOT NULL constraints on any selected columns which had those constraints in the SALES table.
SALES1 is created with 55,000 rows.
SALES1 has PRIMARY KEY and UNIQUE constraints on any selected columns which had those constraints in the SALES table.
SALES1 is created with no rows.
SALES1 is created with 1 row.

Answer(s): A,D

Reference:

https://www.oracle.com/a/ocom/docs/dc/ww-ou-5297-database2019-studyguide-5.pdf

Show Answer Next Question

QUESTION: 235

Which three actions can you perform only with system privileges?

Query any table in a database.
Log in to a database.
Access flat files via a database, which are stored in an operating system directory.
Truncate a table in another schema.
Execute a procedure in another schema.
Use the WITH GRANT OPTION clause.

Answer(s): A,B,F

Show Answer Next Question

Examine the data in the CUST_NAME column of the CUSTOMERS table.

You want to extract only those customer names that have three names and display the * symbol in place of the first name as follows:

Which two queries give the required output?

SELECT LPAD(SUBSTR(cust_name, INSTR(cust_name, ' ')),LENGTH(cust_name),'*') “CUST NAME”
FROM customers
WHERE INSTR(cust_name, ' ',1,2)<>0;
SELECT LPAD(SUBSTR(cust_name, INSTR(cust_name, ' ')),LENGTH(cust_name),'*') “CUST NAME”
FROM customers
WHERE INSTR(cust_name, ' ',-1,2)<>0;
SELECT LPAD(SUBSTR(cust_name, INSTR (cust_name ' ')),LENGTH(cust_name) - INSTR(cust_name, ' '), '*') “CUST NAME”
FROM customers
WHERE INSTR(cust_name, ' ',1,-2)<>0;
SELECT LPAD(SUBSTR(cust_name, INSTR (cust_name ' ')),LENGTH(cust_name) - INSTR(cust_name, ' '), '*') “CUST NAME”
FROM customers
WHERE INSTR(cust_name, ' ',1,2)<>0;

Answer(s): A,B

Show Answer Next Question

QUESTION: 209

View the Exhibit and examine the description for the PRODUCTS and SALES table.

PROD_ID is a primary key in the PRODUCTS table and foreign key in the SALES table with ON DELETE CASCADE option. The SALES table contains data for the last three years. You want to remove all the rows from the PRODUCTS table for which no sale was done for the last three years.

Which is the valid DELETE statement?