IT314 Database Midterm

The ____________________ operator is used to create an outer join in the WHERE clause of a SQL statement.

(+) or outer join

Which of the following symbols represents all the columns contained in a table?\n\n \n1) \n/\n\n \n2) \n;\n\n\n3) \n*\n\n \n4) \n^

*

The keyword ____________________ must be used in a CREATE INDEX command to create a Bitmap index.

BITMAP

Which of the following datatypes refers to fixed-length character data, where n represents the maximum length of the column?

CHAR(n)

Which of the following datatypes refers to fixed-length character data, where n represents the maximum length of the column?\n \n1) CHAR(n)\n \n2) VARCHAR(n)\n \n3) VARCHAR2(n)\n \n4) LONG

CHAR(n)

When creating a sequence, which of the following is not an optional clause?

CREATE SEQUENCE

Which of the following search conditions can be used to identify records that have data stored in a column named ColB?

ColB IS NOT NULL

Which of the following commands will delete only publisher 4 from the PUBLISHER table?

DELETE FROM publisher WHERE pubid = 4;

Which of the following statements can be used to view the structure of the ORDERS table?\n \n1) \nSELECT * FROM orders;\n\n \n2) \nDESCRIBE ORDERS\n\n \n3) \nLIST ORDERS;\n\n \n4) \nNone of the above

DESCRIBE ORDERS

Indexes can speed up row retrieval, but can slow down ____________________ operations because the index must also be updated.

DML

Which of the following keywords is used to remove a database table in Oracle11g?

DROP TABLE

Which of the following keywords is used to remove a database table in Oracle11g?\n \n1) DROP TABLE\n \n2) ALTER TABLE...DROP\n \n3) DELETE TABLE\n \n4) TRUNCATE TABLE

DROP TABLE

In a "one-to-many" relationship, which constraint is usually added to the "many" table?\n \n1) UNIQUE\n \n2) PRIMARY KEY\n \n3) FOREIGN KEY\n \n4) NOT NULL

FOREIGN KEY

Which keywords identify a column that, if it contains a value, it must match data contained in another table?\n\n1) FOREIGN KEY\n \n2) PRIMARY KEY\n \n3) CHECK\n \n4) UNIQUE

FOREIGN KEY

To indicate which database table contains the data to be selected by a query, the table name should be listed in the ____ clause.\n\n \n1) \nSELECT\n\n \n2) \nFROM\n\n \n3) \nWHERE\n\n \n4) \nHAVING

FROM

Which of the following is an example of assigning "o" as a table alias for the ORDERS table in the FROM clause?

FROM orders o, customers c

A COMMIT is explicitly issued when the user exits SQL*Plus.

False

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

False

An outer join operator consists of a minus sign enclosed in parentheses, (-).

False

Case conversion functions can only be used in the SELECT clause of a SELECT statement.

False

DML commands are used to create or modify database tables.

False

Data redundancy is created through a process known as normalization.

False

If a primary key has been identified for the data, then the data is considered to be in first normal form (1NF).

False

If data is only being added to some of the columns in a table, the names of the columns must be listed in the VALUES clause.

False

If the WHERE clause is omitted from the DELETE command, then all columns from the database table will be dropped.

False

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.

False

Only a DATE function can be nested inside another DATE function.

False

SYSTEMDATE can be used to include the computer's date in a SQL statement.

False

The ORDER BY clause is used to group data.

False

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

False

The TRUNCATE TABLE command can be used to delete a table from a database.

False

The UNION set operator will not suppress rows that are returned by both queries.

False

The USER_SEQ data dictionary view can be used to verify sequence settings.

False

The USING clause must be used with the JOIN keyword when linking tables that do not contain a commonly named column.

False

Which of the following statements about the DELETE command is incorrect?

If you omit the mandatory WHERE clause, an error message will be issued.

The ____________________ set operator is used to display the rows returned by both SELECT statements.

Intersect

The ____________________ pseudocolumn is used to generate the next sequence value.

NEXTVAL

The ____________________ function is used to determine the next occurrence of a specific day of the week after a given date.

NEXT_DAY

An index is not implicitly created when which type of constraint is created?

NOT NULL

When sorting the results in ascending order, which of the following values will be presented last in the output?

NULL

A table alias cannot be assigned in the FROM clause if which of the following keywords is used to join tables?

Natural Join

The ____________________ logical operator is evaluated last in a sequence of logical operators.

