Bráulio Figueiredo
Test por , creado hace más de 1 año

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

610
4
0
Bráulio Figueiredo
Creado por Bráulio Figueiredo hace más de 10 años
Cerrar

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

Pregunta 1 de 14

1

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

Selecciona una o más de las siguientes respuestas posibles:

  • A schema object

  • A non-schema object

  • A role

  • All of the above

Explicación

Pregunta 2 de 14

1

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

Selecciona una o más de las siguientes respuestas posibles:

  • SEQUENCE

  • PASSWORD

  • INDEX

  • ROLE

Explicación

Pregunta 3 de 14

1

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

Selecciona una o más de las siguientes respuestas posibles:

  • TABLE

  • SYNONYM

  • SEQUENCE

  • INDEX

Explicación

Pregunta 4 de 14

1

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

Selecciona una o más de las siguientes respuestas posibles:

  • 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));

Explicación

Pregunta 5 de 14

1

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

Selecciona una o más de las siguientes respuestas posibles:

  • TABLE

  • VIEW

  • CONSTRAINT

  • SEQUENCE

Explicación

Pregunta 6 de 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?

Selecciona una de las siguientes respuestas posibles:

  • 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.

Explicación

Pregunta 7 de 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?

Selecciona una de las siguientes respuestas posibles:

  • 0

  • 2

  • 3

  • 4

Explicación

Pregunta 8 de 14

1

ROLES:

Selecciona una de las siguientes respuestas posibles:

  • 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.

Explicación

Pregunta 9 de 14

1

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

Selecciona una de las siguientes respuestas posibles:

  • 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.

Explicación

Pregunta 10 de 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?

Selecciona una de las siguientes respuestas posibles:

  • 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.

Explicación

Pregunta 11 de 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?

Selecciona una de las siguientes respuestas posibles:

  • 3.1415

  • 3.142

  • 3.141

  • None of the above

Explicación

Pregunta 12 de 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?

Selecciona una de las siguientes respuestas posibles:

  • 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

Explicación

Pregunta 13 de 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?

Selecciona una de las siguientes respuestas posibles:

  • 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.

Explicación

Pregunta 14 de 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?

Selecciona una de las siguientes respuestas posibles:

  • 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.

Explicación

Anterior
Siguiente