Q&A Hero

Q: PL/SQL blocks have a section used to declare variables. a. True b. False

Q: In Oracle, you can use the SQL*Plus command SHOW ERRORS to help you diagnose errors found in PL/SQL blocks. a. True b. False

Q: Every PL/SQL block must be given a name. a. True b. False

Q: A persistent stored module is stored and executed on the database client machine. a. True b. False

Q: To remedy the lack of procedural functionality in SQL, and to provide some standardization within the many vendor offerings, the SQL-99 standard defined the use of persistent stored modules. a. True b. False

Q: SQL supports the conditional execution of procedures (IF-THEN-ELSE statements) that are typically supported by a programming language. a. True b. False

Q: A sequence is not associated with a table and can be dropped from a database with a DROP SEQUENCE command.a. Trueb. False

Q: UNION, INTERSECT, and MINUS work properly only if relations are intersect-compatible, which means that the names of the relation attributes and their data types must be different. a. True b. False

Q: An inequality condition is also known as a natural join and an equality condition is also called a theta join. a. True b. False

Q: The command would be used to delete the table row where the P_CODE is "BRT-345".a. DELETE FROM PRODUCT WHERE P_CODE = "BRT-345";b. REMOVE FROM PRODUCT WHERE P_CODE = "BRT-345";c. ERASE FROM PRODUCT WHERE P_CODE = "BRT-345";d. ROLLBACK FROM PRODUCT WHERE P_CODE = "BRT-345";

Q: Which of the following is used to select partial table contents? a. SELECT <column(s)> FROM <Table name> BY <Conditions>; b. LIST <column(s)> FROM <Table name> BY <Conditions>; c. SELECT <column(s)> FROM <Table name> WHERE <Conditions>; d. LIST<column(s)> FROM <Table name> WHERE <Conditions>;

Q: When a user issues the DELETE FROM tablename command without specifying a WHERE condition,_____________-- .a. no rows will be deletedb. the first row will be deletedc. the last row will be deletedd. all rows will be deleted

Q: To remove a row from the PRODUCT table, one must use the________ command.a. COMMITb. DELETEc. ERASEd. KILL

Q: Some RDBMSs, such as Oracle, automatically____________________ data changes when issuing data definition commands.a. COMMITb. ROLLBACKc. UNSAVEd. UPDATE

Q: The___________ command is used to restore the database to its previous condition.a. COMMIT; RESTORE;b. COMMIT; BACKUP;c. COMMIT; ROLLBACK;d. ROLLBACK;

Q: An example of a command a user would use when making changes to a PRODUCT table is________________ .a. CHANGE PRODUCTSET P_INDATE = "18-JAN-2004" WHERE P_CODE = "13-Q2/P2";b. ROLLBACK PRODUCTSET P_INDATE = "18-JAN-2004" WHERE P_CODE = "13-Q2/P2";c. EDIT PRODUCTSET P_INDATE = "18-JAN-2004" WHERE P_CODE = "13-Q2/P2";d. UPDATE PRODUCTSET P_INDATE = "18-JAN-2004" WHERE P_CODE = "13-Q2/P2";

Q: UPDATE tablename*****[WHERE conditionlist];The____________ command replaces the ***** in the syntax of the UPDATE command, shown above.a. SET columnname = expressionb. columnname = expressionc. expression = columnnamed. LET columnname = expression

Q: The SQL command that modifies an attribute"s values in one or more table's rows is _____.a. INSERTb. SELECTc. COMMITd. UPDATE

Q: In Oracle, the_________ command is used to change the display for a column, for example, to place a $ in front of a numeric value.a. DISPLAYb. FORMATc. CHARd. CONVERT

Q: To list all the contents of the PRODUCT table, a user would use___________ .a. LIST * FROM PRODUCTb. SELECT * FROM PRODUCTc. DISPLAY * FROM PRODUCTd. SELECT ALL FROM PRODUCT

Q: The SQL command that allows a user to list the contents of a table is____________ .a. INSERTb. SELECTc. COMMITd. UPDATE

Q: The SQL command that allows a user to permanently save data changes is______________ .a. INSERTb. SELECTc. COMMITd. UPDATE

Q: The SQL command that allows a user to insert rows into a table is______________ .a. INSERTb. SELECTc. COMMITd. UPDATE

Q: The data format for SQL character is____________ .a. CHAR and VARCHARb. VARCHAR onlyc. alphanumericd. CHAR only

Q: The current fully approved version of standard SQL prescribed by the ANSI is______________ .a. SQL-99b. SQL-2003c. SQL-4d. SQL-07

Q: When joining three or more tables, you need to specify a join condition for one pair of tables. a. True b. False

Q: An alias cannot be used when a table is required to be joined to itself in a recursive query. a. True b. False

