单选题SQL语句:alter database test modify name=mytest,其含义是()。Amytest数据库更名为testBtest数据库更名为mytestCmytest数据文件更名为testDtest数据文件更名为mytest
单选题
SQL语句:alter database test modify name=mytest,其含义是()。
A
mytest数据库更名为test
B
test数据库更名为mytest
C
mytest数据文件更名为test
D
test数据文件更名为mytest
参考解析
解析:
暂无解析
相关考题:
Which statement adds a constraint that ensures the CUSTOMER_NAME column of the CUSTOMERS table holds a value?() A. ALTER TABLE customers ADD CONSTRAINT cust_name_nn CHECK customer_name IS NOT NULL;B. ALTER TABLE customers MODIFY CONSTRAINT cust_name_nn CHECK customer_name IS NOT NULL;C. ALTER TABLE customers MODIFY customer_name CONSTRAINT cust_name_nn NOT NULL;D. ALTER TABLE customers MODIFY customer_name CONSTRAINT cust_name_nn IS NOT NULL;E. ALTER TABLE customers MODIFY name CONSTRAINT cust_name_nn NOT NULL;F. ALTER TABLE customers ADD CONSTRAINT cust_name_nn CHECK customer_name NOT NULL;
删除学生表STUD中关于学号XH必须取唯一值的约束。实现该功能的正确SQL语句是______。A.ALTER TABLE STUD ADD XH UNIQUEB.ALTER TABLE STUD MODIFY XH UNIQUEC.ALTER TABLE STUD DROP UNIQUE(XH)D.ALTER TABLE STUD MODIFY UNIQUE(XH)
删除学生表STUD中关于学号XH必须取惟一值的约束。实现该功能的正确SQL语句是 ______。A.ALTER TABLE STUD ADD XH UNIQUEB.ALTER TABLE STUD MODIFY XHUNIQUEC.ALTER TABLE STUD DROP UNIQUE(XH)D.ALTER TABLE STUD MODIFY UNIQUE(XH)
假设需要在数据库中创建角色test_role,可以使用如下()语句。 A.ALTER DATABASE ROLE test_roleB.CREATE ROLE test_roleC.UPDATE ROLE test_roleD.ALTER ROLE test_role
假设数据库中创建了一个用户test,状态为锁定状态,需要使用SQL语句解除锁定,可以使用如下()语句。 A.ALTER USER test ACCOUNTB.ALTER USER test NOLOCKC.ALTER USER test ACCOUNT NOLOCKD.ALTER test ACCOUNT NOLOCK
假设IIS所预设的主目录位置为D:\Test,如果在D:\Test目录下的mytest.htm被浏览,则其在浏览器中的地址为( )。A.http://mytest.htmB.http://localhostC.http://localhost/mytest.htmD.http//localhost/mytest.htm/test/mytest.htm
如果希望更新表authors中的first_name列为非空,那么可以使用哪个语句?()A、alter table authors add first_name not nullB、alter table authors modify first_name not nullC、alter table authors alter first_name not nullD、alter table authors drop first_name not null
为表TEST中ID列添加主键约束的语法是()A、ALTER TABLE TEST CHANGE( ID INT PRIMARY KEY)B、ALTER TABLE TEST ADD( ID INT PRIMARY KEY)C、ALTER TABLE TEST MODIFY( ID INT PRIMARY KEY)D、ALTER TABLE TEST ADD CONSTRAINT PK PRIMARY KEY (ID)
在SQL Server中,修改表中列定义的正确的SQL语句是()。A、ALTER TABLE 表名 ALTER COLUMN 列名 数据类型B、ALTER TABLE 表名 ALTER 列名 数据类型C、ALTER TABLE MODIFY COLUMN 列名 数据类型D、ALTER TABLE 表名 ADD 列名 数据类型
SQL语句:alter database test modify name=mytest,其含义是()。A、mytest数据库更名为testB、test数据库更名为mytestC、mytest数据文件更名为testD、test数据文件更名为mytest
RMAN enables you to open the target database when it is already mounted. Which command must you execute at the RMAN prompt to open the database?()A、’SQL ALTER DATABASE OPEN’;B、SQL ALTER DATABASE ’OPEN’;C、OPEN DATABASE;D、DATABASE OPEN
假设需要在数据库中创建角色test_role,可以使用如下()语句。A、ALTER DATABASE ROLE test_roleB、CREATE ROLE test_roleC、UPDATE ROLE test_roleD、ALTER ROLE test_role
假设数据库中创建了一个用户test,状态为锁定状态,需要使用SQL语句解除锁定,可以使用如下()语句。A、ALTER USER test ACCOUNTB、ALTER USER test NOLOCKC、ALTER USER test ACCOUNT NOLOCKD、ALTER test ACCOUNT NOLOCK
单选题Which of the following represents the correct way to perform an online recovery of datafile 4, which is assigned to a tablespace called USERS?()A shutdown restore datafile 4; recover datafile 4; alter database open;B Sql alter database datafile 4 offline; restore datafile 4; recover datafile 4; alter database open;C Sql alter database datafile 4 offline; restore datafile 4; Sql alter database datafile 4 online;D Sql alter database datafile 4 offline; restore database datafile 4; recover database datafile 4;Sql alter database datafile 4 online;E Sql alter database datafile 4 offline; restore datafile 4; recover datafile 4; Sql alter database datafile 4 online;
单选题You work as an ASP.NET Web Application Developer for SomeCompany. The company uses Visual Studio .NET 2010 as its application development platform. You create an ASP.NET MVC 2 Web application using .NET Framework 4.0. You implement a single project area in the MVC 2 Web application. In the Areas folder, you add a subfolder named MyTest. You add the following files to the appropriate sub-folders: MyController. csMyHome.aspx You register a route of the area, setting the route name to MyTest_default and the area name to test. You create a view named MyViews.aspx that is outside the test area. You need to add a link to MyViews.aspx that points to MyHome.aspx. Which of the following code segments will you use?()A%= Html.ActionLink(MyTest, MyHome, new {area = test}, null)%B%= Html.RouteLink(MyHome, MyTest, new {area = test}, null)% C%= Html.RouteLink(MyTest, MyHome, MyTest, new {area = test}, null)%D%= Html.ActionLink(MyTest, MyHome, MyTest, new {area = test}, null)%