310-814 dernières questions d'examen certification SUN et réponses publiés

Avec la version plus nouvelle de Q&A SUN 310-814, réussir le test SUN 310-814 n'est plus un rêve très loin pour vous. Pass4Test peut vous aider à réaliser ce rêve. Le test simualtion de Pass4Test est bien proche du test réel. Vous aurez l'assurance à réussir le test avec le guide de Pass4Test. Voilà, le succès est juste près de vous.

Pass4Test est un fournisseur professionnel des documentations à propos du test Certification IT, avec lequel vous pouvez améliorer le future de votre carrière. Vous trouverez que nos Q&As seraient persuadantes d'après d'avoir essayer nos démos gratuits. Le démo de SUN 310-814 (même que les autres démos) est gratuit à télécharger. Vous n'aurez pas aucune hésitation après travailler avec notre démo.

La Q&A SUN 310-814 de Pass4Test est liée bien avec le test réel de SUN 310-814. La mise à jour gratuite est pour vous après vendre. Nous avons la capacité à vous assurer le succès de test SUN 310-814 100%. Si malheureusement vous échouerez le test, votre argent sera tout rendu.

Code d'Examen: 310-814
Nom d'Examen: SUN (MySQL 5.0, 5.1 and 5.5 Certified Associate Exam)
Questions et réponses: 240 Q&As

L'équipe de Pass4Test rehcerche la Q&A de test certification SUN 310-814 en visant le test SUN 310-814. Cet outil de formation peut vous aider à se préparer bien dans une courte terme. Vous vous renforcerez les connaissances de base et même prendrez tous essences de test Certification. Pass4Test vous assure à réussir le test SUN 310-814 sans aucune doute.

Pour vous laisser savoir mieux que la Q&A SUN 310-814 produit par Pass4Test est persuadante, le démo de Q&A SUN 310-814 est gratuit à télécharger. Sous l'aide de Pass4Test, vous pouvez non seulement passer le test à la première fois, mais aussi économiser vos temps et efforts. Vous allez trouver les questions presque même que lesquels dans le test réel. C'est pourquoi tous les candidats peuvent réussir le test SUN 310-814 sans aucune doute. C'est aussi un symbole d'un meilleur demain de votre carrière.

On doit faire un bon choix pour passer le test SUN 310-814. C'est une bonne affaire à choisir la Q&A de Pass4Test comme le guide d'étude, parce que vous allez obtenir la Certification SUN 310-814 en dépensant d'un petit invertissement. D'ailleur, la mise à jour gratuite pendant un an est aussi gratuite pour vous. C'est vraiment un bon choix.

310-814 Démo gratuit à télécharger: http://www.pass4test.fr/310-814.html

NO.1 You work as a Database Administrator for a company. The company uses MySQL as its database.
The database contains a table named Employees. You want to remove an index named
Emp_name_idx from the Employees table. Which of the following statements should you use to
accomplish the task?
A. DELETE INDEXEmp_name_idx;
B. CANCEL INDEXEmp_name_idx;
C. REMOVE INDEXEmp_name_idx;
D. DROP INDEXEmp_name_idx;
Answer: D

SUN examen   certification 310-814   310-814   310-814   certification 310-814

NO.2 Adam works as a Database Administrator for a company. He creates a table named Students. He wants
to create a new table named Class with the help of the Students table. Which of the
following syntaxes will Adam use to accomplish the task?
A. CREATE TABLE Class
INSERT INTO SELECT * FROM Students;
B. CREATE TABLE Class
FROM SELECT * FROM Students;
C. CREATE TABLE Class
(SELECT * FROM Students);
D. CREATE TABLE Class
AS SELECT * FROM Students;
Answer: D

SUN   310-814 examen   310-814   310-814

NO.3 Fill in the blank with the appropriate word.
The data type defines a date that is combined with a time of day along with fractional
seconds that is based on a 24-hour clock.
A. datetime
Answer: A

SUN   certification 310-814   310-814

NO.4 Which of the following are the types of numeric literals that can be used in arithmetic expressions?
Each correct answer represents a complete solution. Choose all that apply.
A. Numeric
B. Integer
C. Binary
D. Real
Answer: B,D

certification SUN   310-814   310-814

NO.5 You work as a Database Administrator for a company. The company uses the MySQL database.
You have created a table named Employees. The table contains the following structurE.
The company has three departments. A task has been assigned to you to calculate the sum of the
average length of employees' last name per department. Which of the following queries will you
execute to accomplish the task?
A. SELECTSUM(AVG(LENGTH(last_name))) FROM Employees HAVING department_id;
B. SELECTSUM(AVG(LENGTH(last_name))) FROM Employees GROUP BY department_id;
C. SELECTSUM(AVG(LENGTH(last_name))) FROM Employees WHERE department_id=NOT
NU LL;
D. SELECTSUM(AVG(LENGTH(last_name))) FROM Employees ORDER BY department_id;
Answer: B

SUN   certification 310-814   310-814   certification 310-814

NO.6 Fill in the blank with the appropriate word.
A specifies that the value of a column (or columns), upon which the index is based, must
be unique.
A. unique index
Answer: A

SUN   310-814   310-814   310-814

NO.7 You work as a Database Administrator for a company. The company uses MySQL as its database.
You have created a table named Employees in the database. You want to create a list of
employees working in the organization, but you do not want to display any duplicate row in the
report. Which of the following statements will help you to accomplish the task?
A. SELECTemp_id, emp_name FROM Employees ORDER BY emp_id;
B. SELECTemp_id, emp_name FROM Employees;
C. SELECT DISTINCTemp_id, emp_name FROM Employees;
D. SELECTemp_id, emp_name FROM Employees GROUP BY emp_id;
Answer: C

SUN   310-814   310-814   310-814   310-814

NO.8 Adam works as a Database Administrator for a company. Adam has created a table named
Students. In this table, Adam wants to create a column to store the fees of students. Which of the
following data types will Adam use to accomplish the task?
Each correct answer represents a complete solution. Choose all that apply.
A. NUMBER
B. NUMBER(p,s)
C. DEFAULT
D. BLOB
Answer: A,B

SUN   310-814   310-814 examen   310-814   310-814 examen

