Database Application Final

What is a database?

A. A database is a structure that contains different categories of information and the relationships between these categories.
B. A database is a structure that contains different information of categories.
C. A database is a structure that contains informations about relationships.
D. A database is a structure that contains information about categories and the relationships between these categories.

Which of the following is a valid KIMTAY database?

A. An ITEM is sold to only one customer in an invoice.
B. An INVOICE CONTAINS many customers.
C. A CUSTOMER may have many relationships.
D. A sales representative represents only one customers.

Which table in the KIMTAY database is ITEM ID found?

A. ITEM and INVOICES tables
B. ITEM and INVOICE_LINE tables
C. ITEM table
D. INVOICES table

What information is contained in the CUSTOMER table in the KIMTAY database?

A. Customer name, customer representative, and items ordered by customer
B. Customer name, contact information, and items ordered
C. Customer name and contact information
D. Customer name, contact information, and customer representative

Which of the following is a table in the STAYWELL database?

A. PROPERTY_ID
B. OWNER
C. FIREST_NUM
D. OWNER_NUM

Which of the following is not a table in the STAYWELL database?

A. ADDRESS
B. RESIDENT
C. PROPERTY
D. OWNER

Which of the following is a unique identifier?

A. OWNER
B. OWNER_ID 
C. OWNER_NAME
D. FIRST_NAME and LAST_NAME

Which of the following is not table in the KIMTAY database?

A. REPRESENTATIVE
B. INVOICES
C. ITEM
D. CUSTOMER

Which of the following statements is true?

A. A relational database is a collection of related attributes
B. A relational database is a collection of rows
C. A relational database is a collection of entities
D. All of the above
E. None of the above

Which of the following statements about functional dependencies is true?

A. Column B is functionally dependent on another column when a value for B depends a single value for A at any one time.
B. Column B is functionally dependent on another column when a value for B determines a single value for A at any one time.
C. Column B is functionally dependent on another column when a value for A determines a single value for B at any one time.
D. Column B is functionally dependent on another column when a value for B is part of A.

A primary key is _______.

A. an identifier of columns in a relational table
B. a unique identifier of a table 
C. a unique identifier of a column
D. a column that identifies other columns in a table

When is a table is in first normal form (1NF)?

A. When a table does not contain repeating group
B. When a column is not part of unique identifier
C. When a column is not part of a repeating group
D. When a table contains a unique identifier

Which of the following is not an entity?

A. An event
B. A person
C. A thing
D. An idea

When is a relation in second normal form (2NF)?

A. It is in first normal form and key column is dependent on only a portion of the primary key.
B. It is in first normal form and nonkey column is dependent on only a portion of the primary key.
C. It is in first normal form and no key column is dependent on only a portion of the primary key.
D. It is in first normal form and nonkey column is dependent on only a portion of the primary key.

Which of the following is not a step of database design?

A. Identify the entities involved
B. Identify the unique identifiers for the entities
C. Identify the attributes for all the entities
D. Identify the functional dependences that exist among the attributes
E. All of the above
F. None of the above

Data anomalies are classified into which of the following four categories?

A. Updates, additions, deletions, and inconsistent data
B. Updates, additions, deletions, and unnormalized data
C. Updates, additions, deletions, and consistent data
D. Updates, additions, deletions, and concurrent data

What is an attribute?

A. An attribute is another name for entity
B. An attribute is a property of an entity
C. An attribute is another name for relationship
D. An attribute is a property of a relationship

What is a relationship?

A. A relationship is an association between two relations
B. A relationship is an association between entity and attribute
C. A relationship is an association between two entities
D. A relationship is an association between two attributes

Which of the following removes a table from a database?

A. DELETE
B. REMOVE
C. DROP
D. ERASE
E. All of the above
F. None of the above

Which of the following commands list existing databases in Oracle?

A. LIST DATABASES
B. SHOW DATABASES
C. DISPLAY DATABASES
D. All of the above
E. None of the above

