网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
多选题
You create a new pluggable database, HR_PDB, from the seed database. Which three tablespaces arecreated by default in HR_PDB?（）
A
SYSTEM
B
SYSAUX
C
EXAMPLE
D
UNDO
E
TEMP
F
USERS
参考答案
参考解析
解析：
暂无解析
更多 “多选题You create a new pluggable database, HR_PDB, from the seed database. Which three tablespaces arecreated by default in HR_PDB?（）ASYSTEMBSYSAUXCEXAMPLEDUNDOETEMPFUSERS” 相关考题
考题
In your multitenant container database (CDB) with two pluggable database (PDBs). You want to create a new PDB by using SQL Developer.Which statement is true?()
A. The CDB must be open.B. The CDB must be in the mount stage.C. The CDB must be in the nomount stage.D. Alt existing PDBs must be closed.
考题
Your multitenant container database (CDB) contains a pluggable database, HR_PDB. The default permanent tablespace in HR_PDB is USERDATA. The container database (CDB) is open and you connect RMAN.You want to issue the following RMAN command:RMAN BACKUP TABLESPACE hr_pdb:userdata;Which task should you perform before issuing the command?（）A. Place the root container in ARHCHIVELOG mode.B. Take the user data tablespace offline.C. Place the root container in the nomount stage.D. Ensure that HR_PDB is open.
考题
In your multitenant container database (CDB) containing pluggable database (PDBs), you granted theCREATE TABLE privilege to the common user C A_ADMIN in root and all PDBs. You execute thefollowing command from the root container:SQL >REVOKE create table FROM C A_ADMIN;What is the result?（）A. It executes successfully and the CREATE TABLE privilege is revoked from C # # A_ADMIN in root only.B. It fails and reports an error because the CONTAINER=ALL clause is not used.C. It excludes successfully and the CREATE TABLE privilege is revoked from C # # A_ADMIN in root and all PDBs.D. It fails and reports an error because the CONTAINER=CURRENT clause is not used.E.It executes successfully and the CREATE TABLE privilege is revoked from C # # A_ADMIN in all PDBs.
考题
What is the effect of specifying the "ENABLE PLUGGABLE DATABASE" clause in a "CREATEDATABASE” statement?()
A. It will create a multitenant container database (CDB) with only the root opened.B. It will create a CDB with root opened and seed read only.C. It will create a CDB with root and seed opened and one PDB mounted.D. It will create a CDB that must be plugged into an existing cdb.E. It will create a CDB with root opened and seed mounted.
考题
You create a new pluggable database, HR_PDB, from the seed database. Which three tablespaces arecreated by default in HR_PDB?()
A.SYSTEMB.SYSAUXC.EXAMPLED.UNDOE.TEMPF.USERS
考题
You are planning the creation of a new multitenant container database (CDB) and want to store the ROOT and SEED container data files in separate directories.You plan to create the database using SQL statements.Which three techniques can you use to achieve this?（）A. Use Oracle Managed Files (OMF).B. Specify the SEED FILE_NAME_CONVERT clause.C. Specify the PDB_FILE_NAME_CONVERT initialization parameter.D. Specify the DB_FILE_NAMECONVERT initialization parameter.E. Specify all files in the CREATE DATABASE statement without using Oracle managed Files (OMF).
考题
You are the administrator of two SQL Server 2000 computers. One of these servers contains a 4-GB database named marketing. You want to remove the marketing database from one server and add it to the other as quickly as possible.What should you do?A．Detach the database from the original server by using the sp_detach_db stored procedure. Copy the database and the transaction log files to the new server, and attach them by using the sp_attach_db stored procedure.B．Use the DTS export wizard to transfer all database objects from the original server to the new server. Drop the database from the original server.C．Run a full backup of the database on the original server. Create a new database named marketing on the new server. Restore the backup in the new marketing database. Drop the database from the original server.D．Shut down the original server. Copy the database and the transaction log files to the new server. Use the DISK INIT and DISK REFIT statements to attach the data file to the new server. Drop the database from the original server.
考题
At database startup， you discover that one of the disks containing an index tablespace has been lost due to a media failure. A backup of the lost index tablespace is not available. You have all the necessary scripts to recreate the indexes. You need to re-create the indexes in a new index tablespace. Which action must you perform before re-creating the indexes？（）A、 Start the database in OPEN mode， and create a new index tablespace.B、 Start the database in OPEN mode， and drop the lost index tablespace from the database.C、Start the database in MOUNT mode， create a new index tablespace， and drop the lost index tablespace from the database.D、 Start the database in MOUNT mode， drop the lost index tablespace from the database， open the database， and create a new index tablespace.
考题
Your multitenant container database (CDB) contains three pluggable database (PDBs). You find that the control file is damaged. You plan to use RMAN to recover the control file. There are no startup triggers associated with the PDBs. Which three steps should you perform to recover the control file and make the database fully operational?（）A、Mount the container database (CDB) and restore the control file from the control file auto backup.B、Recover and open the CDB in NORMAL mode.C、Mount the CDB and then recover and open the database, with the RESETLOGS option.D、Open all the pluggable databases.E、Recover each pluggable database.F、Start the database instance in the nomount stage and restore the control file from control file auto backup.
考题
You create a new pluggable database, HR_PDB, from the seed database. Which three tablespaces arecreated by default in HR_PDB?（）A、SYSTEMB、SYSAUXC、EXAMPLED、UNDOE、TEMPF、USERS
考题
You are creating a Web-based application to manage data aggregation for reports. The application connects to a SQL Server 2005 database named DataManager. One page in the application has controls that execute stored procedures in a database named ReportingDatabase. There is an existing Service Broker connection between the DataManager database and ReportingDatabase.You want to add two new message types to the existing service. In each database， you create message types named ProcessReport and SendResult. You need to add the two new message types to the existing service. What should you do first？（）A、Create a queue on each database with the ACTIVATION argument set to DataManager dbo processReport.B、Create a conversation between the databases by using the following Statement BEGIN DIALOG FROM SERVICE ’ProcessReport’ TO SERVICE ’SendResult’C、Create a contract between the services by using the following statement.CREATE CONTRACT processData （ProcessReport SENT BY INITIATOR，SendResult SENT BY TARGET）D、Create services for each database by using the following statement.CREATE SERVICE DataManager on QUEUE ProcessReport
考题
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 database performance. Which method would you use to achieve this objective？（）A、Use the CREATE DATABASE .. command to create the database with Oracle-managed files. B、Use the Database Configuration Assistant (DBCA) to create the database with Oracle-managed files. C、Use Enterprise Manager to create a new database with the Online Transaction Processing (OLTP) option. D、Use Database Configuration Assistant (DBCA) to create the database with Transaction Processing template. E、Use the CREATE DATABASE .. command to create the database with Automatic Storage Management (ASM) file system.
考题
What is the effect of specifying the "ENABLE PLUGGABLE DATABASE" clause in a "CREATEDATABASE” statement?（）A、It will create a multitenant container database (CDB) with only the root opened.B、It will create a CDB with root opened and seed read only.C、It will create a CDB with root and seed opened and one PDB mounted.D、It will create a CDB that must be plugged into an existing cdb.E、It will create a CDB with root opened and seed mounted.
考题
You are planning the creation of a new multitenant container database (CDB) and want to store the ROOT and SEED container data files in separate directories. You plan to create the database using SQL statements. Which three techniques can you use to achieve this?（）A、Use Oracle Managed Files (OMF).B、Specify the SEED FILE_NAME_CONVERT clause.C、Specify the PDB_FILE_NAME_CONVERT initialization parameter.D、Specify the DB_FILE_NAMECONVERT initialization parameter.E、Specify all files in the CREATE DATABASE statement without using Oracle managed Files (OMF).
考题
Identify three valid methods of opening, pluggable databases (PDBs).（）A、ALTER PLUGGABLE DATABASE OPEN ALL ISSUED from the rootB、ALTER PLUGGABLE DATABASE OPEN ALL ISSUED from a pdbC、ALTER PLUGGABLE DATABASE PDB OPEN issued from the seedD、ALTER DATABASE PDB OPEN issued from the rootE、ALTER DATABASE OPEN issued from that pdbF、ALTER PLUGGABLE DATABASE PDB OPEN issued from another pdbG、ALTER PLUGGABLE DATABASE OPEN issued from that pdb
考题
You are creating a Windows Forms Application by using the .NET Framework 3.5.You plan to design a new control that will be used on multiple forms in the app.You need to ensure that the control meets the following requirement （1）It retrieves data from a MSSQL Server 2008 database instance. （2）It uses WPF classes to display data. （3）It uses user-customizable actions when the control is first painted on the form. What should you do？（）A、Create a new custom class for the control that is derived from the Control class.B、Create a new custom class for the control that is derived from the UserControl class.C、Create a new custom class for the control that is derived from the ContentControl class.D、Create a new custom class for the control that is derived from the ContentPresenter class.
考题
You have an Exchange Server 2010 Service Pack 1 （SP1） Mailbox server that contains multiple mailbox databases. You need to ensure that you are notified when deleted mailboxes are purged from the server.What should you do？（）A、Attach a new task to the Application event log.B、Modify the properties of the mailbox database objects.C、Create a new Data Collector Set.D、Create a new Event Viewer Subscription.
考题
You create a Web site with membership and personalization enabled. You must use an existing CRM database for storing the membership information. You need to implement the Membership Provider. What should you do?（）A、Modify the connection string in the Web.config file to connect to the CRM database.B、Add new a SqlMembershipProvider to the Web.config file.C、Create a custom Membership Provider inheriting from MembershipProvider.D、Create a custom MembershipUser inheriting from MembershipUser.
考题
You have an Exchange Server 2010 organization that contains three Mailbox servers.All Mailbox servers are members of a database availability group （DAG） and have a public folder database.The Active Directory forest contains one site.You create a new site and install new Exchange Server 2010 servers in the site.You need to ensure that public folders are stored on servers in both sites.What should you do？（）A、Create a public folder database on a server in the new site. Modify the replication settings for all public foldersB、Create a public folder database on a server in the new site.Run the Set-DatabaseAvailabilityGroup cmdlet from a server in the new siteC、Configure clustered continuous replication （CCR） on two servers in the new site. Modify the replication settings for all public folder databasesD、Configure standby continuous replication （SCR） on a server in the new site. Run the Enable-StorageGroupCopy cmdlet from a server in the new site
考题
A Windows Azure application retrieves data from SQL Azure. You need to recommend an approach for improving application query performance. What should you recommend？（）A、 Create a database view to retrieve the data.B、 Use a clustered index on the SQL Azure database tables.C、 Open a new database connection when an operation times out.D、 Create SQL Azure database table indexes basedon application queries
考题
单选题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 database performance. Which method would you use to achieve this objective？（）A
Use the CREATE DATABASE .. command to create the database with Oracle-managed files. B
Use the Database Configuration Assistant (DBCA) to create the database with Oracle-managed files. C
Use Enterprise Manager to create a new database with the Online Transaction Processing (OLTP) option. D
Use Database Configuration Assistant (DBCA) to create the database with Transaction Processing template. E
Use the CREATE DATABASE .. command to create the database with Automatic Storage Management (ASM) file system.
考题
单选题What is the effect of specifying the "ENABLE PLUGGABLE DATABASE" clause in a "CREATEDATABASE” statement?（）A
It will create a multitenant container database (CDB) with only the root opened.B
It will create a CDB with root opened and seed read only.C
It will create a CDB with root and seed opened and one PDB mounted.D
It will create a CDB that must be plugged into an existing cdb.E
It will create a CDB with root opened and seed mounted.
考题
多选题Identify three valid methods of opening, pluggable databases (PDBs).（）AALTER PLUGGABLE DATABASE OPEN ALL ISSUED from the rootBALTER PLUGGABLE DATABASE OPEN ALL ISSUED from a pdbCALTER PLUGGABLE DATABASE PDB OPEN issued from the seedDALTER DATABASE PDB OPEN issued from the rootEALTER DATABASE OPEN issued from that pdbFALTER PLUGGABLE DATABASE PDB OPEN issued from another pdbGALTER PLUGGABLE DATABASE OPEN issued from that pdb
考题
单选题Your multitenant container database (CDB) contains a pluggable database, HR_PDB. The default permanent tablespace in HR_PDB is USERDATA. The container database (CDB) is open and you connect RMAN. You want to issue the following RMAN command: RMAN BACKUP TABLESPACE hr_pdb:userdata; Which task should you perform before issuing the command?（）A
Place the root container in ARHCHIVELOG mode.B
Take the user data tablespace offline.C
Place the root container in the nomount stage.D
Ensure that HR_PDB is open.
考题
单选题In your multitenant container database (CDB) with two pluggable database (PDBs). You want to create a new PDB by using SQL Developer. Which statement is true?（）A
The CDB must be open.B
The CDB must be in the mount stage.C
The CDB must be in the nomount stage.D
Alt existing PDBs must be closed.
考题
单选题The database is currently open and the temp03.dbf tempfile belonging to the default temporary tablespace TEMP has been corrupted. What steps should you take to recover from this tempfile loss in an efficient manner?（）A
Allow the database to continue running, drop the TEMP tablespace, and then re-create it with new tempfilesB
Shut down the database, restore and recover the tempfile from backup, and then open the database with RESETLOGSC
Allow the database to continue running, take the TEMP tablespace offline, drop the missing tempfile, and then create a new tempfileD
Allow the database to continue running, add a new tempfile to TEMP tablespace with a new name, and drop the tempfile that has been corrupted.
考题
多选题You are planning the creation of a new multitenant container database (CDB) and want to store the ROOT and SEED container data files in separate directories. You plan to create the database using SQL statements. Which three techniques can you use to achieve this?（）AUse Oracle Managed Files (OMF).BSpecify the SEED FILE_NAME_CONVERT clause.CSpecify the PDB_FILE_NAME_CONVERT initialization parameter.DSpecify the DB_FILE_NAMECONVERT initialization parameter.ESpecify all files in the CREATE DATABASE statement without using Oracle managed Files (OMF).
热门标签
最新试卷
