-
While creating a roaming user profile for a particular user, which path is defined under the Profile tab in user account properties windows as shown in the exhibit. ()https://assets.asklib.com/images/image2/2018073013341294983.jpg
A . Absolute Path
B . Relative or UNC path to the sharable profile folder
C . URL path to the web directory containing profile settings
D . Leave it blank. It is automatically filled when user logon.
-
You create a Web site that stores users' active themes in user profile objects. You need to apply users' preferred themes when they log on to the Web site. What should you do? （）
A . In the InitComplete event handler, set the Theme property of the Page object based on the user profile.
B . In the PreLoad event handler, set the Theme property of the Page object based on the user profile.
C . In the OnLoad event handler, set the Theme property of the Page object based on the user profile.
D . In the PreInit event handler, set the Theme property of the Page object based on the user profile.
-
The user SYS creates a job by using the following command:
https://assets.asklib.com/images/image2/2018080116584480510.jpg
Which two statements are true about the job that was created by the preceding command? （）(Choose two.)
A . The job is enabled by default after creation
B . The job is automatically dropped after the end date
C . The job executes with the privileges of the user SYS
D . The globalization environment that exists at the time of the job creation prevails at the job ru
-
View this parameter setting in your database： DB_CREATE_FILE_DEST=’D： \oracle\product\10.2.0\oradata\oracle’ You created a tablespace by using this command： CREATE TABLESPACE USERS； Which two statements are true about the USERS tablespace？（）
A . The tablespace has two data files.
B . An error is reported and tablespace creation fails.
C . Data files are created with names generated by the instance.
D . The tablespace can be extended without specifying the data file.
E . Data files belonging to the USERS tablespace cannot be renamed.
-
Examine the command that is used to create a table： SQL> CREATE TABLE orders（oid NUMBER（6） PRIMARY KEY， odate DATE， ccode NUMBER（6）， oamt NUMBER（10，2）） TABLESPACE users； Which two statements are true about the effect of the above command） （）
A . A CHECK constraint is created on the OID column.
B . A NOT NULL constraint is created on the OID column.
C . The ORDERS table is the only object created in the USERS tablespace.
D . The ORDERS table and a unique index are created in the USERS tablespace.
E . The ORDERS table is created in the USERS tablespace and a unique index is created on the OIDcolumn in the SYSTEM tablespace.
-
A user named User1 uses a computer that runs Windows XP Professional. You need to enable User1 to create local user accounts. You must minimize the rights assigned to the User1 account. Which group should you add User1 to?（）
A . Administrators
B . Power Users
C . Users
D . Network Configuration Operator
-
What is the correct command for creating a new user ID authenticated with LDAP？（）
A . mkuser -R LDAP
-
You are designing a migration strategy to create user IDs for all company users in the new environment. What should you do?（）
A . Create a script that uses Active Directory Services Interfaces (ADSI) to import all user account into the new environment.
B . Create new accounts for all users. Create a trust relationship between the existing environment and the new environment to enable access to resources in the existing environment.
C . Import all user accounts into the new environment by using the Active Directory Migration Tool (ADMT).
D . Import all user accounts into the new environment. Instruct users to no change their passwords during the migration phase so that they can access resources in the existing environment.
-
In order to find out how many database objects a user has created, which view would the DBA query in the Oracle data dictionary? （）
A . DBA_USERS
B . DBA_OBJECTS
C . DBA_TS_QUOTAS
D . DBA_TAB_PRIVS&e
-
What is the default value for the ENABLED attribute of a job or program when it is created? （）
A . TRUE
B . FALSE
C . There is no default. It must be defined at creation time.
D . PENDING
E . NULL
-
William is creating a job class. William specifies the LOGGING_FULL setting for the LOGGING_LEVEL attribute at the time of job class creation. What is the impact of using this setting？（）
A . Detailed information regarding the first run of each job in the class will be written in the job log， and every operation performed on the job class will be logged.
B . Detailed information regarding each run of only the first job in the class will be written in the job log， and every operation performed on the job class will be logged.
C . Detailed information regarding each run of each job in the class will be written in the job log， and every operation performed on the job class will be logged.
D . Detailed information regarding each run of each job in the class will be written in the job log， but operations performed on the job class will not be logged.
-
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 . REFERENCES
B . SELECT
C . UPDATE
D . ALTER
-
You create a Password Settings object （PSO）. You need to apply the PSO to a domain user named User1. What should you do（）
A . Modify the properties of the PSO.
B . Modify the account options of the User1 account.
C . Modify the security settings of the User1 account.
D . Modify the password policy of the Default Domain Policy Group Policy object （GPO）.
-
Examine the command that is used to create a table： SQL> CREATE TABLE orders（oid NUMBER（6） PRIMARY KEY， odate DATE， ccode NUMBER （6）， oamtNUMBER（10，2）） TABLESPACE users； Which two statements are true about the effect of the above command（）
A . A CHECK constraint is created on the OID column.
B . A NOT NULL constraint is created on the OID column.
C . The ORDERS table is the only object created in the USERS tablespace.
D . The ORDERS table and a unique index are created in the USERS tablespace.
E . The ORDERS table is created in the USERS tablespace and a unique index is created on the OID columnin the SYSTEM tablespace.
-
You created a database by using the Database Configuration Assistant. What must you do to access a user account in the sample schemas？（）https://assets.asklib.com/images/image2/2018080110052310043.jpg
A . A
B . B
C . C
D . D
-
The ORDERS table belongs to the user OE. OE has granted the SELECT privilege on the ORDERS table to the user HR.Which statement would create a synonym ORD so that HR can execute the following query successfully?（）
A . CREATE SYNONYM ord FOR orders; This command is issued by OE
B . CREATE PUBLIC SYNONYM ord FOR orders; This command is issued by OE
C . CREATE SYNONYM ord FOR oe.orders; This command is issued by the database administrator
D . CREATE PUBLIC SYNONYM ord FOR oe.orders; This command is issued by the database administrator&e
-
A customer has multiple application servers which create one process for each connected user. All users share the same AIX environment. What is a benefit of using WPARs in this environment？（）
A . WPARs give more controls for resource management than the traditional AIX operating system tools.
B . WPARs support Live Application Mobility which can be used to balance user processes acrosssystems.
C . WPARs each have a copy of the AIX kernel， offering better availability than a system without WPARs.
D . WPARs provide the ability to apply fixes specific for each environment， enabling the customer to create specialized application servers.
-
You create a Password Settings object （PSO）. You need to apply the PSO to a domain user named User1. What should you do（）
A . Modify the properties of the PSO.
B . Modify the account options of the User1 account.
C . Modify the security settings of the User1 account.
D . Modify the password policy of the Default Domain Policy Group Policy object （GPO）.
-
How to create enough jobs for the laid-off workers is a(n)
-
You are the network administrator for All servers run Windows Server 2003.You are creating a backup schedule for the main file server.You need to create a schedule so that backup jobs are completed in the shortestamount of time possible.What should you do？（）
A. Schedule a normal backup every Sunday. Schedule incremental backups every Monday through Saturday.
B. Schedule a normal backup every Sunday. Schedule differential backups every Monday through Saturday.
C. Schedule a copy backup every day.
D. Schedule a normal backup every day.
-
Examine the structure of the EMPLOYEES table:Column name Data type RemarksEMPLOYEE_ID NUMBER NOT NULL, Primary KeyEMP_NAME VARCHAR2(30)JOB_ID VARCHAR2(20) NOT NULLSAL NUMBERMGR_ID NUMBER References EMPLOYEE_ID columnDEPARTMENT_ID NUMBER Foreign key to DEPARTMENT_ID columnof the DEPARTMENTS tableYou need to create a view called EMP_VU that allows the users to insert rows through the view. Which SQL statement, when used to create the EMP_VU view, allows the users to insert rows？（）
A.CREATE VIEW emp_vu AS SELECT employee_id, emp_name, department_id FROM employees WHERE mgr_id IN (102, 120);
B.CREATE VIEW emp_vu AS SELECT employee_id, emp_name, job_id, department_id FROM employees WHERE mgr_id IN (102, 120);
C.CREATE VIEW emp_vu AS SELECT department_id, SUM(sal) TOTALSAL FROM employees WHERE mgr_id IN (102, 120) GROUP BY department_id;
D.CREATE VIEW emp_vu AS SELECT employee_id, emp_name, job_id, DISTINCT department_id FROM employees;
-
The database administrator of your company created a public synonym called HR for the HUMAN_RESOURCES table of the GENERAL schema, because many users frequently use this table. As a user of the database, you created a table called HR in your schema.What happens when you execute this query？（）
<img src='https://img2.soutiyun.com/shangxueba/ask/17133001-17136000/17135882/b1559080aa448ecf1a5fe7380a121c8c.jpg' />
A. You obtain the results retrieved from the public synonym HR created by the database administrator.
B. You obtain the results retrieved from the HR table that belongs to your schema.
C. You get an error message because you cannot retrieve from a table that has the same name as a public synonym.
D. You obtain the results retrieved from both the public synonym HR and the HR table that belongs to your schema, as a Cartesian product.
E. You obtain the results retrieved from both the public synonym HR and the HR table that belongs to your schema, as a FULL JOIN.
-
You create a Web Form that allows users to create a new account. You add a CreateUserWizard control by using the following code segment.You need to ensure that the wizard automatically sends an e-mail message to users when they finish creating their accounts. You add a valid element to the Web.config file.Which code segment should you add to the Page_Load event？（）
A.Wizard1.RequireEmail = True
B.Wizard1.Email = "user@address.com"
C.Wizard1.MailDefinition.From = "registration@mysite.com"
D.SmtpMail.SmtpServer = "mail.contoso.com"
-
Your network consists of a single Active Directory domain named contoso.com. The functional level of the domain is Windows Server 2003.You have a file server named Server1 that is used to store users’ home folders and profiles.On Server1, you create a folder named D:\data\ and share the folder as UserData. You create a new user account named TemplateUser in Active Directory.You need to ensure that each user account you create by copying TemplateUser is configured to have a unique home folder stored in the UserData share.Which home folder path should you specify？ （）
A.D：\data\%homedrive%
B.D：\data\%username%
C.\\server1\userdata\%homedrive%
D.\\server1\userdata\%username%
