Deck 2: Creating and Modifying Database Tables

Question 1

If a column has a YEAR TO MONTH INTERVAL data type,then the value +02-11 specifies a positive time interval of 2 years and 11 months.

Answer 1

True

Question 2

If a user only specifies the time when setting a value for a DATE column,the date portion will default to the current time.

Answer 2

False

Question 3

Up to 6 GB of binary data can be stored in a BLOB column.

Answer 3

False

Question 4

When declaring a NUMBER data type,scale is the total number of digits both to the left and to the right of the decimal point.

Question 5

A TIMESTAMP data type is the same as a DATE data type,except that time zone can be specified.

Question 6

A fixed-point number contains a specific number of decimal places.

Question 7

The CHAR data types stores up to 4,000 characters.

Question 8

The Oracle DBMS stores columns of all data types in the same amount of space.

Question 9

The following declaration represents a floating-point number: my_number NUMBER.

Question 10

The CHAR and VARCHAR2 data types store Unicode character data.

Question 11

To create a table it is only necessary to specify column names.

Question 12

A user schema contains all database objects created by a user.

Question 13

Using the CHAR data type causes a column value to be padded to the maximum declared size of the column.

Question 14

The SQL command to create a database table is an example of DML.

Question 15

The VARCHAR2 data type can store up to 4,000 characters.

Question 16

According to the Oracle Naming Standard,'-' (hyphen)is a legal character.

Question 17

A NOT NULL constraint is an example of a table constraint.

Question 18

Given the column declaration name CHAR(5),if a user attempted to store the value "Jonathan" in the name column,only the first 5 characters would be stored.

Question 19

The following declaration represents an integer: my_int number(4,2).

Question 20

A primary key is defined using an integrity constraint.

Question 21

Which of the following is a legal character in the Oracle Naming Standard?

A)%
B)^
C)#
D)*

Question 22

To check that the value entered into a CHAR column is either 'M' or 'F',you would use a check condition constraint.

Question 23

Which of the following declares a column named "name" that always contains exactly 30 characters?

A)VARCHAR2(30)name
B)CHAR(30)name
C)name VARCHAR2(30)
D)name CHAR(30)

Question 24

Which of the following is not required when creating a table?

A)table size
B)table name
C)column names
D)column data types

Question 25

You can change a column data type from VARCHAR2 to NUMBER.

Question 26

You can always rename a table.

Question 27

In an INTERVAL YEAR TO MONTH data type,which of the following indicates a positive time interval of 2 years and 11 months?

A)2-11
B)+2-11
C)+02-11
D)11-02

Question 28

Which of the following data types is used to store variable length ASCII character data?

A)CHAR
B)NCHAR
C)VARCHAR2
D)NVARCHAR2

Question 29

If the column S_ID is the primary key of the STUDENT table,the constraint name would be pk_STUDENT_S_ID according to the constraint naming convention.

Question 30

Which of the following declarations would be most appropriate for storing a dollar value up to $1000?

A)price NUMBER(5,2)
B)price NUMBER(5)
C)price NUMBER(2)
D)price NUMBER

Question 31

It is possible to temporarily disable constraints in an Oracle database.

Question 32

Which of the following is not part of a DDL command?

A)create table ...
B)drop table ...
C)create constraint ...
D)select table_name from ...

Question 33

Which of the following is not a legal table name according to the Oracle Naming Standard?

A)#COURSE_ID
B)COURSE$ID
C)COURSEID
D)COURSE_ID

Question 34

If a user enters only a time into a DATE column,what will the date portion be set to?

A)January 1,1970
B)first day of the current year
C)first day of the current month
D)current date

Question 35

An Oracle error consists of a 3 letter prefix and a 5 digit code.

Question 36

When you exit from a SQL*Plus session,the connection with the database is automatically closed.

Question 37

To log in to a database using SQL*Plus you only need to provide user name and password.

Question 38

A composite key is created using a value constraint.

Question 39

What is the default format for a DATE value?

A)MM/DD/YY
B)DD-MON-YY
C)MM/DD/YYYY
D)MON-DD-YYYY

Question 40

To view the column names and data types of the LOCATION table you would type DESCRIBE LOCATION;at the SQL*Plus prompt.

Question 41

Which of the following sql commands adds a new VARCHAR2 column of length 20 named new_column to table test?

A)ALTER TABLE test
ADD (new_column VARCHAR2(20))
B)ADD column new_column VARCHAR2(20)to TABLE test
C)ADD to TABLE test (new_column VARCHAR2(20))
D)ALTER TABLE test (new_column VARCHAR2(20))

Question 42

If you need to store a jpeg image in the database,which column declaration would you use?

A)my_image BLOB
B)my_image CLOB
C)my_image LOB
D)my_image BFILE

Question 43

When selecting the table_name column from the all_tables view which tables are displayed?

A)all tables in database
B)all tables in user's schema
C)all tables user has permission to manipulate
D)all newly created tables

Question 44

Which of the following pieces of information is not displayed by SQL*Plus when an error occurs?

