Choose two.Which two statements are

多选题
Choose two.
Which two statements are true about views?

A、 Views can be updated without the need to re-grant privileges on the view.

B、 Views can be indexed.

C、 A view must only refer to tables in its defining query.

D、 The WITH CHECK clause prevents certain rows from being displayed when querying the
View.

E、 The WITH CHECK clause prevents certain rows from being updated or inserted in the
Underlying table through the view.

查看答案

下载APP答题

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

相关试题

单选题 A database is configured to use automatic undo management with temporary undo enabled.
An UPDATE is executed on a temporary table.
Where is the UNDO stored?

A、 in the undo tablespace

B、 in the SYSAUX tablespace

C、 in the SGA

D、 in the PGA

E、 in the temporary tablespace

查看答案

单选题 In the spfile of a single instance database, LOCAL_LISTENER is set to LISTENER_1.
The TNSNAMES.ORA file in $ORACLE_HOME/network/admin in the database home contains:

Which statement is true?

A、 Dynamic service registration cannot be used for this database instance

B、 The LREG process registers services dynamically with the LISTENER_1 listener

C、 LISTENER_1 must also be defined in the LISTENER.ORA file to enable dynamic service registration

D、 There are two listeners named LISTENER and LISTENER_1 running simultaneously using port
1521 on the same host as the database instances

E、 The definition for LISTENER_1 requires a CONNECT_DATA section to enable dynamic service
Registration

查看答案

单选题 choose the best anuswer Evaluate the following SQL statement:
ALTER TABLE hr.emp
SET UNUSED (mgr_iD.;
Which statement is true regarding the effect of the above SQL statement?

A、 Any views created on the EMP table that include the MGR_ID column would be automatically
Modified and remain valid.

B、 Any constraints defined on the MGR_ID column would be removed by the above command.

C、 Any synonym existing on the EMP table would have to be re-created.

D、 Any index created on the MGR in column would continue to exist until the DROP UNUSED
COLUMNS command is executed.

查看答案

单选题 Evaluate the following ALTER TABLEstatement:
ALTER TABLE orders SET UNUSED (order_datE.;
Which statement is true?

A、 After executing the ALTER TABLEcommand, you can add a new column called ORDER_DATE to
The ORDERS table.

B、 The ORDER_DATE column should be empty for the ALTER TABLE command to execute
Succsessfully.

C、 ROLLBACK can be used to get back the ORDER_DATE column in the ORDERStable.

D、 The DESCRIBE command would still display the ORDER_DATE column.

查看答案

单选题 You want to write a query that prompts for two column names and the WHERE condition each
Time it is executed in a session but only prompts for the table name the first time it is executed.
The variables used in your query are never undefined in your session.
Which query can be used?

A、 SELECT &&col1, &&col2FROM &table WHERE &&condition = &&cond;

B、 SELECT &col1, &col2FROM &&table WHERE &condition;

C、 SELECT &col1, &col2FROM “&table” WHERE &condition;

D、 SELECT ‘&&col1’, ‘&&col2’FROM &table WHERE ‘&&condition’ = ‘&cond’;

E、 SELECT &&col1, &&col2FROM &table WHERE &&condition;

查看答案

单选题 Which statement is true about the INTERSECT operator used in compound queries?

A、 Multiple INTERSECT operators are not possible in the same SQL statement

B、 It processes NULLs in the selected columns

C、 INTERSECT is of lower precedence than UNION or UNION ALL

D、 It ignores NULLs

查看答案

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

A、 INTERVAL YEAR TO MONTH

B、 INTERVAL DAY TO SECOND

C、 TIMESTAMP WITH LOCAL TIMEZONE

D、 TIMESTAMP

E、 TIMESTAMP WITH TIMEZONE

查看答案

单选题 Examine the description of the CUSTOMERS table:

You want to display details of all customers who reside in cities starting with the letter D followed
By at least two characters.
Which query can be used?

A、 SELECT * FROM customers WHERE city LIKE ‘D_%’;

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

C、 SELECT * FROM customers WHERE city LIKE ‘D_’;

D、 SELECT * FROM customers WHERE city = ‘D_%’;

查看答案