OR

Which of the following clauses is used to indicate a particular sort sequence for presenting query results?

ORDER BY

Which of the following statements about the INSERT keyword is incorrect?

Oracle11g does not allow column names to be omitted from the INSERT INTO clause.

Which of the following commands allows a user to "undo" uncommitted changes to data?

Rollback

Which of the following commands is used to issue a query?\n\n \n1) \nQUER\n\n \n2) \nFROM\n\n \n3) \nSELECT\n\n \n4) \nQUESTION

SELECT

Which of the following is a valid SQL statement based upon the contents of the CUSTOMERS table?

SELECT customer#, NVL2(referred, 'Referred', 'Not Referred') FROM customers;

Based upon the structure of the ORDERS table, which of the following is a valid SQL statement?\n\n \n1) \nSELECT customer # FROM orders;\n\n \n2) \nSELECT "order#", "customer#" FROM orders;\n\n \n3) \nSELECT order#, orderdate DateOrdered FROM orders;\n\n \n4) \nNone of the above

SELECT order#, orderdate DateOrdered FROM orders;

If a SELECT statement includes SUBSTR(TO_CHAR(SYSDATE, 'fmMONTH DD, YYYY'), -4, 4) in the SELECT clause, which of these functions will be executed first?

TO_CHAR

If a column is defined as NUMBER(5,2), which of the following is true?\n \n1) The column can store a total of 7 digits, with 5 on the left side of the decimal point, and 2 on the right.\n \n2) The column can store a total of 7 digits, all of them on the right side of the decimal point.\n \n3) The column can store a total of 5 digits, with 3 on the left side of the decimal point, and 2 on the right.\n \n4) The column can store a total of 5 digits, all of them on the left side of the decimal point.

The column can store a total of 5 digits, with 3 on the left side of the decimal point, and 2 on the right.

When creating a table, which of the following statements is correct?

The column list must be enclosed in parentheses ( ).

The duration of a(n) ____________________ is defined by when a COMMIT implicitly or explicitly occurs.

Transaction

A database object is a defined, self-contained structure in Oracle11g.

True

A primary key is defined using an integrity constraint.

True

DDL commands are used to create or modify database objects.

True

The operator ^= indicates not equal.

True

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

True

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

True

When a self-join is created, each copy of the table must be assigned a table alias.

True

You must include the MI element in the format argument of a TO_CHAR function to include the minutes when displaying time.

True

To delete table data without saving rollback information, use the ____________________ command.

Truncate

The ____ data type stores variable-length character data.

VARCHAR2

Which of the following contains the ROWID of referenced rows?

index

Which of the following terms represents a collection of fields?\n \n1) field\n \n2) record\n \n3) character\n \n4) file

record

A(n) ____________________ can be used to generate values for a column designated as the primary key for a table.

sequence

The multi-step process used when creating a new system is referred to as ____.\n \n1) the Systems Development Life Cycle\n \n2) data mining\n \n3) E-R Modeling\n \n4) SQL

the Systems Development Life Cycle

What is the maximum number of columns or character strings that can be combined through a single CONCAT function?

two

Which of the following is a table constraint?

unique constraint

Which of the following may contain repeating groups of data?

unnormalized data

What will happen if you try to use the INSERT command to insert a NULL value into a column that has been assigned a PRIMARY KEY constraint?

An error message is returned and the row is not added to the table.

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

Ascii

Which of the following commands can be used to make structural changes to an existing table?

Correct ALTER TABLE

Which of the following terms refers to commands that are used to create or modify database tables?

Correct data definition language (DDL)

Which of the following format elements will display the value of Friday in a specified date as a 6?

D

Although the ____________________ table is rarely used in the industry, it can be valuable for someone learning how to work with functions or testing new functions.

DUAL

To indicate that the three-letter abbreviation for day of the week should be displayed, include ____________________ in the date element format argument.

DY

Which of the following is used to create and maintain the physical database?\n1. Data mining\n2. Database Management System (DBMS)\n3. E-R Model\n4. Systems Development Life Cycle (SDLC)

Database Management System (DBMS)

A column name can consist of up to 225 characters.

False

A column qualifier indicates the column containing the data being referenced.

False

A composite key is created using a value constraint.

False

A database must be shut down before the ALTER TABLE command can be executed.

False

A field is a basic unit of data also referred to as a record.

False

