(Answered) CIST 1220 Final Review: CIST 1220 SQL - Gwinnett Technical College.
CIST 1220 Final Review: CIST 1220 SQL - Gwinnett Technical College. - You can join tables by using a condition in the ____ clause. - To qualify a column name, precede the name of the column with the name of the table, followed by a(n) ____. - To retrieve data from multiple tables in a query you can use the ____ operator with a subquery. - You can precede a subquery with the ____ operator to create a condition that is true if one or more rows are obtained when the subquery is executed. - When a subquery involves a table listed in the outer query, the subquery is called a(n) ____ subquery. - A(n) ____ clause can include statistics calculated for only the groups or columns whose values are identical for each row in a group - You create an alias by typing the name of the table, pressing the ____, and then typing the name of the alias. - The ____ of two tables is a table containing every row that is in either the first table, the second table, or both tables - The ____ of two tables is a table containing all rows that are in both tables. - The ____ of two tables is the set of all rows that are in the first table but that are not in the second table. - Two tables are ____ compatible if they have the same number of columns and if their corresponding columns have identical data types and lengths - For an SQL implementation to truly support the union operation, it must remove ____ rows automatically. - Oracle and SQL Server support the ____ operator but Microsoft Access does not - If you precede the subquery by the ____ operator, the condition is true only if it satisfies all values produced by the subquery - If you precede the subquery by the ____ operator, the condition is true only if it satisfies any value (one or more) produced by the subquery. - Which of the following joins compares the tables in the FROM clause and lists only those rows that satisfy the condition in the WHERE clause? - In a(n) ____ join, all rows from both tables are included regardless of whether they match rows from the other table. - In a ____, all rows from the table on the left (the table listed first in the query) will be included regardless of whether they match rows from the table on the right (the table listed second in the query). - In a ____, all rows from the table on the right will be included regardless of whether they match rows from the table on the left - The product of two tables is formally called the ____ Product - Access does not support the ____ data type - You can use the ____ command to create a new table using data in an existing table - To change rows for which a specific condition is true, use the ____ command - To add data from an existing table to a new table, use a SELECT command in a(n) ____ command - If you have verified that the update you made is correct, you can use the ____ command to make the update permanent - If you have not run the COMMIT command, executing the ____ command will reverse all updates made during the current work session - In order to use the COMMIT command in Oracle, you need to clear the check mark from the ____ check box. - ____ is the default transaction mode in Oracle and commits each action query as soon as the user executes the query - Which of the following commands executes a rollback? ; - Which of the following is a valid SQL command? - The ____ command is permanent - A(n) ____ can be viewed as a sequence of steps that accomplishes a single task. - To delete data from the database, use the ____ command All rows will be deleted from the table. - What happens if you run a DELETE command that does not contain a WHERE clause? - If you specified ____ for a column when you created a table, then changing a value in a column to null is prohibited - In Oracle, use the ____ command to display the structure of a table. - You can use the ____ clause of the ALTER TABLE command to change a column that currently rejects null values so that it will accept null values - In SQL, use the ____ data type for variable-length character columns - You can use the ____ command to delete an entire table and its data - Which of the following is a valid SQL command? - The UPDATE command contains the word ____________________, followed by the name of the column to be updated, an equals sign, and the new value. - The ROLLBACK command reverses changes made to the ____________________ only. - To sort rows in a specific order, use the ____________________ clause with the desired sort key(s). - Before beginning the updates for a transaction, commit any previous updates by executing the ____________________ command. - To add a new column, use the ____________________ clause of the ALTER TABLE command. - In a business organization, a person or an entire group known as the ____ is charged with managing the database. - The CREATE VIEW command includes the words CREATE VIEW, followed by the name of the view, the word ____, and then a query - A(n) ____ is an application program's or an individual user's picture of the database - When renaming columns, you include the new column names in ____ following the name of the view - A view is updatable when it is derived from joining two base tables on the ____ of each table - The command to delete a view is ____ - The main mechanism for providing access to a database is the ____ command - The correct command to allow user Thompson to delete rows in the CUSTOMER table would be: GRANT ____ ON CUSTOMER TO THOMPSON. - When you specify a foreign key, the table referenced by the foreign key is the ____. - The privilege ____ can be granted to change data. - The privilege ____ can be granted to change the table structure - The database administrator uses the ____ command to revoke privileges from users - Which of the following commands deletes an index? - To ensure the uniqueness of values in a nonprimary key column, use the ____ command to create an index - The system catalog is also called the ____. - In Oracle, the ____ table contains information about the tables known to SQL. - The types of constraints supported in SQL are ____. - A view is defined by creating a defining ____________________, which indicates the rows and columns to include in the view. add primary key - To add a primary key after creating a table, you can use the ____________________ clause of the ALTER TABLE command. integrity constraint - "Item classes for parts must be AP, HW, or SG because these are the only valid item classes." is an example of an _________________. - In Oracle and SQL Server, the ____ function displays a value in uppercase letters - In Oracle and SQL Server, the ____ function displays a value in lowercase letters. - In Microsoft Access, the ____ function displays a value in lowercase letters. - In Microsoft Access, the ____ function displays a value in uppercase letters - In Oracle, SQL Server, and Microsoft Access, use the ____ function to round a numeric value to a desired number of decimal places - In Oracle and SQL Server, use the ____ function to truncate everything to the right of the decimal point - In Oracle, to add a specific number of months to a date, use the ____ function. - In SQL Server and Microsoft Access, to add a specific number of months to a date, use the ____ function - In Oracle, you can use the ____ function to obtain today's date. - In Microsoft Access, you can use the ____ function to obtain today's date - In SQL Server, you can use the ____ function to obtain today's date. - To remove extra spaces to the right of a value, for example, the value in a FIRST_NAME column, use the ____ function. - To create a stored procedure in Oracle, use the ____ command. - Variable names in PL/SQL must start with a letter and can contain letters, dollar signs, underscores, and number signs, but cannot exceed ____ characters - In PL/SQL, you can ensure that a variable has the same data type as a particular column by using the ____ attribute - A(n) ____ is a pointer to a row in the collection of rows retrieved by an SQL command - When you use a cursor in a procedure, the ____ command advances the cursor to the next row in the set of rows retrieved by the query and places the contents of the row in the indicated variables - To call a procedure in SQL Server, use the ____ command - In Microsoft Visual Basic, use the ____ statement to create a string variable - A(n) ____ is a procedure that is executed automatically in response to an associated database operation
Connected book
Written for
- Institution
-
Gwinnett Technical College
- Course
-
CIST 1220 SQL (CIST1220)
Document information
- Uploaded on
- October 18, 2022
- Number of pages
- 6
- Written in
- 2022/2023
- Type
- Exam (elaborations)
- Contains
- Questions & answers
Subjects
- cist 1220 final review
- cist 1220 final
- cist 1220 sql
- to qualify a column name
-
you can join tables by using a condition in the clause
-
precede the name of the column with the name of the table
-
f
