Which of the following is a task performed by the driver according to the ODBC standard? Select one: a. Determines the appropriate DBMS b. Converts the data source into an SQL-compliant data structure c. Validates the format of the ODBC command received from the application d. Verifies the application to the data source e. Converts data source error codes into ODBC standard error codes Additional DBA responsibilities do not include ________. Select one: a. controlling database configuration b. requests of changes to existing systems c. maintaining appropriate documentation d. editing E-R diagrams e. problem and error reporting The recovery technique in which the database is returned to a known state and then all valid transactions are reapplied to the database is known as ________. Select one: a. rollforward b. transaction logging c. reprocessing d. checkpointing e. rollback Which of the following is the correct technique for representing a 1:N relationship in the relational model? Select one: a. The key of the child is placed into the relation of the parent. b. The key of the entity on the many side is placed into the relation for the entity on the one side. c. The key of either relation can be placed into the other relation. d. An intersection relation is created, and the keys from both parent entities are placed as keys in the intersection relation. e. The key of the entity on the one side is placed into the relation for the entity on the many side. In the Entity-Relationship data model, all instances of an entity of a given type are grouped into ________. Select one: a. identifiers b. class objects c. entity classes d. entity attributes e. entity objects In a 1:1 relationship, a single entity instance of one type is related to a single entity instance of the same or another type. Select one: True False The TOP built-in function in SQL is used to find the maximum value in a numeric column. Select one: True False Which SQL keyword is used to eliminate duplicate rows in the results of an SQL SELECT query? Select one: a. ORDER BY b. REDUCE c. UNIQUE d. SORT e. DISTINCT Ensuring that every value of a foreign key matches a value of the corresponding primary key is an example of a referential integrity constraint. Select one: True False Which of the following is true about a relation? Select one: a. A relation may have duplicate rows. b. The order of the columns in a relation must go from largest to smallest. c. A relation may have multiple names. d. A relation may have duplicate column names. e. All entries in any column must be of the same kind.
Which of the following is a task performed by the driver according to the ODBC standard? Select one: a. Determines the appropriate DBMS b. Converts the data source into an SQL-compliant data structure c. Validates the format of the ODBC command received from the application d. Verifies the application to the data source e. Converts data source error codes into ODBC standard error codes Additional DBA responsibilities do not include ________. Select one: a. controlling database configuration b. requests of changes to existing systems c. maintaining appropriate documentation d. editing E-R diagrams e. problem and error reporting The recovery technique in which the database is returned to a known state and then all valid transactions are reapplied to the database is known as ________. Select one: a. rollforward b. transaction logging c. reprocessing d. checkpointing e. rollback Which of the following is the correct technique for representing a 1:N relationship in the relational model? Select one: a. The key of the child is placed into the relation of the parent. b. The key of the entity on the many side is placed into the relation for the entity on the one side. c. The key of either relation can be placed into the other relation. d. An intersection relation is created, and the keys from both parent entities are placed as keys in the intersection relation. e. The key of the entity on the one side is placed into the relation for the entity on the many side. In the Entity-Relationship data model, all instances of an entity of a given type are grouped into ________. Select one: a. identifiers b. class objects c. entity classes d. entity attributes e. entity objects In a 1:1 relationship, a single entity instance of one type is related to a single entity instance of the same or another type. Select one: True False The TOP built-in function in SQL is used to find the maximum value in a numeric column. Select one: True False Which SQL keyword is used to eliminate duplicate rows in the results of an SQL SELECT query? Select one: a. ORDER BY b. REDUCE c. UNIQUE d. SORT e. DISTINCT Ensuring that every value of a foreign key matches a value of the corresponding primary key is an example of a referential integrity constraint. Select one: True False Which of the following is true about a relation? Select one: a. A relation may have duplicate rows. b. The order of the columns in a relation must go from largest to smallest. c. A relation may have multiple names. d. A relation may have duplicate column names. e. All entries in any column must be of the same kind.
Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
Related questions
Question
Which of the following is a task performed by the driver according to the ODBC standard?
Select one:
a. Determines the appropriate DBMS
b. Converts the data source into an SQL-compliant data structure
c. Validates the format of the ODBC command received from the application
d. Verifies the application to the data source
e. Converts data source error codes into ODBC standard error codes
Additional DBA responsibilities do not include ________.
Select one:
a. controlling database configuration
b. requests of changes to existing systems
c. maintaining appropriate documentation
d. editing E-R diagrams
e. problem and error reporting
The recovery technique in which the database is returned to a known state and then all valid transactions are reapplied to the database is known as ________.
Select one:
a. rollforward
b. transaction logging
c. reprocessing
d. checkpointing
e. rollback
Which of the following is the correct technique for representing a 1:N relationship in the relational model?
Select one:
a. The key of the child is placed into the relation of the parent.
b. The key of the entity on the many side is placed into the relation for the entity on the one side.
c. The key of either relation can be placed into the other relation.
d. An intersection relation is created, and the keys from both parent entities are placed as keys in the intersection relation.
e. The key of the entity on the one side is placed into the relation for the entity on the many side.
In the Entity-Relationship data model, all instances of an entity of a given type are grouped into ________.
Select one:
a. identifiers
b. class objects
c. entity classes
d. entity attributes
e. entity objects
In a 1:1 relationship, a single entity instance of one type is related to a single entity instance of the same or another type.
Select one:
True
False
The TOP built-in function in SQL is used to find the maximum value in a numeric column.
Select one:
True
False
Which SQL keyword is used to eliminate duplicate rows in the results of an SQL SELECT query?
Select one:
a. ORDER BY
b. REDUCE
c. UNIQUE
d. SORT
e. DISTINCT
Ensuring that every value of a foreign key matches a value of the corresponding primary key is an example of a referential integrity constraint.
Select one:
True
False
Which of the following is true about a relation?
Select one:
a. A relation may have duplicate rows.
b. The order of the columns in a relation must go from largest to smallest.
c. A relation may have multiple names.
d. A relation may have duplicate column names.
e. All entries in any column must be of the same kind.
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 3 steps
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY