Using DDL Statements to Create and Manage Tables ( Section 2)

Pregunta 1 de 16

1

A table is which of the following?

Selecciona una de las siguientes respuestas posibles:

A schema object
A nonschema object
A role
All of these

Explicación

Pregunta 2 de 16

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 16

1

A CONSTRAINT is assigned to which of the following?This

Selecciona una de las siguientes respuestas posibles:

TABLE
SYNONYM
SEQUENCE
INDEX

Explicación

Pregunta 4 de 16

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 16

1

Which of the following options can be used with the reserved word CREATE to form the beginning of 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 16

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

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 16

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 16

1

Which of the following is true about ROLES?

Selecciona una de las siguientes respuestas posibles:

Roles are schema objects but only when created from within a user account.
Roles are in the same namespace as CONSTRAINTS.
Roles are in the same namespace as TABLES.
Roles are in the same namespace as USERS.

Explicación

Pregunta 9 de 16

1

The 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 data types 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 16

1

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 16

1

What is the displayed output of the SELECT statement?

Selecciona una de las siguientes respuestas posibles:

3.1415
3.142
3.141
None of these

Explicación

Pregunta 12 de 16

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 these

Explicación

Pregunta 13 de 16

1

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 data type for ORDER_YEAR is a CHAR, and CHAR data types aren't allowed in a PRIMARY KEY constraint.
The statement will fail because there is no precision for the ORDER_ID column's data type.
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 16

1

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

Pregunta 15 de 16

1

The difference between dropping a column from a table with DROP and setting a column to be UNUSED is:

Selecciona una de las siguientes respuestas posibles:

An UNUSED column can be recovered.
The UNUSED column and its data are retained within the table's storage allocation and counts against the total limit on the number of columns the table is allowed to have.
A column that is dropped with DROP no longer appears within the table's description as shown with the DESC or DESCRIBE statement, whereas a column that is set to UNUSED still appears in the table's structure as shown in the output of the DESC statement.
Nothing.

Explicación

Pregunta 16 de 16

1

The purpose of the CREATE DIRECTORY statement is to create a named object in the database:

Selecciona una de las siguientes respuestas posibles:

That lists names of user accounts that have external privileges
That contains lookup reference material for queries
That identifies the root directory of the Oracle server installation
That points to a directory you choose somewhere within the Oracle server's file system

	Creado por Craig Willey hace más de 4 años

Databases

Using DDL Statements to Create and Manage Tables ( Section 2)

Using DDL Statements to Create and Manage Tables ( Section 2)

Pregunta 1 de 16

A table is which of the following?

Selecciona una de las siguientes respuestas posibles:

Explicación

Pregunta 2 de 16

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

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

Explicación

Pregunta 3 de 16

A CONSTRAINT is assigned to which of the following?This

Selecciona una de las siguientes respuestas posibles:

Explicación

Pregunta 4 de 16

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

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

Explicación

Pregunta 5 de 16

Which of the following options can be used with the reserved word CREATE to form the beginning of a complete SQL statement? (Choose three.)

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

Explicación

Pregunta 6 de 16

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

Selecciona una de las siguientes respuestas posibles:

Explicación

Pregunta 7 de 16

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:

Explicación

Pregunta 8 de 16

Which of the following is true about ROLES?

Selecciona una de las siguientes respuestas posibles:

Explicación

Pregunta 9 de 16

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

Selecciona una de las siguientes respuestas posibles:

Explicación

Pregunta 10 de 16

Which one of the following is true?

Selecciona una de las siguientes respuestas posibles:

Explicación

Pregunta 11 de 16

What is the displayed output of the SELECT statement?

Selecciona una de las siguientes respuestas posibles:

Explicación

Pregunta 12 de 16

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:

Explicación

Pregunta 13 de 16

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:

Explicación

Pregunta 14 de 16

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:

Explicación

Pregunta 15 de 16

The difference between dropping a column from a table with DROP and setting a column to be UNUSED is:

Selecciona una de las siguientes respuestas posibles:

Explicación

Pregunta 16 de 16

The purpose of the CREATE DIRECTORY statement is to create a named object in the database:

Selecciona una de las siguientes respuestas posibles:

Explicación

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