NO.9 You work as a Database Administrator for a company. The company uses MySQL as its database.
You have created two tables named Employees and Departments in the database. Now, you want
to display data from both tables. Which of the following actions will you perform to accomplish the task?
A. Join
B. Table Merge operator
C. HAVING
D. GROUP BY
Answer: A

SUN   310-814   310-814   310-814   310-814

NO.10 Adam works as a Database Administrator for a company. The company uses MySQL as its
database. Adam has created a table named Employees in the database. He wants to retrieve the
information of those employees who have at least one person reporting to them. Which of the
following queries will Adam execute to accomplish the task?
A. SELECTemployee_id, last_name, job_id, department_id FROM Employees WHERE
employee_id
EXISTS (SELECT manager_id WHERE manager_id is NULL);
B. SELECTemployee_id, last_name, job_id, department_id FROM Employees HAVING
employee_id
IN (SELECT manager_id FROM Employees WHERE manager_id is NOT NULL);
C. SELECTemployee_id, last_name, job_id, department_id FROM Employees outer WHERE
EXISTS
(SELECT 'x' FROM Employees WHERE manager_id = outer.employee_id);
D. SELECTemployee_id, last_name, job_id, department_id FROM Employees WHERE
employee_idIN
(SELECT manager_id WHERE manager_id is NOT NULL);
Answer: C

SUN   certification 310-814   certification 310-814   310-814   310-814   310-814

NO.11 You work as a Database Administrator for a company. The company uses MySQL as its database.
You have written two statements, which are as follows:
1. SELECT DISTINCT OBJECT_TYPE
FROM USER_OBJECTS;
2. SELECT OBJECT_TYPE
FROM ALL_OBJECTS;
Which of the following options explains the difference between the results of these two
statements? Each correct answer represents a complete solution. Choose all that apply.
A. The first statement will display distinct object types that can be accessed by the user.
B. The second statement will display all object types that a user can access.
C. The first statement will display distinct object types owned by a user.
D. The second statement will display all object types owned by a user.
Answer: B,C

SUN   certification 310-814   310-814   310-814   310-814

NO.12 Review the following ER diagram:
Which of the following SQL statements will return all rows for a given CUST_ID and PROD_ID
where sales of specific products on a given day are greater than 10?
Additionally the list should be ordered by CUST_LAST_NAME, CUST_FIRST_NAME and
PROD_NAME.
A. SELECTa.cust_last_name, a.cust_first_name, b.prod_name, c.time_id
FROM customers a, products b, times c, sales e
WHERE a.cust_id=e.cust_id
AND b.prod_id=e.prod_id
AND c.time_id=e.time_id
B. GROUP BYa.cust_last_name, a.cust_first_name, b.prod_name, c.time_id
HAVING COUNT(*) > 10
ORDER BY a.cust_last_name, a.cust_first_name, b.prod_name, c.time_id;
C. SELECTa.cust_last_name, a.cust_first_name, b.prod_name, c.time_id, COUNT(*)
FROM customers a, products b, times c, sales e
WHERE a.cust_id=e.cust_id
AND b.prod_id=e.prod_id
AND c.time_id=e.time_id
GROUP BY a.cust_last_name, a.cust_first_name, b.prod_name, c.time_id
HAVING COUNT(*) > 10;
D. SELECTa.cust_last_name, a.cust_first_name, b.prod_name, c.time_id, COUNT(*)
FROM customers a, products b, times c, sales e
WHERE a.cust_id=e.cust_id
AND b.prod_id=e.prod_id
AND c.time_id=e.time_id
GROUP BY a.cust_last_name, a.cust_first_name, b.prod_name, c.time_id
HAVING COUNT(*) > 10
ORDER BY a.cust_last_name, a.cust_first_name, b.prod_name, c.time_id;
E. SELECTa.cust_last_name, a.cust_first_name, b.prod_name, c.time_id, COUNT(*) TOTAL
FROM customers a, products b, times c, sales e
WHERE a.cust_id=e.cust_id
AND b.prod_id=e.prod_id
AND c.time_id=e.time_id
GROUP BY a.cust_last_name, a.cust_first_name, b.prod_name, c.time_id
ORDER BY a.cust_last_name, a.cust_first_name, b.prod_name, c.time_id;
F. SELECTa.cust_last_name, a.cust_first_name, b.prod_name, c.time_id,
COUNT(*) TOTAL
FROM customers a, products b, times c, sales e
WHERE a.cust_id=e.cust_id
AND b.prod_id=e.prod_id
AND c.time_id=e.time_id
AND total > 10
GROUP BY a.cust_last_name, a.cust_first_name, b.prod_name, c.time_id
ORDER BY a.cust_last_name, a.cust_first_name, b.prod_name, c.time_id;
Answer: C

SUN   certification 310-814   certification 310-814

NO.13 Speed Inc. is a courier company. It delivers letters, parcels, and other items to their desired
destination. The company wants to create a database that keeps the records of items received,
items delivered, and also the information about any undelivered item. A table named Courierdetail has the
following attributes:
CustomerName
Address
ContactNumber
DateOfReceiving
DeliveryAcknowledgement
Which of the above-mentioned attributes can be designated as the primary key?
A. CustomerName
B. None of the attributes can be designated as the primary key.
C. Address
D. ContactNumber
Answer: B

SUN   310-814   310-814 examen   310-814 examen   310-814   310-814 examen

NO.14 FreeE
Consider the exhibit given below:
Which of the following queries will return the name of the customer who placed the highest amount of
orders and the total order amount?
A. SELECT CUSTOMER,MAX(UNITPRICE*QUANTITY) AS "TOTAL"
FROM ORDERS
GROUP BY CUSTOMER
/
B. SELECT CUSTOMER,SUM(UNITPRICE*QUANTITY) AS "TOTAL"
FROM ORDERS
WHERE SUM(UNITPRICE*QUANTITY)=
(SELECT MAX(SUM(UNITPRICE*QUANTITY))
FROM ORDERS
GROUP BY CUSTOMER)
GROUP BY CUSTOMER
/
C. SELECT CUSTOMER,SUM(UNITPRICE*QUANTITY) AS "TOTAL"
FROM ORDERS
GROUP BY CUSTOMER
HAVING SUM(UNITPRICE*QUANTITY)=
(SELECT MAX(SUM(UNITPRICE*QUANTITY))
FROM ORDERS
GROUP BY CUSTOMER)
/
D. SELECT CUSTOMER,SUM(UNITPRICE*QUANTITY) AS "TOTAL"
FROM ORDERS
GROUP BY CUSTOMER
HAVING SUM(UNITPRICE*QUANTITY)=
(SELECT SUM(UNITPRICE*QUANTITY)
FROM ORDERS
GROUP BY CUSTOMER)
/
Answer: C