A full outer join can be created by including an outer join operator on both sides of the linking condition stated in the WHERE clause.

False

A search condition can be specified in a(n) SELECT clause.

False

A table alias can be assigned in the FROM clause, even when tables are being joined using the NATURAL JOIN keywords.

False

A table must contain a minimum of two columns.

False

The DELETE TABLE command can be used to remove a table from a database.

False

The DROP command can be used to remove rows from an existing table.

False

The GROUP BY clause can only be used when a SELECT statement includes a group function.

False

An _________________________ is a variant of the B-tree index structure and is used as an alternative to the conventional heap-organized table.

Index Organized Table

The ____________________ keyword can be included in the FROM clause to link tables.

JOIN

Which of the following keywords can be used to join two tables that do not contain a commonly named and defined column?

JOIN...ON

If you are attempting to join two tables that have multiple common columns, which of the following JOIN keywords should be used to specify how the tables should be linked?

JOIN...USING

To indicate that minutes should be displayed, include ____________________ in the time element format argument.

MI

The ____________________ clause identifies the lowest value a sequence can generate.

MINVALUE

Which of the following keywords can be used to change the size, datatype, and/or default value of an existing column?\n \n1) ADD\n \n2) MODIFY\n \n3) CHANGE\n \n4) RESET

MODIFY

Which of the following is a valid table name?\n \n1) MYTABLE\n \n2) DISTINCT\n \n3) SELECT\n \n4) CHAR

MYTABLE

To remove a PUBLIC synonym, you must include the ____ keyword in the DROP command.

PUBLIC

Which of the following is a valid SQL statement?\n\n \n1) \nSELECT title, retail-cost FROM books;\n\n \n2) \nSELECT title, retail-cost "Profit"\n\n \n3) \nSELECT DISTINCT title, category\nFROM books/\n\n \n4) \nAll of the above

SELECT title, retail-cost FROM books;

Based upon the contents of the PUBLISHER table, which of the following is a valid SQL statement?\n\n \n1) \nSELECT * FROM pubid;\n\n \n2) \nSELECT * FROM name;\n\n \n3) \nSELECT * FROM contact;\n\n\n4) \nSELECT * FROM publisher;

SELECT*FROM publisher

Which of the following format model elements can be used to spell out a number?

SP

A column represents a field in the physical database table.

True

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

True

A group function can be used in a(n) inline view.

True

A subquery can be used with the INSERT command to enter data from an existing table into the destination table.

True

A table name can be up to 30 characters in length.

True

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

True

An ORDER BY clause can reference a column to be used for sorting based upon its position in the SELECT clause.

True

The DROP COLUMN clause of the ALTER TABLE command can only be used to delete one column at a time.

True

The DROP TABLE command can be used to remove a table and all its data from a database.

True

The HAVING clause specifies which groups will be displayed in the results, while the WHERE clause restricts the records that are retrieved from the table for processing.

True

The IN logical operator is similar to using OR.

True

The VALUES clause is not included with the INSERT command if the data is being retrieved from another table.

True

The VARIANCE function is used to determine the variance in a group of numeric data.

True

Which of the following keywords is omitted from the INSERT command if the data to be added to a table is already contained in another table?

VALUES

What name is used to denote a common field that exists between two tables, but is also the primary key for one of the tables?\n \n1) duplicate key\n\n2) foreign key\n \n3) composite primary key\n \n4) distinct key

foreign key

If you are creating a new table containing four columns from an existing table and want to change the name of one of the columns when it is created in the new table, add a column list containing ____ names in the CREATE TABLE clause.

four

A(n) ____________________ outer join is necessary when you need rows returned from either table that do not have a matching record in the other table.

full

Data stored in separate tables can be reconstructed through the use of ____________________.

joins

When the WHERE clause contains multiple types of operators, which of the following is resolved last?

logical operators

The fact that a person can wear different size clothes and that different people can wear the same size clothes is best characterized as a what type of relationship?\n \n1) one-to-many\n \n2) many-to-many\n \n3) one-to-all\n \n4) one-to-one

many-to-many

The outer join operator is placed on the side of the joining condition that has ____________________ rows.

missing, deficient, or NULL

Which of the following commands will change the name of the LASTNAME column to LAST_NAME in the CUSTOMERS table?

none of the above

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

suggested correction

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

table size

If more than ____________________ percent of a table is expected to be returned in the results of a query, then an index will probably not speed up the process.

