网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
Which of the following will DELETE all of the rows from table T03?（）
A
DELETE * FROM TABLE T03
B
DELETE ALL FROM T03
C
DELETE * FROM T03
D
DELETE FROM T03
参考答案
参考解析
解析：
暂无解析
更多 “单选题Which of the following will DELETE all of the rows from table T03?（）A DELETE * FROM TABLE T03B DELETE ALL FROM T03C DELETE * FROM T03D DELETE FROM T03” 相关考题
考题
在下列查询语句中，与SELECT TABl*FROM，TABl WHERE InStr([简历]，”篮球”)o功能相同的语句是（ ）。A.SELECT TABl．*FROM TABl WHERE TABl．简历Like”篮球”B.SELECT TABl．*FROM TABl WHERE TABl．简历Like”*篮球”C.SELECT TABl．*FROM TABl WHERE TABl．简历Like”*篮球*”D.SELECT TABl．*FROM TABl WHERE TABl．简历Like”篮球*”
考题
The opening of cursor CSR01 produces the following result set:STUDENT LASTNM FIRSTNM CLASSNO 123 Brown John T100 213 Bailey JamesT100 312 Carter Arlene T210 465 Chas Devon T305 546 Davis Steven T405If this Fetch statement is executed: FETCH csr01 INTO :studnum, :firstname, :lastname, :class Which of the following DELETE statements will cause this row to be deleted?（）A.DELETE ALL FROM tab01 FOR CURRENT OF csr01B.DELETE FROM tab01 FOR CURRENT csr01 WITH RSC.DELETE * FROM tab01 WHERE CURRENT csr01 WITH CSD.DELETE FROM tab01 WHERE CURRENT OF csr01 WITH RR
考题
Assuming PUBLIC has been granted all privileges on table T1, which of the following statements would continue to permit any user to add rows to table T1, but not remove them?()
A.REVOKE DROP ON t1 FROM PUBLICB.REVOKE UPDATE ON t1 FROM PUBLICC.REVOKE DELETE ON t1 FROM PUBLICD.REVOKE CONTROL ON t1 FROM PUBLIC
考题
Which of the following statements eliminates all but one of each set of duplicate rows in the DEPT column in the STAFF table?()
A.SELECT UNIQUE dept FROM staffB.SELECT DISTINCT dept FROM staffC.SELECT (dept) UNIQUE FROM staffD.SELECT (dept) DISTINCT FROM staff
考题
Consider the following table called EMPLOYEES: ID FIRSTNAME LASTNAME JOB LEVELCLERK 3If the following SQL statement is executed, how many rows will be deleted? DELETE FROM employees WHERE 1 = 1()
A.0B.1C.3D.6
考题
Which of the following will DELETE all of the rows from table T03?()
A.DELETE * FROM TABLE T03B.DELETE ALL FROM T03C.DELETE * FROM T03D.DELETE FROM T03
考题
Which of the following commands should be used to delete an entry from the ／etc／inittab?()
A.xitabB.rmitabC.chitabD.delitab
考题
Which of the following statements is used to revoke all DML privileges on table EMPLOYEE from user TOM?()
A.REVOKE ALL PRIVILEGES FROM USER tomB.REVOKE ALL ON EMPLOYEE FROM USER tomC.REVOKE EXECUTE ON EMPLOYEE FROM USER tomD.REVOKE PRIVILEGES ON EMPLOYEE FROM USER tom
考题
What does the TRUNCATE statement do?（）A、Removes the tableB、Removes all rows from a tableC、Shortens the table to 10 rowsD、Removes all columns from a tableE、Removes foreign keys from a table
考题
Which of the following statements eliminates all but one of each set of duplicate rows in the DEPT column in the STAFF table?（）A、SELECT UNIQUE dept FROM staffB、SELECT DISTINCT dept FROM staffC、SELECT (dept) UNIQUE FROM staffD、SELECT (dept) DISTINCT FROM staff
考题
The opening of cursor CSR01 produces the following result set: STUDENT LASTNM FIRSTNM CLASSNO 123 Brown John T100 213 Bailey James T100 312 Carter Arlene T210 465 Chas Devon T305 546 Davis Steven T405 If this Fetch statement is executed: FETCH csr01 INTO :studnum, :firstname, :lastname, :class Which of the following DELETE statements will cause this row to be deleted?（）A、DELETE ALL FROM tab01 FOR CURRENT OF csr01B、DELETE FROM tab01 FOR CURRENT csr01 WITH RSC、DELETE * FROM tab01 WHERE CURRENT csr01 WITH CSD、DELETE FROM tab01 WHERE CURRENT OF csr01 WITH RR
考题
Which of the following statements is used to prevent user TOM from adding and deleting data in table TAB1?（）A、REVOKE ADD, DELETE FROM USER tom ON TABLE tab1B、REVOKE ADD, DELETE ON TABLE tab1 FROM USER tomC、REVOKE INSERT, DELETE FROM USER tom ON TABLE tab1D、REVOKE INSERT, DELETE ON TABLE tab1 FROM USER tom
考题
Which of the following will DELETE all of the rows from table T03?（）A、DELETE * FROM TABLE T03B、DELETE ALL FROM T03C、DELETE * FROM T03D、DELETE FROM T03
考题
Which of the following commands should be used to delete an entry from the /etc/inittab?（）A、xitabB、rmitabC、chitabD、delitab
考题
Which of the following can be utilized from a Legacy form without additional coding？（）A、Field ValidationsB、Query Save logicC、Dialog formsD、All of the above
考题
Which of the following statements is used to revoke all DML privileges on table EMPLOYEE from user TOM?（）A、REVOKE ALL PRIVILEGES FROM USER tomB、REVOKE ALL ON EMPLOYEE FROM USER tomC、REVOKE EXECUTE ON EMPLOYEE FROM USER tomD、REVOKE PRIVILEGES ON EMPLOYEE FROM USER tom
考题
Which of the following commands must be issued to remove a stored script from the recovery catalog？（）A、DELETE SCRIPTB、ERASE SCRIPTC、REMOVE SCRIPTD、UNCATALOG SCRIPT
考题
All the database users are presently connected to the database instance and working. The HR user hasopened three database sessions and executed the following command in one of his sessions：SQL UPDATE persons SET ccode=’U031’ WHERE ccode=’U029’； 123 rows updated.SQL DELETE FROM persons WHERE exp=’Y’；3 rows deleted. The SYS user opens a new session after HR executed the above commands. Which sessions can see theeffect of the UPDATE and DELETE commands（）A、All sessions of the HR user onlyB、All sessions of the HR user and the SYS userC、The session of the HR user that executed the commandsD、All the sessions for which the database users have access privilege to the PERSONS table
考题
User A executes the following command to drop a large table in your database：SQL DROP TABLE trans； While the drop table operation is in progress， user B executes the following command on the same table：SQL DELETE FROM trans WHERE tr_type=’SL’； Which statement is true regarding the DELETE command（）A、It fails to delete the records because the records are locked in SHARE mode.B、It deletes the rows successfully because the table is locked in SHARE modeC、It fails to delete the records because the table is locked in EXCLUSIVE mode.D、It deletes the rows successfully because the table is locked in SHARE ROW EXCLUSIVE mode.
考题
User A executes the following command to drop a large table in your database： SQL DROP TABLE trans； While the drop table operation is in progress， user B executes the following command on the same table： SQL DELETE FROM trans WHERE tr_type=’SL’； Which statement is true regarding the DELETE command（）A、It fails with a "Resource Busy" error.B、It deletes the rows successfully because the table is locked in SHARE mode.C、It fails to delete the records because the table is locked in EXCLUSIVE mode.D、It deletes the rows successfully because the table is locked in SHARE ROW EXCLUSIVE mode.
考题
单选题Consider the following table called EMPLOYEES: ID FIRSTNAME LASTNAME JOB LEVEL CLERK 3 If the following SQL statement is executed, how many rows will be deleted? DELETE FROM employees WHERE 1 = 1（）A
0B
1C
3D
6
考题
单选题You are responsible for a data warehouse application that uses records from an external table to update one of the dimension tables periodically. The records in the external table may contain data for new rows in the dimension table， or for updates to its existing rows. Which type of SQL command would you use to transfer the data from the external table to the dimension table as efficiently as possible？（）A
MERGEB
SELECT …CROSS JOINC
INSERT ALL …SELECTD
CREATE VIEW …CONSTRAINT
考题
单选题User A executes the following command to drop a large table in your database： SQL DROP TABLE trans； While the drop table operation is in progress， user B executes the following command on the same table： SQL DELETE FROM trans WHERE tr_type=’SL’； Which statement is true regarding the DELETE command（）A
It fails with a Resource Busy error.B
It deletes the rows successfully because the table is locked in SHARE mode.C
It fails to delete the records because the table is locked in EXCLUSIVE mode.D
It deletes the rows successfully because the table is locked in SHARE ROW EXCLUSIVE mode.
考题
单选题Assuming PUBLIC has been granted all privileges on table T1, which of the following statements would continue to permit any user to add rows to table T1, but not remove them?（）A
REVOKE DROP ON t1 FROM PUBLICB
REVOKE UPDATE ON t1 FROM PUBLICC
REVOKE DELETE ON t1 FROM PUBLICD
REVOKE CONTROL ON t1 FROM PUBLIC
考题
单选题User A executes the following command to drop a large table in your database：SQL DROP TABLE trans； While the drop table operation is in progress， user B executes the following command on the same table：SQL DELETE FROM trans WHERE tr_type=’SL’； Which statement is true regarding the DELETE command（）A
It fails to delete the records because the records are locked in SHARE mode.B
It deletes the rows successfully because the table is locked in SHARE modeC
It fails to delete the records because the table is locked in EXCLUSIVE mode.D
It deletes the rows successfully because the table is locked in SHARE ROW EXCLUSIVE mode.
考题
单选题What does the TRUNCATE statement do?（）A
Removes the tableB
Removes all rows from a tableC
Shortens the table to 10 rowsD
Removes all columns from a tableE
Removes foreign keys from a table
考题
单选题Which of the following will DELETE all of the rows from table T03?（）A
DELETE * FROM TABLE T03B
DELETE ALL FROM T03C
DELETE * FROM T03D
DELETE FROM T03
考题
单选题All the database users are presently connected to the database instance and working. The HR user hasopened three database sessions and executed the following command in one of his sessions：SQL UPDATE persons SET ccode=’U031’ WHERE ccode=’U029’； 123 rows updated.SQL DELETE FROM persons WHERE exp=’Y’；3 rows deleted. The SYS user opens a new session after HR executed the above commands. Which sessions can see theeffect of the UPDATE and DELETE commands（）A
All sessions of the HR user onlyB
All sessions of the HR user and the SYS userC
The session of the HR user that executed the commandsD
All the sessions for which the database users have access privilege to the PERSONS table
热门标签
最新试卷