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

List the properties of NoSQL databases?
Describe the process of designing and developing a database.
Relational databases store data in tables that are organized into columns and rows, sometimes called records and cells. T or F
Database Administrators and Server Administrators both have responsibilities for backing up data.
Data refers to the format in which data is stored, processed, and transferred.
What does it mean to maintain a database?
large scale database
SQL-formatting for a database named "Construct"?
Describe the roles of Database Administrators (DBAs) in the context of database development.