网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
多选题
Which four are correct guidelines for naming database tables? （）
A
Must begin with either a number or a letter.
B
Must be 1-30 characters long.
C
Should not be an Oracle Server reserved word.
D
Must contain only A-Z, a-z, 0-+, _, *, and #.
E
Must contain only A-Z, a-z, 0-9, _, $, and #.
F
Must begin with a letter.
参考答案
参考解析
解析：
暂无解析
更多 “多选题Which four are correct guidelines for naming database tables? （）AMust begin with either a number or a letter.BMust be 1-30 characters long.CShould not be an Oracle Server reserved word.DMust contain only A-Z, a-z, 0-+, _, *, and #.EMust contain only A-Z, a-z, 0-9, _, $, and #.FMust begin with a letter.” 相关考题
考题
Which four are correct guidelines for naming database tables? ()
A. Must begin with either a number or a letter.B. Must be 1-30 characters long.C. Should not be an Oracle Server reserved word.D. Must contain only A-Z, a-z, 0-+, _, *, and #.E. Must contain only A-Z, a-z, 0-9, _, $, and #.F. Must begin with a letter.
考题
You must track all transactions that modify certain tables in the sales schema for at least three years.Automatic undo management is enabled for the database with a retention of one day.Which two must you do to track the transactions?（）A. Enable supplemental logging for the database.B. Specify undo retention guarantee for the database.C. Create a Flashback Data Archive in the tablespace where the tables are stored.D. Create a Flashback Data Archive in any suitable tablespace.E. Enable Flashback Data Archiving for the tables that require tracking
考题
A frame with two，or sometimes four，arms through which are threaded the guidelines and which is used to keep the drill stem and bit in line with the center opening in the temporary guide base is the ______.A.drill stem guideB.guide frameC.drill string frameD.casing guide
考题
Which four are correct guidelines for naming database tables? （）A、Must begin with either a number or a letter.B、Must be 1-30 characters long.C、Should not be an Oracle Server reserved word.D、Must contain only A-Z, a-z, 0-+, _, *, and #.E、Must contain only A-Z, a-z, 0-9, _, $, and #.F、Must begin with a letter.
考题
Which two are correct steps in taking a binary backup of MyISAM tables?（）A、Always stop the server prior to the backupB、Stop the server or lock the tables prior to the backupC、Stop the server or lock the databases prior to the backupD、Make a copy of the .frm, .myd, and the .myi filesE、Make a copy of the binary log and tablespace files
考题
You are working as a DBA on the decision support system. There is a business requirement to track and store all transactions for at least three years for a few tables in the database. Automatic undo management is enabled in the database. Which configuration should you use to accomplish this task？（）A、 Enable Flashback Data Archive for the tables.B、 Specify undo retention guarantee for the database.C、 Enable supplemental logging for the database.D、 Query V$UNDOSTAT to determine the amount of undo that will be generated and create an undo tablespace for that size.E、 Create Flashback Data Archive on the tablespace on which the tables are stored.
考题
Which is the correct command to back up the database， back up the archived redo logs， and then remove the backed-up archived redo logs？（） A、 backup databaseB、 backup database and archivelogsC、 backup database plus archivelogsD、 backup database plus archivelog delete inputE、 backup database and archivelog delete input
考题
The three tasks shown have been completed in order to configure a naming method： Task 1： Installed on server and client： Oracle Net Services， TCP/IP， TCP/IP protocol adaptor Task 2： Started default listener on port 1521 Task 3： Added global database name to the listener.ora file. Which naming method was configured？（）A、host naming methodB、local naming methodC、directory naming methodD、external naming method
考题
Which is the correct command to put the database in ARCHIVELOG mode？（） A、 alter database archivelogB、 alter system enable archivelog modeC、 alter database enable archiveD、 alter database archivelog enableE、 None of the above
考题
You need to improve the performance of the tempdb database on SQL1.Which two actions should you perform？（）A、Move tempdb onto a faster disk volume.B、Increase the initial size of tempdb to 1.5 GBC、Increase the size of the data files in the Tracking database.D、Decrease the file growth increment for tempdb to 25 MBE、Use more local temporary tables and fewer global temporary tables in the Tracking database.
考题
单选题You are working as a DBA on the decision support system. There is a business requirement to track and store all transactions for at least three years for a few tables in the database. Automatic undo management is enabled in the database. Which configuration should you use to accomplish this task？（）A
Enable Flashback Data Archive for the tables.B
Specify undo retention guarantee for the database.C
Enable supplemental logging for the database.D
Query V$UNDOSTAT to determine the amount of undo that will be generated and create an undo tablespace for that size.E
Create Flashback Data Archive on the tablespace on which the tables are stored.
考题
单选题Which is the correct command to back up the database， back up the archived redo logs， and then remove the backed-up archived redo logs？（）A
backup databaseB
backup database and archivelogsC
backup database plus archivelogsD
backup database plus archivelog delete inputE
backup database and archivelog delete input
考题
多选题Which three statements are correct about temporary tables？（）AIndexes and views can be created on temporary tables.BBoth the data and the structure of temporary tables can be exported.CTemporary tables are always created in a user’s temporary tablespace.DThe data inserted into a temporary table in a session is available to other sessions.EData manipulation language （DML） locks are never acquired on the data of temporary tables.
考题
单选题You design a Business Intelligence （BI） solution by using SQL Server 2008. You plan to create a SQL Server 2008 Reporting Services （SSRS） solution. Developers generate random reports against a data source that contains 200 tables. Power users generate random reports against four of the 200 tables. You need to design a strategy for the SSRS solution to meet the following requirements： ·Uses minimum amount of development effort. ·Provides two sets of tables in SSRS to the developers group and the power users group. Which strategy should you use？（）A
Create two Report Builder models.Include the four frequently used tables in the first model and all the tables in the second model.B
Create a Report Builder model by using all the tables.Create a perspective within the model to use only the four frequently used tables.C
Create a Report Builder model by using all the tables. Create two folders.Place the four frequently used tables in the first folder and the remaining tables in the second folder.D
Create two Data Source Views.Include all the tables in one Data Source View and the four frequently used tables in the other Data Source View.Create two Report Builder models so that each model uses one of the Data Source Views.
考题
多选题What are four capabilities of the mysql client program?（）ACreating, dropping, and modifying tables and indexesBInitiating a binary backup of the database by using the START BACKUP commandCDisplaying replication status informationDShutting down the server by using the SHUTDOWN commandECreating and dropping databasesFCreating and administering users
考题
多选题You need to ensure that the stored procedure that inserts new loan requests can access data in tables that are stored in another database on the same SQL Server instance. Which two actions should you perform?（）AEnsure that the stored procedure and the tables are owned by users that are associated with the same SQL Server login.BEnsure that the stored procedure and the tables are owned by the same database user.CEnsure that the stored procedure and the tables use the same database schema.DConfigure the multiuser database option on both databases.EConfigure the cross-database ownership chaining option on both databases.
考题
单选题Which naming method uses the tnsnames.ora file to store the connect descriptor used by the client whileconnecting to the database instance from a remote machine（）A
Host naming methodB
Local naming methodC
External naming methodD
Directory naming method
考题
单选题A frame with two，or sometimes four，arms through which are threaded the guidelines and which is used to keep the drill stem and bit in line with the center opening in the temporary guide base is the（）.A
drill stem guideB
guide frameC
drill string frameD
casing guide
考题
多选题Which statements are correct about temporary tables（）AIndexes and views can be created on temporary tables.BBoth the data and the structure of temporary tables can be exported.CTemporary tables are always created in a user’s temporary tablespace.DThe data inserted into a temporary table in a session is available to other sessions.EData manipulation language （DML） locks are never acquired on the data of temporary tables
考题
多选题You need to improve the performance of the tempdb database on SQL1.Which two actions should you perform？（）AMove tempdb onto a faster disk volume.BIncrease the initial size of tempdb to 1.5 GBCIncrease the size of the data files in the Tracking database.DDecrease the file growth increment for tempdb to 25 MBEUse more local temporary tables and fewer global temporary tables in the Tracking database.
考题
多选题Which two are correct steps in taking a binary backup of MyISAM tables?（）AAlways stop the server prior to the backupBStop the server or lock the tables prior to the backupCStop the server or lock the databases prior to the backupDMake a copy of the .frm, .myd, and the .myi filesEMake a copy of the binary log and tablespace files
考题
多选题Which four are correct guidelines for naming database tables?（）AMust begin with either a number or a letter.BMust be 1-30 characters long.CShould not be an Oracle Server reserved word.DMust contain only A-Z, a-z, 0-+, _, *, and #.EMust contain only A-Z, a-z, 0-9, _, $, and #.FMust begin with a letter.
考题
单选题In which situation would you use static database registration for a listener（）A
when multiple databases are to be registered with the listenerB
when DBAs need to connect remotely to start up the database instanceC
when users need to connect the database instance using the host naming methodD
when the database instance that is to be registered with the listener is configured in shared server mode
考题
单选题Which is the correct command to put the database in ARCHIVELOG mode？（）A
alter database archivelogB
alter system enable archivelog modeC
alter database enable archiveD
alter database archivelog enableE
None of the above
考题
单选题Which naming method uses the tnsnames.ora file to store the connect descriptor used by the client while connecting to the database instance from a remote machine？（）A
host naming methodB
local naming methodC
external naming methodD
directory naming method
考题
单选题You are connecting to an Oracle database server from a client by using the following connect string： SQL CONNECT hr/hr@pdserver.us.oracle.com：1521/proddb Which naming method is being used in this case？（）A
Local NamingB
Easy ConnectC
External NamingD
Directory Naming
考题
单选题You are identifying dictionary objects in the Oracle database. Which of the following is a view in the data dictionary?（）A
V$DATABASE B
DBA_TABLES C
SYSAUD$ D
EMP
考题
单选题Click the Exhibit button and examine the diagram. You are running a database that takes advantage of features provided by Connection Manager， heterogeneous services， and external procedures. The diagram depicts the components used for the naming method you just configured. Which naming method are you using？（）A
Host naming method.B
Local naming method.C
Directory naming method.D
External naming method.
热门标签
最新试卷
