网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
A DBA has been asked to create a table which will contain a substantial amount of detailed sales information for each calendar month and maintain it to contain only the last 12 months. Which of the following methods will facilitate the online removal of the oldest month’s data?（）
A
Create an MQT that selects the oldest month of data with the REFRESH IMMEDIATE option.
B
Create 12 separate tables, create a view based on all 12, drop the table with the oldest month's data then drop and re- create the view.
C
Create a range partitioned table, partitioned by month, and use the ALTER TABLE statement to detach the oldest month and attach storage for new data.
D
Create a single table, extract the data to be retained using UNLOAD with a SELECT statement, drop and re-create the table then load only the data to be retained.
参考答案
参考解析
解析：
暂无解析
更多 “单选题A DBA has been asked to create a table which will contain a substantial amount of detailed sales information for each calendar month and maintain it to contain only the last 12 months. Which of the following methods will facilitate the online removal of the oldest month’s data?（）A Create an MQT that selects the oldest month of data with the REFRESH IMMEDIATE option.B Create 12 separate tables, create a view based on all 12, drop the table with the oldest month's data then drop and re- create the view.C Create a range partitioned table, partitioned by month, and use the ALTER TABLE statement to detach the oldest month and attach storage for new data.D Create a single table, extract the data to be retained using UNLOAD with a SELECT statement, drop and re-create the table then load only the data to be retained.” 相关考题
考题
Which three statements are characteristic of the MEMORY storage engine?()
A.It can support transactionsB.Table contents are not saved if the server is restartedC.It cannot contain text or BLOB columnsD.It can support foreign keysE.Each table is represented on disk as an.frm fileF.Each table has a corresponding.MYI and .MYD file
考题
The STUDENT_GRADES table has these columns:The registrar has asked for a report on the average grade point average (GPA) for students enrolled during semesters that end in the year 2000. Which statement accomplish this?（）A.B.C.D.E.F.
考题
You notice that during peak hours, some firewall enforcers contain a high number of auth table entries. As you investigate the issue, you discover that all users are getting auth table mappings to all firewalls, which is not acceptable.What should you do on the Junos Pulse Access Control Service to resolve this problem?（）A. Delete the default auth table mapping policyB. Create auth table mapping policies that route users to specific resourcesC. Create Resource Access policies that permit access to specific resourcesD. Create Source Interface policies that route users to specific resources
考题
A user needs to create a trigger that will update table T2 whenever a row is added to table T1. Assuming the user has all appropriate privileges for table T2, which privilege is required on table T1 to create the trigger?（）A.REFERENCESB.SELECTC.UPDATED.ALTER
考题
Consequently,there has been a growing interest in natural foods:foods which do not contain additives and which have not been（ ）by chemical fertilizers widely used in farming today.A.effected
B.interfered
C.disturbed
D.affected
考题
While designing your database， you have created the EMPLOYEES table as an index/x7forganized table （IOT）. You want to create a bitmap index on the JOB_ID column to make queries faster. Which task must have been completed so that you are able to create the bitmap index？（）A、A primary key must have been created.B、A mapping table must have been created.C、An overflow tablespace must have been specified.D、The PCTTHRESHOLD option must have been specified.
考题
You are designing an application for a telecom company and you have been asked to design a database table to facilitate monthly bill generation. The bill would include details of customer calls， listed in chronological order. Which method would you follow to achieve this objective without increasing the overhead of sorting the rows？（）A、create a hash cluster to store the dataB、create an index cluster to store the dataC、create a partitioned table to store the dataD、create a sorted hash cluster to store the dataE、create a heap table with rowid to store the data
考题
While designing your database， you have created the EMPLOYEES table as an index-organized table （IOT）. You want to create a bitmap index on the JOB_ID column to make queries faster. Which task must have been completed so that you are able to create the bitmap index？（） A、A primary key must have been created.B、A mapping table must have been created.C、An overflow tablespace must have been specified.D、The PCTTHRESHOLD option must have been specified.
考题
A system administrator has been asked to install an APAR but wants to be able to easily remove it. Which install option should be used？（）A、applyB、cleanupC、commitD、reject
考题
A DBA has been asked to create a table which will contain a substantial amount of detailed sales information for each calendar month and maintain it to contain only the last 12 months. Which of the following methods will facilitate the online removal of the oldest month’s data?（）A、Create an MQT that selects the oldest month of data with the REFRESH IMMEDIATE option.B、Create 12 separate tables, create a view based on all 12, drop the table with the oldest month's data then drop and re- create the view.C、Create a range partitioned table, partitioned by month, and use the ALTER TABLE statement to detach the oldest month and attach storage for new data.D、Create a single table, extract the data to be retained using UNLOAD with a SELECT statement, drop and re-create the table then load only the data to be retained.
考题
A system administrator has been asked to lock a specific login account. Which of the following commands is used to accomplish this？（）A、pwdckB、usrckC、chuserD、rmuser
考题
A user needs to create a trigger that will update table T2 whenever a row is added to table T1. Assuming the user has all appropriate privileges for table T2, which privilege is required on table T1 to create the trigger?（）A、REFERENCESB、SELECTC、UPDATED、ALTER
考题
A system administrator has been asked to document the hardware configuration of a system. Which command can be used to assist in this task？（）A、lscfgB、mkdevC、lslppD、cfgmgr
考题
You notice that during peak hours, some firewall enforcers contain a high number of auth table entries. As you investigate the issue, you discover that all users are getting auth table mappings to all firewalls, which is not acceptable. What should you do on the Junos Pulse Access Control Service to resolve this problem?（）A、Delete the default auth table mapping policyB、Create auth table mapping policies that route users to specific resourcesC、Create Resource Access policies that permit access to specific resourcesD、Create Source Interface policies that route users to specific resources
考题
You are responsible for a data warehouse application that uses records from an external table to update one of the dimension tables periodically. The records in the external table may contain data for new rows in the dimension table， or for updates to its existing rows. Which type of SQL command would you use to transfer the data from the external table to the dimension table as efficiently as possible？（）A、MERGEB、SELECT …CROSS JOINC、INSERT ALL …SELECTD、CREATE VIEW …CONSTRAINT
考题
Examine the following steps performed on a database instance： 1. The DBA grants the CREATE TABLE system privilege to the SKD user with ADMIN OPTION. 2. The SKD user creates a table. 3. The SKD user grants the CREATE TABLE system privilege to the HR user. 4. The HR user creates a table. 5. The DBA revokes the CREATE TABLE system privilege from SKD. Which statement is true after step 5 isperformed（）A、The table created by SKD is not accessible and SKD cannot create new tables.B、The tables created by SKD and HR remain， but both cannot create new tables.C、The table created by HR remains and HR still has the CREATE TABLE system privilege.D、The table created by HR remains and HR can grant the CREATE TABLE system privilege to other users.
考题
Which three statements are characteristic of the MEMORY storage engine?（）A、It can support transactionsB、Table contents are not saved if the server is restartedC、It cannot contain text or BLOB columnsD、It can support foreign keysE、Each table is represented on disk as an.frm fileF、Each table has a corresponding.MYI and .MYD file
考题
Which is a valid CREATE TABLE statement?（）A、CREATE TABLE EMP9$# AS (empid number(2));B、CREATE TABLE EMP*123 AS (empid number(2));C、CREATE TABLE PACKAGE AS (packid number(2));D、CREATE TABLE 1EMP_TEST AS (empid number(2));
考题
单选题Examine the following steps performed on a database instance： 1：The DBA grants the CREATE TABLE system privilege to the SKD user with ADMIN OPTION. 2：The SKD usercreates a table. 3：The SKD user grants theCREATETABLE system privilege to the HR user. 4：The HR user creates a table. 5：The DBA revokes the CREATE TABLE system privilege from SKD. Which statement is true after step 5 is performed（）A
The table created by SKD isnot accessibleand SKD cannot create new tables.B
The tables created by SKD and HR remain， but both cannot create new tables.C
The table created by HR remains and HR still has the CREATE TABLE system privilege.D
The table created by HR remains and HR can grant the CREATE TABLE system privilege to other users.
考题
填空题What has been done by the heating system supplier?____ has been asked to find out the cause of the accident.
考题
单选题You are configuring the data source for an Oracle database. You will need to specify a test table for WebLogic to test the status of the database. Which option should you choose?（）A
a table name which has 100s of recordsB
a table name which has 10s of recordsC
a table name which has empty recordsD
a table name which has 1000s of recordsE
never use a table name
考题
单选题While designing your database， you have created the EMPLOYEES table as an index/x7forganized table （IOT）. You want to create a bitmap index on the JOB_ID column to make queries faster. Which task must have been completed so that you are able to create the bitmap index？（）A
A primary key must have been created.B
A mapping table must have been created.C
An overflow tablespace must have been specified.D
The PCTTHRESHOLD option must have been specified.
考题
单选题A DBA has been asked to create a table which will contain a substantial amount of detailed sales information for each calendar month and maintain it to contain only the last 12 months. Which of the following methods will facilitate the online removal of the oldest month’s data?（）A
Create an MQT that selects the oldest month of data with the REFRESH IMMEDIATE option.B
Create 12 separate tables, create a view based on all 12, drop the table with the oldest month's data then drop and re- create the view.C
Create a range partitioned table, partitioned by month, and use the ALTER TABLE statement to detach the oldest month and attach storage for new data.D
Create a single table, extract the data to be retained using UNLOAD with a SELECT statement, drop and re-create the table then load only the data to be retained.
考题
单选题Which describes the default behavior when you create a table? （）A
The table is accessible to all users.B
Tables are created in the public schema.C
Tables are created in your schema.D
Tables are created in the DBA schema.E
You must specify the schema when the table is created.
考题
多选题Which three statements are characteristic of the MEMORY storage engine?（）AIt can support transactionsBTable contents are not saved if the server is restartedCIt cannot contain text or BLOB columnsDIt can support foreign keysEEach table is represented on disk as an.frm fileFEach table has a corresponding.MYI and .MYD file
考题
单选题You are designing an application for Certkiller .com and you have been asked to design a database table to facilitate monthly bill generation. The bill would include details of customer calls， listed in chronological order.Which method would you follow to achieve this objective without increasing the overhead of sorting the rows？（）A
create a hash cluster to store the dataB
create an index cluster to store the dataC
create a partitioned table to store the dataD
create a sorted hash cluster to store the dataE
create a heap table with rowid to store the data
考题
单选题Examine the following steps performed on a database instance： 1. The DBA grants the CREATE TABLE system privilege to the SKD user with ADMIN OPTION. 2. The SKD user creates a table. 3. The SKD user grants the CREATE TABLE system privilege to the HR user. 4. The HR user creates a table. 5. The DBA revokes the CREATE TABLE system privilege from SKD. Which statement is true after step 5 isperformed（）A
The table created by SKD is not accessible and SKD cannot create new tables.B
The tables created by SKD and HR remain， but both cannot create new tables.C
The table created by HR remains and HR still has the CREATE TABLE system privilege.D
The table created by HR remains and HR can grant the CREATE TABLE system privilege to other users.
考题
单选题You have been asked to create a static route with a next hop that is not directly connected to the router. Which configuration parameter enables the static route to accomplish this scenario？（）A
resolveB
indirectC
next-hopD
recursive
热门标签
最新试卷