Single Choice Questions 6. In SQL Server, there are two types of databases: system databases and (    ). A. Object-oriented databases.                B. User databases. C. Relational databases.                           D. Test databases.   7. Normalization of the database schema is performed during the (    ) of database design. A. Requirements analysis phase. B. Conceptual design phase. C. Logical design phase. D. Physical design phase.     8. The incorrect operation expression involving NULL values in SQL is (    ) A. AGE IS NULL         B. AGE IS NOT NULL    C. AGE = NULL          D. NOT (AGE IS NULL)

Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
icon
Related questions
Question

Course: Principles of Database  

please solve it within 30 minutes. please please, please
Thank you


Single Choice Questions

6. In SQL Server, there are two types of databases: system databases and (    ).

A. Object-oriented databases.                B. User databases.

C. Relational databases.                           D. Test databases.

 

7. Normalization of the database schema is performed during the (    ) of database design.

A. Requirements analysis phase.

B. Conceptual design phase.

C. Logical design phase.

D. Physical design phase.  

 

8. The incorrect operation expression involving NULL values in SQL is (    )

A. AGE IS NULL         B. AGE IS NOT NULL   

C. AGE = NULL          D. NOT (AGE IS NULL)

 

9. One of the characteristics of a database is data sharing, strictly speaking, data sharing refers to (    ).

A. Multiple programs sharing a data collection within the same application.

B. Multiple users sharing data in the same language.

C. Multiple users sharing a data file.

D. Multiple applications, multiple languages, and multiple users mutually using a data collection.

 

10. Special relational operations implemented by a relational database management system include (    ).

A. Sorting, indexing, statistics.                  B. Selection, projection, join.

C. Association, update, sorting.             D. Display, print, tabulation.

Expert Solution
steps

Step by step

Solved in 5 steps

Blurred answer
Knowledge Booster
Distributed Database Concepts
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education