quanta ocp

Question no: 1 Evaluate the SQL statement: Truncate table dept; Which three are true about the SQL statement? (Choose three .) A. It releases the storage space used by the table. B. It does not release the storage space used by the table. C. You can

586. Consider the following command: Backup database plus archivelog delete input; How many backup sets wocould be created by this command if the following were true: Control-file auto backups were enabled. The size of backup sets was not restricted.

400. Which of the following methods can be used to detect block upload uption? A. ANALYZE operations B. dbv C. SQL queries that access the potentially encrypted upt block D. RMAN E. All of the above Answer: E Answer: Reference:

Users are connected to a database instance, which is using Automatic Storage Management (ASM).The DBA executes the command as follows to shut down the ASM instance: Users connect to a DB instance, using Automatic storage Management (ASM).The DBA

QUESTION 68You have three temporary tablespace groups named G1, G2, and G3 in your database. You areCreating a new temporary tablespace as follows:CREATE temporary tablespace TEMP1 tempfile '/u1/data/temp1.dbf ' SIZE 10M tablespaceGROUP ";Which

QUESTION 63Which method would the changes made by a particular transaction without affectingThe changes made by other transactions?A. Point-in-time RecoveryB. Execute the ROLLBACK command with transaction numberC. Flashback the database to before

Preface Aside from a few questions, I am a little satisfied with all the series of blog posts. For my own monograph, I will post an Oracle blog every day, and other blog posts will be posted in my spare time. Click Database Configuration

Preface If we have some experience in starting and stopping databases, we always think that there is only one command. However, I have seen a book with more than 100 pages dedicated to the operation process after the command. Let's just talk a

Every day is a repeat of 2.1 lines. The work is boring, and the work described above is done. The technology used is also the same. It has been used since its entry into the company, never changed. Without passion, it's just a groose job. Every day,

1. backup and recovery problems The final result of considering business needs, performance, and capital costs is usually a compromise. It is extremely important to record this scheme, usually in the form of a service level agreemenet ). The service

121. you want to create a new optimized database for your transactional production environment to be used by a financial application. while creating the database, you want the Oracle software to take care of all basic settings to optimize the

Statement: the answer is a personal understanding of Oracle. 1. Because of a power outage, instance failure has occurred. From what point in the redo log does recovery in and where does it end? A. Current redo log and inactive redo log B. Checkpoint

33.You want to create an ORD_DETAIL table to store details for an order placed having the following business requirement:1) The order ID will be unique and cannot have null values.2) The order date cannot have null values and the default shocould be

21. Examine the description of the EMP_DETAILS table given below:Name NULL TYPEEMP_ID NOT NULL NUMBEREMP_NAME not null VARCHAR2 (40)EMP_IMAGE LONGWhich two statements are true regarding SQL statements that can be executed on the EMP_DETAIL table?

6. Examine the structure of the SHIPMENTS table: Name Null Type PO_ID not null number (3) PO_DATE NOT NULL DATE SHIPMENT_DATE NOT NULL DATE SHIPMENT_MODE VARCHAR2 (30) SHIPMENT_COST NUMBER (8, 2) You want to generate a report that displays the PO_ID

24. Examine the structure proposed for the TRANSACTIONS table:Name Null TypeTRANS_ID not null number (6)CUST_NAME not null VARCHAR2 (20)CUST_STATUS not null VARCHAR2TRANS_DATE NOT NULL DATETRANS_VALIDITY INTERVAL DAY TO SECONDCUST_CREDIT_VALUE

12. You need to produce a report where each customer's credit limit has been incremented by $1000. InThe output, the customer's last name shoshould have the heading Name and the incremented credit limitShocould be labeled New Credit Limit. The

13. View the Exhibit and examine the structure of the PRODUCTS table. You need to generate a report in the following format:CATEGORIES5MP Digital Photo Camera's category is PhotoY Box's category is ElectronicsEnvoy Ambassador's category is

1 about undoThe database can have more than one undo tablespace;Undo segments can automatically grow, shrink on demand 2 about Oracle Data Dump export and importYou can change the table name during the import operation;You can override an existing

Exercise 2-1 Installing SQL Developer on a Windows computerIn this exercise, you will install SQL Developer on a Windows computer1. Download the current SQL Developer version from the following