SUN   certification 310-814   310-814   310-814

NO.15 You work as a Database Administrator for a company. The company uses MySQL as its database
development platform. You have created a table named Employees in the database. You want to
display the names of the employees whose salary is more than $5000, but you do not want to
display any duplicate content. Therefore, you have written the following query:
SELECT emp_id, DISTINCT emp_name WHERE salary > 5000
FROM Employees;
Which of the following statements is true about the above query?
A. The statement will display only unique names whose salary is more than $5000.
B. The UNIQUE clause should be used in place of the DISTINCT clause.
C. The statement will give an error.
D. The statement will display those records whose salary is more than $5000.
Answer: C

SUN   certification 310-814   310-814   310-814   310-814

NO.16 Which of the following statements is correct for equijoin used to join two tables named Employees and
Department?
A. SELECTDept_Name, Emp_Name
FROM Departments d1, Employees e1
ORDER BY Dept_Name, Emp_Name;
B. SELECTD.Dept_Name, E.Emp_Name
FROM Departments d1, Employees e1
HAVING Dept_Name, Emp_Name;
C. SELECTE.Emp_Name,
D. Dept_Name
FROM Departments d1, Employees e1
WHERE Dept_No = Dept_No
ORDER BY Dept_Name, Emp_Name;
E. SELECTDept_Name, Emp_Name
FROM Departments d1, Employees e1
WHERE d1.Dept_No = e1.Dept_No
ORDER BY Dept_Name, Emp_Name;
Answer: D

SUN   310-814   certification 310-814   310-814   certification 310-814

NO.17 Which of the following functions can be performed by a view?
Each correct answer represents a complete solution. Choose all that apply.
A. Restrict a user to specific columns in a table.
B. Contain a sub query in the FROM clause.
C. Join columns from multiple tables, so that they look like a single table.
D. Restrict a user to specific rows in a table.
Answer: A,C,D

SUN   310-814   310-814   certification 310-814   certification 310-814

NO.18 You work as a Database Administrator for a company. The company uses MySQL as the
database platform. You have created a table named Students in the database. The structure of the table is
as follows:
Stu_IDNUMBER (3) PRIMARY KEY
Stu_NameVARCHAR2 (25) NOT NULL
Fee NUMBER (8, 2)
Class NUMBER (5);
You have executed the following statement for the table "Students":
SELECT e.Stu_Name, m.Fee
FROM Students e, Students m
WHERE e.Stu_ID = m.stu_ID;
Which of the following join types have you used in the above statement?
A. Cross join
B. Equijoin
C. Self join
D. Outer join
Answer: C

SUN   310-814   310-814

NO.19 Which of the following properties of concurrency control refers to the requirement that other
operations cannot access or see the data in an intermediate state during the execution of a
transaction?
A. Consistency
B. Durability
C. Atomicity
D. Isolation
Answer: D

certification SUN   310-814   310-814   310-814

NO.20 Which of the following are true about UPDATE statements?
Each correct answer represents a complete solution. Choose all that apply.
A. You can use the WHERE clause to have your update affects a specific set of rows.
B. You use the SET clause to update multiple columns of a table separated by commas.
C. You can use co-related sub query in UPDATE statements to update data from other tables.
D. If you don't use the WHERE clause then the UPDATE will not update any rows in the table.
Answer: A,B,C

SUN examen   310-814   310-814   certification 310-814   310-814

NO.21 You work as a Database Administrator for a company. The company uses MySQL as its database.
You have created a new table named Employees, which keeps all the information of the
employees. You want to add a new row to the Employees table. Which of the following statements
will you use to accomplish the task?
A. INSERT (column1,column2, ...columnN) INTO <table_name> VALUES(value1, value2, ...v
alueN);
B. INSERT INTO <table_name>(column1, column2, ...columnN) VALUES(value1 ,value2,
...va lueN);
C. INSERT <table_name>(column1, column2, ...columnN), VALUES(value1, value2, ...valueN
);
D. INSERT INTO <table_name>(column1, column2,... columnN), VALUES(value1, value2,
...v alueN);
Answer: B

SUN   310-814 examen   310-814 examen   310-814 examen

NO.22 Which of the following statements will delete all the records from the table T1?
Each correct answer represents a complete solution. Choose all that apply.
A. TRUNCATE TABLE T1;
B. DELETE FROM T1;
C. DELETE * FROM T1;
D. DELETE T1;
Answer: A,B,D

SUN   310-814   310-814 examen

NO.23 Considering the exhibit given below:
SQL> INSERT INTO T1 VALUES (10,'JOHN');
1 row created
SQL> INSERT INTO T1 VALUES (12,'SAM');
1 row created
SQL> INSERT INTO T1 VALUES (15,'ADAM');
1 row created
SQL> SAVEPOINT A;
Savepointcreated SQL>
UPDATE T1
2 SET NAME='SCOTT'
3 WHERE CUST_NBR=12;
1 row updated
SQL> SAVEPOINT B;
Savepointcreated
SQL> DELETE FROM T1 WHERE NAME LIKE '%A%';
1 row deleted
SQL> GRANT SELECT ON T1 TO BLAKE;
Grant succeeded
SQL> ROLLBACK;
Rollback complete
What will be the output of SELECT * FROM T1;?
A. CUST_NBR NAME
---------------- ---------
10 JOHN
B. CUST_NBR NAME
---------------- ---------
10 JOHN
12 SCOTT
15 ADAM
C. CUST_NBR NAME
---------------- ---------
10 JOHN
15 ADAM
D. CUST_NBR NAME
---------------- ---------
10 JOHN
12 SCOTT
Answer: D

SUN examen   310-814 examen   310-814 examen

NO.24 DRAG DROP
Drag and drop the correct constraint types to their corresponding specifications.
Answer:

