Help
Options
Didn't know it?
click below
click below
Knew it?
click below
click below
Don't Know
Remaining cards (0)
Know
retry
shuffle
restart
0:00
Embed Code - If you would like this activity on your web page, copy the script below and paste it into your web page.
Normal Size Small Size show me how
Normal Size Small Size show me how
Info Man
Certification Exam
| Question | Answer |
|---|---|
| The terms "bitmap," "b-tree," and "hash" refer to which type of database structure? A. View B. Function C. Index D. Stored procedure E. Trigger | C - Index |
| One reason to add an index is to: A. Decrease storage space. B. Increase database security. C. Improve performance of select statements. D. Improve performance of insert statements | C - Improve performance of select statements. |
| Which key uniquely identifies a row in a table? A. foreiqn B. primary C. local D. superkey | B - Primary |
| Which command should you use to give a user permission to read the data in a table? A. ALLOW SELECT B. LET READ C. PERMIT READ D. GRANT SELECT | D - Grant Select |
| You need to enable a new employee to authenticate to your database. Which command should you use? A. ALLOW USER B. CREATE USER C. ADD USER D. INSERT USER E. ALTER USER | B - Create User |
| Which keyword can be used in a create table statement? A. ORDER BY B. DISTINCT C. GROUP BY D. UNIQUE | D - Unique |
| You need to store product quantities, and you want to minimize the amount of storage space that is used. Which data type should you use? A. INTEGER B. DOUBLE C. COUNT D. FLOAT | A - Integer |
| You need to store product names that vary from three to 30 characters. You also need to minimize the amount of storage space that is used. Which data type should you use? A. VARCHAR (3, 30) B. CHAR (3, 30) C. VARCHAR (30) D. CHAR (30) | C - VARCHAR (30) |
| One reason to create a stored procedure is to: A. Improve performance. B. Minimize storage space. C. Bypass case sensitivity requirements. D. Give the user control of the query logic. | A - Improve performance |
| Which permission does a user need in order to run a stored procedure? A. EXECUTE B. ALLOW C. CALL D. RUN | A - Execute |
| In SQL, an insert statement is used to add a: A. User to a database. B. Row of data to a table. C. Table to a database. D. Column to a table definition | B - Row of Data to a table |
| You have two tables. Each table has three rows. How many rows will be included in the Cartesian product of these two tables? A. 0 B. 3 C. 6 D. 9 | D - 9 |
| You are writing an SQL statement to retrieve rows from a table. Which data manipulation language (DML) command should you use? A. READ B. SELECT C. OUTPUT D. GET | B - Select |
| Which constraint ensures a unique value in the ID column for each customer? A. DISTINCT B. FOREIGN KEY C. SEQUENTIAL D. PRIMARY KEY | D - Primary Key |
| The component that holds information for a single entry in a table is called a: A. Data type B. Row C. Column D. View | B - Row |
| You execute the following statement: SELECT EmployeeID, FirstName, DepartmentName FROM Employee, Department This type of operation is called a/an: A. Intersection B. Outer join C. Equi-join D. Cartesian product | D - Cartesian product |
| Which command should you use to add a column to an existing table? A. MODIFY B. ALTER C. UPDATE D. INSERT E. CHANGE | B - Alter |
| You are writing a select statement to find every product whose name contains a specific character. Which keyword should you use in your where clause? A. FIND B. BETWEEN C. INCLUDES D. LIKE | D - Like |
| You have a table that contains information about all students in your school. Which SQL keyword should you use to change a student's first name in the table? A. UPDATE B. CHANGE C. SELECT D. INSERT | A - Update |
| Which keyword would you use in a select statement to return rows that meet a specific condition? A. WHERE B. UNION C. ORDER BY D. FROM | A - Where |
| Which command should you use to remove a table from a database? A. REMOVE TABLE B. UPDATE TABLE C. DROP TABLE D. DELETE TABLE | C - Drop Table |
| You need to store the contact information for each student in your school database. You should store each student's information in a: A. Stored procedure B. Function C. Row D. Variable | C - Row |
| Which category of SQL statements is used to add, remove, and modify database structures? A. Data access language (DAL) B. Data manipulation language (DML) C. Data control language (DCL) D. Data definition language (DDL) | D - Data definition language (DDL) |
| Data in a database is stored in: A. Tables B. Queries C. Data types D. Stored procedures | A - Tables |
| You need to establish a set of permissions that you can routinely assign to new users. What should you create? A. Resource B. Group C. List D. Role | D - Role |
| Which database term is used to describe the process of applying a backup to a damaged or corrupt database? A. Recover B. Restore C. Commit D. Attach | B - Restore |
| Denormalization is performed in order to: A. Reduce redundancy. B. Eliminate repeating groups. C. Create smaller tables. D. Improve query performance. | D. Improve query performance. |
| Which two keys establish a relationship between two tables? (Choose two.) A. candidate B. foreign C. superkey D. local E. primary | B - Foreign E - Primary |
| One difference between a function and a stored procedure is that a function: A. Must be called from a trigger. B. Must return a value. C. Cannot contain a transaction. D. Cannot accept parameters. | B -Must return a value. |
| Which keyword must be included in a create view statement? A. WHERE B. ORDER BY C. UPDATE D. SELECT | D - SELECT |
| You need to remove a view named EmployeeView from your database. Which statement should you use? A. DELETE VIEW EmployeeView B. DELETE EmployeeView C. DROP EmployeeView D. DROP VIEW EmployeeView | D - DROP VIEW EmployeeView |
| A named group of SQL statements that can be executed in a database is called a: A. Subroutine B. Formula C. Stored procedure D. Method | C - Stored procedure |
| A view can be used to: A. Save an extra copy of data stored in a separate table. B. Limit access to specific rows or columns of data in a table. C. Ensure referential integrity. D. Save historical data before deleting it from the base table. | B - Limit access to specific rows or columns of data in a table. |
| On which database structure does an update statement operate? A. Table B. User C. Trigger D. Role | A - Table |
| You delete rows in a table named Order. The corresponding rows in the OrderItem table are automatically deleted. This process is an example of a/an: A. Inherited delete B. Cascade delete C. Functional delete D. Waterfall delete E. Domino delete | B - Cascade delete |
| You have a table named Employee that includes four columns. You execute the following statement: SELECT * FROM Employee Which columns are returned? A. all columns B. only the last column C. only the first column D. only the first and last columns | A - all columns |
| Which two elements are required to define a column? (Choose two.) A. A name B. A key C. An index D. A data type | A - A name D - A data type |
| What defines the amount of storage space that is allocated to a value in a column? A. format B. key C. data type D. validator | C - Data type |
| You are creating a table to store customer data. The AccountNumber column uses values that always consist of one letter and four digits. Which data type should you use for the AccountNumber column? A. CHAR B. BYTE C. DOUBLE D. SMALLINT | A - CHAR |
| What is one difference between an update statement and a delete statement? An update statement can change only one row A delete statement cannot use a where clause An update statement does not remove rows from a table | An update statement does not remove rows from a table. |
| You need to store the first name, last name, and student ID for 100 students. This information will be stored in a table as: A. 100 items and three cells. B. 100 rows and three columns. C. three rows and 100 columns. D. three items and 100 cells. | B - 100 rows and three columns. |
| What are three valid data manipulation language (DML) commands? (Choose three.) A. INSERT B. COMMIT C. DELETE D. OUTPUT E. UPDATE | A. INSERT C. DELETE E. UPDATE |
| You assign User1 a set of permissions that include the WITH GRANT OPTION. The WITH GRANT OPTION enables User1 to: A request a log of permission use. B delegate permissions to other users. C create new database users. D view other users' permissions. | C - create new database users. |
| Which type of index changes the order in which the data is stored in a table? A. non-sequential B. sequential C. non-clustered D. clustered | A - non-sequential |
| Which statement should you use to remove a foreign key? A. ALTER TABLE B. DELETE TABLE C. DELETE FOREIGN KEY D. ALTER FOREIGN KEY | A - ALTER TABLE |
| First normal form requires that a database excludes: A. Foreign keys B. Composite keys C. Duplicate rows D. Repeating groups | D - Repeating groups |
| On which database structure does an insert statement operate? A. Role B. Trigger C. User D. Stored procedure E. Table | E - Table |
| You need to rename a column in a database table. Which data definition language (DDL) statement should you use? A. ALTER B. INSERT C. CREATE D. UPDATE | A - Alter |
| You need to add rows to a database table. Which Structured Query Language (SQL) keyword should you use? A. JOIN B. INSERT C. CREATE D. UPDATE | A - JOIN |
| You need to retrieve data from two related database tables based on a column that exists in both tables. Which command should you use in a query? A. INTERSECT B. UNION C. JOIN D. TRUNCATE | B - UNION |
| You need to delete a database table. Which data definition language (DDL) keyword should you use? A. ALTER B. DELETE C. DROP D. TRUNCATE | C - DROP |
| You develop a database to store data about textbooks. The data must be stored to process at a later time. Which database object should you use to store the data? A. View B. Table C. Function D. Stored procedure | D - Stored procedure |
| You need to create a view to filter rows of data from an underling table. Which type of clause must be included in the CREATE VIEW statement? A. CONSTRAINT B. WHERE C. JOIN D. FILTER | B - WHERE |
| You have a database that contains 10 terabytes of data. You need to back up the database every two hours. Which type of backup should you use? A. archive B. incremental C. partial D. full | C - partial |
| In which situation do you need to perform a restore on a database? when data becomes corrupted in the database when you need to roll back a transaction when you encounter an error in your application when data needs to be deleted from the database | A - when data becomes corrupted in the database |
Created by:
Kaiyce