You issued this command: DROP TABLE hr. employees; Which three statements are true? A) ALL constraints defined on HR, EMPLOYEES are dropped. B) The HR. EMPLOYEES table may be moved to the recycle bin. ...
You issued this command: DROP TABLE hr. employees; Which three statements are true? A) ALL constraints defined on HR, EMPLOYEES are dropped. B) The HR. EMPLOYEES table may be moved to the recycle bin. ...
Which is the default column or columns for sorting output from compound queries using SET operators such as INTERSECT in a SQL statement? A) The first column in the last SELECT of the compound query B ...
You are administering a multitenant container database (CDB) cdb1 that has multiple pluggable databases (PDBs). As the sys user on cdb$root, you execute the commands: SQL> CREATE USER C##ADMIN IDENTIF ...
Your database is running in archivelog mode. Examine the parameters for your database instance: LOG_ARCHIVE_DEST_l =’LOCATION=/disk1/arch MANDATORY’ LOG_ARCHIVE_DEST_2 =’LOCATION=/disk2/arch’ LOG_ ...
Which three statements are true about views in an Oracle database? A) The WITH CHECK clause prevents certain rows from being displayed when querying the view. B) The WITH CHECK clause prevents certain ...
Which two statements are true about external tables? A) Indexes can be created on them. B) You can populate them from existing data in the database by using the CREATE TABLE AS SELECT command. C) DML ...
老师:今天在做FTP本地用户登入操作出现一个问题,就是匿名帐户可以登录并访问服务器上的文件,而本地用户lisi和root用户都报错了,是什么原因? ...
**** 本内容被作者隐藏 **** 点此浏览《数据库免费视频教程》完整版