A store can only have one sales catalog.
A sales catalog is used to bundle similar products.
A sales catalog may be used to place a product in more than one category.
Every store must have a sales catalog.
第1题:
A. You can use RMAN stored scripts
B. Recovery is faster if data is stored in catalog in addition to the control file
C. You can store backup information of all registered databases in one place
D. Database backups are automatically deleted when they are older than the specified time period
第2题:
第3题:
Identity two advantages of using a recovery catalog in-load of the control File of the target database Recovery Manager (RMAN).()
第4题:
Which statement is false about sales catalogs?()
第5题:
The CALC function is used several times within the sales report. To simplify maintenance you want to store the function in one place and call it from within your PL/SQL trigger code. Which node would you use in object navigator to create a report level programme unit to store the function?()
第6题:
Your database is running in NOARCHIVELOG mode with two online redo log files. The SALES table contains sales information for the organization. The SALES table belongs to the SALESTB tablespace. On Monday, you insert 10 rows into the SALES table. The current log sequence number is 14. You change the tablespace status from READ WRITE to READ ONLY for the SALESTB tablespace. You shut down the database and take a backup of the SALESTB tablespace. On Tuesday, you start the database. You change the status for the SALESTB tablespace from READ ONLY to READ WRITE. You insert 10 more rows into the SALES table and shut down the database. The current log sequence number is 15. When you try to open the database on Wednesday morning, you discover that the SALESTB tablespace was lost because of a media failure. Which of the following options is true about recovering the SALES table?()
第7题:
Examine the following statement that is used to modify the constraint on the SALES table: SQL> ALTER TABLE SALES MODIFY CONSTRAINT pk DISABLE VALIDATE; Which three statements are true regarding the above command()
第8题:
第9题:
There can be more than one master catalog for a store
A sales catalog is a subset of the master catalog
The master catalog is the central place for the stores merchandise
There can be more than one sales catalog for a store
Multiple stores can share a master catalog
第10题:
The SALES table cannot be recovered because the database is running in NOARCHIVELOG mode.
The SALES table can be recovered by restoring the SALESTB tablespace from the backup and performing a media recovery.
The SALES table can be recovered by restoring the SALESTB tablespace from the backup without performing any media recovery.
The SALES table can be recovered by restoring the SALESTB tablespace from the backup, but the rows inserted on Tuesday need to be inserted again.
第11题:
A subquery should retrieve only one row.
A subquery can retrieve zero or more rows.
A subquery can be used only in SQL query statements.
Subqueries CANNOT be nested by more than two levels.
A subquery CANNOT be used in an SQL query statement that uses group functions.
When a subquery is used with an inequality comparison operator in the outer SQL statement, the column list in the SELECT clause of the subquery should contain only one column.
第12题:
New Mexico than in Massachusetts
Massachusetts than in New Mexico
Massachusetts than any other nine states
the District of Columbia than in Massachusetts
第13题:
As for "distressed sales", which of the following statements is TRUE?( )
[A] It occupies 35% to 40% of the whole house sales in the history.
[B] It is made up of both the foreclosed homes and short sales.
[C] It prevents people from selling their houses too cheaply.
[D] It has little influence on the formerly prosperous housing market.
第14题:
Which of the following statements about a Sales Catalog is TRUE?()
第15题:
Which of the following statements is false?()
第16题:
Which of the following statements about a Master Catalog is FALSE?()
第17题:
Which two statements about subqueries are true? ()
第18题:
Indentify two advantages of using recovery catalog instead of the control file of the database in RecoveryManager (RMAN).()(Choose two.)
第19题:
Indentify two advantages of using recovery catalog instead of the control file of the database in Recovery Manager (RMAN).()
第20题:
The Master Catalog must be a proper tree.
The product management tools work with a Master Catalog.
A product cannot belong to more than one category.
A store may have more than one Master Catalog.
第21题:
Programme units.
PL/SQL libraries.
Database object.
Built in packages.
第22题:
Sales catalogs are used for customer display purposes.
With a sales catalog products can be placed in many locations.
If sales catalogs are used then it is not necessary to have a master catalog.
Sales catalogs can be used to target specific customer segments.
Sales catalogs can be used to control what products a customer can see.
第23题:
$31.20
$25.00
$24.00
$21.84
$19.50