Database written interview question Bank (Oracle, MySQL, etc.)

Database written interview question Bank (Oracle, MySQL, etc.)

⊙"DB written interview 67" in Oracle, about table partitioning the following description is incorrect ()
⊙"DB written interview 65" in Oracle, which table partitioning method suggests a power of 2 (2, 4, 8, and so on) to get the most average data release ()
⊙"DB Test interview 63" to return data in the name ' address is addr format, the following SQL statement is correct
⊙"DB written interview 61" The following about data model requirements error is ()
⊙"db written interview 59" below about view description Incorrect Yes ()
⊙DB written interview 57 which of the following descriptions of the features of the SQL language is correct? () (Multi-choice)
⊙ DB Written interview 54 grants the user USER4 the Insert permission to the table student and allows it to be granted to another user
⊙"DB written interview 52" in Oracle, which of the following scalar types cannot be saved to a database table ()
⊙"DB Test interview 50" which function's return value is not equal to -97 ()
⊙ "db written interview 47" transactional consistency means ()
⊙"DB written interview 45" below about deadlock detection and recovery narrative error Yes ()
⊙"DB written interview 43" The persistence of the transaction means ()
⊙ "DB written interview 41" The following implementation "defines the student's number and his average score as a view" which of the SQL statements is correct? （）
⊙"DB Test interview 39" deletes the Dept column of the Student table, but removes it only if no view or constraint references the column.
⊙ "DB written interview 38" CREATE table T1 and make the table Employid field values non-null and unique SQL statement is the following?
⊙ "DB written interview 36" which of the following statements about the E-R model and the E-r diagram is wrong? ()
⊙"DB written interview 34" Description of the Oracle system process and role, which is correct to have () (Multiple choice)
⊙"DB written interview 33" which three components does the Scheduler
⊙"db written interview 31" Below is information on the EMP employee table, which relies on this information to complete the following questions:
⊙"DB written interview 29" When the client configures the local service name, the following information is not required to provide ()
⊙DB Written interview 27 The following options, which are not part of the SQL statement, are ()
⊙"DB written interview 25" in the following statements about InnoDB and MyISAM, the correct is () (Multi-choice)
⊙ "DB written interview 22" SQL language set data query, data manipulation, data definition and data control functions in one, where CREATE, DROP, ALTER
⊙"DB written interview 21" General database if the log is full, it will appear ()
⊙"DB written interview 20" The following comparisons are true ()
⊙"DB written interview 19" The following about the To_char (), to_date () function will not go wrong during use (two options)
⊙The DB written interview 18 constraint prevents invalid data from entering the table, maintains data consistency, and Oracle provides several constraints, the following description is correct ()
⊙"DB Test interview 17" The following is a description of the view, the error is ()
⊙"DB written interview 15" The following statement uses column aliases, which can result in an error () (two options)
DB Written interview 12 write out the following 50 SQL statements (2) according to the requirements of the topic
⊙"DB Test interview 10" in the following options, is not a SQL constraint is ()
⊙"DB written interview 8" Xiao Ming designed the following student management system, known relationship:
⊙"DB Test Interview 6" the field that is suitable for indexing is () (Multiple-choice)
⊙"db written interview 2" which user is not the user that exists after the default installation of Oracle ()
⊙<a href= "http://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454771853&idx=2&sn= ed153e0924116f9d1d2f8568663f0da2&chksm= Fe8bb5f5c9fc3ce3d874ead3c67e3cbd5bcf065ec8329e40c6006e7709755799bfc4b3909e94&scene=21#wechat_redirect " target= "_blank" data_ue_src= "http://mp.weixin.qq.com/s?__biz=mzizota2njeznq==&mid=2454771853&idx=2& sn=ed153e0924116f9d1d2f8568663f0da2&chksm= Fe8bb5f5c9fc3ce3d874ead3c67e3cbd5bcf065ec8329e40c6006e7709755799bfc4b3909e94&scene=21#wechat_redirect " Style= "Margin:0px;padding:0px;color: #607FA6; text-decoration:none;max-width:100%;font-family:" LINE-HEIGHT:21PX; White-space:pre;widows:1;font-size:14px;background-color: #ffffff; box-sizing:border-box= ""!important; = "" >"db written interview 1" The following logical structures that are not part of Oracle are ()

About Me

......................................................................................................................... ...... ● In this paper, wheat seedling, only focus on the database technology, pay more attention to the use of technology ● This article is in itpub(http://blog.itpub.net/26736162), blog Park (http://www.cnblogs.com/ Lhrbest) and the personal public number (XIAOMAIMIAOLHR) have synchronized updates ● This article itpub address: http://blog.itpub.net/26736162/viewspace-2134706/ < Span style= "color: #666666;" > this article PDF version wheat seedling Cloud disk address: http://blog.itpub.net/26736162/viewspace-1624453/ QQ Group: 230161599 Group: Private chat ● Contact me please add QQ friends (642808185) , indicate the reason for adding ● The article is derived from the study notes of wheat seedlings, partly collated from the network, if there is infringement or improper place also please understand ● <span style= "color: #666666; font-family:" font-size:14.6667px;white-space:normal;background-color:# C7DAF1; " = "" > Copyright, Welcome to share this article, reproduced please retain the source ......................................................................................................................... ...... Pick up the phone use the client scan the left image below to pay attention to the public number of wheat seedlings:xiaomaimiaolhr, scan the right QR code to join the wheat seedlings QQ Group, Learn the most practical database technology. 650) this.width=650; "src=" http://blog.itpub.net/attachment/201607/6/26736162_1467812292IsyS.jpg "width=" 200 " height= "/>650" this.width=650; "src=" http://blog.itpub.net/attachment/201701/7/26736162_ 1483765845qyth.png "width=" "height="/>

650) this.width=650; "Src=" Http://rescdn.qqmail.com/zh_CN/htmledition/images/function/qm_open/ico_ Mailme_02.png "alt=" ico_mailme_02.png "/> 650" this.width=650; "border=" 0 "src="//pub.idqqimg.com/wpa/images/ Group.png "alt=" dba written interview explaining "Title=" dba written interview "/>

This article is from the "Wheat Seedling Blog" blog, please be sure to keep this source http://lhrbest.blog.51cto.com/2318295/1903708

Database written interview question Bank (Oracle, MySQL, etc.)