Database Practice of the Day (2017/8/1)
(Multiple Choice) 1. The operation that cannot be done on a view is ()?
A Update view
C Define a new table on the view
D Define a new view on the view
(Multiple Choice) 2. According to the traditional data model classification, database systems can be classified into three types ().
A Large, medium and small
B Western, Chinese and compatible
C Hierarchy, webs and relationships
D Data, graphics and multimedia
(Multiple Choice) 3. In the SELECT statement of SQL language, which clause () implements the sort operation.
D ORDER BY
(Multiple Choice) 4. DBMS provides DML to implement operations on data. A DML that can be used interactively on its own is called ().
A Host type
(Multiple Choice) 5. The main functions of JDBC are? 1/1
A Creating a connection to the database
B Send SQL statements to the database
C Processing data and querying results
D All of the above
(Multiple choice) 6. table toutiao_tb
title data auther type
abc 2016.2.23 bob 1
bcv 2016.3.3 http 1
cvt 2016.3.3 http 1
bcvvcm 2016.3.5 js 2
nmhh 2016.2.3 html 2
hhj 2016.3.3 java 3
rrr 2016.3.2 cc 1
Query for records whose title contains cv and whose type is 1
A select * from toutiao_tb where title = 'cv' and type='1'
B select * from toutiao_tb where title like '%cv%' andtype=1
C select * from toutiao_tb where title like '*cv' andtype=1
D select * from toutiao_tb where title ='*cv*' and type='1‘
Whether you will or not! I all hope that you will actively [leave a comment] participate in the answer! Only then can the editors go out with questions based on what people are learning! Let's all strive for maximum progress! (Forward to a friend around you who needs it! )