Oracle 1z0 051 Study guides, Revision 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;...

Oracle Database SQL Fundamentals 1z0-051 Exam,100% CORRECT Last document update:   ago

Question: 1 Which statement is true regarding the INTERSECT operator? A. It ignores NULL values. B. Reversing the order of the intersected tables alters the result. C. The names of columns in all SELECT statements must be identical. D. The number of columns and data types must be identical for all SELECT statements in the query. Question: 2 Which three statements are true regarding the data types in Oracle Database 0g/11g? (Choose three.) A. Only one LONG column can be used per table. B. A TIM...