Quiz
Simulado Capítulo 2
Create a free account to finish this quiz
Save your progress and see your final score.
Already have an account? Sign in
Questions in this 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));- 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.
Information
- Description
- Programas de Certificação Oracle (Exame OCE 1Z0-047 (Simulados)) Quiz on Simulado Capítulo 2, created by braulio_figueiredo on 05/05/2015.
- Author
- braulio_figueiredo
- Language
- Português
- Views
- 5
- Tags
- Rating
- No ratings yet Rate this quiz