NO.25 You work as a Database Administrator for a company. The company uses the MySQL database.
You have created a new table named Employees in the database and performed update operation but
you got an error because of the last transaction. Now, you want to terminate the last transaction. Which of
the following commands can you use to accomplish the task?
Each correct answer represents a complete solution. Choose all that apply.
A. ROLLBACK
B. REMOVE
C. DELETE
D. COMMIT
Answer: A,D

SUN examen   310-814 examen   certification 310-814   310-814 examen

NO.26 Which of the following will be true about a table column if you plan to create an index on that
column?
Each correct answer represents a complete solution. Choose all that apply.
A. The column is often used in the WHERE clause of SQL statements.
B. The column contains very small number of NULL values.
C. The table is updated frequently.
D. The column should contain a wide range of values.
Answer: A,D

SUN   certification 310-814   310-814

NO.27 You work as a Database Administrator for a company. The company uses MySQL as its database.
You want to use group functions, so you have decided to put an alias of group functions as 'GP'.
Which of the following are the correct ways to use group functions?
Each correct answer represents a complete solution. Choose all that apply.
A. GP1(GP2(GPn(group_item))) = result
B. GP1(GP2(group_item)) = result
C. GP1(GP2(GP3(group_item))) = result
D. GP1(group_item) = result
Answer: B,D

certification SUN   certification 310-814   310-814   310-814   310-814

NO.28 Fill in the blank with the appropriate term.
A provides a concise and flexible means for matching strings of text,
suchas particular characters, words, or patterns of characters.
A. regular expression
Answer: A

SUN   310-814 examen   310-814   310-814 examen

NO.29 Which of the following provides reliable units of work that allow correct recovery from failures and
keeps a database consistent even in cases of system failure?
A. Database security B.
Two-phase commit C.
Concurrency control
D. Database transaction
Answer: D

SUN   310-814   certification 310-814   310-814

NO.30 Which of the following terms is described in the statement below?
"It is procedural code that is automatically executed in response to certain events on a particular
table or view in a database."
A. Data type
B. Table
C. Datetime data type
D. Database trigger
Answer: D

certification SUN   310-814   310-814 examen   310-814 examen

Maintenant, beaucoup de professionnels IT prennent un même point de vue que le test SUN 310-814 est le tremplin à surmonter la pointe de l'Industrie IT. Beaucoup de professionnels IT mettent les yeux au test Certification SUN 310-814.

Dernières SUN 310-814 310-813 310-045 310-400 examen pratique questions et réponses

On peut voir que beaucoup de candidats ratent le test SUN 310-814 310-813 310-045 310-400 quand même avec l'effort et beaucoup de temps dépensés. Cest une bonne preuve que le test SUN 310-814 310-813 310-045 310-400 est difficile à réussir. Pass4Test offre le guide d'étude bien fiable. Sauf le test SUN 310-814 310-813 310-045 310-400, Pass4Test peut offrir les Q&As des autres test Certification IT.

Pass4Test est un site web qui vous donne plus de chances à passer le test de Certification SUN 310-814 310-813 310-045 310-400. Le résultat de recherche sortis par les experts de Pass4Test peut assurer que ce sera vous ensuite qui réussirez le test SUN 310-814 310-813 310-045 310-400. Choisissez Pass4Test, choisissez le succès. L'outil de se former de Pass4Test est bien efficace. Parmi les gens qui ont déjà passé le test, la majorité a préparé le test avec la Q&A de Pass4Test.

310-814 310-813 310-045 310-400 est un test de SUN Certification, donc réussir 310-814 310-813 310-045 310-400 est le premier pas à mettre le pied sur la Certifiction SUN. Ça peut expliquer certiainement pourquoi le test SUN 310-814 310-813 310-045 310-400 devient de plus en plus chaud, et il y a de plus en plus de gens qui veulent participer le test 310-814 310-813 310-045 310-400. Au contraire, il n'y a que pas beaucoup de gens qui pourrait réussir ce test. Dans ce cas, si vous vous réfléchissez étudier avec une bonne Q&A?

Code d'Examen: 310-814

Nom d'Examen: SUN (MySQL 5.0, 5.1 and 5.5 Certified Associate Exam)

Questions et réponses: 240 Q&As

Code d'Examen: 310-813

Nom d'Examen: SUN (MySQL 5.0 Developer Certified Professional Exam, Part II )

Questions et réponses: 70 Q&As

Code d'Examen: 310-045

Nom d'Examen: SUN (NetBeans Integrated Development Environment 6.1 Programmer Certified Expert Exam)

Questions et réponses: 122 Q&As

Code d'Examen: 310-400

Nom d'Examen: SUN (Sun Certified Integrator for Identity Manager 7.1)

Questions et réponses: 56 Q&As

Ajoutez le produit de Pass4Test au panier, vous pouvez participer le test avec une 100% confiance. Bénéficiez du succès de test SUN 310-814 310-813 310-045 310-400 par une seule fois, vous n'aurez pas aucune raison à refuser.

Le test certification SUN 310-814 310-813 310-045 310-400 est une bonne preuve de connaissances professionnelles et la techniques. Dans l'Industrie IT, beaucoiup de humains ressource font l'accent de lesquels certificats que les volontiers obtiennent. C'est clairement que le certificat SUN 310-814 310-813 310-045 310-400 puisse augmenter la compétition dans ce marché.

Nous croyons que pas mal de candidats voient les autres site web qui offrent les ressources de Q&A SUN 310-814 310-813 310-045 310-400. En fait, le Pass4Test est le seul site qui puisse offrir la Q&A recherchée par les experts réputés dans l'Industrie IT. Grâce à la Q&A de Pass4Test impressionée par la bonne qualité, vous pouvez réussir le test SUN 310-814 310-813 310-045 310-400 sans aucune doute.

310-400 Démo gratuit à télécharger: http://www.pass4test.fr/310-400.html