10

The starting value for a sequence cannot be changed using the ____________________ SEQUENCE command.

ALTER

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

ALTER TABLE faculty DISABLE CONSTRAINT faculty_loc_id_fk;

A(n) implicit commit is issued when the user enters and executes COMMIT; in SQL*Plus.

False

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

False

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.

False

The WHERE clause specifies which groups will be displayed in the results.

False

The data being inserted into a table are listed in the ADD clause of the INSERT command.

False

The default size of a VARCHAR2 column is one character.

False

The default size of the CHAR column is 2.

False

The format argument in the TO_CHAR function must be enclosed in double quotation marks.

False

The maximum width of a NUMBER column is 25 digits.

False

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

False

To indicate that the numeric value of the day of the year for a date is being specified, include DAY in format argument of the TO_DATE function.

False

To retain the structure of a table, while deleting all its data and releasing their storage space, execute the TRUNC command.

False

When combining the results of two SELECT statements with the MINUS keyword, duplicate rows are suppressed in the results.

False

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.

False

You can determine the number of characters in a column by using the COUNT function.

False

Columns used to group data in the GROUP BY clause do not have to be listed in the SELECT clause.

True

If no value is assigned to a column when a row is added to a table, the column will contain a NULL value.

True

If the WHERE clause of the DELETE command is omitted, then all rows in the referenced table will be removed.

True

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

True

Logical operators are evaluated in the order of NOT, AND, and OR.

True

More than one column can be changed at a time with the ALTER TABLE...MODIFY command.

True

Oracle11g is case sensitive when comparing data to a search condition.

True

The most common type of join is an equijoin, which joins two or more tables together based upon the tables having equivalent data values in a common column.

True

The precision of a NUMBER does not include the decimal point itself in the total number of digits that can be stored in a column.

True

Transaction control statements are used to either save modified data or to undo changes before they are committed.

True

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

True

When a column is deleted, the deletion is permanent.

True

Which of the following set operators will display only the unique results of the combined SQL statements?

UNION

When two tables that share more than one common column are being joined, the JOIN...____________________ keywords are normally used in the FROM clause to join the tables.

USING

A MERGE statement containing an UPDATE and an INSERT clause is also called a(n) ____________________ statement.

Upsert

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

VARCHAR2

The ____ function is used to determine how widely data are spread out within a group.

Variance

Which of the following is a valid statement?

When rows are added to a table, the column names can be omitted if the values are listed in the same order as the columns are listed in the table.

Which of the following is a valid statement?\n \n1) Constraints are rules used to enforce business rules, practices, and policies.\n \n2) Constraints prevent errors by not allowing data to be added to tables if the data violates specific rules.\n \n3) Constraints ensure the accuracy and integrity of data.\n \n4) all of the above

all of the above

When the WHERE clause contains multiple types of operators, which of the following is resolved first?

arithmetic operations

How can constraints be added to a table?\n \n1) as part of the CREATE TABLE command\n \n2) as part of the ALTER TABLE command\n \n3) as part of the PRIMARY KEY command\n\n4) both a and b

both a and b

Which of the following types of columns will automatically left-align the column heading when it is displayed?\n\n \n1) \ncharacter\n\n \n2) \nnumeric\n\n \n3) \ndate\n\n \n4) \nboth a and c

both a and c

_____________ table can be added to the physical database to eliminate a many-to-many relationship.

bridging

What is added to a relational database to eliminate many-to-many relationships?\n \n1) bridging table\n \n2) transitive dependency\n \n3) primary entity\n \n4) secondary entity

bridging table

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

drop x cascade constraints

Which of the following types of joins is created by matching equivalent values in each table?

equality join

If a group function is used in the SELECT clause, any ____ listed in the SELECT clause must also be listed in the GROUP BY clause.

individual column

Which of the following is used to determine the correct organization for data that is to be stored in a database?\n \n1) E-R model\n \n2) normalization process\n \n3) systems implementation and review\n \n4) systems analysis

normalization process

To display rows from one table that do not have a corresponding row in the other table, you must create a(n) ____________________ join.

outer

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

select table_name from ...

A user who is issuing DML commands can save modified data or undo uncommitted changes by issuing ____ statements.

transaction control

Which of the following keywords cannot be used to modify an existing table?

Correct ALTER TABLE...AS

