A user selects their proper domain and is unable to log into their Windows computer.The error states:‘System cannot log you on to the domain because the system’s computer account in its primary domain is missing or the password on that account is incorrect’.Which of the following is the MOST likely cause for this error?()
第1题:
Youworkforacompanythatsellsbooks.YouarecreatingareportforaSQLServer2005database.Thereportwilllistsalesrepresentativesandtheirtotalsalesforthecurrentmonth.Thereportmustincludeonlythosesalesrepresentativeswhomettheirsalesquotaforthecurrentmonth.Themonthlysalesquotais$2,000.Thedateparametersarepassedinvariablesnamed@FromDateand@ToDate.Youneedtocreatethereportsothatitmeetstheserequirements.WhichSQLqueryshouldyouuse?()
A.SELECTs.AgentName,SUM(ISNULL(o.OrderTotal,0.00))ASSumOrderTotalFROM SalesAgentsJOINOrderHeaderoONs.AgentID=o.AgentIDWHEREo.OrderDateBETWEEN@FromDateAND@ToDateGROUPBYs.AgentName
B.SELECTs.AgentName,SUM(ISNULL(o.OrderTotal,0.00))ASSumOrderTotalFROMSalesAgentsJOINOrderHeaderoONs.AgentID=o.AgentIDWHEREo.OrderDateBETWEEN@FromDateAND@ToDateANDo.OrderTotal>=2000GROUPBYs.AgentName
C.SELECTs.AgentName,SUM(ISNULL(o.OrderTotal,0.00))ASSumOrderTotalFROMSalesAgentsJOINOrderHeaderoONs.AgentID=o.AgentIDWHEREo.OrderDateBETWEEN@FromDate AND@ToDateGROUPBYs.AgentNameHAVINGSUM(o.OrderTotal)>=2000
D.SELECTs.AgentName,SUM(ISNULL(o.OrderTotal,0.00))ASSumOrderTotalFROMSalesAgentsJOINOrderHeaderoONs.AgentID=o.AgentIDWHEREo.ordertotal=2000ANDo.OrderDateBETWEEN@FromDateAND@ToDateGROUPBYs.AgentNameHAVINGSUM(o.OrderTotal)>=2000
第2题:
若要求查找姓名中第一个字为‘刘’的学生号和姓名。下面列出的SQL语句中,哪个是正确的?
A.SELECT S#,SNAME FROM SWHERE SNAME=′刘%′
B.SELECT S#,SNAME FROM SWHERE SNAME=′刘′
C.SELECTS#,SNAMEFROMSWHERESNAMELIKE=′刘%′
D.SELECTS#,SNAMEFROMSWHERESNAME=′刘′
第3题:
A.SELECTS#FROMSCWHEREC#="C2"ANDGRADE>=(SELECTGRADEFROMSCWHEREC#="C2")
B.SELECTS#FROMSCWHEREC#="C2"ANDGRADE>=(SELECTGRADEFROMSCWHEREC#="C2")
C.SELECTS#FROMSCWHEREC#="C2"ANDGRADENOTIN(SELECTGRADEFROMSCWHEREC#="C2")
D.SELECTS#FROMSCWHEREC#="C2"ANDGRADE=(SELECTMAX(GRADE)FROMSCWHEREC#="C2"
第4题:
“学生—选课—课程”数据库中的三个关系: S(S#,SNAME,SEX,AGE),SC(S#,C#,GRADE),C(C#,CNAME,TEACHER) 它们的主键为第一个。 “查询选修了3门以上课程的学生的学生号”,正确的SQL语句是()。
第5题:
A.It is used to detect loops.
B.It is an interface identifier.
C.It selects a compression algorithm.
D.It specifies the transmission media.
第6题:
A. USER_CONSTRAINTS
B. USER_OBJECTS
C. ALL_CONSTRAINTS
D. USER_CONS_COLUMNS
E. USER_COLUMNS
第7题:
设学生表S、课程表C和学生选课表SC的结构如下:
S(学号,姓名,年龄,系别)
C(课程号,课程名)
SC(学号,课程号,成绩)
查询学生姓名及所选修课程的课程号和成绩,实现此功能的SELECT语句是______。
A.SELECTS.姓名,SC课程号,SC成绩FROM S WHERE S.学号=SC.学号
B.SELECTS.姓名,SC课程号,SC成绩FROM SC WHERE S.学号=SC.成绩
C.SELECTS.姓名,SC课程号,SC成绩FROMS,SC WHERE S.学号=SC.学号
D.SELECTS.姓名,SC课程号,SC成绩FROM S,SC
第8题:
Please ____those details that you would like to change.
A. select
B. selection
C. selecting
D. selects
第9题:
若要求查找姓名中第一个字为‘刘’的学生号和姓名。下面列出的SQL语句中,哪个是正确的?
A.SELECTS#,SNAMEFROMS WHERESNAME='刘%'
B.SELECTS#,SNAMEFROMS WHERESNAME='刘_'
C.SELECTS#,SNAMEFROMS WHERESNAME LIKE='刘%'
D.SELECTS#,SNAMEFROMS WHERESNAME='刘_'
第10题:
“学生—选课—课程”数据库中的三个关系: S(S#,SNAME,SEX,AGE), SC(S#,C#,GRADE), C(C#,CNAME,TEACHER) 若要求查找姓名中第二个字为‘阳’字的学生的学号和姓名,下列SQL语句中,哪一个(些)是正确的?() Ⅰ.SELECTS#,SNAMEFROMSWHERESNAME=‘_阳%’ Ⅱ.SELECTS#,SNAMEFRQMSWHERESNAMELIKE‘_阳%’ Ⅲ.SELECTS#,SNAMEFROMSWHERESNAMELIKE‘%阳%’