OCA OCP Oracle Certification Exam Braindumps

1. View the Exhibit and examine the structure of the SALES, CUSTOMERS, PRODUCTS, 1z0-051 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:
Which statement is true regarding the above command?
 
A.The NEW_SALES table would not get created because the DEFAULT value cannot be specified in the column definition.
B.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.
C.The NEW_SALES table would not get created because the column names in the CREATE TABLE command and the SELECT clause do not match.
D.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.
Answer: B

2. View the Exhibit to examine the description for the SALES table.
Which views can have all DML operations performed on it? (Choose all that apply.)
 
A.CREATE VIEW v3
B.CREATE VIEW v1
C.CREATE VIEW v2
D.CREATE VIEW v4
Answer: AB

3. You need to extract details of those products in the SALES table where the PROD_ID column contains the string '_D123'.
Which WHERE clause could be used in the SELECT statement to get the required output?
A.WHERE prod_id LIKE '%_D123%' ESCAPE '_'
B.WHERE prod_id LIKE '%\_D123%' ESCAPE '\'
C.WHERE prod_id LIKE '%_D123%' ESCAPE '%_'
D.WHERE prod_id LIKE '%\_D123%' ESCAPE '\_'
Answer: B