NO.1 A company has 30,000 employees with identities spread across multiple resources on
heterogeneous platforms. The company has issues with publishing corporate data to its web site
in a timely and secure fashion. The IT department is inundated with requests for password resets.
The corporation has security concerns about unknown active accounts and wants fine-grained
control over corporate resources. Company auditors require quarterly reports of employee
resource entitlements, certified by their managers. In addition, the company wants to streamline its
product channel with a partner corporation by sharing corporate resources. Which two business
drivers support deploying Identity Manager? (Choose two.)
A. The company wants to enhance IT security by intercepting access requests to authorize users
for applications.
B. The company wants to reduce IT costs by implementing self-service password reset.
C. The company wants to enhance IT security by detecting and preventing network intrusion.
D. The company wants to reduce IT costs by implementing single sign-on (SSO).
E. The company wants to enhance IT security by automating the deprovisioning of accounts.
F. The company wants to enhance IT security by maintaining digital signatures.
Answer: B,E

SUN examen   310-400 examen   310-400 examen   310-400 examen

NO.2 What are three of the essential features of the XPRESS language? (Choose three.)
A. uses Postfix notation
B. uses Prefix notation
C. is structured using XML syntax
D. is compiled
E. describes an SPML syntax
F. has notion of libraries
Answer: B,C,F

SUN   310-400   certification 310-400

NO.3 Which two business factors support the configuration of Identity Manager SPE? (Choose two.)
A. The solution must support provisioning of up to 100,000 employee identities across disparate
systems.
B. The solution must support a self-service account feature for 1,000,000+ customer identities.
C. The solution must support complex approval processes for all provisioning requests.
D. The solution must utilize a corporate LDAP resource as its user repository.
E. The solution must maintain a single repository for all identities, request state, configuration, and
audit data.
Answer: B,D

SUN   certification 310-400   310-400   310-400

NO.4 When a work item is generated by an executing task, the top-level variable userview is copied
into
the WorkItem data model. Which variable name is used to reference the userview?
A. userview
B. task.userview
C. variable.userview
D. variables.userview
E. context.userview
F. baseContext.userview
G. display.userview
Answer: D

SUN   certification 310-400   310-400 examen   310-400 examen

NO.5 Which statement is NOT true?
A. Attestations allow managers to sign off on an employees entitlements as appropriate to the
employees job function and responsibilities.
B. Mitigations allow a manager or other responsible individual to acknowledge and sustain a
control violation with appropriate cause or
conditions.
C. Remediations allow a manager or other responsible individual to correct a control violation
immediately, which is reflected in the entitlement
record that is saved for audit reporting.
D. Policy scans must be launched in auditor to catch control violations resulting from provisioning
through the Identity Manager side.
E. Entitlements are snapshots of access rights generated at the time of an access scan to record
attestation reviews for reporting and forensics;
however, they can be updated using rescans to reflect the absolute latest entitlements.
Answer: D

SUN   310-400   310-400   310-400   certification 310-400

NO.6 Which three SPML 1.0 ExtendedRequests has the SPML 2.0 implementation standardized?
(Choose three.)
A. disableUser
B. launchProcess
C. resetUserPassword
D. changeUserPassword
E. listResourceObjects
F. runForm
Answer: A,C,D

SUN   certification 310-400   310-400   310-400 examen   310-400

NO.7 A company has a policy of using the first initial from a users name concatenated with the
users
last name plus a counter to generate unique user names. For example, a user named John Doe
would be assigned jdoe as a user name. The second John Doe hired would be assigned jdoe2
and so on. Why might this approach be problematic?
A. Multiple users can be assigned the same user name.
B. Identity Manager cannot programmatically concatenate names.
C. Identity Manager cannot specify user names; these come from authoritative sources.
D. Name changes make historical reporting and auditing difficult.
E. Identity Manager has no way of knowing or generating the next available counter.
Answer: D

certification SUN   310-400   certification 310-400

NO.8 Which major deliverable will require the identification of an authoritative source for user
identity?
A. user self service
B. password management
C. identity synchronization
D. delegated administration
E. password management and delegated administration
Answer: C

SUN examen   310-400   310-400 examen

NO.9 Identity Manager uses Confirmation and Correlation rules while performing synchronization
tasks.
Which of these rules provides faster processing and why?
A. The Confirmation Rule is faster because it uses only a single AttributeCondition clause in the
rule syntax.
B. The Correlation Rule is faster because it uses only a single AttributeCondition clause in the rule
syntax.
C. The Correlation Rule is faster because it uses only data contained in the repository.
D. The Confirmation Rule is faster because it uses only data contained in the repository.
Answer: C

certification SUN   310-400   310-400   310-400 examen

NO.10 Which two features are provided by Identity Manager to improve audit compliance? (Choose
two.)
A. Audit controls are enforced upon provisioning.
B. Resource groups encapsulate fine-grained entitlements that can be assigned to a user by a
manager, ensuring fine-grained, separation of
duties.
C. Roles allow managers to assign entitlements while ensuring separation of duties.
D. Identity Manager stores and encrypts all personal data, such as government-issued IDs.
E. Identity Manager supports reading of resource logs for forensic analysis and reporting.
Answer: A,C

SUN   certification 310-400   310-400 examen   310-400

Guide de formation plus récente de SUN 310-814

Le Certificat SUN 310-814 est un passport rêvé par beaucoup de professionnels IT. Le test SUN 310-814 est une bonne examination pour les connaissances et techniques professionnelles. Il demande beaucoup de travaux et efforts pour passer le test SUN 310-814. Pass4Test est le site qui peut vous aider à économiser le temps et l'effort pour réussir le test SUN 310-814 avec plus de possibilités. Si vous êtes intéressé par Pass4Test, vous pouvez télécharger la partie gratuite de Q&A SUN 310-814 pour prendre un essai.

Pass4Test peut vous fournir un raccourci à passer le test SUN 310-814: moins de temps et efforts dépensés. Vous trouverez les bonnes documentations de se former dans le site Pass4Test qui peut vous aider efficacement à réussir le test SUN 310-814. Si vous voyez les documentations dans les autres sites, c'est pas difficile à trouver qu''elles sont venues de Pass4Test, parce que lesquelles dans Pass4Test sont le plus complété et la mise à jour plus vite.

Pour l'instant, vous pouvez télécharger le démo gratuit de Q&A SUN 310-814 dans Pass4Test pour se former avant le test SUN 310-814.

Pass4Test vous promet de vous aider à passer le test SUN 310-814, vous pouvez télécharger maintenant les Q&As partielles de test SUN 310-814 en ligne. Il y a encore la mise à jour gratuite pendant un an pour vous. Si vous malheureusement rater le test, votre argent sera 100% rendu.

