SQL Please answer the following questions.1. which one(s) of the following change(s) the name of a database?b) sp_renamedbe) (a) and (c)c) alter database modify name =f) (b) and (c)a) sp_renamed) alter name2. which one(s) of the following constraints is/are located under "relation-name →Keys" in SQL Server Management Studio?a) PRIMARY KEYb) FOREIGN KEYc) DEFAULT d) UNIQUEe) CHECKf) (a) and (b)g) (a) and (c)h) (a) and (d) i) (a), (b) and (c)j) (a), (b) and (d)3. which one(s) of the following SQL Server constraint(s) make(s) attribute value(s) ofa relation different from one another?a) PRIMARY KEYb) FOREIGN KEYc) DEFAULT d) UNIQUEe) CНECKf) (a) and (b)g) (a) and (c)h) (a) and (d) i) (a), (b) and (c)j) (a), (b) and (d)4. we do not have to specify which one(s) of the following values in the INSERT INTO .VALUES statement?a) IDENTITY attributes.b) an attribute on which a DEFAULT constraint exists.c) an attribute defined with NOT NULL.d) an attribute defined without NOT NULL.f) (a) and (c)j) (c) and (d)e) (a) and (b)g) (a) and (d)h) (b) and (c)i) (b) and (d)k) (a), (b) and (c)I) (a), (b) and (d)m) (b), (c) and (d)n) (a), (b), (c) and (d)

(Q1)a and cit changes the namer of the database. (Q2) A,B&D these are the attributes which are…

|1. which one(s) of the following change(s) the name of a database? a) sp_rename d) alter name c) alter database modify name = f) (b) and (c) b) sp_renamedb e) (a) and (c) | 2. which one(s) of the following constraints is/are located under "relation-name > Keys" in SQL Server Management Studio? -) PRIMARY ΚEY b) FOREIGN KEY c) DEFAULT d) UNIQUE e) CНECK Alal and (h) al lal and (c) bllal and Id) il (al (bland (c)

|1. which one(s) of the following change(s) the name of a database? a) sp_rename d) alter name c) alter database modify name = f) (b) and (c) b) sp_renamedb e) (a) and (c) | 2. which one(s) of the following constraints is/are located under "relation-name > Keys" in SQL Server Management Studio? -) PRIMARY ΚEY b) FOREIGN KEY c) DEFAULT d) UNIQUE e) CНECK Alal and (h) al lal and (c) bllal and Id) il (al (bland (c)

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

See similar textbooks

Similar questions

Database Administration (SQL SERVER ARCHITECTURE ) What is the definition of “Always on Availability”?
List the properties of NoSQL databases?
Relational databases store data in tables that are organized into columns and rows, sometimes called records and cells. T or F
Explain the purpose and functionalities of database query languages such as SQL (Structured Query Language). Discuss the different types of SQL queries (SELECT, INSERT, UPDATE, DELETE) and their applications.
database defination
Database Administrators and Server Administrators both have responsibilities for backing up data.
Explain what a data dictionary is and what kinds of data it stores.
Explanation it correctly and details Q)what is a schedule of values? why is it important
Describe the roles of Database Administrators (DBAs) in the context of database development.