University:
Eastern Kentucky University
Course:
CSC 310 | Data Structures
Academic year:

2020
Views:

262

Pages:

4
Author:

levedzgetmo7f

Databases 2020 / Question 1 The _____ constraint assigns a value to an attribute when a new row is added to a table. Select one: a. UNIQUE b. DEFAULT c. CASCADE d. NOT NULL Question 2 A table can be deleted from the database by using the _____ TABLE command. Select one: a. ERASE b. DELETE c. MODIFY d. DROP Question 3 In Oracle, _____ retrieves the current value of a sequence. Select one: a. NEXTVAL b. VARCHAR c. CURRVAL d. VARCHAR2 Question 4 You cannot have an invalid entry in the foreign key column; at the same time, you cannot delete a vendor row as long as a product row references that vendor. This is known as _____. Select one: a. referential integrity b. batch updating c. cross joining d. authentication Question 5 If we are going to create a database based on the above diagram, how many primary key constraints do we need to create? Select one: a. 6 b. 2 c. 4 d. 3 Question 6 The _____ command permanently saves all changes-such as rows added, attributes modified, and rows deleted-made to any table in the database. Select one: a. COMMIT b. SELECT c. ROLLBACK d. UPDATE Question 7 The _____ constraint is used to validate data when an attribute value is entered. Select one: a. CHECK b. SET NULL c. CASCADE d. UNIQUE Question 8 The SQL data type DATE stores date in the _____ date format. Select one: a. Julian b. Gregorian c. Babylonian d. Lunar Question 9 If we are going to create a database based on the above diagram, how many foreign key constraints do we need to create? Select one: a. 3 b. 2 c. 4 d. 6 Question 10 When writing SQL table-creating command sequences, the entire table definition is enclosed in _____. Select one: a. quotations b. commas c. parentheses d. asterisks Question 11 Words used by a system that cannot be used for any other purpose are called _____ words. For example, in Oracle SQL, the word INITIAL cannot be used to name tables or columns. Select one: a. unique b. character c. reserved d. null Question 12 The _____ specification creates an individual index on a respective attribute; use it to avoid having duplicated values in a column. Select one: a. VARCHAR b. UNIQUE c. NOT NULL d. UPDATE Question 13 All changes in a table structure are made using the _____ TABLE command, followed by a keyword that produces the specific changes a user wants to make. Select one: a. COMMIT b. ALTER c. ROLLBACK d. UPDATE Question 14 Which of the entities on the above diagram will be implemented as a table with a composite primary key? Select one: a. UNIT and STUDENT b. UNIT c. STUDENT d. ENROLMENT Question 15 SQL requires the use of the _____command to enter data into a table. Select one: a. INSERT b. NOT NULL c. COMMIT d. SELECT ◄ Jump to...

Data Structures: Database Quiz Questions

Related Documents

Recommended Documents

Description

Related Documents

Want to Download This Document?

Free up your schedule!

Take 5 seconds to unlock