Code d'Examen: 310-814

Nom d'Examen: SUN (MySQL 5.0, 5.1 and 5.5 Certified Associate Exam)

Questions et réponses: 240 Q&As

310-814 Démo gratuit à télécharger: http://www.pass4test.fr/310-814.html

NO.1 You work as a Database Administrator for a company. The company uses the MySQL database.
You have created a new table named Employees in the database and performed update operation but
you got an error because of the last transaction. Now, you want to terminate the last transaction. Which of
the following commands can you use to accomplish the task?
Each correct answer represents a complete solution. Choose all that apply.
A. ROLLBACK
B. REMOVE
C. DELETE
D. COMMIT
Answer: A,D

certification SUN   310-814 examen   certification 310-814

NO.2 You work as a Database Administrator for a company. The company uses the MySQL database.
You have created a table named Employees. The table contains the following structurE.
The company has three departments. A task has been assigned to you to calculate the sum of the
average length of employees' last name per department. Which of the following queries will you
execute to accomplish the task?
A. SELECTSUM(AVG(LENGTH(last_name))) FROM Employees HAVING department_id;
B. SELECTSUM(AVG(LENGTH(last_name))) FROM Employees GROUP BY department_id;
C. SELECTSUM(AVG(LENGTH(last_name))) FROM Employees WHERE department_id=NOT
NU LL;
D. SELECTSUM(AVG(LENGTH(last_name))) FROM Employees ORDER BY department_id;
Answer: B

SUN   certification 310-814   310-814   310-814

NO.3 Speed Inc. is a courier company. It delivers letters, parcels, and other items to their desired
destination. The company wants to create a database that keeps the records of items received,
items delivered, and also the information about any undelivered item. A table named Courierdetail has the
following attributes:
CustomerName
Address
ContactNumber
DateOfReceiving
DeliveryAcknowledgement
Which of the above-mentioned attributes can be designated as the primary key?
A. CustomerName
B. None of the attributes can be designated as the primary key.
C. Address
D. ContactNumber
Answer: B

certification SUN   310-814   310-814   certification 310-814

NO.4 Adam works as a Database Administrator for a company. He creates a table named Students. He wants
to create a new table named Class with the help of the Students table. Which of the
following syntaxes will Adam use to accomplish the task?
A. CREATE TABLE Class
INSERT INTO SELECT * FROM Students;
B. CREATE TABLE Class
FROM SELECT * FROM Students;
C. CREATE TABLE Class
(SELECT * FROM Students);
D. CREATE TABLE Class
AS SELECT * FROM Students;
Answer: D

certification SUN   310-814   310-814

NO.5 Which of the following properties of concurrency control refers to the requirement that other
operations cannot access or see the data in an intermediate state during the execution of a
transaction?
A. Consistency
B. Durability
C. Atomicity
D. Isolation
Answer: D

certification SUN   310-814   310-814 examen

NO.6 You work as a Database Administrator for a company. The company uses MySQL as its database.
You have created two tables named Employees and Departments in the database. Now, you want
to display data from both tables. Which of the following actions will you perform to accomplish the task?
A. Join
B. Table Merge operator
C. HAVING
D. GROUP BY
Answer: A

certification SUN   310-814 examen   310-814   310-814 examen   310-814 examen

NO.7 Which of the following will be true about a table column if you plan to create an index on that
column?
Each correct answer represents a complete solution. Choose all that apply.
A. The column is often used in the WHERE clause of SQL statements.
B. The column contains very small number of NULL values.
C. The table is updated frequently.
D. The column should contain a wide range of values.
Answer: A,D

SUN   310-814 examen   310-814   310-814

NO.8 You work as a Database Administrator for a company. The company uses MySQL as its database.
You have created a table named Employees in the database. You want to create a list of
employees working in the organization, but you do not want to display any duplicate row in the
report. Which of the following statements will help you to accomplish the task?
A. SELECTemp_id, emp_name FROM Employees ORDER BY emp_id;
B. SELECTemp_id, emp_name FROM Employees;
C. SELECT DISTINCTemp_id, emp_name FROM Employees;
D. SELECTemp_id, emp_name FROM Employees GROUP BY emp_id;
Answer: C

SUN   certification 310-814   310-814 examen   certification 310-814   310-814

NO.9 You work as a Database Administrator for a company. The company uses MySQL as its database.
You have created a new table named Employees, which keeps all the information of the
employees. You want to add a new row to the Employees table. Which of the following statements
will you use to accomplish the task?
A. INSERT (column1,column2, ...columnN) INTO <table_name> VALUES(value1, value2, ...v
alueN);
B. INSERT INTO <table_name>(column1, column2, ...columnN) VALUES(value1 ,value2,
...va lueN);
C. INSERT <table_name>(column1, column2, ...columnN), VALUES(value1, value2, ...valueN
);
D. INSERT INTO <table_name>(column1, column2,... columnN), VALUES(value1, value2,
...v alueN);
Answer: B

SUN examen   310-814 examen   310-814   310-814   310-814

NO.10 Which of the following are true about UPDATE statements?
Each correct answer represents a complete solution. Choose all that apply.
A. You can use the WHERE clause to have your update affects a specific set of rows.
B. You use the SET clause to update multiple columns of a table separated by commas.
C. You can use co-related sub query in UPDATE statements to update data from other tables.
D. If you don't use the WHERE clause then the UPDATE will not update any rows in the table.
Answer: A,B,C

SUN   310-814   310-814   310-814   310-814 examen

NO.11 Fill in the blank with the appropriate word.
The data type defines a date that is combined with a time of day along with fractional
seconds that is based on a 24-hour clock.
A. datetime
Answer: A

certification SUN   certification 310-814   310-814

NO.12 Fill in the blank with the appropriate term.
A provides a concise and flexible means for matching strings of text,
suchas particular characters, words, or patterns of characters.
A. regular expression
Answer: A

SUN   310-814   certification 310-814

NO.13 Which of the following functions can be performed by a view?
Each correct answer represents a complete solution. Choose all that apply.
A. Restrict a user to specific columns in a table.
B. Contain a sub query in the FROM clause.
C. Join columns from multiple tables, so that they look like a single table.
D. Restrict a user to specific rows in a table.
Answer: A,C,D

SUN examen   310-814   certification 310-814   certification 310-814

