|
Question 1.
The DBA has added STATE column to the CUSTOMERS table and has asked you to add a corresponding State item to the Customers block of the Orders form. You want to make it easier for order entry clerks to enter the correct state abbreviation.
Most customers are located in five southeastern states, although on very rare occasions there will be customers from outside that area. You decide to implement a list item with five values for the State item and allow clerks to enter the state abbreviation director for those customers outside the region.
Which style of list item will you create for the State item?
A. A pop list
B. A Tlist
C. A combo box.
D. There is no style of list item that allows users to enter values that are not on the list.
Answer: C
Explanation:
Oracle 9i: Forms Developer Build Internet Application M8-P11 Combo box: Appears as a field with a down arrow next to its right side (Use the button to display all the combo box list elements. The combo box accepts user input.)
Question 2.
Exhibit:
You want to create a new data block. You click the Data Blocks node in the Object Navigator, and then you click Create to invoke the Create Data Block dialog box. As you click through the pages of the wizard, the page shown in the exhibit appears.
After looking at the exhibit, what do you know is true about this form?
A. The block you are creating is based on a view.
B. The block you are creating is based on a stored procedure.
C. The form contains at least one block in addition to the block you are creating.
D. In addition to the block you are creating, the form contains at least two other blocks that are
master-detail blocks.
E. The block you are creating is based on a table that has at least one foreign key relationship to
another table.
Answer: C
Explanation:
Oracle 9i: Forms Developer Build Internet Application M4-P32
You can build a master-detail form module either by creating a relation between a master and detail block explicitly, or implicitly by using the Data Block Wizard.
1. Create the master block as described earlier in this lesson in the topic Creating a New Data Block.
2. Invoke the Data Block Wizard in the Object Navigator.
3. Follow the same steps as before to create a new data block in the Data Block Wizard until you come to the Master-Detail page.
Question 3.
You are creating an application on a Windows PC, and you want to test a form.
What are two ways to start an OC4J instance on the PC? (Choose two)
A. From the Forms Builder menu.
B. From the Windows Start menu.
C. By executing a batch file that is included with Oracle9iDS.
D. From the test form that is included with Oracle9iDS.
E. From the HTML front end (runform.htm) that is included with Oracle9iDS.
F. By running a Forms Builder form, which automatically starts OC4J.
Answer: B, C
Explanation:
Oracle 9i: Forms Developer Build Internet Application M3-P17
To use OC4J on Windows NT, you start it by executing the batch file provided, called startinst.bat. This file is located in the j2ee\Oracle9iDS\ subdirectory of ORACLE_HOME. If you will be testing your applications on your client machine, it is a good idea to set up a shortcut to this batch file, and also to the batch file to stop the OC4J instance, called stopinst.bat.
Question 4.
While updating an existing customer record using the Customers form, the user invoked the Orders form by clicking the CONTROL.Orders_btn button. The When-Button-Pressed trigger had the following code:
CALL_FORM('orders');
There is a requirement to navigate back to the Customers form after the order details have also been updated.
This will be achieved through a form-level Key-Exit trigger in the Orders form. Which code should be used?
A. IF GET_APPLICATION_PROPERTY(calling_form) IS NOT NULL THEN
EXIT_FORM(ASK_COMMIT, NO_ROLLBACK;
ELSE
EXIT_FORM;
END IF;
B. VALIDATE(FORM_SCOPE);
IF :SYSTEM.FORM_STATUS <> 'QUERY' THEN
GO_FORM('customers');
ELSE
EXIT_FORM;
END IF;
C. ENTER;
IF :SYSTEM.CURSOR_BLOCK = 'CHANGED' THEN
COMMIT_FORM;
ELSE
EXIT_FORM(NO_VALIDATE, NO_ROLLBACK);
END IF;
D. IF :SYSTEM.FORM_STATUS = 'CHANGED' THEN
COMMIT_FORM:
END IF;
GO_FORM(customers');
Answer: A
Oracle Forms Developer 6i: Build Internet Applications II M9-P17
Question 5.
In the Product.fmb module, data block items are displayed on two content canvases. You define a set of icon buttons that users must have access to at all times.
Which canvases type is appropriate to display the buttons?
A. Overlay stacked canvas.
B. Overlay Tab canvas that is associated with a separate window.
C. Content canvas that is associated with the same window as the two content canvases.
D. Horizontal Toolbar canvas that is associated with a separate window.
E. Horizontal Toolbar canvas that is associated with the same window as the two content
canvases.
Answer: E
Question 6.
Exhibit:
You are developing an Order Entry form. The When-New-Form-Instance trigger executes a query on the only block in the form. Instead of the alert shown in the exhibit, when the query cannot be performed you want to display to the user a message with the actual database error that is received. What can you do to implement this?
A. In the When-New-Form-Instance trigger, insert this code after the EXECUTE_QUERY built in:
IF NOT FORM _SUCCESS THEN message(DBMS_ERROR_TEXT); END IF;
B. In the When-New-Form-Instance trigger, insert this code after the EXECUTE_QUERY built in:
IF NOT FORM_SUCCESS THEN message(SQLERRM); END IF;
C. Place this code in a form-level On-Error trigger:
IF ERROR_CODE = 40505 THEN message(DBMS_ERROR_TEXT);END IF;
D. Place this code in a form-level On-Error trigger:
IF ERROR_CODE = 40505 THEN message(SQLERRM);
END IF;
E. Add this exception handler to the When-New-Form-Instance trigger:
EXCEPTION
WHEN ERROR_CODE = 40505 THEN
MESSAGE(DBMS_ERROR_TEXT);
F. Add this exception handler to the When-New-Form-Instance trigger:
EXCEPTION
WHEN ERROR_CODE = 40505 THEN
MESSAGE(SQLERRM);
Answer: C
Question 7.
Exhibit:
Which of the items depicted in the Menu Editor (shown in the exhibit) must contain PL/SQL code?
A. Exit and Save only.
B. File, Edit, and Customers only.
C. All items shown in the Menu Editor should contain PL/SQL code.
D. Exit, Save, Customers Report, Open Customers, and Call Customers only.
E. Exit, Save, Cut, Copy, Paste, Customers Form, Customers Report, Open Customers, and Call
Customers only.
Answer: D
Question 8.
To centralize some of your processing, you decide to write PL/SQL library modules that contain procedures that can be called from the triggers or menu items.
You want the message "Credit limit exceeded" to be displayed when the values in the order_total and credit_limit fields in the Orders form meet certain criteria. Which code do you use?
A. IF :order_total > 10000
AND :credit_limit < 10000 THEN
MESSAGE('Credit limit exceeded');
END IF;
B. IF :SYSTEM.cursor_item > 10000
AND :SYSTEM.trigger_item < 10000 THEN
MESSAGE('Credit limit exceeded');
END IF;
C. IF NAME_IN('order_total') > 10000
AND NAME_IN('credit_limit') < 10000 THEN
MESSAGE('Credit limit exceeded');
END IF;
D. IF COPY('ORDERS.order_total') > 10000
AND COPY('ORDERS.credit_limit') < 10000 THEN
MESSAGE('Credit limit exceeded');
END IF;
E. IF :ORDERS.order_total > 10000
AND :ORDERS.credit_limit < 10000 THEN
MESSAGE('Credit limit exceeded');
END IF;
Answer: C
Question 9.
How can you programmatically determine which button a user pressed to respond to an alert?
A. Use the GET_ALERT_PROPERTY function.
B. Use the GET_ALERT_BUTTON_PROPERTY function.
C. Check the value returned by the SHOW_ALERT function to see if it is 1, 2, or 3.
D. Check the value returned by the SHOW_ALERT function to see if it is ALERT_BUTTON1,
ALERT_BUTTON2, or ALERT_BUTTON3.
E. Check the value returned by the SHOW_ALERT function to see if it is ALERT_BUTTON1,
ALERT_BUTTON2, or ALERT_BUTTON3.
Answer: D or E – because they are same.
Question 10.
You should enable the user to add additional values to a list item at run time. You must also ensure that the Record Group LOCATIONS, which is used to populate the list item, can be updated with any user-supplied value. What two actions could you take to accomplish this? (Choose two)
A. Add a new value to the list item by calling the POPULATE_LIST built-in.
B. Add a new value to LOCATIONS by calling the POPULATE_GROUP built-in.
C. Add a new value to the list item by calling the ADD_LIST_ELEMENT built-in.
D. Remove duplicate values in LOCATIONS by calling the DELETE_LIST_ELEMENT built-in.
E. Add a new value to LOCATIONS by calling the ADD_GROUP_ROW and
SET_GROUP_CHAR_CELL built-ins.
F. Add a new value to LOCATIONS by calling the ADD_GROUP_ROW and
SET_GROUP_NUMBER_CELL built-ins.
Answer: C, E
Question 11.
Your company assigns three possible credit ratings to customers: Poor, Good, and Excellent
(represented numerically by 1, 2, and 3). The DBA has just added a RATING column to the CUSTOMERS table and has asked you to add an item to your form so that data entry clerks can populate the RATING column.
To restrict data entry clerks to one of these three values, you decide to create a radio group for the Rating item. With the Customers block selected in the Layout Editor, you use the radio button to create three radio buttons on the canvas.
You then set the labels (Poor, Good, and Excellent) and values (1, 2, and 3) for the radio buttons.
You set the name of the radio group to RATING, its Data Type to Number, and its Database column to Rating.
You run the form to test it. When you execute a query, however, no records are returned, although there are many customer records in the database.
What can you do to make the query return the records?
A. Set the Mapping of Other Values property for the radio group to Null.
B. Create a fourth radio button for an undetermined credit rating and leave its value blank.
C. Create a fourth radio button for an undetermined credit rating and explicitly set its value to Null.
D. Choose a different type of input, because radio groups do not allow query of Null values.
Answer: A
Explanation:
Oracle 9i: Forms Developer Build Internet Application M8-P23
Handling Other Values in a Radio Group
If the base table column for a radio group accepts values other than those associated with your radio buttons, you must use one of the following methods to specify how you want to handle the values:
•Ignore other values (by leaving the radio group's Mapping of Other Values property blank)
•Associate the other values with one of the existing radio buttons (by naming the associated value of the button in the Mapping of Other Values property)
Note: Ignoring other values results in the entire row being ignored during query processing.
NULL Values in a Radio Group
A radio group can treat NULL as a valid value. You should account for the NULL case, if your base table column allows them. Do this in one of the following ways:
•Use the Mapping of Other Values property to implicitly force NULL to a radio button.
•Assign the NULL to its own radio button.
Note: To assign a NULL value, leave the Radio Button Value property blank.
Question 12.
You are editing the INVENTORY tab canvas. You set the Tab Attachment Edge property to RIGHT. You also change the ordering of INVENTORY tab pages in the Object Navigator. The Direction property has not been customized.
What influence will this have on the display of tab pages at run time?
A. The highest tab page in the Object Navigator will appear at the far left of the tab stack.
B. The highest tab page in the Object Navigator will appear at the top of the tab stack.
C. The highest tab page in the Object Navigator will appear at the far right of the tab stack.
D. The highest tab page in the Object Navigator will appear at the bottom of the tab stack.
E. The lowest tab page in the Object Navigator will appear at the start of the tab stack.
Answer: B
Question 13.
You write a form in which there are two text items (FIELD 1 and FIELD2) and a button (BTN1) arranged in the following sequence:
FIELD1,
BTN2,
FIELD2
Which three conditions will combine to produce a Navigation Trap when the focus is in FIELD1 and the user presses the [Next Item] key? (Choose three)
A. FIELD1 has a Post-Text-Item trigger that fails.
B. FIELD1 has a Pre-Text-Item trigger that fails.
C. FIELD1 has a When-New-Item-Instance trigger that fails.
D. FIELD2 has a Post-Text-Item trigger that fails.
E. FIELD2 has a Pre-Text-Item trigger that fails.
F. FIELD2 has a When-New-Item-Instance trigger that fails.
G. The Keyboard Navigable property of BTN1 is set to No.
H. The Keyboard Navigable property of BTN1 is set to Yes.
Answer: B, E, G
Question 14.
Which two statements define a Static Record Group? (Choose two)
A. The Record Group can be created only at run time.
B. The Record Group is not associated with a query.
C. The Record Group can be created and modified only at design time.
D. The Record Group can be created and modified at design time or at run time.
E. You can modify the structure of this Record Group by adding columns and rows at run time.
F. You can modify the structure of this Record Group by associating it with a query at run time.
Answer: B, C
Question 15.
There is a requirement in the Orders form to direct the focus depending on the value in the Sales Rep Id text item. The design team has not yet decided on the exact details, but you propose the following style of code:
IF :ORDERS.Sales_Rep_Id = ... THEN --value to be decided later
GO_ITEM(...); --item to be decided later
ELSE
GO_ITEM(...); --item to be decided later
END IF;
A colleague suggest that the code could be called from the triggers listed below. In fact, not all these triggers can execute the code.
Which three triggers can call the code? (Choose three)
A. Post-Block on the Orders block.
B. Pre-Block on the Order_Items block.
C. When-New-Block-Instance on the Orders block.
D. Post-Text-Item on the Sales Rep Id text item.
E. When-Validate-Item on the Sales Rep Id text item.
F. When-New-Block-Instance on the Order_Items block.
Answer: C, E, F
Question 16.
The REGIONS non-query Record Group has two char columns.
Which built-in can you use to replace any existing rows in REGIONS with the results of a query?
A. ADD_GROUP_ROW('REGIONS',2);
B. rgno :- POPULATE_GROUP('REGIONS');
C. rgno := POPULATE_GROUP_WITH_QUERY('REGIONS', 'select name, country, id from
region table');
D. rgno := CREATE_GROUP_FROM_QUERY('REGIONS', 'select name, country, id from region
table')
E. rgno := CREATE_GROUP_FROM_QUERY('REGIONS', 'select name, country from region
table');
F. rgno := POPULATE_GROUP_WITH_QUERY('REGIONS', 'select name, country from region
table');
G. You cannot populate a non-query Record Group with the results of a query.
Answer: F
Question 17.
You are a developer in the IT department of a municipal utility. You have been tasked with integrating two applications that are already in production.
The first application is a customer management system. Its main form is the Customers form, in which utility clerks enter and update customer information.
The second application is a GIS application. One of its forms, the Address form, enables clerks to enter an address, click a button, and have the address verified and property formatted according to postal standards.
You need to add a button to the Customers form that will pass the customer address to the Address form and receive the properly formatted address back. A variable of the user-defined type Addr_Typ will contain the address information to be passed back and forth between the two users.
Which method of sharing data will you use?
A. Global variables
B. Global record group
C. Parameters
D. Shared PL/SQL library
E. There is no method of sharing data that enables you to use a variable of a user-defined type.
Answer: D
Question 18.
Consider the following scenario:
In a multiform application, the user started in FormA.
1. From FormA, the user invoked FormB using CALL_FORM.
2. From FormB, the user invoked FormC using OPEN_FORM.
3. From FormC, the user invoked FormD using OPEN_FORM.
4. From FormB, the user invoked FormE using CALL_FORM.
There is an additional form in the application, called FormF.
Which statement is true?
A. FormF can be invoked from FormC using CALL_FORM.
B. FormF can be invoked from FormA using OPEN_FORM.
C. FormF can be invoked from FormD using CALL_FORM.
D. FormF can be invoked from FormE using CALL_FORM.
E. FormF can be invoked from FormB using OPEN_FORM.
Answer: D
Question 19.
Some forms that you wrote have been through part of the testing cycle. One of the testers has reported encountering a "Navigation Trap" in your Orders form.
Which scenario could have caused the Navigation Trap?
A. The Pre-Form trigger validates the user and time of day and also contains the code:
GO_ITEM('ORDERS.Date_Ordered');
This is an illegal call to a restricted built-in, resulting in the Navigation Trap.
B. Two adjacent text items have When-New-Item-Instance triggers that fail when executed.
This left the internal cursor with no place to go when the tester attempted to navigate to them,
and there was a
fatal error for the form.
C. A Pre-Text-Item trigger allows the focus unto the text item the first time it is executed, but
subsequent execution raises a FORM_TRIGGER_FAILURE.
A Pre-Text-Item trigger on a different text item also fails.
D. The Next Navigation Data Block and Previous Navigation Data Block properties of the Orders
and Order_Items blocks have been set so that the focus cannot move to the Inventories block.
E. A When-Validate-Item trigger on a text item validates the contents of the wrong field, and you
have coded a GO_ITEM() that sends the focus back to the item that invoked it.
F. The Next Navigation Item and Previous Navigation Item properties of some text items have
been set so that the user is stuck in an infinite navigation loop.
Answer: C
Question 20
Exhibit:
You are modifying a form that has four buttons on a canvas. Button2, Button3, and Button4 are all sub classed from Button1.
You want to change the width of all the buttons, so you open the Property Palette for Button1 and change its width to 60. In the Layout Editor, you can see that all buttons have become smaller except for Button3.
You open the Property Palette for Button3 (as shown in the exhibit).
Why did the width for Button3 not change to 60?
A. Button3 was not properly sub classed.
B. Width is a changed property in Button3.
C. Width is a variant property in Button3.
D. Width is a default property in Button3.
E. Width is an inherited property in Button3.
Answer: C
|
Question 1.
You work as a database administrator at ABC.com. You have just installed Microsoft SQL Server Management Studio on one of ABC.com’s workstations and the Microsoft Business Intelligence Development Studio. You have been requested to design a 12 table transactional package to be stored on an offsite server’s msdb data store. You decide that BIDS in this scenario is an overkill and you decide to uninstall it.
What utility should you run to create the requested package?
A. Use the bulk copy program.
B. Use the DTS Designer.
C. Use the Microsoft SQL Server Import and Export Wizard.
D. Use Process Control Tool.
E. Use the Package Migration Wizard.
F. Use the Process Control Tool
G. Use the ISIS.
Answer: C
Explanation:
Question 2.
DRAG DROP
You work as a database administrator at ABC.com. ABC.com is using a SQL Server 2008 instance that contains a database named ABC_DB1. As part of your backup method of ABC_DB1, you do a Full backup every Sunday at 01:00, you do a differential backup weekdays at 22:00, and you do transactional log backup weekdays at 08:00; 12:00 and 16:00. You have received notification that the user database data files have failed on Thursday at 15:00. You need to ensure that ABC_DB1 are retrieve as quickly as possible with as small as possible amount of data loss.
What steps should you take? Use only steps that apply.
Answer:
Question 3.
DRAG DROP
You work as a database administrator at ABC.com. ABC.com is using a SQL Server 2008 instance that contains a database named ABC_Prod. During the night a daily full backup of ABC_Prod is started at 03:15, a differential backup is performed every 90 days minutes and a transaction log backup is performed every 20 minutes. This particular day your CEO has requested that you make an extra full backup during the lunch break starting at 11.30.
How can you meet her request while keeping the database backup files in order for future backups and restores?
Answer:
Question 4.
You work as a database administrator at ABC.com. ABC.com is using a SQL Server 2008 instance. The SQL Server 2008 instance hosts quite a few applications. ABC also has a server named ABC-SR43 that is used to store log files. You have to set up a new job that stores log files on ABC-SR43. You create a new account ABC\Log_Account. You set it up to be run by the SQL Server Agent Services. However, your job fails to store any log files on ABC-SR43. After some investigation you notice that the job does not have permissions to store files on ABC-SR43.
How should you remedy the situation? Select the best option.
A. You should set up ABC\Log_Accoun as a Remote Service account.
B. You should set up ABC\Log_Accoun as a Domain service account.
C. You should set up ABC\Log_Accoun as a Local Service account.
D. You should set up ABC\Log_Accoun as a Local System account.
E. You should set up ABC\Log_Accoun as a Network Service account.
F. You should set up ABC\Log_Account as a Domain account.
Answer: F
Explanation:
The service startup account defines the Microsoft Windows account in which SQL Server Agent runs and its network permissions. SQL Server Agent runs as a specified user account. For compatibility with earlier versions of SQL Server, SQL Server Agent can also run as the Local System account. In this scenario you should select a Domain account, which allows sufficient permissions and improved security.
Question 5.
You work as a database administrator at ABC.com. ABC.com is using a SQL Server 2008 instance that has a table named ABC_Training. ABC_ Training contains a column named ABC_Distance. A new ABC.com training policy states that the training (ie. The ABC_Distance column in the ABC_Training table) cannot be increased or decreased by more than 3%.
How should you implement the ABC Training Policy?
A. You should consider developing a view which rolls back non-compliant ABC.com policy
changes to ABC_Distance.
B. You should consider developing a stored procedure which rolls back non-compliant ABC.com
policy compliant changes to the ABC_Distance column.
C. You should consider developing a primary key constraint to the ABC_training table which only
contains valid values on ABC_Distance.
D. You should consider developing a create trigger which rolls back non-compliant ABC.com
policy changes to the ABC_Distance column.
E. You should consider developing an update trigger which rolls back non-compliant ABC.com
policy changes to the ABC_Distance column.
F. You should consider developing a delete trigger which rolls back non-compliant ABC.com
Policy changes to the ABC_Distance column.
Answer: E
Explanation:
Question 6.
You work as a database administrator at ABC.com. ABC.com is using a SQL Server 2008 instance that contains a database named ABC_DB. ABC.com contains a lot of customer data which is processed by the Web application. You need to keep the customer information safe since it is confidential. This information includes files of data, backups, and log files.
How can this be achieved and still keep the performance and functionality of the web application? Select one or two.
A. You should consider adding a transaction Log on ABC_DB, and set the information to be
encrypted for a fixed time.
B. Use BitLocker Drive Encryption on the hard drives on the SQL Server.
C. Use EFS (Encrypting File System) on the hard drives on the SQL Server.
D. You should consider enabling the Transparent Database Encryption on ABC_DB and back up
the transaction log.
E. You should consider enabling the Transparent Database Encryption on ABC_DB and enabling
the Transparent Database Encryption on master database.
F. Use cell-level encryption for the specific data that needs to be kept safe.
Answer: D
Explanation:
With the introduction of transparent data encryption (TDE) in SQL Server 2008, users now have the choice between cell-level encryption as in SQL Server 2005, full database-level encryption by using TDE, or the file-level encryption options provided by Windows. TDE is the optimal choice for bulk encryption to meet regulatory compliance or corporate data security standards. TDE works at the file level, which is similar to two Windows® features: the Encrypting File System (EFS) and BitLocker™ Drive Encryption, the new volume-level encryption introduced in Windows Vista®, both of which also encrypt data on the hard drive. TDE does not replace cell-level encryption, EFS, or BitLocker.
Question 7.
You work as a database administrator at ABC.com. ABC.com is using two SQL Server 2008 sample named ABCSmp1 and ABCSmp2. Furthermore, ABCSmp1 contains a database named ABC_DB. A ABC.com user named Mia Hamm uses her logon MiaHamm to log on to the database on ABCSmp1. During the week you have transferred ABC_DB to ABCSmp2. You manually recreate the Mia Hamm login on ABCSmp2. However, when she tries to login on ABC_DB at ABCSmp2, she received an error message stating that she is not allowed access. Mia Hamm needs to access ABC_DB and you need to make it happen.
What T-SQL code should you use? (Each correct option is part of the answer. Choose TWO)
A. Use ABC.com;
B. Use ABC_DB; *
C. Use ABCSmp1;
D. Use ABCSmp2;
E. ALTER LOGIN MiaHamm WITH DEFAULT_DATABASE = ABC_DB;
F. CHANGE LOGIN MiaHamm WITH DEFAULT_DATABASE = ABC_DB;
G. ALTER LOGIN MiaHamm WITH PASSWORD = 'pwd1234' UNLOCK;
H. CHANGE LOGIN MiaHamm WITH PASSWORD = 'pwd1234' UNLOCK;
I. CHANGE USER MiaHamm WITH LOGIN = MiaHamm;
J. ALTER USER MiaHamm WITH LOGIN = MiaHamm; *
K. ALTER LOGIN MiaHamm ENABLE;
L. CHANGE LOGIN MiaHamm ENABLE;
Answer: B, J
Explanation:
Question 8.
You work as a database administrator at ABC.com. ABC.com is using a SQL Server 2008 instance. Your junior assistant is curious about on how to move a table, such as ABC_table, from its current scheme (scheme1) to another scheme (scheme2)
How can you accomplish this in T-SQL?
A. You should consider using the following:
ALTER TABLE Schema1.ABC_Table SWITCH TO Schema2.ABC_table;
B. You should consider using the following:
ALTER AUTHORIZATION ON Schema1.ABC_Table TO Schema2;
C. You should consider using the following:
ALTER SCHEMA schema2 TRANSFER schema1.ABC_table;
D. You should consider using the following:
ALTER SCHEMA schema1 TRANSFER schema2.ABC_table;
E. You should consider using the following:
ALTER USER Schema1 WITH DEFAULT_SCHEMA = Schema2;
F. You should consider using the following:
MOVE ABC_Table FROM SCHEMA schema1 TO schema2
G. You should consider using the following:
MOVE ABC_Table FROM schema1 TO schema2
Answer: C
Explanation:
ALTER SCHEMA can only be used to move securables between schemas in the same database. To change or drop a securable within a schema, use the ALTER or DROP statement specific to that securable.
Question 9.
You work as a database administrator at ABC.com. ABC.com is using a SQL Server 2008 instance. You have received instructions from management to allow the users at ABC.com on the SQL Server sample to use the OPENROWSET() function to search remote information sources. You study incomplete code in the exhibit carefully. (Line numbers are used for reference purposes only)
Exhibit:
01. sp_configure 'show advanced options', 1
02. RECONFIGURE
03.
04. RECONFIGURE
05. GO
06.
07. SELECT a.*
08. FROM OPENROWSET('SQLNCLI', 'Server=Madrid;Trusted_Connection=yes;',
09. 'SELECT GroupName, Name, DepartmentID
10. FROM AdventureWorks.HumanResources.Department
11. ORDER BY GroupName, Name') AS a;
12. GO
Which T-SQL statement should you insert at line 03 to make the batch meet the requirement in this scenario?
A. sp_configure 'Router control', 1
B. sp_configure 'Router control', 0
C. sp_configure 'Transaction Logs', 1
D. sp_configure 'Transaction Logs', 0
E. sp_configure 'Ad Lib Distributed Queries ', 1
F. sp_configure 'Ad Lib Distributed Queries ', 0
G. sp_configure 'Ad Hoc Distributed Queries', 1
H. sp_configure 'Ad Hoc Distributed Queries', 0
Answer: G
Explanation:
By default, SQL Server does not allow ad hoc distributed queries using OPENROWSET and OPENDATASOURCE. When this option is set to 1, SQL Server allows ad hoc access. When this option is not set or is set to 0, SQL Server does not allow ad hoc access. Ad hoc distributed queries use the OPENROWSET and OPENDATASOURCE functions to connect to remote data sources that use OLE DB. OPENROWSET and OPENDATASOURCE should be used only to reference OLE DB data sources that are accessed infrequently. For any data sources that will be accessed more than several times, define a linked server.
Question 10.
You work as a database administrator at ABC.com. ABC.com is using a SQL Server 2008 instance. The a SQL Server 2008 instance is used on a Windows Server 2000 server and uses the mixed authentication mode. Management wants you to ensure the following:
• SQL Server 2008 logins must have the same password complexity rules which are enforced by
Windows Server 2000 for authentication.
• Full compliance of all users with regarding to adhering to the password complexity rules.
What actions should you take?? (Each correct option is part of the answer. Choose TWO)
A. You should consider using the ALTER LOGIN ... CHECK_EXPIRATION = OFF statement to
change the entire login of all users.
B. You should consider using the ALTER LOGIN ... CHECK_EXPIRATION = ON statement to
change the entire login of all users.
C. You should consider using the command ALTER LOGIN ... NO CREDENTIAL.
D. You should consider using the command ALTER LOGIN ... UNLOCK.
E. You should consider using the command ALTER LOGIN ... ADD CREDENTIAL.
F. You should consider using the command ALTER LOGIN ... DROP CREDENTIAL.
G. You should consider using the ALTER LOGIN ... CHECK_POLICY = ON statement to change
the entire login of all users.
H. You should consider using the ALTER LOGIN ... CHECK_POLICY = OFF statement to change
the entire login of all users.
I. Create a policy using Policy-Based Management that matches the requirements of this
scenario.
J. You should consider using the ALTER LOGIN ... CREDENTIAL = statement to change the
entire login of all users.
Answer: G, I
Explanation:
ALTER LOGIN
CHECK_POLICY = { ON | OFF }
Applies only to SQL Server logins. Specifies that the Windows password policies of the computer on which SQL Server is running should be enforced on this login. The default value is ON. Policy-Based Management is a system for managing one or more instances of SQL Server 2008. When SQL Server policy administrators use Policy-Based Management, they use SQL Server Management Studio to create policies to manage entities on the server, such as the instance of SQL Server, databases, or other SQL Server objects.
Copyright © 2004 CertsBraindumps.com Inc. All rights reserved.