821248
Description
Quiz by Bráulio Figueiredo, updated more than 1 year ago
|
Created by Bráulio Figueiredo
over 10 years ago
|
|
Question 1
Question
A table is which of the following? (Choose all that apply.)
Answer
-
A schema object
-
A non-schema object
-
A role
-
All of the above
Question 2
Question
Which of the following are schema objects? (Choose all that apply.)
Answer
-
SEQUENCE
-
PASSWORD
-
INDEX
-
ROLE
Question 3
Question
A CONSTRAINT is assigned to which of the following? (Choose all that apply.)
Answer
-
TABLE
-
SYNONYM
-
SEQUENCE
-
INDEX
Question 4
Question
Which of the following are valid CREATE TABLE statements? (Choose three.)
Answer
-
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));
Question 5
Question
Which of the following may follow the reserved word CREATE to form a complete SQL
statement? (Choose three.)
Answer
-
TABLE
-
VIEW
-
CONSTRAINT
-
SEQUENCE
Question 6
Question
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?
Answer
-
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.
Question 7
Question
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?
Answer
-
0
-
2
-
3
-
4
Question 8
Question
ROLES:
Answer
-
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.
Question 9
Question
The DESCRIBE, or DESC, command, can be used to do which of the following?
Answer
-
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.
Question 10
Question
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?
Answer
-
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.
Question 11
Question
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?
Answer
-
3.1415
-
3.142
-
3.141
-
None of the above
Question 12
Question
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?
Answer
-
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
Question 13
Question
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?
Answer
-
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.
Question 14
Question
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?
Answer
-
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.
Want to create your own Quizzes for free with GoConqr? Learn more.