A)error line number
B)error location
C)error code
D)suggested correction

Question 45

Almost all relational database vendors support the ____ ANSI standard.

A)SQL-88
B)SQL-92
C)SQL-93
D)SQL-99

Question 46

Which of the following is true when decreasing the maximum size of a CHAR column?

A)it is an unrestricted action
B)it is only permitted if all values are NULL
C)all values in the column will be truncated to the new size
D)all values larger than the new size will be automatically set to NULL

Question 47

Which command is used to disable the constraint named faculty_loc_id_fk in the faculty table?

A)MODIFY TABLE CONSTRAINT
DISABLE faculty_loc_id_fk;
B)ALTER TABLE faculty
DISABLE faculty_loc_id_fk;
C)MODIFY TABLE faculty
DISABLE faculty_loc_id_fk;
D)ALTER TABLE faculty
DISABLE CONSTRAINT faculty_loc_id_fk;

Question 48

Which of the following is not required to log in to an Oracle database using SQL*Plus?

A)password
B)database server ip
C)host string
D)user name

Question 49

Which of the following is not automatically transferred to a new table name upon renaming a table?

A)indexes
B)constraints
C)views
D)privileges

Question 50

Which of the following pieces of information about a table is not displayed when using the DESCRIBE command?

A)column name
B)column data type
C)not null settings
D)table constraints

Question 51

____ commands are used to add new database objects.

A)DML
B)DDL
C)DCL
D)XML

Question 52

Which of the following column data type changes is permitted?

A)DATE to CHAR
B)VARCHAR2 to CHAR
C)CHAR to NUMBER
D)NUMBER to DATE

Question 53

Which of the following LOB data types does not store the entire large object in the database?

A)BLOB
B)BFILE
C)CLOB
D)NCLOB

Question 54

SQL command words are also known as ____.

A)Java commands
B)terms
C)code words
D)reserved words

Question 55

Which command would be used to delete table x and all foreign key constraints to x?

A)delete x
B)delete x cascade constraints
C)drop x
D)drop x cascade constraints

Question 56

The ____ data type stores variable-length character data.

A)CHAR
B)VARCHAR
C)VARCHAR2
D)STRING2

Question 57

The Oracle Naming Standard states that objects must be from 1 to ____ characters long.

A)20
B)30
C)40
D)unlimited

Question 58

Which of the following data dictionary views can only be seen by users with special privileges?

A)USER
B)ALL
C)DBA
D)SCHEMA

Question 59

Which of the following is a table constraint?

A)not null constraint
B)check condition
C)unique constraint
D)default constraint

Question 60

Which of the following is not created using an integrity constraint?

A)foreign key
B)primary key
C)composite key
D)surrogate key

Question 61

A ____ is a character LOB,storing up to 4 GB of character data in the database.

A)BFILE
B)BLOB
C)CLOB
D)CHAR

Question 62

A(n)____________________ is a whole number with no digits on the right side of the decimal point.

Question 63

A(n)____________________ specifies the kind of data that the column stores.

Question 64

Fixed-length character data is stored in the ____________________ data type.

Question 65

The data objects within a user schema are called database objects or ____________________.

Question 66

Deleting columns from a table is a(n)____ action.

A)restricted
B)unrestricted
C)illegal
D)privileged

Question 67

____________________ are restrictions on the data values that a column can store.

Question 68

The ____ constraint specifies whether the user must enter a column for a specific record,or whether the value can be NULL (indeterminate or unknown).

A)INDEF
B)INPUT
C)NULL
D)NOT NULL

Question 69

____ constraints define specific data values or data ranges that must be inserted into columns and whether values must be unique or not NULL.

A)Value
B)Integrity
C)Redundancy
D)Range

Question 70

A(n)____ number would be best to store a currency value.

A)int
B)char
C)floating-point
D)fixed-point

Question 71

The VARCHAR2 data type stores variable-length character data up to a maximum of ____________________ characters.

Question 72

The CHAR data type stores fixed-length character data up to a maximum size of ____ characters.

A)2,000
B)4,000
C)10,000
D)unlimited

Question 73

Each SQL*Plus command is terminated with a(n)____.

A)period
B)semicolon
C)colon
D)exclamation mark

Question 74

Oracle10g stores character data in VARCHAR2 and CHAR columns using ____ encoding.

A)Unicode
B)ASCII
C)EBCDIC
D)Java

Question 75

The ____________________ specifies the number of digits on the right side of the decimal point.

Question 76

You use the ____ data type for any column that stores numerical data upon which users may perform arithmetic calculations.

A)NUMBER
B)NUMERIC
C)VAR
D)FLOAT

Question 77

______________________________ commands are used to insert,update,delete,and view data.

Question 78

The ____ TABLE command is used to modify an existing column's data declaration.

A)CHANGE
B)RESET
C)MODIFY
D)ALTER

Question 79

____________________ is the total number of digits both to the left and to the right of the decimal point.

Question 80

NVARCHAR2 and NCHAR store character data with ____________________ coding.