You are the DBA for an academic database. You need to create a role that allows a group of users to modify existing rows in the STUDENT_GRADES table. Which set of statements accomplishes this? ()
A . CREATE ROLL registrar; GRANT MODIFY ON student_grant TO registrar; GRANT registrar to user 1, user2, user3
B . CREATE NEW ROLE registrar; GRANT ALL ON student_grant TO registrar; GRANT registrar to user 1, user2, user3
C . CREATE ROLL registrar; GRANT UPDATE ON student_grant TO registrar; GRANT ROLE to user1, user2, user3
D . CREATE ROLL registrar; GRANT UPDATE ON student_grant TO registrar; GRANT registrar to user 1, user2, user3;
E . CREATE registrar; GRANT CHANGE ON student_grant TO registrar; GRANT registrar
-
As an experienced technician, you are responsible for Technical Support. A customer calls to ask the best signal level and noise level for cell phone. How to respond?()
A . -40dBm signal and -90dBm noise
B . -50dBm signal and -90dBm noise
C . -30dBm signal and -90dBm noise
D . -20dBm signal and -90dBm noise
-
You are analyzing the performance of a SQL Azure database. You need to recommend an approach for identifying the indexes that should be added to improve database performance. What should you recommend?()
A . Use SQL Server Profiler to identify missing indexes.
B . Use the Database Engine Tuning Advisor to identify missing indexes.
C . Use a Dynamic Management View to analyze query plans.
D . Use a DynamicManagement View to ascertain the number of pending I/O requests.
-
You examine the port statistics on a Cisco Catalyst switch and notice an excessive number offrames are being dropped. Which of the following are possible reasons for the drops?()
A . Unknown destination MAC address
B . Bad cabling
C . MAC forwarding table is full
D . Port configured for half duplex
E . Port configured for full duplex
F . Network congestio
-
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 records
B . a table name which has 10s of records
C . a table name which has empty records
D . a table name which has 1000s of records
E . never use a table name
-
As an experienced technician, you are responsible for Technical Support. One of the trainees isasking your advice on VPN Termination Device and Firewall Placement. Which of the following approaches will you recommend?()
A . inline with a firewall
B . in a DMZ outside the firewall
C . parallel with a firewall
D . in a DMZ behind the firewall
-
You are designing a plan to migrate an application to Windows Azure. The application generates log files in a proprietary format. You need to recommend an approach for retaining the existing log file format. What should you recommend?()
A . Configure Windows Azure Diagnostics to transfer event logs.
B . Configure Windows Azure Diagnostics to transfer directories.
C . Configure Windows AzureDiagnostics to transfer performance counters.
D . Configure Windows Azure Diagnostics to transfer basic Windows Azure logs.
-
You are managing an Oracle Database 10g database that uses Oracle Managed Files (OMF). You enabled the block change tracking feature for the database. Which statement regarding the change tracking file is true?()
A . One block change tracking file is created for each data file. By default, the file is created in DB_CREATE_FILE_DEST.
B . One block change tracking file is created for each data file. By default, the file is created in BACKGROUND_DUMP_DEST.
C . One block change tracking file is created for the database. By default, the file is created in DB_CREATE_FILE_DEST.
D . One block change tracking file is created for the database. By default, the file is created in BACKGROUND_DUMP_DEST.
-
As an experienced technician, you are responsible for infrastructure design and global configuration changes. You are asked to deploy a Voice over Wireless LAN for your company. If the cells have the same channel, the separation between them should be:()
A . 19dbm
B . 10dbm
C . 67dbm
D . 86dbm
-
As an experienced technician, you are responsible for Technical Support. Which of the followingdescriptions is correct about the characteristic of SLB one arm mode?()
A . This out-of-band approach supports scaling
B . SLB· is not inline.
C . Mode is not as common as bridge or routed mode.
D . Return traffic requires PB·R, server default gateway pointing to SLB·, or client source NAT·
-
As an experienced Network Engineer, you are required to implement the security architecture assessment. Which of the following statement describes the most important reason for that?()
A . Create a design specification document.
B . Integrate routing and switching components.
C . Document power and UPS availability
D . Document the customer's current and future technology projects.
-
You are managing an Oracle Database 11g instance.You want to create a duplicate database for testing purpose. What are the prerequisites for performing the active database duplication?()
A . The source database backup must be copied over the net for test database.
B . The source database must be run in ARCHIVELOG mode if the database is open.
C . The source database must be shut down cleanly if the database is in mounted state.
D . A net service name should be set up and a listener configured with the target as well as the source database.
-
You need to design an access control strategy for resources that are located in the extranet for partners and for internal users. Your solution must meet business and security requirements. What should you do?()
A . Create a new child domain named extranet.corp.woodgrovebank.com in the existing forest. Create user accounts for users from partner companies in the new child domain. Create shortcut trusts in which the child domain trusts every domain in the forest
B . Create a new forest and domain named extranet.woodgrovebank.com. Create user accounts for users from partner companies in the new domain. Create a one-way forest trust relationship in which the extranet forest trusts the company forest
C . Create a new forest and domain named extranet.woodgrovebank.com. Create user accounts for users from partner companies in the new domain. Create an external trust relationship in which the extranet domain trusts the den.corp.woodgrovebank.com domain
D . Create a child domain of the den.corp.woodgrovebank.com domain for the extranet. Create user accounts for users from partner companies in the new child domain. Create an external trust relationship in which the forest root domain trusts the extranet domai
-
You are maintaining the SALES database for an organization. You have enabled the Flashback Database feature and want to estimate the flashback space required for future operations. Which view would you query to estimate the flashback space required?()
A . V$DATABASE
B . V$FLASHBACK_DATABASE_STAT
C . V$FLASHBACK_DATABASE_LOG
D . V$RECOVERY_FILE_DEST
-
You are designing an authentication strategy for the accounting department. Your solution must meet business requirements. What should you do?()
A . Install wireless network cards on all accounting department computers. Select PEAP authentication
B . Install user certificates on all accounting department computers. Configure these computers to respond to requests for IPSec encryption
C . Issue smart cards and smart card readers to all accounting department users and computers. Require NTLMv2 authentication
D . Issue smart cards and smart card readers to all accounting department users and computers. Configure the domain to require smart cards for the accounting department users during logo
-
You are planning to move streaming media content to Windows Azure Storage. You need to recommend an approach for providing worldwide users the fastest possible access to the content. Which two actions should you recommend?()
A . Use a Shared Access Signature.
B . Use Windows Azure page blob storage.
C . Use Windows Azure block blob storage.
D . Use the Windows Azure Content Delivery Network (CDN).
-
As an experienced technician, you are responsible for Technical Support in your company. You ask one of the trainees to document the layers of an existing CIS network. Which three statements best characterize this process? ()(Choose three.)
A . It provides reliable input for verifying network consistency.
B . It requires a network audit to support some upgrade decisions.
C . It requires a network audit to support any network restructuring.
D . It begins with gathering organizational input that may be inaccurate.
-
You are the Database Administrator (DBA) of your company. You execute the following statement on an Oracle 10g instance: SQL> ALTER SYSTEM SWITCH LOGFILE; Which two tasks are performed when the statement is executed? ()
A . The DBWn process writes to the datafile.
B . Changes in the background process are recorded.
C . The log file is updated with the current SCN number.
D . The System Change Number (SCN) is recorded in the control file.
E . The changes to the listener configuration in the listener.ora file are recorded.
-
The datafiles of your database are ASM files. You are performing a check for datafile block corruption by using the DBVERIFY utility. What is a prerequisite for checking block corruption on an ASM datafile by using the DBVERIFY utility?()
A . The block change tracking feature must be enabled.
B . OMF must be configured on your database.
C . The database must be in ARCHIVELOG mode.
D . A USERID must be supplied.
-
You are designing a test plan for an existing Windows Azure .NET 4 application. Method calls return incorrect results for certain input parameters. You need to recommend an approach for debugging the method calls. What should you recommend?()
A . Attach the remote debugger to the application.
B . Use the Microsoft Visual Studio 2010 Test Manager tool.
C . Use IntelliTrace to collect only eventsfrom the application.
D . Use IntelliTrace to collect events and call information from the application.
-
As an experienced technician, you are responsible for Technical Support. Which of the following descriptions is correct about the characteristic of SLB one arm mode?()
A . This out-of-band approach supports scaling
B . SLB is not inline.
C . Mode is not as common as bridge or routed mode.
D . Return traffic requires PBR, server default gateway pointing to SLB, or client source NAT.
-
You are working on an Oracle Database 10g database. For which purposes would you use the Flashback Transaction Query feature? ()
A . To recover a dropped table.
B . To recover a dropped schema.
C . To recover data from a truncated table.
D . To view changes made by all the transactions during a given period of time.
E . To view changes made by a single transaction during a given period of time.
-
You are looking into an investment that will pay you $12,000 per year for the next 10 years. If you require a 15 percent return, the most you would pay for this investment is $_____________.
-
When you apply for an E-mail box, you are expected to fill in your necessary personal information before you _____ the form.
-
We are not in a position of placing an order with you for the table-cloths at the price you offered.()
A.of placing
B.table-cloths
C.at
D.offered