You need to modify the STUDENTS table to add a primary key on the STUDENT_ID column. The table is currently empty. Which statement accomplishes this task?() A. ALTER TABLE students ADD PRIMARY KEY _ id;B. ALTER TABLE students ADD CONSTRAINT PRIMARY KEY (student_id);C. ALTER TABLE students ADD CONSTRAINT stud_id_pk PRIMARY KEY student_id;D. ALTER TABLE students ADD CONSTRAINT stud_id_pk PRIMARY KEY (student_id);E. ALTER TABLE students MODIFY CONSTRAINT stud_id_pk PRIMARY KEY (student_id);

网友您好，请在下方输入框内输入要搜索的题目：

题目内容（请给出正确答案）

You need to modify the STUDENTS table to add a primary key on the STUDENT_ID column. The table is currently empty. Which statement accomplishes this task?()

A. ALTER TABLE students ADD PRIMARY KEY _ id;

B. ALTER TABLE students ADD CONSTRAINT PRIMARY KEY (student_id);

C. ALTER TABLE students ADD CONSTRAINT stud_id_pk PRIMARY KEY student_id;

D. ALTER TABLE students ADD CONSTRAINT stud_id_pk PRIMARY KEY (student_id);

E. ALTER TABLE students MODIFY CONSTRAINT stud_id_pk PRIMARY KEY (student_id);

参考答案

更多 “ You need to modify the STUDENTS table to add a primary key on the STUDENT_ID column. The table is currently empty. Which statement accomplishes this task?() A. ALTER TABLE students ADD PRIMARY KEY _ id;B. ALTER TABLE students ADD CONSTRAINT PRIMARY KEY (student_id);C. ALTER TABLE students ADD CONSTRAINT stud_id_pk PRIMARY KEY student_id;D. ALTER TABLE students ADD CONSTRAINT stud_id_pk PRIMARY KEY (student_id);E. ALTER TABLE students MODIFY CONSTRAINT stud_id_pk PRIMARY KEY (student_id); ” 相关考题

考题 Bootstrap中,通过对表格调用类()可实现响应式表格。 A..table-condensedB..table-stripedC..table-hoverD..table-responsive

查看答案

考题通过对表格调用Bootstrap中的类()可实现条纹状表格效果。 A.table-stripedB.table-hoverC.table-responseD.table

查看答案

考题 You examine the output of SHOW GLOBAL STATUS and notice that the value of Created_tmp_disk_tables is consistently increasing.Which two variables would likely fix this issue?() A.Table_open_cacheB.Table_open_cache_instancsC.Table_definition_cacheD.Tmp_table_sizeE.Max_heap_table_sizeF.Max_tmp_tables

查看答案

考题 A MySQL replication slave is set up as follows: User all InnoDB tablesReceives ROW-based binary logs Has the read-only optionThe replication slave has been found in an error state.You check the MySQL error log file and find the following entries:2013-08-27 13:55:44 9056 [ERROR] Slave SQL: Could not execute Write_rows event on table test.tl; Duplicate entry ‘3’ for key’PRIMARY’ , Error_code: 1062; handler error HA_ERR_FOUND_DUPP_KEY; the event’s master log 56_master-bin.000003, end_log_pas 653, Error_code: 10622013-08-27 13:55:44 9056 [Warning] Salve: Duplicate entry ‘3’ for key ‘PRIMARY’Error_code: 10622013-08-27 13:55:44 9056 [ERROR] Error running query, slave SQL thread aborted. Fix theproblem, and restart the slave SQL thread with SLAVE START”, We stopped at log ‘56_masterbin.000003’ position 496 What are two possible causes for this error to occur?（）A.The slave was created with mysqldump –u root –p – skip-lock-table—all-databases /data/data.sqlB.The slave user does have INSERT, UPDATE, or DELETE permission and cannot execute the write_rows functionC.For tables with UNIQUE keys, statement-based replication must be used maintain integrityD.The root user on the slave has executed FLUSH LOGS, causing the relay-log to doublewriteE.The applications have the SUPER privilege, which allows them to update rows

