The SALES_Q1 and USERS tablespaces exist in one of your databases and TEMP is a temporary tablespace. Segment creation is not deferred. You execute this command: Which three statements must be true so that the SALES user can create tables…
View the Exhibit and examine the structure of the PRODUCTS table. Which two tasks require subqueries? (Choose two.) A. Display the number of products whose PROD_LIST_PRICE is more than the average PROD_LIST_PRICE B. Display suppliers whose PROD_LIST_PRICE is less than…
Which three statements are true about Oracle synonyms? (Choose three.) A. A synonym cannot be created for a PL/SQL package B. A synonym can be available to all users C. A SEQUENCE can have a synonym D. A synonym created…
Which three statements are true regarding indexes? (Choose three.) A. A UNIQUE index can be altered to be non-unique B. A SELECT statement can access one or more indices without accessing any tables C. A table belonging to one user…
A script abc.sql must be executed to perform a job. A database user HR, who is defined in this database, executes this command: $ sqlplus hr/hr@orcl @abc.sql What will happen upon execution? A. The command succeeds and HR will be…
Examine these commands: Which two statements are true about the sqlldr execution? (Choose two.) A. It overwrites data in EMP with data in EMP.DAT B. It uses the database buffer cache to load data C. It generates a log that…
Which two are true about shrinking a segment online? (Choose two.) A. It is not possible to shrink either indexes or Index Organized Tables (IOTs) B. It always eliminates all migrated rows if any exist in the table C. To…
Your database instance was shut down normally and then started in NOMOUNT state. You then execute this command: ALTER DATABASE MOUNT; Which two actions are performed? (Choose two.) A. The online redo logs are opened B. The online data files…
Which statement is true about aggregate functions? A. Aggregate functions can be nested to any number of levels B. The AVG function implicitly converts NULLS to zero C. Aggregate functions can be used in any clause of a SELECT statement…
The CUSTOMERS table has a CUST_CREDIT_LIMIT column of data type NUMBER. Which two queries execute successfully? (Choose two.) A. SELECT NVL(cust_credit_limit * .15, ‘Not Available’) FROM customers; B. SELECT NVL2(cust_credit_limit * .15, ‘Not Available’) FROM customers; C. SELECT NVL(TO_CHAR(cust_credit_limit *…