821248
Beschreibung
Quiz von Bráulio Figueiredo, aktualisiert more than 1 year ago
|
Erstellt von Bráulio Figueiredo
vor mehr als 10 Jahre
|
|
Frage 1
Frage
A table is which of the following? (Choose all that apply.)
Antworten
-
A schema object
-
A non-schema object
-
A role
-
All of the above
Frage 2
Frage
Which of the following are schema objects? (Choose all that apply.)
Antworten
-
SEQUENCE
-
PASSWORD
-
INDEX
-
ROLE
Frage 3
Frage
A CONSTRAINT is assigned to which of the following? (Choose all that apply.)
Antworten
-
TABLE
-
SYNONYM
-
SEQUENCE
-
INDEX
Frage 4
Frage
Which of the following are valid CREATE TABLE statements? (Choose three.)
Antworten
-
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));
Frage 5
Frage
Which of the following may follow the reserved word CREATE to form a complete SQL
statement? (Choose three.)
Antworten
-
TABLE
-
VIEW
-
CONSTRAINT
-
SEQUENCE
Frage 6
Frage
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?
Antworten
-
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.
Frage 7
Frage
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?
Antworten
-
0
-
2
-
3
-
4
Frage 8
Frage
ROLES:
Antworten
-
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.
Frage 9
Frage
The DESCRIBE, or DESC, command, can be used to do which of the following?
Antworten
-
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.
Frage 10
Frage
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?
Antworten
-
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.
Frage 11
Frage
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?
Antworten
-
3.1415
-
3.142
-
3.141
-
None of the above
Frage 12
Frage
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?
Antworten
-
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
Frage 13
Frage
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?
Antworten
-
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.
Frage 14
Frage
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?
Antworten
-
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.
Möchten Sie mit GoConqr kostenlos Ihre eigenen Quiz erstellen? eigenen Mehr erfahren.