Q: The COUNT function is designed to tally the number of non-null "values" of an attribute, and is often used in conjunction with the DISTINCT clause. a. True b. False

Q: Some RDBMSs, such as Microsoft Access, automatically make the necessary conversions to eliminate case sensitivity. a. True b. False

Q: Most SQL implementations yield case-insensitive searches. a. True b. False

Q: The conditional LIKE must be used in conjunction with wildcard characters. a. True b. False

Q: ANSI-standard SQL allows the use of special operators in conjunction with the WHERE clause. a. True b. False

Q: SQL allows the use of logical restrictions on its inquiries such as OR, AND, and NOT. a. True b. False

Q: Date procedures are often more software-specific than other SQL procedures. a. True b. False

Q: String comparisons are made from left to right. a. True b. False

Q: Mathematical operators cannot be used to place restrictions on character-based attributes. a. True b. False

Q: Oracle users can use the Access QBE (query by example) query generator. a. True b. False

Q: You can select partial table contents by naming the desired fields and by placing restrictions on the rows to be included in the output. a. True b. False

Q: Although SQL commands can be grouped together on a single line, complex command sequences are best shown on separate lines, with space between the SQL command and the command's components. a. True b. False

Q: All SQL commands must be issued on a single line. a. True b. False

Q: If you have not yet used the COMMIT command to store the changes permanently in the database, you can restore the database to its previous condition with the ROLLBACK command.a. Trueb. False

Q: The COMMIT command does not permanently save all changes. In order to do that, you must use SAVE. a. True b. False

Q: Any changes made to the contents of a table are not physically saved on disk until you use the SAVE <table name> command.a. Trueb. False

Q: To list the contents of a table, you must use the DISPLAY command.a. Trueb. False

Q: You cannot insert a row containing a null attribute value using SQL. a. True b. False

Q: SQL requires the use of the ADD command to enter data into a table. a. True b. False

Q: The CHECK constraint is used to define a condition for the values that the attribute domain cannot have. a. True b. False

Q: Entity integrity is enforced automatically when the primary key is specified in the CREATE TABLE command sequence. a. True b. False

Q: Only numeric data types can be added and subtracted in SQL. a. True b. False

Q: Data type selection is usually dictated by the nature of the data and by the intended use. a. True b. False

Q: SQL is considered difficult to learn; its command set has a vocabulary of more than 300 words. a. True b. False

Q: The ANSI SQL standards are also accepted by the ISO. a. True b. False

Q: The ANSI prescribes a standard SQL"the current fully approved version is known as SQL07. a. True b. False

Q: A database language enables the user to perform complex queries designed to transform the raw data into useful information.a. Trueb. False

Q: A database language enables the user to create database and table structures to perform basic data management chores.a. Trueb. False

Q: Explain the two SQL functions.

Q: How can a table be deleted from the database? Provide an example.

Q: What are the wildcard characters that are used with the LIKE command? Provide one or more examples of each.

Q: What is a subquery? When is it used? Does the RDBMS deal with subqueries any differently from normal queries?

Q: Which command is used to save changes to the database? What is the syntax for this command?

Q: What is a schema? How many schemas can be used in one database?

Q: The_________ condition is generally composed of an equality comparison between the foreign key and the primary key of related tables.

Q: To make the output more readable, the SQL standard permits the use of aliases for any column in a______________ statement.

Q: The _____________specification is used to avoid having duplicated values in a column.

Q: The SQL data type DATE stores date in the____________ date format.

Q: ________________is the process the DBMS uses to verify that only registered users access the database.

Q: An alias is especially useful when a table must be joined to itself in a(n)_____________ query.

Q: A(n)___________ is performed when data are retrieved from more than one table at a time.

Q: The___________- clause of the GROUP BY statement operates very much like the WHERE clause in the SELECT statement.

Q: Rows can be grouped into smaller collections quickly and easily using the__________- clause within the SELECT statement.

Q: A(n)___________order sequence is a multilevel ordered sequence that can be created easily by listing several attributes, separated by commas, after the ORDER BY clause.

Q: A table can be deleted from the database by using the__________ command.

Q: If a user adds a new column to a table that already has rows, the existing rows will default to a value of_____________ for the new column.

Q: A specialty field in mathematics, known as _________algebra, is dedicated to the use of logical operators.

Q: In SQL, all_____________ expressions evaluate to true or false.

Q: The command, coupled with appropriate search conditions, is an incredibly powerful tool that enables a user to transform data into information.

Q: A(n)___________ , also known as a nested query or an inner query, is a query that is embedded (or nested) inside another query.

Q: A(n)__________ character is a symbol that can be used as a general substitute for other characters or commands.

Q: In an INSERT command, a user can indicate just the attributes that have required values by listing the_______ inside parentheses after the table name.

Q: To delete an index, one must use the______________ command.