查看答案

考题物化视图日志默认的名字是:() A. M$LOG_TABLE_NAMEB. MLOG$_TABLE_NAMEC. MLOG_ TABLE_NAME

查看答案

考题 DreamWeaver 的 Modify 菜单中,对整个选定表格的列宽度值从百分比转换为像素选哪项?A. Table→Clear Cell HeightsB. Table→Clear Cell WidthsC. Table→Convert Widths to PixelsD. Table→Convert Widths to Percent解析：Table→Clear Cell Heights 用来将表格的行高清除，Table→Clear Cell Widths 用来将表格的列宽清除，Table→Convert Widths to Pixels 将整个选定表格的列宽度值从百分比转换为像素，Table→Convert Widths to Percent 将整个选定表格的列宽度值从像素转换为百分比

查看答案

考题数据库应用系统在运行过程中，发现随着数据量的不断增加，有部分查询业务和数据更新业务执行耗时越来越长。经分析，这些业务都与表Table1有关。假设Table1有30多个字段，分别为（Key，A1，A2，...Am，B1，B2，...Bn）。执行频度较高的查询业务都只用到A1，A2，...Am中的大部分属性，因此，DBA决定将表Table1分解为Table2（Key，A1，A2，...Am）和Table3（Key，B1，B2，...Bn）。为了使所有对Table1的查询程序不必修改，应该（请作答此空）；为了使对Table1的更新业务能正确执行，应该（）；这样实现了（）。A.修改所有对Tabel1的查询程序 B.创建视图Table1，为Ttable2和Table3的自然连接 C.只修改使用A1，A2，...Am中属性的程序 D.只修改使用B1，B2，...Bn中属性的程序

查看答案

考题数据库应用系统在运行过程中，发现随着数据量的不断增加，有部分查询业务和数据更新业务执行耗时越来越长。经分析，这些业务都与表Table1有关。假设Table1有30多个字段，分别为（Key，A1，A2，...Am，B1，B2，...Bn）。执行频度较高的查询业务都只用到A1，A2，...Am中的大部分属性，因此，DBA决定将表Table1分解为Table2（Key，A1，A2，...Am）和Table3（Key，B1，B2，...Bn）。为了使所有对Table1的查询程序不必修改，应该（）；为了使对Table1的更新业务能正确执行，应该（请作答此空）；这样实现了（）。A.修改所有对Table1更新的事务程序 B.创建视图Table1，为Table2和Table3的自然连接 C.只修改对A1，A2，...Am中属性更新的事务程序 D.只修改对B1，B2，...Bn中属性更新的事务程序

查看答案

考题数据库应用系统在运行过程中，发现随着数据量的不断增加，有部分查询业务和数据更新业务执行耗时越来越长。经分析，这些业务都与表Table1有关。假设Table1有30多个字段，分别为（Key，A1，A2，...Am，B1，B2，...Bn）。执行频度较高的查询业务都只用到A1，A2，...Am中的大部分属性，因此，DBA决定将表Table1分解为Table2（Key，A1，A2，...Am）和Table3（Key，B1，B2，...Bn）。为了使所有对Table1的查询程序不必修改，应该（）；为了使对Table1的更新业务能正确执行，应该（）；这样实现了（请作答此空）。A.数据的逻辑独立性 B.数据的物理独立性 C.程序的逻辑独立性 D.程序的物理独立性

查看答案

考题如果TABLE为数据段中0032单元的符号名，其中存放的内容为1234H，当执行指令”MOV AX,TABLE”和”LEA AX,TABLE”后，（AX)中的内容分别为多少？A．执行MOV AX , TABLE后（AX）=1234HB．执行LEA AX, TABLE 后（AX）=0032H.C．执行MOV AX , TABLE后（AX）=0032HD．执行LEA AX, TABLE 后（AX）=1234H

查看答案

热门标签

最新试卷