网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
Examinethecommand:SQL>ALTERUSERskdACCOUNTLOCK;Whichtwostatementsaretrueafterthecommandisexecuted()
A.TheSKDusercannotlogintothedatabaseinstance.
B.TheobjectsownedbytheSKDuserarenotaccessibletoanyuser.
C.TheotheruserscanaccesstheobjectsownedbytheSKDuser，onwhichtheyhaveaccess.
D.ThepasswordfortheSKDuserexpiresandtheuserisforcedtochangethepasswordatthenextlogin
参考答案
更多 “ Examinethecommand:SQL>ALTERUSERskdACCOUNTLOCK;Whichtwostatementsaretrueafterthecommandisexecuted() A.TheSKDusercannotlogintothedatabaseinstance.B.TheobjectsownedbytheSKDuserarenotaccessibletoanyuser.C.TheotheruserscanaccesstheobjectsownedbytheSKDuser，onwhichtheyhaveaccess.D.ThepasswordfortheSKDuserexpiresandtheuserisforcedtochangethepasswordatthenextlogin ” 相关考题
考题
在oracle数据库中,执行下面的命令 SQL> ALTER USER skd ACCOUNT LOCK; 有关执行结果下面那两项描述正确?()
A.SKD 用户的对象不能被任何用户访问B.用户SKD 密码过期，在下次登陆时强制用户修改密码C.用户SKD 不能登陆数据库实例D.其它用户可以访问SKD 用户的对象，当用户已经在访问对象的时候
考题
Which statement correctly describes SQL and ／SQL*Plus? ()
A. Both SQL and /SQL*plus allow manipulation of values in the database.B. /SQL* Plus recognizes SQL satement and sends them to the server; SQL is the Oracle proprietary interface for executing SQL statements.C. /SQL* Plus language for communicating with the Oracle server to access data; SQL recognizes SQL statements and sends them to the server.D. /SQL manipulates data and table definition in the database; /SQL* Plus does not allow manipulation of values in the database.
考题
Which two are attributes of ／SQL*Plus? ()
A. /SQL*Plus commands cannot be abbreviated.B. /SQL*Plus commands are accesses from a browser.C. /SQL*Plus commands are used to manipulate data in tables.D. /SQL*Plus commands manipulate table definitions in the database.E. /SQL*Plus is the Oracle proprietary interface for executing SQL statements.
考题
在oracle数据库中,执行下面的命令SQL>ALTERUSERskd ACCOUNTLOCK;有关执行结果下面哪两项描述正确?()
A.SKD用户的对象不能被任何用户访问B.用户SKD密码过期，在下次登陆时强制用户修改密码C.用户SKD不能登陆数据库实例D.其它用户可以访问SKD用户的对象，当用户已经在访问对象的时候
考题
Examinethecommand:ALTERDATABASEADDSUPPLEMENTALLOGDATA(PRIMARYKEY)COLUMNS;Whatdoesthecommandaccomplish?()
A.Createsanadditionalcopyofthedatabaseonlineredologfiles.B.StorestheprimarykeycolumnvaluesofeachrowinvolvedinaDMLoperationintheonlineredologfiles.C.StorestheprimarykeycolumnvaluesofeachrowinvolvedinaDMLoperationinthesupplementallogfiles.D.StorestheoldandnewprimarykeycolumnvaluesofeachrowinvolvedinaDMLoperationonlywhentheprimarykeyismodifiedintheonlineredologfiles.
考题
Examinethecommand:SQLDBMS_STATS.SET_TABLE_PREFS(’SH’,’CUSTOMERS’,’PUBLISH’,’false’);Whichstatementdescribestheeffectoftheabovecommand()
A.AutomaticstatisticscollectionisstoppedfortheCUSTOMERStable.B.StatisticsfortheCUSTOMERStablearelockedandcannotbeoverwritten.C.ExistingstatisticsfortheCUSTOMERStablebecomeunusableforthequeryoptimizer.D.Subsequently，statisticsgatheredontheCUSTOMERStablearestoredaspendingstatistics
考题
T-SQL是SQL语言的方言，Oracle的PL/SQL不是SQL方言
热门标签
最新试卷