Which of the following SQL*Plus commands will display the structure of a table?\n \n1) DISPLAY\n \n2) DESC\n \n3) DSC\n \n4) VIEW

DESC

Which of the following commands can be used to view the structure of a table?\n\n \n1) \nCONCATENATION\n\n \n2) \nDESCRIBE\n\n \n3) \nSELECT\n\n \n4) \nNone of the above

DESCRIBE

If you omit the search condition in the delete query no record will be deleted.

False

Single-row functions return one row of results for each group or category of rows processed.

False

The IN comparison operator is used when searching for a pattern of characters.

False

The JOIN keyword is used in the WHERE clause to indicate the tables that should be joined or linked.

False

The JOIN keyword must be used in the WHERE clause of a SELECT statement.

False

The JOIN...USING keywords are used to join two tables that do not have a commonly named and defined column.

False

The MODIFY TABLE command can be used to change the size of a table.

False

The MODIFY command can be used to change existing data stored in a table.

False

The ON clause can be used only if the tables being joined have a common column with the same name.

False

The VALUES clause of the UPDATE command is used to specify the columns being updated and the new data values.

False

The outer join operator is used to combine the results of multiple SELECT statements.

False

The table called DUMMY consists of a blank holding area that can be referenced by a user.

False

When the INSERT command is used to add rows to a table, the column names of the table must be specified.

False

When the column names are listed in the INSERT INTO clause of the INSERT command, the order of the names must exactly match the order of the data values in the UPDATE clause.

False

When using the ALTER TABLE...DROP COLUMN command, which of the following is not correct?

The command can be used to delete multiple columns from a table.

Which of the following commands is used to modify existing data in a table?

UPDATE

A search condition begins with the keyword ____.

WHERE

The outer join operator can only be used in the ____________________ clause.

WHERE

When does a COMMIT command implicitly occur?

When the user issues a DDL command such as CREATE or ALTER TABLE.

Which of the following can lead to partial dependencies?\n\n1) composite primary key\n \n2) common fields\n \n3) foreign keys\n \n4) normalization

composite primary key

A(n) ____ simply identifies the type of data that Oracle11g will be expected to store in a column.\n \n1) data definition\n \n2) data format\n \n3) datatype\n \n4) data record

datatype

In an E-R Model a person, place, or thing with characteristics to be stored in the database are referred to as?\n \n1) entity\n \n2) row\n \n3) attribute\n \n4) file

entity

A table alias is assigned to a table in the WHERE clause.

false

Which of the following terms refers to a group of related records?\n \n1) database\n \n2) character\n \n3) field\n \n4) file

file

Which of the following may contain partial dependencies, but cannot contain repeating groups?\n \n1) unnormalized data\n \n2) first normal form (1NF)\n \n3) second normal form (2NF)\n \n4) third normal form (3NF)

first normal form

Which of the following usually correlates to a primary key in another table?\n \n1) transitive dependency\n \n2) composite primary key\n \n3) foreign key\n \n4) partial dependency

foreign key

Joins are classified as ____________________ joins if the results can only contain the rows that had matching values in each table, rather than rows being matched with NULL values.

inner

Which of the following declarations would be most appropriate for storing a dollar value up to (but not including) $1000?

price NUMBER(5,2)

A column ____________________ indicates the table containing the column being referenced.

qualifier

Data in first normal form (1NF) does not contain which of the following?

repeating groups

If you think that you may wish to rollback part of a transaction, but not the whole thing, it is a good idea to create a ____.

savepoint

Which of the following may contain transitive dependencies, but not partial dependencies?\n \n1) unnormalized data\n \n2) first normal form (1NF)\n \n3) second normal form (2NF)\n \n4) third normal form (3NF)

second normal form

When a format argument is included in a function, it must be enclosed in ____.

single quotation marks

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

surrogate key

In which step of the Systems Development Life Cycle (SDLC) are the logical and physical components defined?\n \n1) systems recovery\n \n2) systems analysis\n \n3) systems design\n \n4) systems implementation and review

systems design

Data in second normal form (2NF) may contain which of the following?\n \n1) repeating groups\n \n2) transitive dependencies\n \n3) partial dependencies\n \n4) both a and b

transitive dependencies

Which of the following symbols can be used to combine data from different columns into one column of output?\n\n \n1) \n||\n\n \n2) \n^\n\n \n3) \n%\n\n \n4) \n*

||

When modifying data in existing columns, which of the following is correct?

A column must be as wide as the data it already contains.

