摘要：
Which mode of database shutdown requires an instance recovery at the time of the next database startup?A.ABORTB.NORMALC.IMMEDIATED.TRANSACTIONAL 数据库在关 阅读全文
posted @ 2017-11-15 17:47
巴啦啦大魔王
阅读(126)
评论(0)
推荐(0)
摘要：
View the Exhibit and examine the output of the query in different times when the following command runs in an RMAN sessions:RMAN> BACKUP DATABASE FILE 阅读全文
posted @ 2017-11-15 17:44
巴啦啦大魔王
阅读(113)
评论(0)
推荐(0)
摘要：
Which two statements are true about encrypting RMAN backup? (Choose two.)A. The transparent encryption of backups uses the encryption walletB. The dat 阅读全文
posted @ 2017-11-15 17:41
巴啦啦大魔王
阅读(109)
评论(0)
推荐(0)
摘要：
Which option is best practice for creating a recovery catalog owner in the catalog database? A. Granting UNLIMITED QUOTA on the SYSTEM tablespace to t 阅读全文
posted @ 2017-11-15 17:40
巴啦啦大魔王
阅读(103)
评论(0)
推荐(0)
摘要：
The database is running in the ARCHIVELOG mode. It has three redo log groups with one membereach. One of the redo log groups has become corrupted. You 阅读全文
posted @ 2017-11-15 17:39
巴啦啦大魔王
阅读(83)
评论(0)
推荐(0)
摘要：
In Recovery Manager (RMAN), you are taking image copies of the data files of your productiondatabase and rolling them forward at regular intervals. Yo 阅读全文
posted @ 2017-11-15 17:37
巴啦啦大魔王
阅读(119)
评论(0)
推荐(0)
摘要：
Which options must you configure while performing an automated Tablespace Point-in-Time Recovery (TSPITR) by using Recovery Manager (RMAN)?A. New chan 阅读全文
posted @ 2017-11-15 17:34
巴啦啦大魔王
阅读(187)
评论(0)
推荐(0)
摘要：
Your database is running in ARCHIVELOG mode.One of the data files,USERDATA01.dbf,inthe USERS tablespace is damaged and you need to recover the file un 阅读全文
posted @ 2017-11-15 17:20
巴啦啦大魔王
阅读(164)
评论(0)
推荐(0)
摘要：
You work with a newly created database. Presently, there is no application load on the database instance. You want to create a baseline for tuning the 阅读全文
posted @ 2017-11-15 17:17
巴啦啦大魔王
阅读(103)
评论(0)
推荐(0)
摘要：
You issued the following commands to configure setting in RMAN;RMAN> CONFIGURE DEVICE TYPE sbt PARALLELISM 1;RMAN> CONFIGURE DEFAULT DEVICE TYPE TO sb 阅读全文
posted @ 2017-11-15 17:16
巴啦啦大魔王
阅读(162)
评论(0)
推荐(0)
摘要：
You need to maintain a record of all transactions on some tables for at least three years. Automatic undo management is enabled for the database.What 阅读全文
posted @ 2017-11-15 17:14
巴啦啦大魔王
阅读(147)
评论(0)
推荐(0)
摘要：
Which are the two prerequisites before setting up Flashback Data Archive? (Choose two.)A.Flash recovery area must be definedB.Undo retention guarantee 阅读全文
posted @ 2017-11-15 17:13
巴啦啦大魔王
阅读(108)
评论(0)
推荐(0)
摘要：
You have enabled backup optimization for the RMAN environment. Identify two criteria on which RMAN will skip the file, if it has already been backed u 阅读全文
posted @ 2017-11-15 17:09
巴啦啦大魔王
阅读(127)
评论(0)
推荐(0)
摘要：
You are using the control file to maintain information about the database backups that are being performed by Recovery Manager (RMAN).Identify two sce 阅读全文
posted @ 2017-11-15 17:07
巴啦啦大魔王
阅读(146)
评论(0)
推荐(0)
摘要：
View the Exhibit and note the contents of V$DIAG_INFO.Which statement is true about the ADR? A. The text alert log file will be available in Diag Trac 阅读全文
posted @ 2017-11-15 17:06
巴啦啦大魔王
阅读(82)
评论(0)
推荐(0)
摘要：
You want to set the following initialization parameters for your database instance:LOG_ARCHIVE_DEST_1 = 'LOCATION=/disk1/arch' LOG_ARCHIVE_DEST_2 ='LO 阅读全文
posted @ 2017-11-15 17:04
巴啦啦大魔王
阅读(89)
评论(0)
推荐(0)
摘要：
A database instance is using an Automatic Storage Management (ASM) instance, which has a disk group, DGROUP1, created as follows:SQL> CREATE DISKGROUP 阅读全文
posted @ 2017-11-15 17:03
巴啦啦大魔王
阅读(116)
评论(0)
推荐(0)
摘要：
The EMP table has some discrepancy in data entry with a particular employee ID. You execute thequery as shown in the Exhibit to retrieve all versions 阅读全文
posted @ 2017-11-15 17:01
巴啦啦大魔王
阅读(78)
评论(0)
推荐(0)
摘要：
Before a Flashback Table operation, you execute the following command:ALTER TABLE employees ENABLE ROW MOVEMENT;Why would you need this to be executed 阅读全文
posted @ 2017-11-15 16:59
巴啦啦大魔王
阅读(103)
评论(0)
推荐(0)
摘要：
Which three types of files can be automatically placed in the flash recovery area (fast recovery area in 11g Release 2)?(Choose three.)A. Alert log fi 阅读全文
posted @ 2017-11-15 16:58
巴啦啦大魔王
阅读(123)
评论(0)
推荐(0)
摘要：
You want to use the automatic management of backup and recovery operations features for your database.Which configuration must you set?A. Enable the f 阅读全文
posted @ 2017-11-15 16:11
巴啦啦大魔王
阅读(157)
评论(0)
推荐(0)
摘要：
Examine the following command used to perform incremental level 0 backup:RMAN> BACKUP INCREMENTAL LEVEL 0 DATABASE;To enable the block change tracking 阅读全文
posted @ 2017-11-15 16:10
巴啦啦大魔王
阅读(90)
评论(0)
推荐(0)
摘要：
To accomplish user-managed backup for the USERS tablespace, you issued the following command to put the database in backup mode:SQL> ALTER TABLESPACE 阅读全文
posted @ 2017-11-15 16:09
巴啦啦大魔王
阅读(103)
评论(0)
推荐(0)
摘要：
Exhibit: View the Exhibit to examine the parameter values. You are planning to set the value for theMEMORY_TARGET parameter of your database instance. 阅读全文
posted @ 2017-11-15 16:07
巴啦啦大魔王
阅读(120)
评论(0)
推荐(0)
摘要：
View the Exhibit for the object interdependency diagram.The PRODUCTS table is used to create the PRODCAT_VW view. PRODCAT_VW is used in the GET_DATA p 阅读全文
posted @ 2017-11-15 16:04
巴啦啦大魔王
阅读(83)
评论(0)
推荐(0)
摘要：
Using the LIST command in Recovery Manager (RMAN), which two pieces of information in the RMAN repository can be listed? (Choose two.) A. stored scrip 阅读全文
posted @ 2017-11-15 16:02
巴啦啦大魔王
阅读(96)
评论(0)
推荐(0)
摘要：
Examine the following commands and their output:SQL> SELECT ename, sal FROM emp WHERE ename='JAMES';ENAME SAL JAMES 1050SQL> UPDATE emp SET sal=sal+sa 阅读全文
posted @ 2017-11-15 16:00
巴啦啦大魔王
阅读(104)
评论(0)
推荐(0)
摘要：
You are managing a 24*7 database. The backup strategy for the database is to perform user-managed backups. Identify two prerequisites to perform the b 阅读全文
posted @ 2017-11-15 15:58
巴啦啦大魔王
阅读(144)
评论(0)
推荐(0)
摘要：
Examine the following scenario:-Database is running in ARCHIVELOG mode.-Complete consistent backup is taken every Sunday.-On Tuesday the instance term 阅读全文
posted @ 2017-11-15 15:57
巴啦啦大魔王
阅读(131)
评论(0)
推荐(0)
摘要：
You are managing an Oracle Database 11g database. You want to take a backup on tape drives of the USERS tablespace that has a single data file of 900 阅读全文
posted @ 2017-11-15 15:52
巴啦啦大魔王
阅读(120)
评论(0)
推荐(0)
摘要：
Identify the channel settings that can be performed using the CONFIGURE CHANNEL or ALLOCATE CHANNEL commands in RMAN (choose all that apply)A. Limitin 阅读全文
posted @ 2017-11-15 15:48
巴啦啦大魔王
阅读(149)
评论(0)
推荐(0)
摘要：
What two are the prerequisites for enabling Flashback Database? (Choose two)A. The database must be in ARCHIVELOG modeB. The database must be in MOUNT 阅读全文
posted @ 2017-11-15 15:47
巴啦啦大魔王
阅读(122)
评论(0)
推荐(0)
摘要：
You realize that the control file is damaged in your production database. After restoring the control file from autobackup, what is the next step that 阅读全文
posted @ 2017-11-15 15:46
巴啦啦大魔王
阅读(113)
评论(0)
推荐(0)
摘要：
While performing a regular check on your recovery catalog you realized that the catalog database is running out of space and you do not have options t 阅读全文
posted @ 2017-11-15 15:44
巴啦啦大魔王
阅读(125)
评论(0)
推荐(0)
摘要：
On Friday at 11:30 am you decided to flash back the database because of a user error that occurred at 8:30 am.Which option must you use to check wheth 阅读全文
posted @ 2017-11-15 15:41
巴啦啦大魔王
阅读(110)
评论(0)
推荐(0)
摘要：
You performed the RMAN database backup with the KEEP option. Which two statements are true regarding this backup? (Choose two.)A. The backup contains 阅读全文
posted @ 2017-11-15 15:40
巴啦啦大魔王
阅读(73)
评论(0)
推荐(0)
摘要：
You need to perform a block media recovery on the tools01.dbf data file in the SALES database by using Recovery Manager (RMAN).Which two are the prere 阅读全文
posted @ 2017-11-15 15:36
巴啦啦大魔王
阅读(108)
评论(0)
推荐(0)
摘要：
Examine the following command that is used to duplicate a database on the same host:RMAN> RUN{ALLOCATE AUXILIARY CHANNEL, aux 1 DEVICE TYPE DISK;DUPLI 阅读全文
posted @ 2017-11-15 15:35
巴啦啦大魔王
阅读(76)
评论(0)
推荐(0)
摘要：
View the Exhibit and examine the steps that you executed to create a database resource plan. Subsequently, you execute the following procedure which r 阅读全文
posted @ 2017-11-15 15:34
巴啦啦大魔王
阅读(140)
评论(0)
推荐(0)
摘要：
You plan to execute the following command to perform a Flashback Database operation in your database:SQL> FLASHBACK DATABASE TO TIMESTAMP (SYSDATE -5/ 阅读全文
posted @ 2017-11-15 15:31
巴啦啦大魔王
阅读(113)
评论(0)
推荐(0)
摘要：
You are in the process of creating a Virtual Private Catalog (VPC) in your Oracle Database 11g database. The Prod1, Prod2 and Prod3 Oracle Database 10 阅读全文
posted @ 2017-11-15 15:30
巴啦啦大魔王
阅读(127)
评论(0)
推荐(0)
摘要：
Which two client requests are captured during database replay Capture? (Choose two)A. Flashback queriesB. Shared server requestsC. Login and logoff ac 阅读全文
posted @ 2017-11-15 15:26
巴啦啦大魔王
阅读(160)
评论(0)
推荐(0)
摘要：
The RECYCLEBIN parameter is set to ON for your database. You drop a table, PRODUCTS, from the SCOTT schema.Which two statements are true regarding the 阅读全文
posted @ 2017-11-15 15:24
巴啦啦大魔王
阅读(132)
评论(0)
推荐(0)
摘要：
Examine the following command:SQL> ALTER TABLE booking SHRINK SPACE COMPACT;Which activity is performed when the preceding command is executed?A. The 阅读全文
posted @ 2017-11-15 15:22
巴啦啦大魔王
阅读(144)
评论(0)
推荐(0)
摘要：
Examine the following scenario: The target database instance is running. The most recent backup available for the target database was taken two days a 阅读全文
posted @ 2017-11-15 15:21
巴啦啦大魔王
阅读(126)
评论(0)
推荐(0)
摘要：
Multiple RMAN sessions are connected to the database instance.Examine the following output when backup commands are running in server sessions: What c 阅读全文
posted @ 2017-11-15 15:18
巴啦啦大魔王
阅读(189)
评论(0)
推荐(0)
摘要：
The database is configured in ARCHIVELOG mode and regular complete database backups are taken.The loss of which two types of files may require a recov 阅读全文
posted @ 2017-11-15 15:16
巴啦啦大魔王
阅读(156)
评论(0)
推荐(0)
摘要：
You observed the following output for a user session: What do you infer from the preceding output?A. Resumable set for session with sid 18B. The user 阅读全文
posted @ 2017-11-15 15:14
巴啦啦大魔王
阅读(183)
评论(0)
推荐(0)
摘要：
Your database interface is running. A user SCOTT starts a SQL *Plus session, and issues the following query:SQL> SELECT * FROM sales;Which process wou 阅读全文
posted @ 2017-11-15 15:12
巴啦啦大魔王
阅读(266)
评论(0)
推荐(0)
摘要：
View the exhibit and examine the output. Which statement can be an inference from the output?Exhibit: A. The FRA disk group has an asynchronous I/O bo 阅读全文
posted @ 2017-11-15 15:10
巴啦啦大魔王
阅读(214)
评论(0)
推荐(0)
摘要：
You are using recovery Manager (RMAN) with a recovery catalog to backup up your production database. The backups and the archived redo log files are c 阅读全文
posted @ 2017-11-15 15:06
巴啦啦大魔王
阅读(115)
评论(0)
推荐(0)
摘要：
In your database, the flash recovery area (FRA) is configured as the default for RMAN backups. You executed the following commands to configure the se 阅读全文
posted @ 2017-11-15 15:04
巴啦啦大魔王
阅读(102)
评论(0)
推荐(0)
摘要：
You want to perform an RMAN backup of database as a copy. Which two factors will you consider while performing the backup operation? (Choose two).A. T 阅读全文
posted @ 2017-11-15 15:02
巴啦啦大魔王
阅读(91)
评论(0)
推荐(0)
摘要：
Your production database is running in archivelog mode and you are using recovery manager (RMAN) with recovery catalog to perform the database backup 阅读全文
posted @ 2017-11-15 15:00
巴啦啦大魔王
阅读(139)
评论(0)
推荐(0)
摘要：
What are the prerequisites for performing flashback transactions? (Choose all that apply)A.Supplemental log must be enabledB.Supplemental log must be 阅读全文
posted @ 2017-11-15 14:56
巴啦啦大魔王
阅读(130)
评论(0)
推荐(0)
摘要：
Which command creates an image copy?A. backup as copyB. backup copyC. copy as backupD. copy back 阅读全文
posted @ 2017-11-15 14:52
巴啦啦大魔王
阅读(113)
评论(0)
推荐(0)
摘要：
Why does the number of blocks for the table remain the sale after the shrink operation?A.Because the table did not contain migrated or chained rows B. 阅读全文
posted @ 2017-11-15 14:26
巴啦啦大魔王
阅读(136)
评论(0)
推荐(0)
摘要：
The following command is executed to shut down an Automatic Storage Management (ASM) instance:SQL>SHUTDOWN ABORT;Which two statements describe the con 阅读全文
posted @ 2017-11-15 14:15
巴啦啦大魔王
阅读(108)
评论(0)
推荐(0)
摘要：
You executed the following commands in a database session: Which statement is true about the contents of the recycle bin in this situation?A.They rema 阅读全文
posted @ 2017-11-15 14:14
巴啦啦大魔王
阅读(135)
评论(0)
推荐(0)
摘要：
A database has three online redo log groups with one member each. A redo log member with the status ACTICE is damages while the database is running.Wh 阅读全文
posted @ 2017-11-15 14:12
巴啦啦大魔王
阅读(123)
评论(0)
推荐(0)
摘要：
You executed the following query: Considering that all the redo logs are available, what information can you derive from the output of the preceding q 阅读全文
posted @ 2017-11-15 14:11
巴啦啦大魔王
阅读(119)
评论(0)
推荐(0)
摘要：
Because of a logical corruption in the EMPLOYES tables, you want to perform Tablespace Point-in-Time Recovery (TSPITR) to recover the table. Before yo 阅读全文
posted @ 2017-11-15 14:10
巴啦啦大魔王
阅读(133)
评论(0)
推荐(0)
摘要：
You execute the following command to set the redundancy retention policy in Recovery Manager(RMAN):RMAN> CONFIGURE RETENTION POLICY TO REDUNDANCY 3;Id 阅读全文
posted @ 2017-11-15 14:09
巴啦啦大魔王
阅读(104)
评论(0)
推荐(0)
摘要：
View Exhibit1 to examine the DATA disk group when all the disks are online. Why is the rebalancing not performed and the content of the disk group not 阅读全文
posted @ 2017-11-15 14:07
巴啦啦大魔王
阅读(131)
评论(0)
推荐(0)
摘要：
View the Exhibit and examine the data manipulation language (DML) operations that you performed on the NEWEMP table. Note that the first two updated a 阅读全文
posted @ 2017-11-15 14:02
巴啦啦大魔王
阅读(141)
评论(0)
推荐(0)
摘要：
Given below are RMAN commands to enable backup optimization and set the retention policy: The USERS tablespace has never been backed up. You take the 阅读全文
posted @ 2017-11-15 14:00
巴啦啦大魔王
阅读(130)
评论(0)
推荐(0)
摘要：
View the Exhibit and examine the parameter settings in your server-side parameter file (SPFILE). When you tried to start the database instance, you re 阅读全文
posted @ 2017-11-15 13:58
巴啦啦大魔王
阅读(139)
评论(0)
推荐(0)
摘要：
A user receives the following error while performing a large volume of inserts into a table: The issue is resolved by increasing the space quota on th 阅读全文
posted @ 2017-11-15 13:55
巴啦啦大魔王
阅读(158)
评论(0)
推荐(0)
摘要：
Which two statements are true about a duplicate database that is created by using the DUPLICATE command in RMAN? (Choose two.)A.It is a copy or a subs 阅读全文
posted @ 2017-11-15 13:53
巴啦啦大魔王
阅读(145)
评论(0)
推荐(0)
摘要：
Your database is using a default temporary tablespace that contains the temp01.tmp temporary file.All the users on the database use the default tempor 阅读全文
posted @ 2017-11-15 13:52
巴啦啦大魔王
阅读(153)
评论(0)
推荐(0)
摘要：
In your production database, you:-Are using Recovery Manager (RMAN) with a recovery catalog to perform the backup operation at regular intervals-Set t 阅读全文
posted @ 2017-11-15 13:50
巴啦啦大魔王
阅读(151)
评论(0)
推荐(0)
摘要：
Which statement is true about a Scheduler-generated event?A. It can be generated when a file arrives on the file system.B. it indicates state changes 阅读全文
posted @ 2017-11-15 13:48
巴啦啦大魔王
阅读(135)
评论(0)
推荐(0)
摘要：
Examine the following command for RMAN backup: Which statement Is true regarding the approach in the command?A.The RMAN multiplexing level is 4.B.It i 阅读全文
posted @ 2017-11-15 13:46
巴啦啦大魔王
阅读(106)
评论(0)
推荐(0)
摘要：
Identify two options that Oracle recommends while configuring the backup and recovery environment for your recovery catalog. (Choose two.)A. configuri 阅读全文
posted @ 2017-11-15 13:45
巴啦啦大魔王
阅读(129)
评论(0)
推荐(0)
摘要：
As part of archiving the historical data, you want to transfer data from one database to anotherdatabase, which is on another server. All tablespaces 阅读全文
posted @ 2017-11-15 13:44
巴啦啦大魔王
阅读(151)
评论(0)
推荐(0)
摘要：
Which two statements are true about an image copy backup? (Choose two.)A. It may only be taken to disk.B. It will contain only the used blocks.C. It w 阅读全文
posted @ 2017-11-15 13:40
巴啦啦大魔王
阅读(129)
评论(0)
推荐(0)
摘要：
Your company wants to upgrade the production database to a Real Application Clusters (RAC)environment. You set up the best RAC database and want to re 阅读全文
posted @ 2017-11-15 13:39
巴啦啦大魔王
阅读(572)
评论(0)
推荐(0)
摘要：
You work in a data warehouse environment that involves the execution of complex queries. The current content of the SQL cache contains the ideal workl 阅读全文
posted @ 2017-11-15 13:37
巴啦啦大魔王
阅读(112)
评论(0)
推荐(0)
摘要：
The database users regularly complain about the difficulty in performing transactions. On investigation, you find that some users perform long-running 阅读全文
posted @ 2017-11-15 13:35
巴啦啦大魔王
阅读(95)
评论(0)
推荐(0)
摘要：
View the Exhibit and examine the RMAN commands. Which statement describes the effect of a backup retention policy on the backup of a backup set?A.Eith 阅读全文
posted @ 2017-11-15 13:31
巴啦啦大魔王
阅读(115)
评论(0)
推荐(0)
摘要：
Which two statements are true about the compressed backups in RMAN? (Choose two.)A.Compressed backups can only be taken on the tape drives.B.The binar 阅读全文
posted @ 2017-11-15 13:30
巴啦啦大魔王
阅读(175)
评论(0)
推荐(0)
摘要：
Users are connected to a database instance that is using Automatic Storage Management (ASM).The DBA executes the command as follows to shut down the A 阅读全文
posted @ 2017-11-15 13:26
巴啦啦大魔王
阅读(150)
评论(0)
推荐(0)
摘要：
You execute the following FLASHBACK TABLE command: Which two statements are correct?(Choose two.)A.The EMP table that was dropped by mistake earlier i 阅读全文
posted @ 2017-11-15 13:25
巴啦啦大魔王
阅读(140)
评论(0)
推荐(0)
摘要：
In your test database:-You are using Recovery Manager (RMAN) to perform incremental backups of your test database-The test database is running in NOAR 阅读全文
posted @ 2017-11-15 13:14
巴啦啦大魔王
阅读(88)
评论(0)
推荐(0)
摘要：
Your database is running in ARCHIVELOG mode. You have been taking backups of all the data files and control files regularly.You are informed that some 阅读全文
posted @ 2017-11-15 11:39
巴啦啦大魔王
阅读(147)
评论(0)
推荐(0)
摘要：
Your production database it functional on the SHOST1 host. You are backing up the productiondatabase by using Recovery Manager (RMAN) with the recover 阅读全文
posted @ 2017-11-15 11:33
巴啦啦大魔王
阅读(139)
评论(0)
推荐(0)
摘要：
Identify the scenarios in which the RMAN CROSSCHECK comm and is useful. (Choose all that apply.)A.To check that the obsolete backups are deleted from 阅读全文
posted @ 2017-11-15 11:22
巴啦啦大魔王
阅读(174)
评论(0)
推荐(0)
摘要：
The environmental variable ORACLE-BASE is set. You want to check the diagnostic files created as part of the Automatic Diagnostic Repository (ADR). Vi 阅读全文
posted @ 2017-11-15 11:17
巴啦啦大魔王
阅读(101)
评论(0)
推荐(0)
摘要：
Which two operations are NOT performed by the DUPLICATE command in Recovery Manager (RMAN) while duplicating a running database? (Choose Two)A.Creatin 阅读全文
posted @ 2017-11-15 11:15
巴啦啦大魔王
阅读(147)
评论(0)
推荐(0)
摘要：
Which of the following is not a valid linguistic sort element?A. Accent expansionB. Canonical equivalenceC. Reverse secondary sortingD. Ignorable char 阅读全文
posted @ 2017-11-15 10:59
巴啦啦大魔王
阅读(117)
评论(0)
推荐(0)
摘要：
What is the name of the file that identifies the set of available locale definitions?A. locale.defB. lxdef.oraC. lx1boot.nlbD. lx1boot.oraE. lang.def 阅读全文
posted @ 2017-11-15 10:56
巴啦啦大魔王
阅读(167)
评论(0)
推荐(0)
摘要：
Case-insensitive sorts are always accent insensitive by default.A. TrueB. False Accent-insensitive sorts are always case insensitive,not the other way 阅读全文
posted @ 2017-11-15 10:54
巴啦啦大魔王
阅读(90)
评论(0)
推荐(0)
摘要：
Which NLS parameter directly governs linguistic searches?A. NLS_SEARCH_LB. NLS_SORTC. NLS_SEARCHD. NLS_SORT_LE. None of the above Linguistic searches 阅读全文
posted @ 2017-11-15 10:51
巴啦啦大魔王
阅读(68)
评论(0)
推荐(0)
摘要：
How many different calendars does Oracle 11g support?A. 22 B. 7C. 6D. 15E. 2 Oracle supports seven distinct calendars:Gregorian,Japanese Imperial,ROC 阅读全文
posted @ 2017-11-15 10:49
巴啦啦大魔王
阅读(96)
评论(0)
推荐(0)
摘要：
Which is not a valid locale definition file type?A. LanguageB. Linguistic sortC. CalendarD. TerritoryE. Character set Calendar definitions are not sto 阅读全文
posted @ 2017-11-15 10:46
巴啦啦大魔王
阅读(92)
评论(0)
推荐(0)
摘要：
Which of the following would be affected by setting NLS_LENGTH_SEMANTICS=CHAR?A. All objects in the databaseB. Tables owned by SYS and SYSTEMC. Data d 阅读全文
posted @ 2017-11-15 10:42
巴啦啦大魔王
阅读(103)
评论(0)
推荐(0)
摘要：
Which NLS parameter can be used to change the default Oracle sort method from binary to linguistic for the SQL SELECT statement?A. NLS_LANGB. NLS_COMP 阅读全文
posted @ 2017-11-15 10:37
巴啦啦大魔王
阅读(92)
评论(0)
推荐(0)
摘要：
Which of the following NLS_SORT parameter values would result in case-insensitive and accent-insensitive binary sorts?A. NLS_SORT = BINARYB. NLS_SORT 阅读全文
posted @ 2017-11-15 10:31
巴啦啦大魔王
阅读(168)
评论(0)
推荐(0)
摘要：
Automatic data conversion will occur if which of the following happens?A. The client and server have different NLS_LANGUAGE settings.B. The client and 阅读全文
posted @ 2017-11-15 10:25
巴啦啦大魔王
阅读(117)
评论(0)
推荐(0)
摘要：
In a database with the database character set of US7ASCII and a national character set of UTF-8, which datatypes would be capable of storing Unicode d 阅读全文
posted @ 2017-11-15 10:21
巴啦啦大魔王
阅读(90)
评论(0)
推荐(0)
浙公网安备 33010602011771号