QUESTION 234 Q73In one of your databases, user KING is: 1. Not a DBA user 2. An operating system ( OS) user Examine this command and its output: What must you do so that KING is authenticated by the OS when connecting to the database instance?

QUESTION 237 Which statement is true about the INTERSECT operator used in compound queries?

QUESTION 240 .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?

QUESTION 241 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?

QUESTION 242 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?

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?

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?

Evaluate the following ALTER TABLEstatement: ALTER TABLE orders SET UNUSED (order_date); Which statement is true?

choose the best answer 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?

choose one Which statement is true about profiles?

choose one Which statement is true about the DEFAULT profile?

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

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

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

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