[Free] 2018(Jan) Latesttests Dumpsleader Oracle 1z0-047 Dumps with VCE and PDF Download 81-90

Latesttests 2018 Jan Oracle Official New Released 1z0-047
100% Free Download! 100% Pass Guaranteed!
http://www.Latesttests.com/1z0-047.html

Oracle Database SQL Expert

Question No: 81

View the Exhibit and examine the description of the CUSTOMERS table.

Latesttests 2018 PDF and VCE

You want to add a constraint on the CUST_FIRST_NAME column of the CUSTOMERS table so that the value inserted in the column does not have numbers.

Which SOL statement would you use to accomplish the task?

  1. ALTER TABLE CUSTOMERS ADD CONSTRAINT cust_f_name

    CHECK(REGEXP_LIKE(cust_first_name1#39;^A-Z ‘))NOVALIDATE;

  2. ALTER TABLE CUSTOMERS ADD CONSTRAINT cust_f_name

    CHECK(REGEXP_LIKE(cust_first_name,#39;^[0-9]’))NOVALIDATE;

  3. ALTER TABLE CUSTOMERS ADD CONSTRAINT cust_f_name

    CHECK(REGEXP_LIKE(cust_first_name,#39;[[:alpha: ]]’))NOVALIDATE;

  4. ALTER TABLE CUSTOMERS ADD CONSTRAINT cust_f_name

CHECK(REGEXP_LIKE(cust_first_name,#39;[[:digit: ]]’))NOVALIDATE ;

Answer: C

Question No: 82

Latesttests 2018 PDF and VCE

View the Exhibit and examine the structure of the CUST table.

Evaluate the following SQL statements executed in the given order: ALTER TABLE cust

ADD CONSTRAINT cust_id_pk PRIMARY KEY(cust_id) DEFERRABLE INITIALLY DEFERRED;

INSERT INTO cust VALUES (1 /RAJ1); -row 1 INSERT INTO cust VALUES (1 ,#39;SAM); -row 2

COMMIT;

SET CONSTRAINT cust_id_pk IMMEDIATE;

INSERT INTO cust VALUES (1 /LATA1); -row 3 INSERT INTO cust VALUES (2 .KING1); -row 4 COMMIT;

Which rows would be made permanent in the CUST table?

  1. row 4 only

  2. rows 2 and 4

  3. rows 3 and 4

  4. rows 1 and 4

    Answer: C

    Question No: 83

    You need to create a table with the following column specifications:

    1. Employee ID (numeric data type) for each employee

    2. Employee Name, (character data type) which stores the employee name

    3. Hire date, to store the date when the employee joined the organization

    4. Status (character data type). It should contain the value if no data is entered.

    5. Resume (character large object [CLOB] data type), which would contain the resume submitted by the employee

      Which is the correct syntax to create this table?

      1. CREATE TABLE EMP_1 (emp_id NUMBER(4), emp_name VARCHAR2(25), start_date DATE,

        e_status VARCHAR2(10) DEFAULT ACTIVE#39;,

        resume CLOB(200));

      2. CREATE TABLE 1_EMP (emp_id NUMBER(4), emp_name VARCHAR2(25), start_date DATE,

        emp_status VARCHAR2(10) DEFAULT ACTIVE#39;,

        resume CLOB);

      3. CREATE TABLE 1_EMP (emp_id NUMBER(4),

        emp_name VARCHAR2(25), start_date DATE, emp_status VARCHAR2(10) DEFAULT quot;ACTIVEquot;,

        resume CLOB);

      4. CREATE TABLE EMP_1

(emp_id NUMBER, emp_name VARCHAR2(25), start_date DATE,

emp_status VARCHAR2(10) DEFAULT ACTIVE#39;,

resume CLOB);

Answer: D

Question No: 84

Which two statements are true regarding the types of table joins available in Oracle Database 10g? (Choose two.)

  1. You can use the JOIN clause to join only two tables.

  2. You can explicitly provide the join condition with a NATURAL JOIN.

  3. You can use the USING clause to join tables on more than one column.

  4. You can use the ON clause to specify multiple conditions while joining tables.

Answer: C,D

Question No: 85

Which statement is true regarding the CUBE operator in the GROUP BY clause of a SQL statement?

  1. It produces only aggregates for the groups specified in the GROUP BY clause.

  2. It finds all the NULL values in the superaggregates for the groups specified in the GROUP BY clause.

  3. It produces 2 n possible superaggregate combinations, if the n columns and expressions are specified in the GROUP BY clause.

  4. It produces n 1 possible superaggregate combinations, if the n columns and expressions are specified in the GROUP BY clause.

Answer: C

Question No: 86

Which two statements are true about sequences created in a single instance database? (Choose two.)

  1. The numbers generated by a sequence can be used only for one table.

  2. DELETE lt;sequencenamegt; would remove a sequence from the database.

  3. CURRVAL is used to refer to the last sequence number that has been generated.

  4. When the MAXVALUE limit for a sequence is reached, you can increase the MAXVALUE limit by using the ALTER SEQUENCE statement.

  5. When a database instance shuts down abnormally, the sequence numbers that have been cached but not used would be available once again when the database instance is restarted.

Answer: C,D

Question No: 87

Evaluate the following SQL statements in the given order: DROP TABLE dept;

CREATE TABLE dept

(deptno NUMBER(3) PRIMARY KEY,

deptname VARCHAR2(10));

DROP TABLE dept;

FLASHBACK TABLE dept TO BEFORE DROP;

Which statement is true regarding the above FLASHBACK operation?

  1. It recovers only the first DEPT table.

  2. It recovers only the second DEPT table.

  3. It does not recover any of the tables because FLASHBACK is not possible in this case.

  4. It recovers both the tables but the names would be changed to the ones assigned in the RECYCLEBIN.

Answer: B

Question No: 88

View the Exhibit and examine the structure of the MARKS_DETAILS and MARKStables.

Latesttests 2018 PDF and VCE

Which is the best method to load data from the MARKS DETAILStable to the MARKStable?

  1. Pivoting INSERT

  2. Unconditional INSERT

  3. Conditional ALL INSERT

  4. Conditional FIRST INSERT

Answer: A

Question No: 89

Which statements are true regarding the usage of the WITH clause in complex correlated subqueries? (Choose all that apply.)

  1. It can be used only with the SELECT clause.

  2. The WITH clause can hold more than one query.

  3. If the query block name and the table name were the same, then the table name would take precedence.

  4. The query name in the WITH clause is visible to other query blocks in the WITH clause as well as to the main query block.

Answer: A,B,D

Question No: 90

OE and SCOTT are the users in the database. The ORDERS table is owned by OE. Evaluate the statements issued by the DBA in the following sequence:

CREATE ROLE r1;

GRANT SELECT, INSERT ON oe. orders TO r1;

GRANT r1 TO scott;

GRANT SELECT ON oe. orders TO scott;

REVOKE SELECT ON oe.orders FROM scott;

What would be the outcome after executing the statements?

  1. SCOTT would be able to query the OE.ORDERS table.

  2. SCOTT would not be able to query the OE.ORDERS table.

  3. The REVOKE statement would remove the SELECT privilege from SCOTT as well as from the role R1.

  4. The REVOKE statement would give an error because the SELECT privilege has been granted to the role R1

Answer: A

100% Free Download!
Download Free Demo:1z0-047 Demo PDF
100% Pass Guaranteed!
Download 2018 Latesttests 1z0-047 Full Exam PDF and VCE

Latesttests ExamCollection Testking
Lowest Price Guarantee Yes No No
Up-to-Dated Yes No No
Real Questions Yes No No
Explanation Yes No No
PDF VCE Yes No No
Free VCE Simulator Yes No No
Instant Download Yes No No

2018 Latesttests IT Certification PDF and VCE