NO.14 Which of the following terms is described in the statement below?
"It is procedural code that is automatically executed in response to certain events on a particular
table or view in a database."
A. Data type
B. Table
C. Datetime data type
D. Database trigger
Answer: D

SUN examen   310-814   310-814   310-814 examen   310-814

NO.15 You work as a Database Administrator for a company. The company uses MySQL as its database
development platform. You have created a table named Employees in the database. You want to
display the names of the employees whose salary is more than $5000, but you do not want to
display any duplicate content. Therefore, you have written the following query:
SELECT emp_id, DISTINCT emp_name WHERE salary > 5000
FROM Employees;
Which of the following statements is true about the above query?
A. The statement will display only unique names whose salary is more than $5000.
B. The UNIQUE clause should be used in place of the DISTINCT clause.
C. The statement will give an error.
D. The statement will display those records whose salary is more than $5000.
Answer: C

SUN   310-814   certification 310-814   certification 310-814

NO.16 Considering the exhibit given below:
SQL> INSERT INTO T1 VALUES (10,'JOHN');
1 row created
SQL> INSERT INTO T1 VALUES (12,'SAM');
1 row created
SQL> INSERT INTO T1 VALUES (15,'ADAM');
1 row created
SQL> SAVEPOINT A;
Savepointcreated SQL>
UPDATE T1
2 SET NAME='SCOTT'
3 WHERE CUST_NBR=12;
1 row updated
SQL> SAVEPOINT B;
Savepointcreated
SQL> DELETE FROM T1 WHERE NAME LIKE '%A%';
1 row deleted
SQL> GRANT SELECT ON T1 TO BLAKE;
Grant succeeded
SQL> ROLLBACK;
Rollback complete
What will be the output of SELECT * FROM T1;?
A. CUST_NBR NAME
---------------- ---------
10 JOHN
B. CUST_NBR NAME
---------------- ---------
10 JOHN
12 SCOTT
15 ADAM
C. CUST_NBR NAME
---------------- ---------
10 JOHN
15 ADAM
D. CUST_NBR NAME
---------------- ---------
10 JOHN
12 SCOTT
Answer: D

SUN   certification 310-814   310-814 examen

NO.17 Which of the following provides reliable units of work that allow correct recovery from failures and
keeps a database consistent even in cases of system failure?
A. Database security B.
Two-phase commit C.
Concurrency control
D. Database transaction
Answer: D

certification SUN   310-814   310-814 examen   certification 310-814

NO.18 You work as a Database Administrator for a company. The company uses MySQL as the
database platform. You have created a table named Students in the database. The structure of the table is
as follows:
Stu_IDNUMBER (3) PRIMARY KEY
Stu_NameVARCHAR2 (25) NOT NULL
Fee NUMBER (8, 2)
Class NUMBER (5);
You have executed the following statement for the table "Students":
SELECT e.Stu_Name, m.Fee
FROM Students e, Students m
WHERE e.Stu_ID = m.stu_ID;
Which of the following join types have you used in the above statement?
A. Cross join
B. Equijoin
C. Self join
D. Outer join
Answer: C

SUN   310-814 examen   310-814 examen   310-814 examen

NO.19 You work as a Database Administrator for a company. The company uses MySQL as its database.
The database contains a table named Employees. You want to remove an index named
Emp_name_idx from the Employees table. Which of the following statements should you use to
accomplish the task?
A. DELETE INDEXEmp_name_idx;
B. CANCEL INDEXEmp_name_idx;
C. REMOVE INDEXEmp_name_idx;
D. DROP INDEXEmp_name_idx;
Answer: D

SUN examen   310-814   310-814   310-814

NO.20 Which of the following are the types of numeric literals that can be used in arithmetic expressions?
Each correct answer represents a complete solution. Choose all that apply.
A. Numeric
B. Integer
C. Binary
D. Real
Answer: B,D

SUN examen   310-814 examen   certification 310-814

NO.21 FreeE
Consider the exhibit given below:
Which of the following queries will return the name of the customer who placed the highest amount of
orders and the total order amount?
A. SELECT CUSTOMER,MAX(UNITPRICE*QUANTITY) AS "TOTAL"
FROM ORDERS
GROUP BY CUSTOMER
/
B. SELECT CUSTOMER,SUM(UNITPRICE*QUANTITY) AS "TOTAL"
FROM ORDERS
WHERE SUM(UNITPRICE*QUANTITY)=
(SELECT MAX(SUM(UNITPRICE*QUANTITY))
FROM ORDERS
GROUP BY CUSTOMER)
GROUP BY CUSTOMER
/
C. SELECT CUSTOMER,SUM(UNITPRICE*QUANTITY) AS "TOTAL"
FROM ORDERS
GROUP BY CUSTOMER
HAVING SUM(UNITPRICE*QUANTITY)=
(SELECT MAX(SUM(UNITPRICE*QUANTITY))
FROM ORDERS
GROUP BY CUSTOMER)
/
D. SELECT CUSTOMER,SUM(UNITPRICE*QUANTITY) AS "TOTAL"
FROM ORDERS
GROUP BY CUSTOMER
HAVING SUM(UNITPRICE*QUANTITY)=
(SELECT SUM(UNITPRICE*QUANTITY)
FROM ORDERS
GROUP BY CUSTOMER)
/
Answer: C

SUN   310-814   310-814   certification 310-814   310-814 examen   310-814

NO.22 Which of the following statements is correct for equijoin used to join two tables named Employees and
Department?
A. SELECTDept_Name, Emp_Name
FROM Departments d1, Employees e1
ORDER BY Dept_Name, Emp_Name;
B. SELECTD.Dept_Name, E.Emp_Name
FROM Departments d1, Employees e1
HAVING Dept_Name, Emp_Name;
C. SELECTE.Emp_Name,
D. Dept_Name
FROM Departments d1, Employees e1
WHERE Dept_No = Dept_No
ORDER BY Dept_Name, Emp_Name;
E. SELECTDept_Name, Emp_Name
FROM Departments d1, Employees e1
WHERE d1.Dept_No = e1.Dept_No
ORDER BY Dept_Name, Emp_Name;
Answer: D

SUN   310-814 examen   certification 310-814   certification 310-814   certification 310-814

