Which statement is true about TRUNCA

单选题 Which statement is true about TRUNCATE and DELETE?

A、 For large tables TRUNCATE is faster than DELETE

B、 For tables with multiple indexes and triggers is faster than TRUNCATE

C、 You can never TRUNCATE a table if foreign key constraints will be violated

D、 You can never tows from a table if foreign key constraints will be violated

查看答案

下载APP答题

由4l***ml提供分享举报纠错

相关试题

单选题 Examine the description of the CUSTOMERS table:
Name Null? Type
-----------------------------------------------------------------------------------------
CUST_ID Not NULL VARCHAR2(6)
FIRST_NAME VARCHAR2(50)
LAST_NAME Not NULL VARCHAR2(50)
ADDRRESS VARCHAR2(50)
CITY VARCHAR2(25)
You want to display detalls of all castomers who reside in cities starting with the letter D followed by at least two
Character
Which query can be used?

A、 SELECT * FROM customers WHERE city = 'D_%';

B、 SELECT * FROM customers WHERE city = '%D_';

C、 SELECT * FROM customers WHERE city LIKE 'D_%';

D、 SELECT * FROM customers WHERE city LIKE 'D_';

查看答案

单选题 You have been tasked to create a table for a banking application.
One of the columns must meet three requirements:
1) Be stored in a format supporting date arithmetic without using conversion functions
2) Store a loan period of up to 10 years
3) Be used for calculating interest for the number of days the loan remains unpaid
Which data type should you use?

A、 TIMESTAMP WITH TIMEZONE

B、 TIMESTAMP

C、 TIMESTAMP WITH LOCAL TIMEZONE

D、 INTERVAL YEAR TO MONTH

E、 INTERVAL DAY TO SECOND

查看答案

单选题 View the Exhibit and examine the structure of the SALES, CUSTOMERS, PRODUCTS, and TIMES tables.The
PROD_ID column is the foreign key in the SALES table, which references the PRODUCTS tableSimilarly, the
CUST_ID and TIME_ID columns are also foreign keys in the SALES table referencing the CUSTOMERS and
TIMES tables, respectively.Evaluate the following CREATE TABLE command:
CREATE TABLE new_sales(prod_id, cust_id, order_date DEFAULT SYSdateASSELECT prod_id,
Cust_id,time_idFROM sales;
Which statement is true regarding the above command?

A、 The NEW_SALES table would not get created because the DEFAULT value cannot be specified in the column definition.

B、 The NEW_SALES table would get created and all the NOT NULL constraints defined on the specified columns would be passed to the new table

C、 The NEW_SALES table would not get created because the column names in the CREATE TABLE commandand the SELECT clause do not match.

D、 The NEW_SALES table would get created and all the FOREIGN KEY constraints defined on the specified
Columns would be passed to the new table

查看答案

单选题 Examine the desciption of the EMPLOYEES table:
Nane Null Type
----------------------------------------------------------
EMP_ID NOT NUL NUMBER
EMP_NAME VARCHAR2 (40)
DEPT_ID NUMBER(2)
SALARY NUMBER(8,2)
JOIN_DATE DATE
Which query is valid?

A、 SELECT dept_id, join_date, SUM(salary) FROM employees GROUP BY dept_id, join_date;

B、 SELECT depe_id,join_date, SUM(salary) FROM employees GROUP BY dept_id:

C、 SELECT dept_id,MAX (AVG (salary)) FROM employees GROUP BY dept_id;

D、 SELECT dept_ id,AVG (MAX (salary)) FROM employees GROUP BY dapt_id;

查看答案

单选题 Examine the desaiption of the PRODUCT_INFORMATION table:
Name NULL? Type
------------------------------------------------------------------------
PROD_ID NOT NULL NUMBER(2)
PROD_NANE VARCRAR2 (10)
LIST_PRICE NUMBER(6,2)
Which query retrieves the number of products with a null list price?

A、 SELECT (COUNT(list_PRICE FERM Product_intormation WHERE list_price=NULL;

B、 SELECT Count(nvl( list_price,0) )FROM pruduct_information WHERE list_price is null;

C、 SELECT COUNT(DISTINCT last_PRICE FROM produet_infomation WHERE last_price is nulll.

D、 BELECT COUNT(list_PRICE from proceduct_information where list_price is NULL;

查看答案

单选题 Which statement is true regarding the SESSION_PRIVS dictionary view?

A、 It contains the object privileges granted to other users by the current user session.

B、 It contains the system privileges granted to other users by the current user session.

C、 It contains the current system privileges available in the user session.

D、 It contains the current object privileges available in the user session.

查看答案

单选题 Examine this query:
SELECT 2 FROM dual d1 CROSS JOIN dual d2 CROSS JOIN dual d3;
What is returned upon execution?

A、 no rows

B、 an error

C、 8 rows

D、 6 rows

E、 1 row

F、 3 rows

查看答案

单选题 Examine this query:
SELECT TRUNC (ROUND(156.00,-2),-1) FROM DUAL;
What is the result?

A、 16

B、 160

C、 150

D、 200

E、 100

查看答案