單項選擇題有關SQLSERVER 2008創(chuàng)建數(shù)據(jù)表的說法,以下正確的是()

A.數(shù)據(jù)庫對創(chuàng)建表的數(shù)量沒有限制
B.創(chuàng)建數(shù)據(jù)庫表示不能同時創(chuàng)建約束
C.創(chuàng)建數(shù)據(jù)庫表的同時創(chuàng)建主鍵,實際上是在創(chuàng)建表后對表進行修改
D.創(chuàng)建數(shù)據(jù)庫表的同時創(chuàng)建外鍵,實際上是在創(chuàng)建表后對表進行修改


您可能感興趣的試卷

你可能感興趣的試題

1.單項選擇題在SQLServer數(shù)據(jù)庫中,HAVING和WHERE子句以及GROUPBY可以在同一SELECT語句中使用,其正確的先后順序為()

A.GROUP BY WHERE HAVING
B.WHE REGROUP BY HAVING
C.WHE REHAVING GROUP BY
D.HAVING WHERE GROUP BY

2.單項選擇題查詢student表中的所有非空email信息,以下語句正確的是()

A.Select email from student where email!=null
B.Select email from student where emailnotisnull
C.Select email from student where email<>null
D.Select email from student where emailisnotnull

4.單項選擇題一個電視經(jīng)銷商在表Tvtype中維護庫存的電視信息,下述()語句能顯示價格(iprice)最昂貴的三種電視機的信息(cDiscription)

A.select top3 cDiscription fromTvtype order by iprice asc
B.select cDiscription from Tvtype where max(iprice)>3
C.select top3 cDiscription from Tvtype order by iprice desc
D.selec tcDiscription max(iprice)from Tvtype order by iprice

5.單項選擇題有名為 Sales 的表,現(xiàn)需要按客戶姓名(CustomerName)和銷售日期(SalesDate)排序返回銷售數(shù)據(jù)。為每個客戶提供最近期的銷售必須首先列出。應使用的查詢語句為()

A.select CustomerName,SalesDate from Sales group by CustomerName,SalesDate
B.select CustomerName,SalesDate from Sales order by CustomerName,SalesDate
C.select CustomerName,SalesDate from Sales group by CustomerNameorderbySalesDateDESC
D.select CustomerName,SalesDate from Sales order by CustomerName,SalesDateDESC