NO.23 You work as a Database Administrator for a company. The company uses MySQL as its database.
You want to use group functions, so you have decided to put an alias of group functions as 'GP'.
Which of the following are the correct ways to use group functions?
Each correct answer represents a complete solution. Choose all that apply.
A. GP1(GP2(GPn(group_item))) = result
B. GP1(GP2(group_item)) = result
C. GP1(GP2(GP3(group_item))) = result
D. GP1(group_item) = result
Answer: B,D

certification SUN   certification 310-814   310-814   310-814

NO.24 Review the following ER diagram:
Which of the following SQL statements will return all rows for a given CUST_ID and PROD_ID
where sales of specific products on a given day are greater than 10?
Additionally the list should be ordered by CUST_LAST_NAME, CUST_FIRST_NAME and
PROD_NAME.
A. SELECTa.cust_last_name, a.cust_first_name, b.prod_name, c.time_id
FROM customers a, products b, times c, sales e
WHERE a.cust_id=e.cust_id
AND b.prod_id=e.prod_id
AND c.time_id=e.time_id
B. GROUP BYa.cust_last_name, a.cust_first_name, b.prod_name, c.time_id
HAVING COUNT(*) > 10
ORDER BY a.cust_last_name, a.cust_first_name, b.prod_name, c.time_id;
C. SELECTa.cust_last_name, a.cust_first_name, b.prod_name, c.time_id, COUNT(*)
FROM customers a, products b, times c, sales e
WHERE a.cust_id=e.cust_id
AND b.prod_id=e.prod_id
AND c.time_id=e.time_id
GROUP BY a.cust_last_name, a.cust_first_name, b.prod_name, c.time_id
HAVING COUNT(*) > 10;
D. SELECTa.cust_last_name, a.cust_first_name, b.prod_name, c.time_id, COUNT(*)
FROM customers a, products b, times c, sales e
WHERE a.cust_id=e.cust_id
AND b.prod_id=e.prod_id
AND c.time_id=e.time_id
GROUP BY a.cust_last_name, a.cust_first_name, b.prod_name, c.time_id
HAVING COUNT(*) > 10
ORDER BY a.cust_last_name, a.cust_first_name, b.prod_name, c.time_id;
E. SELECTa.cust_last_name, a.cust_first_name, b.prod_name, c.time_id, COUNT(*) TOTAL
FROM customers a, products b, times c, sales e
WHERE a.cust_id=e.cust_id
AND b.prod_id=e.prod_id
AND c.time_id=e.time_id
GROUP BY a.cust_last_name, a.cust_first_name, b.prod_name, c.time_id
ORDER BY a.cust_last_name, a.cust_first_name, b.prod_name, c.time_id;
F. SELECTa.cust_last_name, a.cust_first_name, b.prod_name, c.time_id,
COUNT(*) TOTAL
FROM customers a, products b, times c, sales e
WHERE a.cust_id=e.cust_id
AND b.prod_id=e.prod_id
AND c.time_id=e.time_id
AND total > 10
GROUP BY a.cust_last_name, a.cust_first_name, b.prod_name, c.time_id
ORDER BY a.cust_last_name, a.cust_first_name, b.prod_name, c.time_id;
Answer: C

certification SUN   310-814 examen   certification 310-814   310-814   310-814

NO.25 Adam works as a Database Administrator for a company. Adam has created a table named
Students. In this table, Adam wants to create a column to store the fees of students. Which of the
following data types will Adam use to accomplish the task?
Each correct answer represents a complete solution. Choose all that apply.
A. NUMBER
B. NUMBER(p,s)
C. DEFAULT
D. BLOB
Answer: A,B

certification SUN   310-814 examen   310-814 examen   310-814

NO.26 Fill in the blank with the appropriate word.
A specifies that the value of a column (or columns), upon which the index is based, must
be unique.
A. unique index
Answer: A

certification SUN   310-814   310-814

NO.27 Which of the following statements will delete all the records from the table T1?
Each correct answer represents a complete solution. Choose all that apply.
A. TRUNCATE TABLE T1;
B. DELETE FROM T1;
C. DELETE * FROM T1;
D. DELETE T1;
Answer: A,B,D

SUN examen   310-814 examen   310-814   310-814

NO.28 You work as a Database Administrator for a company. The company uses MySQL as its database.
You have written two statements, which are as follows:
1. SELECT DISTINCT OBJECT_TYPE
FROM USER_OBJECTS;
2. SELECT OBJECT_TYPE
FROM ALL_OBJECTS;
Which of the following options explains the difference between the results of these two
statements? Each correct answer represents a complete solution. Choose all that apply.
A. The first statement will display distinct object types that can be accessed by the user.
B. The second statement will display all object types that a user can access.
C. The first statement will display distinct object types owned by a user.
D. The second statement will display all object types owned by a user.
Answer: B,C

SUN   310-814   310-814

NO.29 DRAG DROP
Drag and drop the correct constraint types to their corresponding specifications.
Answer:

NO.30 Adam works as a Database Administrator for a company. The company uses MySQL as its
database. Adam has created a table named Employees in the database. He wants to retrieve the
information of those employees who have at least one person reporting to them. Which of the
following queries will Adam execute to accomplish the task?
A. SELECTemployee_id, last_name, job_id, department_id FROM Employees WHERE
employee_id
EXISTS (SELECT manager_id WHERE manager_id is NULL);
B. SELECTemployee_id, last_name, job_id, department_id FROM Employees HAVING
employee_id
IN (SELECT manager_id FROM Employees WHERE manager_id is NOT NULL);
C. SELECTemployee_id, last_name, job_id, department_id FROM Employees outer WHERE
EXISTS
(SELECT 'x' FROM Employees WHERE manager_id = outer.employee_id);
D. SELECTemployee_id, last_name, job_id, department_id FROM Employees WHERE
employee_idIN
(SELECT manager_id WHERE manager_id is NOT NULL);
Answer: C

SUN examen   310-814 examen   310-814 examen

Vous pouvez tout d'abord télécharger le démo SUN 310-814 gratuit dans le site Pass4Test. Une fois que vous décidez à choisir le Pass4Test, Pass4Test va faire tous efforts à vous permettre de réussir le test. Si malheureusement, vous ne passez pas le test, nous allons rendre tout votre argent.