Quiz
Exame OCE 1Z0-047 (Capítulos 1 e 2)
Perguntas do quiz (14)
1A table is which of the following? (Choose all that apply.)
- AA schema object
- BA non-schema object
- CA role
- DAll of the above
2Which of the following are schema objects? (Choose all that apply.)
- ASEQUENCE
- BPASSWORD
- CINDEX
- DROLE
3A CONSTRAINT is assigned to which of the following? (Choose all that apply.)
- ATABLE
- BSYNONYM
- CSEQUENCE
- DINDEX
4Which of the following are valid CREATE TABLE statements? (Choose three.)
- ACREATE TABLE $ORDERS
(ID NUMBER,
NAME VARCHAR2(30)); - BCREATE TABLE CUSTOMER_HISTORY
(ID NUMBER,
NAME VARCHAR2(30)); - CCREATE TABLE “Boat Inventory”
(ID NUMBER,
NAME VARCHAR2(30)); - DCREATE TABLE workSchedule
(ID NUMBER,
NAME VARCHAR2(30));
- ACREATE TABLE $ORDERS
5Which of the following may follow the reserved word CREATE to form a complete SQL
statement? (Choose three.)- ATABLE
- BVIEW
- CCONSTRAINT
- DSEQUENCE
6You 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?- AThe question is flawed because you cannot have an INDEX named
CUSTOMER#ADDRESS. - BThe question is flawed because you cannot have a VIEW and a CONSTRAINT with identical
names in the same schema. - CThe SQL statement will fail to execute and result in an error message because you cannot
create a TABLE name with the “#” character. - DThe 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. - EThe SQL statement will execute and the TABLE will be created.
- AThe question is flawed because you cannot have an INDEX named
7You 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?- A0
- B2
- C3
- D4
8ROLES:
- AAre schema objects, but only when created from within a user account.
- BAre in the same namespace as CONSTRAINTS.
- CAre in the same namespace as TABLES.
- DAre in the same namespace as USERS.
9The DESCRIBE, or DESC, command, can be used to do which of the following?
- AShow a table’s columns and the datatypes of those columns.
- BShow a brief paragraph describing what the table does.
- CShow a table’s name and who created it.
- DShow the data that is contained within a table.
10You 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?- AThe execution fails because there is no precision indicated for NUMBER.
- BThe execution fails because there is no precision indicated for VARCHAR2.
- CThe execution fails because there is no precision indicated for CHAR.
- DThe execution succeeds and the table is created.
11The 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?- A3.1415
- B3.142
- C3.141
- DNone of the above
12Which 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?- ACREATE TABLE POSITIONS
(POSITION_ID NUMBER(3),
CONSTRAINT POSITION_CON UNIQUE (POSITION_ID)); - BCREATE TABLE POSITIONS
(POSITION_ID NUMBER(3),
CONSTRAINT POSITION_CON PRIMARY KEY (POSITION_ID)); - CCREATE TABLE POSITIONS
(POSITION_ID NUMBER(3),
CONSTRAINT POSITION_CON REQUIRED (POSITION_ID)); - DNone of the above
- ACREATE TABLE POSITIONS
13Review 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?- AThe statement will fail because the datatype for ORDER_YEAR is a CHAR, and CHAR
datatypes aren’t allowed in a PRIMARY KEY constraint. - BThe statement will fail because there is no precision for the ORDER_ID column’s datatype.
- CThe table will be created, but the primary key constraint will not be created because the
name does not include the “_PK” suffix. - DThe statement will succeed: the table will be created and the primary key will also be
created.
- AThe statement will fail because the datatype for ORDER_YEAR is a CHAR, and CHAR
14Review 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?- AThe statement will fail because you cannot create two primary key constraints on the table.
- BThe statement will successfully create the table and the first primary key, but not the
second. - CThe statement will successfully create a single table and one composite primary key
consisting of two columns. - DThe statement will successfully create the table and two primary keys.
Informações
- Descrição
- Simulado do exame de certificação OCE 1Z0-047 Oracle
- Autor
- Bráulio Figueiredo
- Idioma
- Português
- Visualizações
- 640
- Etiquetas
- Avaliação
- 4,5 de 5 · 2 avaliações Avalie este quiz