Bráulio Figueiredo
Quiz by , created more than 1 year ago

Simulado do exame de certificação OCE 1Z0-047 Oracle

610
4
0
Bráulio Figueiredo
Created by Bráulio Figueiredo over 10 years ago
Close

Exame OCE 1Z0-047 (Capítulos 1 e 2)

Question 1 of 14

1

A table is which of the following? (Choose all that apply.)

Select one or more of the following:

  • A schema object

  • A non-schema object

  • A role

  • All of the above

Explanation

Question 2 of 14

1

Which of the following are schema objects? (Choose all that apply.)

Select one or more of the following:

  • SEQUENCE

  • PASSWORD

  • INDEX

  • ROLE

Explanation

Question 3 of 14

1

A CONSTRAINT is assigned to which of the following? (Choose all that apply.)

Select one or more of the following:

  • TABLE

  • SYNONYM

  • SEQUENCE

  • INDEX

Explanation

Question 4 of 14

1

Which of the following are valid CREATE TABLE statements? (Choose three.)

Select one or more of the following:

  • CREATE TABLE $ORDERS
    (ID NUMBER,
    NAME VARCHAR2(30));

  • CREATE TABLE CUSTOMER_HISTORY
    (ID NUMBER,
    NAME VARCHAR2(30));

  • CREATE TABLE “Boat Inventory”
    (ID NUMBER,
    NAME VARCHAR2(30));

  • CREATE TABLE workSchedule
    (ID NUMBER,
    NAME VARCHAR2(30));

Explanation

Question 5 of 14

1

Which of the following may follow the reserved word CREATE to form a complete SQL
statement? (Choose three.)

Select one or more of the following:

  • TABLE

  • VIEW

  • CONSTRAINT

  • SEQUENCE

Explanation

Question 6 of 14

1

You are logged in to user FINANCE. It is currently the only schema in the entire database. The
following exist in the database:

– A VIEW named VENDORS
– A CONSTRAINT named VENDORS
– An INDEX named CUSTOMER#ADDRESS
You attempt to execute the following SQL statement:

CREATE TABLE CUSTOMER#ADDRESS
(ID NUMBER,
NAME VARCHAR2(30));

Which one of the following is true?

Select one of the following:

  • The question is flawed because you cannot have an INDEX named
    CUSTOMER#ADDRESS.

  • The question is flawed because you cannot have a VIEW and a CONSTRAINT with identical
    names in the same schema.

  • The SQL statement will fail to execute and result in an error message because you cannot
    create a TABLE name with the “#” character.

  • The SQL statement will fail to execute and result in an error message because you cannot
    create a TABLE that has the same name as an INDEX in the same schema.

  • The SQL statement will execute and the TABLE will be created.

Explanation

Question 7 of 14

1

You have a single database, with only one schema. The following four objects exist in the
database:

– A TABLE named PRODUCT_CATALOG
– A TABLE named ADS
– A USER named PRODUCT_CATALOG
– A VIEW named CONFERENCE_SCHEDULE

How many of the four objects are owned by the schema?

Select one of the following:

  • 0

  • 2

  • 3

  • 4

Explanation

Question 8 of 14

1

ROLES:

Select one of the following:

  • Are schema objects, but only when created from within a user account.

  • Are in the same namespace as CONSTRAINTS.

  • Are in the same namespace as TABLES.

  • Are in the same namespace as USERS.

Explanation

Question 9 of 14

1

The DESCRIBE, or DESC, command, can be used to do which of the following?

Select one of the following:

  • Show a table’s columns and the datatypes of those columns.

  • Show a brief paragraph describing what the table does.

  • Show a table’s name and who created it.

  • Show the data that is contained within a table.

Explanation

Question 10 of 14

1

You attempt to execute the following SQL statement:

CREATE TABLE VENDORS
(VENDOR_ID NUMBER,
VENDOR_NAME VARCHAR2,
CATEGORY CHAR);

Which one of the following is true?

Select one of the following:

  • The execution fails because there is no precision indicated for NUMBER.

  • The execution fails because there is no precision indicated for VARCHAR2.

  • The execution fails because there is no precision indicated for CHAR.

  • The execution succeeds and the table is created.

Explanation

Question 11 of 14

1

The following SQL statements create a table with a column named A, and then add a row to
that table.

CREATE TABLE NUMBER_TEST (A NUMBER(5,3));
INSERT INTO NUMBER_TEST (A) VALUES (3.1415);
SELECT A FROM NUMBER_TEST;

What is the displayed output of the SELECT statement?

Select one of the following:

  • 3.1415

  • 3.142

  • 3.141

  • None of the above

Explanation

Question 12 of 14

1

Which of the following SQL statements creates a table that will reject attempts to INSERT a
row with NULL values entered into the POSITION_ID column?

Select one of the following:

  • CREATE TABLE POSITIONS
    (POSITION_ID NUMBER(3),
    CONSTRAINT POSITION_CON UNIQUE (POSITION_ID));

  • CREATE TABLE POSITIONS
    (POSITION_ID NUMBER(3),
    CONSTRAINT POSITION_CON PRIMARY KEY (POSITION_ID));

  • CREATE TABLE POSITIONS
    (POSITION_ID NUMBER(3),
    CONSTRAINT POSITION_CON REQUIRED (POSITION_ID));

  • None of the above

Explanation

Question 13 of 14

1

Review the following SQL statement.

CREATE TABLE shipping_Order
( order_ID NUMBER,
order_Year CHAR(2),
customer_ID NUMBER,
CONSTRAINT shipping_Order PRIMARY KEY (order_ID, order_Year));

Assume there is no table already called SHIPPING_ORDER in the database. What will be the
result of an attempt to execute the preceding SQL statement?

Select one of the following:

  • The statement will fail because the datatype for ORDER_YEAR is a CHAR, and CHAR
    datatypes aren’t allowed in a PRIMARY KEY constraint.

  • The statement will fail because there is no precision for the ORDER_ID column’s datatype.

  • The table will be created, but the primary key constraint will not be created because the
    name does not include the “_PK” suffix.

  • The statement will succeed: the table will be created and the primary key will also be
    created.

Explanation

Question 14 of 14

1

Review the following SQL statement.

CREATE TABLE personnel
( personnel_ID NUMBER(6),
division_ID NUMBER(6),
CONSTRAINT personnel_ID_PK PRIMARY KEY (personnel_ID),
CONSTRAINT division_ID_PK PRIMARY KEY (division_ID));

Assume there is no table already called PERSONNEL in the database. What will be the result
of an attempt to execute the preceding SQL statement?

Select one of the following:

  • The statement will fail because you cannot create two primary key constraints on the table.

  • The statement will successfully create the table and the first primary key, but not the
    second.

  • The statement will successfully create a single table and one composite primary key
    consisting of two columns.

  • The statement will successfully create the table and two primary keys.

Explanation

Previous
Next