A PRIMARY KEY constraint can be added to an existing table by using the ____ clause of the ALTER TABLE command.\n \n1) MODIFY\n2) ADD\n \n3) CONSTRAINT\n \n4) none of the above

ADD

Which of the following is a valid SQL statement?\n \n1) CREATE TABLE newname (colA NUMBER, colB DATE);\n \n2) CREATE TABLE newname as SELECT * FROM books;\n \n3) CREATE TABLE newname (colA, colB);\n \n4) CREATE TABLE newname (colA DATE, colB VARCHAR2(3);

CREATE TABLE newname (colA NUMBER, colB DATE);

A column qualifier is separated from the column using which symbol?

(.) period

If the results of a SELECT statement include more than one column of data, the column names must be separated in the SELECT clause by which of the following symbols?\n\n \n1) \n,\n\n \n2) \n" "\n\n \n3) \n' '\n\n \n4) \n*

,

The column definition of NUMBER(7, 4) indicates a precision of ____.

7

The column definition of NUMBER(7, 4) indicates a precision of ____.\n \n1) 7\n \n2) 4\n \n3) 11\n \n4) 3

7

What is used to indicate the end of an SQL statement?\n\n \n1) \n/\n\n \n2) \n:\n\n \n3) \n;\n\n \n4) \n*

;

Which of the following keywords cannot be used to modify an existing table?\n \n1) ALTER TABLE...ADD\n \n2) ALTER TABLE...DROP COLUMN\n \n3) ALTER TABLE...MODIFY\nCorrect Answer 4) ALTER TABLE...AS

ALTER TABLE...AS

Which of the following keywords can be used to indicate that a column alias should be included in the results?\n\n \n1) \nAS\n\n \n2) \nFROM\n\n \n3) \nSELECT\n\n \n4) \nALIAS

AS

A DBMS includes which of the following capabilities?

All of the above

What will happen when the following query is executed: UPDATE student SET s_class='SR';

All records in the student table will be updated

Which command instructs Oracle11g to create a new table?\n \n1) CREATE NEW TABLE\n \n2) CREATE TABLE...FROM\n3) CREATE TABLE\n \n4) ALTER TABLE

CREATE TABEL

Which of the following is not a constraint type in Oracle11g?\n \n1) CHECK\n \n2) UNIQUE\n \n3) NOT NULL\n \n4) REFERENCE

REFERENCE

The ____________________ function fills the area to the right of a character string with a specific character.

RPD

Which of the following is an interface tool that allows a user to create, edit, and manipulate data in Oracle11g?\n \n1) SQL\n\n2) SQL*Plus\n \n3) ASCII\n \n4) Script

SQL*Plus

Which of the following statements about creating constraints is incorrect?\n \n1) If a constraint applies to more than one column, the constraint must be created at the table level.\n \n2) Using the column level approach, the definition of the constraint is included as part of the column definition.\n \n3) When you create constraints at the column level, the constraint being created applies to the column specified.\n \n4) The NOT NULL constraint can be created at either the column level or the table level.

The NOT NULL constraint can be created at either the column level or the table level.

A transaction is defined as the set of statements that are committed at one time.

True

Data that is being added to a table is specified in the VALUES clause of the INSERT command.

True

Every table name within a specific schema must be unique.

True

Group functions return one result per group of rows processed.

True

INITCAP can be used to convert character strings to mixed-case characters.

True

The ____________________ set operator is used to display the combined results returned by multiple SELECT statements.

UNION ALL

The purpose of the ____ constraint is to ensure that two records do not have the same value stored in the same column. However, it can contain NULL values.\n \n1) PRIMARY KEY\n2) UNIQUE\n \n3) CHECK\n \n4) FOREIGN KEY

UNIQUE

Partial dependency exists if what conditions exist?

a column is dependent only on a portion of a composite primary key

A field in the logical design of a database is represented by what in the physical database?\n\n1) column\n \n2) row\n \n3) field\n \n4) row

column

When a constraint is created at the ____ level with the CREATE TABLE command, the constraint definition is simply included as part of the column definition.\n \n1) table\n\n2) column\n \n3) database\n \n4) row

column

If more than one column is listed in the INSERT INTO clause, the column names must be separated by ____.

commas

Which of the following can be used to link the data in two or more tables together?

common field

A(n) ____ is used to indicate how data should relate to a given search condition.

comparison operator