Evaluate the following SQL statement

多选题 Evaluate the following SQL statement:
SQL> select cust_id, cust_last_name "Last name" FROM customers
WHERE country_id = 10 UNION
SELECT cust_id CUST_NO, cust_last_name FROM customers
WHERE country_id = 30
Identify three ORDER BY clauses either one of which can complete the query.

A、 ORDER BY "Last name"

B、 ORDER BY 2, cust_id

C、 ORDER BY CUST_NO

D、 ORDER BY 2, 1

E、 ORDER BY "CUST_NO"

查看答案

下载APP答题

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

相关试题

多选题 Which three commands execute successfully on PRODUCTS?

A、 CREATE INDEX price_idx on products (price);

B、 ALTER TAELE products DROP COLUMN expiry_date;

C、 ALTER TABLE products SET UNUSED(expiry_date);

D、 TRUNCATE TABLE products;

E、 ALTER TABLE products DROP UNUSED COLUMNS

F、 DROP TABLE products

查看答案

单选题 choose one
Which statement is true about the DEFAULT profile?

A、 It can be dropped and recreated.

B、 It must be explicitly assigned to a user.

C、 The values assigned to the resource limits and password parameters in the default profile can be altered.

D、 A different DEFAULT profile can be created for each user in a database.

查看答案

多选题 Choose three
Which three are true about dropping columns from a table?

A、 A column drop is implidtly committed

B、 A column can be removed only if it contains no data.

C、 A column that is referenced by another column in any other table cannot be dropped.

D、 A column must be set as unused before it is dropped from a table.

E、 E A primary key column cannot be dropped.

F、 Multiple columns can be dropped simultaneously using the ALTER TABLE command.

查看答案

单选题 A user establishes a connection to a database instance by using an Oracle Net connection.
You want to ensure the following:
The user account must be locked after five unsuccessful login attempts.
Data read per session must be limited for the user.
The user cannot have more than three simultaneous sessions.
The user must have a maximum of 10 minutes session idle time before being logged off automatically.
How would you accomplish this?

A、 by granting a secure application role to the user

B、 by implementing Database Resource Manager

C、 by using Oracle Label Security options

D、 by assigning a profile to the user

查看答案

单选题 You want to use table compression suitable for OLTP that will:
Compress rows for all DML statements on that table
Minimize the overheads associated with compression Which compression option is best suited for this?

A、 COLUMN STORE COMPRESS FOR QUERY LOW

B、 ROW STORE COMPRESS BASIC

C、 COLUMN STORE COMPRESS FOR ARCHIVE LOW

D、 COLUMN STORE COMPRESS FOR ARCHIVE HIGH

E、 ROW STORE COMPRESS ADVANCED

查看答案

单选题 You are administering a database and you receive a requirement to apply t he following restrictions:
A connection must be terminated after four unsuccessful login attempts by user.
A user should not be able to create more than four simultaneous sessions.
User session must be terminated after 15 minutes of inactivity.
Users must be prompted to change their passwords every 15 days.
How would you accomplish these requirements?

A、 by granting a secure application role to the users

B、 by creating and assigning a profile to the users and setting the REMOTE_OS_AUTHENT parameter to FALSE

C、 By creating and assigning a profile to the users and setting the FAILED_LOGIN_ATTEMPTS parameter to 4

D、 By Implementing Fine-Grained Auditing (FGA) and setting the REMOTE_LOGIN_PASSWORD_FILE parameter to NONE.

E、 By implementing the database resource Manager plan and setting the SEC_MAX_FAILED_LOGIN_ATTEMPTS parameters to 4.

查看答案

单选题 In your database, you want to ensure that idle sessions that are blocking active are that are blocking active are
Automatically terminated after a specified period of time. How would you accomplish this?

A、 Setting a metric threshold

B、 Implementing Database Resource Manager

C、 Enabling resumable timeout for user sessions

D、 Decreasing the value of t he IDLE_TIME resource limit in t he default profile

查看答案

单选题 choose one
Which statement is true about profiles?

A、 Resource limits specified in a profile assigned to a user are always enabled.

B、 A profile can be assigned only to one user.

C、 Password management using profiles is always enabled.

D、 A user can exist without any profile.

查看答案