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
