题目
题目
单项选择题

Question at position 17 ________ is a set of commands used to update and query a database.DDL DML DPL DCL

选项
A.DDL
B.DML
C.DPL
D.DCL
查看解析

查看解析

标准答案
Please login to view
思路分析
The question asks which set of SQL commands is used to update and query a database. Option A: DDL (Data Definition Language) — This set includes statements like CREATE, ALTER, and DROP that define or modify the database schema. It does not primarily cover data manipulati......Login to view full explanation

登录即可查看完整答案

我们收录了全球超50000道考试原题与详细解析,现在登录,立即获得答案。

类似问题

This function in the library of Pandas allows you to manipulate data and create new variables (please choose all the correct answers, one or more):

Please create the following data frame: library(tidyverse)student <- tibble(  sid = c(66666,66666,66666,66666,66666,66666,22222,22222,22222,22222,22222,           11111,11111,11111,11111,11111,44444,44444,44444,44444,44444, 44444,           55555,55555,55555,55555,55555,55555, 33333,33333,33333,33333,33333,33333, 77777),   course = c("COMM101", "COMM102", "COMM103", "COMM201", "COMM204","COMM205", "COMM101",              "COMM102", "COMM103", "COMM201","COMM204", "COMM101", "COMM102", "COMM103",              "COMM201", "COMM205", "COMM101", "COMM102", "COMM103", "COMM201","COMM204",              "COMM205", "COMM101", "COMM102", "COMM103","COMM201", "COMM204", "COMM205",             "COMM101", "COMM102", "COMM103", "COMM201", "COMM204","COMM205", "COMM205"),   year = c(2016, 2016, 2016, 2017, 2017, 2017, 2016, 2016, 2017, 2017,2017,2016, 2016,            2016, 2017, 2017, 2016, 2016, 2016, 2016, 2017, 2017,2016, 2016, 2016, 2016,            2017, 2017,2016, 2016, 2016, 2017, 2017, 2017, 2017),  grade = c(85, 88, 72, 67, 80, 90, 77, 77, 77, 77, 77, 78, 82, 82, 80, 90, 80, 80, 80,             85, 85, 85, 79, 80, 81, 82, 83, 84, 90, 88, 95, 80, 80, 80, 99))   You wanted to find out how many unique students have taken courses in 2016.  student %>%   filter(year == 2016) %>%   XXXX(sid) %>% summarise(XXXX(sid)) The result of your code should look something like this: # A tibble: 1 × 1             XXXXXXXXXX                                <int> 1                    6 Please complete the code below. student %>%   filter(year == 2016) %>%   [Fill in the blank] (sid) %>% summarise([Fill in the blank] (sid))  

Question at position 51 A database is maintained and queried using the data mapping language (DML).TrueFalse

Question at position 33 INSERT INTO is an example of ________ code.DDL DCLDMLTIO

更多留学生实用工具

加入我们，立即解锁 海量真题 与 独家解析，让复习快人一步！