Oracle 1z0 051 - Study guides, Class notes & Summaries

Oracle 1Z0-051 Exam Questions & Answers 2023 Last document update:   ago

Oracle 1Z0-051 Exam Questions & Answers 2023 Number: 1Z0-051 Passing Score: 800 Time Limit: 120 min File Version: 38.9 Oracle 1Z0-051 Exam Questions & Answers Exam Name: Oracle Database 11g: SQL Fundamentals I Exam Test-Papers QUESTION 1 Evaluate the following CREATE TABLE commands: CREATE TABLE orders (ord_no NUMBER(2) CONSTRAINT ord_pk PRIMARY KEY, ord_date DATE, cust_id NUMBER(4)); CREATE TABLE ord_items (ord_no NUMBER(2), item_no NUMBER(3), qty NUMBER(3) CHECK (qty BETWEEN 1...

Oracle 1z0-051 SQL Fundamentals I Practice Exam(Questions And Answers) Last document update:   ago

Which two statements will drop the primary key defined on table EMP? The primary key name is PK_EMP. a. ALTER TABLE EMP DROP PRIMARY KEY; b. DROP CONSTRAINT PK_EMP; c. ALTER TABLE EMP DROP CONSTRAINT PK_EMP; d. ALTER CONSTRAINT PK_EMP DROP CASCADE; e. DROP CONSTRAINT PK_EMP ON EMP; a. ALTER TABLE EMP DROP PRIMARY KEY; c. ALTER TABLE EMP DROP CONSTRAINT PK_EMP; What happens when you issue the following command? (Choose all that apply.) TRUNCATE TABLE SCOTT.EMPLOYEE;...