821248
Descripción
Test por Bráulio Figueiredo, actualizado hace más de 1 año
|
Creado por Bráulio Figueiredo
hace más de 10 años
|
|
Pregunta 1
Pregunta
A table is which of the following? (Choose all that apply.)
Respuesta
-
A schema object
-
A non-schema object
-
A role
-
All of the above
Pregunta 2
Pregunta
Which of the following are schema objects? (Choose all that apply.)
Respuesta
-
SEQUENCE
-
PASSWORD
-
INDEX
-
ROLE
Pregunta 3
Pregunta
A CONSTRAINT is assigned to which of the following? (Choose all that apply.)
Respuesta
-
TABLE
-
SYNONYM
-
SEQUENCE
-
INDEX
Pregunta 4
Pregunta
Which of the following are valid CREATE TABLE statements? (Choose three.)
Respuesta
-
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));
Pregunta 5
Pregunta
Which of the following may follow the reserved word CREATE to form a complete SQL
statement? (Choose three.)
Respuesta
-
TABLE
-
VIEW
-
CONSTRAINT
-
SEQUENCE
Pregunta 6
Pregunta
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?
Respuesta
-
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.
Pregunta 7
Pregunta
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?
Respuesta
-
0
-
2
-
3
-
4
Pregunta 8
Pregunta
ROLES:
Respuesta
-
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.
Pregunta 9
Pregunta
The DESCRIBE, or DESC, command, can be used to do which of the following?
Respuesta
-
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.
Pregunta 10
Pregunta
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?
Respuesta
-
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.
Pregunta 11
Pregunta
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?
Respuesta
-
3.1415
-
3.142
-
3.141
-
None of the above
Pregunta 12
Pregunta
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?
Respuesta
-
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
Pregunta 13
Pregunta
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?
Respuesta
-
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.
Pregunta 14
Pregunta
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?
Respuesta
-
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.
¿Quieres crear tus propios Tests gratis con GoConqr? Más información.