Which command is used to list all columns in MS SQL Server?

A. DESCRIBE
B. SELECT
C. SHOW
D. LIST
E. All of the above
F. None of the above

Which of the following does NOT NULL indicate?

A. Column must have a value including zero
B. Column must not be void
C. Column must have a value including blank
D. Column must have a value including void value

Which command is used to work within a specific database in Oracle?

A. SELECT DATABASE
B. USE DATABASE
C. DEFAULT DATABASE
D. All of the above
E. None of the above

Which of the following SQL statements is valid?

A. SELECT all FROM sales_rep;
B. SELECT * FROM SALES_REP
C. SELECT all FROM SALES_REP
D. SELECT * FROM sales_rep;
E. All of the above
F. None of the above

Which of the following is not valid SQL command?

A. UPDATE
B. SHOW
C. SELECT
D. INSERT
E. All of the above
F. None of the above

Which of the following SQL statements is valid?

A. DROP TABLE SALES_REP;
B. INSERT INTO SALES_REP VALUES('25, 'Donna', 'Sanchez');
C. UPDATE SALES_REP LAST_NAME = 'Austin';
D. DELETE SALES_REP;

Which of the following SQL statements is valid for MySQl, Oracle, and MS SQL Server?

A. CREATE TABLE sales_rep (id NUMBER(2), name CHAR (30));
B. CREATE TABLE sales_rep (id CHAR(2), name VARCHAR(30));
C. CREATE TABLE sales_rep (id NUMBER, name VARCHAR2(30));
D. CREATE TABLE sales_rep (id CHAR(2), name CHAR(30));
E. All of the above
F. None of the above

Which of the following commands list columns of a table in MS SQL?

A. DESCRIBE
B. DESC
C. EXEC SP_TABLE
D. EXEC SP_COLUMNS
E. All of the above
F. None of the above

Which of the following comparison operators is NOT EQUAL?

A. NOT
B. ^=
C. !=
D. <>
E. All of the above
F. None of the above

Which of the following is not a valid compound operator?

A. AND
B. OR 
C. NOT
D. BETWEEN
E. All of the above
F. None of the above

Which of the following statements will display rows for a commission greater than 100 and less than 2000?

A. An identifier of columns in a relational table
B. A column that identifies other columns in a table
C. SELECT col1, col2, coln FROM table_name WHERE commission BETWEEN 100 AND 20001;
D. SELECT col1, col2, coln FROM table_name WHERE commission > 100 AND commission < 2000;
E. SELECT col1, col2, coln FROM table_name WHERE commission BETWEEN 100 and 2000;
F. SELECT col1, col2, coln FROM table_name WHERE commission >= 100 AND commission <= 2000

Which of the following is a valid statement?

A. WHERE clause to limit the rows and HAVING clause to limit the groups
B. WHERE clause to limit the groups and HAVING clause to the limit the columns
C. WHERE clause to limit the rows and HAVING clause to limit the columns
D. WHERE clause to limit the groups and HAVING clause to limit the groups

Which of the following is not an aggregate function?

A. COUNT 
B. AVG
C. SUM
D. MED
E. All of the above
F. None of the above

Which of the following is a valid SQL statement?

A. SELECT col1, col2 FROM table_name WHERE col1 = value GROUP BY col2, ORDER BY col1;
B. SELECT col1, col2 FROM table_name WHERE col1 = value GROUP BY col1;
C. SELECT col1, col2 FROM table_name WHERE col1 = value ORDER BY col1;
D. SELECT col1, col2 WHERE col1 = value FROM table_name ORDER BY col1;

Which of the following SQL statements will display REP_ID column values in a sorted manner?

A. SELECT rep_id FROM SALES_REP ORDERED ASC;
B. SELECT rep_id FROM SALES_REP SORTED BY rep_id DESC;
C. SELECT rep_id FROM SALES_REP SORTED ASC;
D. SELECT rep_id FROM SALES_REP ORDER BY rep_id DESC;
E. All of the above
F. None of the above

Which of the following statements will list a specific record in a table?

A. SELECT col1, col2 FROM table_name col1 = value;
B. SELECT col1, col2 FROM table_name WHERE col1 = value;
C. SELECT col1, col2, table_name WHERE col1 = value;
D. SELECT col1, col2 FROM table_name WHERE col1 value;
E. All of the above
F. None of the above

Which query will return rows for a column that has no value?

A. SELECT col1, col2 FROM table_name where co1 = "";
B. SELECT col1, col2 FROM table_name WHERE col1 IS NULL;
C. SELECT col1, col2 FROM table_name WHERE col1 IS NOT NULL;
D. SELECT col1, col2 FROM table_name WHERE col1 IS NULL;

Which of the following is true of a subquery?

A. It is referred to as a query within a query
B. It is evaluated first
C. It is referred to as the inner query
D. Its results are used by the outer query
E. All of the above
F. None of the above

What are the steps to join two tables?

A. List columns to be displayed, list of tables containing displayed columns, restrict rows from the two tables that have common values.
B. List columns to be displayed, list of tables containing displayed columns, restrict rows from the two tables that have common values in matching columns.
C. List columns to be displayed, list of tables containing displayed columns, restrict columns from the two tables that have common values.
D. List columns to be displayed, list of tables containing displayed columns, restrict columns from the two tables that have common values in matching rows.
E. All of the above
F. None of the above

What is an EXISTS operator?

A. An operator that to retrieve data from a specific table
B. An operator that checks the existence of rows that satisfies some criterion
C. An operator that checks the existence of rows in another table
D. An operator that to retrieve data from another table
E. All of the above
F. None of the above

Which of the following would you use to produce a combination of all rows from two tables?

A. FULL OUTER JOIN
B. PRODUCT
C. FULL INNER JOIN
D. FULL JOIN

What is an alias?

A. an alternate name for a column in the FROM clause
B. an alternate name of a column in the database
C. an alternate name for a table in the FROM clause
D. an alternate name of a table in the database

Which of the following statements is true?

A. Right outer join, all rows from the table on the left are not included regardless of whether they match rows from the table on the right.
B. Right outer join, all rows from the table on the right are included regardless of whether they match rows from the table on the left.
C. Left outer join, all rows from the table on the left are not included regardless of whether they match rows from the table on the right.
D. Left outer join, all rows from the table on the right are included regardless of whether they match rows from the table on the left.

Which two conditions must be met in order to use UNION operators?

A. The two tables must have the table types and same number of columns.
B. The two tables must have the table types and same column names.
C. The two tables must have the column datatypes and same number of columns.
D. The two tables must have the column names and same number of columns.

Which of the following statements is valid? 

A. ALL operator: the condition is true only if it satisfies all values: ANY operator: the condition is true if it satisfies any value.
B. ALL operator: the condition is true only if it satisfies all values.
C. ALL operator: the condition is true if it satisfies more than one value.
D. ALL operator: the condition is true only if it satisfies any value. ANY operator: the condition is true if it satisfies all value.
E. All of the above
F. None of the above

Which of the following is not a SET operator in MySQL Server?

A. UNION
B. INTERSECT
C. MINUS
D. EXCEPT
E. All of the above
F. None of the above

Which of the following is not true about joining a table to itself?

A.   Known as SELF-JOIN
B. Must use columns aliases
C. Must join the same table using primary key
D. Known as INNER-JOIN
E. All of the above
F. None of the above

Which of the following is not a valid JOIN command?

A. INNER JOIN
B. OUTER JOIN
C. FULL INNER JOIN
D. FULL OUTER JOIN
E. All of the above
F. None of the above

Which of the following is not a valid INSERT statement?

A. INSERT INTO table_name VALUES (val1, val2);
B. INSERT INTO table_name (column1, column2) VALUES (val1, val2);
C. INSERT INTO table_name1 SELECT col1, col2 FROM table_name2;
D. INSERT INTO table_name1 VALUES (SELECT col1, col2 FROM table_name1);
E. All of the above
F. None of the above

How do you reverse a transaction?

A. Use UNDO feature
B. Use ROLLBACK
C. Set AUTOCOMMIT OFF
D. Set SAVE OFF
E. All of the above
F. None of the above

Which of the following is not a valid command related to transactions?

A. ROLLBACK
B. COMMIT
C. SAVE 
D. All of the above
E. None of the above

How do you add a column to an existing table in MySQL?

A. MODIFY TABLE table_name ADD COLUMN new_column CHAR(3);
B. MODIFY TABLE table_name ADD new_column CHAR(3);
C. ALTER TABLE table_name ADD COLUMN new_column CHAR(3);
D. ALTER TABLE table_name ADD new_column CHAR(3);

How do you change a column to an existing table in MS SQL Server?

A. ALTER TABLE table_name ALTER COLUMN column_name CHAR(3);
B. ALTER TABLE table_name ALTER COLUMN column_name CHAR(3);
C. MODIFY TABLE table_name MODIFY COLUMN new_column CHAR(3);
D. MODIFY TABLE table_name ALTER column_name CHAR(3);

Which of the following SQL statements is valid?

A. INSERT INTO table_name (val1, val2);
B. ALTER COUMN column_name SET PRIMARY KEY;
C. INSERT INTO table_name1 SELECT col1, col2 FROM table_name2;
D. ALTER TABLE table_name SET col1 PRIMARY KEY;
E. All of the above
F. None of the above

Which of the following statements is valid?

A. DROP table_name;
B. DELETE TABLE table_name;
C. UPDATE TABLE table_name SET col1 = new_value;
D. ALTER TABLE table_name MODIFY col1 CHAR(10);
E. All of the above
F. None of the above

Which of the following statements defines a TRANSACTION?

A. A transaction is a physical unit of work.
B. A transaction is a sequence of steps that accomplish a single task.
C. A transaction is a physical sequence of steps to accomplish a task.
D. A transaction is logical units of work.
E. All of the above
F. None of the above

Which clause is used to change a column in a table?

A. MODIFY
B. ALTER
C. UPDATE
D. SET

Which of the following SQL vendors does not include AUTOCOMMIT?

A. MySQL
B. Oracle
C. MS SQL Server
D. All of the above
E. None of the above

Which of the following statements is not true about a view?

A. A view is an individual user's picture of the database.
B. A view is a derived table from one or more base tables.
C. A view provides a great simplification of table administration.
D. A view provides a measure of security.
E. All of the above
F. None of the above

Which of the following vendors will display an error when using an ORDER BY clause in a CREATE VIEW statement?

A. MySQL and Oracle
B. MySQL and MS SQL Server
C. Oracle and MS SQL Server
D. All of the above
E. None of the above

Which of the following is not true about updatable views?

A. A view is updatable when the base table(s) contain the primary keys.
B. A view is not updatable when it contains computed column.
C. A view is updatable when the base table(s) contain the foreign keys.
D. A view is updatable regardless of the underlying query.
E. All of the above
F. None of the above

Which of the following SQL commands removes a view from the database?

A. DELETE VIEW
B. REMOVE VIEW
C. DROP VIEW
D. ERASE VIEW

Which of the following SQL statements is false?

A. GRANT SELECT ON SALES_REP TO JOHNSON;
B. GRANT VIEW ON SALES_REP TO JOHNSON;
C. GRANT DELETE ON SALES_REP TO JOHNSON;
D. GRANT UPDATE ON SALES_REP TO JOHNSON;
E. All of the above
F. None of the above

Which of the following statements is true?

A. In a large database, indexes are essential to decrease the time required to retrieve records
B. DBMS must update he index whenever corresponding data in the database is updated.
C. Indexes consume large amount of space that outweighs its benefits.
D. In a small database, however, indexes might not provide any significant benefits.
E. All of the above
F. None of the above

Information kept about tables is usually known as _________.

A. table dictionary
B. data dictionary
C. schema dictionary
D. system dictionary

Which of the following SQL statements is valid?

A. ALTER TABLE INVOICES ADD FOREIGN KEY (CUST_ID) CUSTOMER (CUST_ID);
B. ALTER TABLE INVOICES FOREIGN KEY (CUST_ID) REFERENCES CUSTOMER (CUST_ID);
C. ALTER TABLE INVOICES ADD (CUST_ID) REFERENCES CUSTOMER (CUST_ID);
D. ALTER TABLE INVOICES ADD FOREIGN KEY (CUST_ID) REFERENCES CUSTOMER (CUST_ID);
E. All of the above
F. None of the above

Which of the following SQL clauses is used to enforce data  integrity?

A. NOT NULLABLE
B. CHECK
C. UNIQUENESS
D. WHERE

Which of the following SQL statements is correct?

A. CREATE NODUPLICATE INDEX SSN ON SALES_REP (SOC_SEC_NUM);
B. CREATE UNIQUE INDEX SSN ON SALES_REP (SOC_SEC_NUM);
C. CREATE DISTINCT INDEX SSN ON SALES_REP (SOC_SEC_NUM);
D. CREATE DUPLICATE INDEX SSN ON SALES_REP (SOC_SEC_NUM);

Which SQL vendor supports an UPPER function to display values in uppercase?

A. mySQL
B. Oracle
C. MS SQL Server
D. All of the above
E. None of the above

Which of the following functions do you use to get a current data and time in Oracle?

A. CURDATE
B. SYSDATE
C. GETDATE
D. DATETIME
E. All of the above
F. None of the above

Which SQL vendor has a CONCAT function that takes only two strings as arguments?

A. MySQL
B. Oracle
C. MS SQL Server
D. All of the above
E. None of the above

Which of the following statements best defines stored procedure?

A. Stored procedure is an SQL script stored on a server and can be executed automatically.
B. Stored procedure is an SQL script stored locally in a computer can be executed when needed.
C. Stored procedure is an SQL script stored in the database and can be executed automatically.
D. Stored procedure is an SQL script stored in the database and can be executed when needed.

What construct is used to handle conditions that can arise when accessing the database in MySQL?

A. EXIT HANDLER
B. ERROR HANDLER
C. EXCEPTION HANDLER
D. NOTFOUND HANDLER
E. All of the above
F. None of the above

What is a cursor?

A. A cursor is a pointer to a column in the collection of rows retrieved by an SQL command.
B. A cursor is a pointer to a column in the collection of columns retrieved by an SQL command.
C. A cursor is a pointer to a row in the collection of rows retrieved by an SQL command.
D. A cursor is a pointer to a row in the collection of columns retrieved by an SQL command.
E. All of the above
F. None of the above

What are the steps to use a cursor in a procedure?

A. DECLARE, OPEN, SELECT, CLOSE
B. DECLARE, OPEN, FETCH, CLOSE
C. OPEN, SELECT, CLOSE
D. OPEN, FETCH, CLOSE
E. All of the above
F. None of the above

How do you run a stored procedure in MS SQL Server?

A. RUN procedure_name
B. EXEC procedure_name
C. CALL procedure_name
D. procedure_name
E. All of the above
F. None of the above

Which of the following statements in true?

A. A trigger is a procedure that is executed in response to an INSERT and UPDATE command.
B. A trigger is a procedure that is executed in response to an associated database operation, such as an INSERT, UPDATE, OR DELETE command.
C. A trigger is a procedure that is executed automatically in response to an INSERT, UPDATE, or DELETE command.
D. A trigger is a procedure that is executed automatically in response to an associated database operation.

Which of the following commands is required in MySQL to create a stored procedure?

A. PROCEDURE
B. DELIMITER
C. CURSOR
D. BEGIN and END