chevron_left
0 points
15 11 8

Q. ____ 2. Attributes may share a ____. a. name c. location b. domain d. table

b. domain

Q. ____ 9. A ____ attribute is one that cannot be subdivided. a. composite c. single-valued b. simple d. multivalued

b. simple

Q. Popular ____ include Access, Oracle, DB2, MySQL, and SQL Server.

Database Management Systems (DBSM)

Q. The six clauses of the SELECT statement must be coded in the following order:

SELECT, FROM, WHERE, GROUP BY, HAVING, ORDER BY

Q. ____ 16. A derived attribute is indicated in the Chen model by a ____. a. single line c. circle b. dashed line d. double line

b. dashed line

Q. Write an aggregate expression for the number of entries in the vendor_name column: _________________________.

COUNT(vendor_name)

Q. The LIKE conditional operator is used by the _____ OPERAND1.

V_CONTACT

Q. Popular ____ include Access, Oracle, DB2, MySQL, and SQL Server.​

​DBMSs

Q. Figure 10-1 (Refer to figure 10-1.) Which column or columns in each table are foreign keys? -------------------------------------------------------- A) Orders: OrderID; OrderLineItems: OrderID and OrderSequence; Products: ProductID B) Orders: none; OrderLineItems: OrderID and OrderSequence; Products: none C) Orders: OrderID; OrderLineItems: OrderSequence; Products: ProductID D) Orders: none; OrderLineItems: OrderID and ProductID; Products: none

D

Q. To enforce referential integrity for a delete operation, a MySQL database can a. return an error instead of deleting any rows b. set the foreign key values in the related rows to null c. delete the related rows in the foreign key table d. a, b, or c

d. a, b, or c

Q. ____ 11. ____ attributes can have many values. a. Composite c. Single-valued b. Simple d. Multivalued

d. Multivalued

Q. Popular ____ include Access, Oracle, DB2, MySQL, and SQL Server.​

DBMSs

Q. Which uses the least amount of storage? -------------------------------------------------------- A) ‘ex‘ stored in a column of type CHAR(20) B) ‘example‘ stored in a column of type CHAR(20) C) they all use the same amount of storage D) ‘exam‘ stored in a column of type CHAR(20)

C

Q. Which uses the least amount of storage? -------------------------------------------------------- A) ‘ex‘ stored in a column of type VARCHAR2(20) B) ‘example‘ stored in a column of type VARCHAR2(20) C) they all use the same amount of storage D) ‘exam‘ stored in a column of type VARCHAR2(20)

A

Q. When renaming columns, you include the new column names in ____ following the name of the view.

parentheses

Q. MySQL allows multiple triggering conditions per trigger.

FALSE

Q. If an error occurs, each of the numeric functions returns a/an ____________ value.

null

Q. A table ___________________ can be used when you want to assign a temporary name to a table.

alias

Q. Computed or derived facts are sometimes called ____ to differentiate them from stored facts.

metrics

Q. What is the correct MySQL command to modify the values stored in a record?

UPDATE

Q. ____ 9. A ____ attribute is one that cannot be subdivided. a. composite c. single-valued b. simple d. multivalued

b. simple

Q. What allows you to execute SQL commands in a command-line application?

sqlcmd scripts

Q. The _________ function concatenates a string with the specified separator string added in between. -------------------------------------------------------- A) SUBSTRING_INDEX B) CONCAT C) CONCAT_WS D) LTRIM

C

Q. MySQL and MongoDB are management systems used for

Database creation and maintenance

Q. What is the correct MySQL command to modify the values stored in a record?

UPDATE

Q. To enforce referential integrity for a delete operation, a MySQL database can return an error instead of deleting any rows set the foreign key values in the related rows to null delete the related rows in the foreign key table a, b, or c a or c

A b c

Q. MySQL is another language that is added to SQL to organize database.

FALSE

Q. What type of software programs are Access, Oracle, DB2, MySQL, and SQL Server?

DBMSs

Q. MySQL allows multiple triggering conditions per trigger. T/F

FALSE

Q. Which of the following is not a good guideline for deciding when to create an index for a column? -------------------------------------------------------- A) The column contains a large number of distinct values. B) The column is frequently updated. C) The column is a updated infrequently. D) The column is frequently used in search conditions or joins.

B

Q. When you specify a foreign key, the table referenced by the foreign key is the ____.

parent

Q. A(n) _____ database stores each database fragment at a single site. a. partially replicated b. partitioned c. unreplicated d. fully replicated

c. unreplicated

Q. What kind of statements are USE, CREATE, ALTER, and DROP?

DDL

Q. The default date format for MySQL is _________________. mm/dd/yy yy/dd/mm mon-dd-yyyy yyyy-mm-dd

yyyy-mm-dd

More Posts

MySQL Online Quiz Questions Answers 1 Lalit Kumar - Jan 15
Android Online Quiz Questions Answers 2 Lalit Kumar - Jan 17
CSS Online Quiz Questions Answers 2 Lalit Kumar - Jan 15
C++ Online Quiz Questions Answers 2 Lalit Kumar - Jan 13
JavaScript Online Quiz Questions Answers 2 Lalit Kumar - Jan 12
Android Online Quiz Questions Answers 1 Lalit Kumar - Jan 16
AJAX Online Quiz Questions Answers Lalit Kumar - Jan 16
CSS Online Quiz Questions Answers 1 Lalit Kumar - Jan 15
C++ Online Quiz Questions Answers 1 Lalit Kumar - Jan 13
JavaScript Online Quiz Questions Answers 3 Lalit Kumar - Jan 12