Aula 3 MySQL Developer, Certificação 1Z0-871

Apresentação de Erick e Oromar, Segue apresentação (APRESENTAÇÃO 18/03/2013)

1. 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.

2.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

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





4.Which of the following statements will a user use to display a database in MySQL?

A.DISPLAY DATABASES;
B.SELECT * FROM DATABASES;
C.SHOW DATABASE;
D.VIEW DATABASES;

5.Which of the following syntaxes will a user use to remove a database in MySQL?

A.CANCEL DATABASE [IF EXISTS] database_name;
B.REMOVE DATABASE [IF EXISTS] database_name;
C.DELETE DATABASE [IF EXISTS] database_name;
D.DROP DATABASE [IF EXISTS] database_name;

6.The company uses MySQL as its database.
You have created a table named Employees. You want to insert a row in the table. The structure of the
table is as follows:

Emp_ID NUMBER PRIMARY KEY

Emp_Name VARCHAR2 (30)

Emp_Address VARCHAR2 (40)

Which of the following statements can you use to accomplish the task?

Each correct answer represents a complete solution. Choose all that apply.

A. INSERT INTO Employees VALUES (100, 'Adam', 'California');
B. INSERT INTO Employees ('Adam', 'California');
C. INSERT INTO Employees (Emp_Name, Emp_Address)
VALUES ('Adam', 'California');
D. INSERT INTO Employees (Emp_ID, Emp_Name, Emp_Address) VALUES (100, 'Adam', 'California');


7.You work as a Database Administrator for Pass4sure.com. The company uses MySQL as its database.

You have written the following MySQL statement to calculate the salary of employees:

SELECT (5000+((base_salary*5.0)/100)) FROM Employees; What will happen if you remove the
parentheses from the statement?

A.The output will be more than the desired output.
B.A syntax error will occur.
C.The output will be less than the desired output.
D.The same value will be displayed.

8.Which of the following data types can be used in MySQL?

Each correct answer represents a complete solution. Choose all that apply.

A.Date and Time
B.Function
C.Numeric
D.String

9.Which of the following conditions is true if you are using the DROP TABLE command to delete a table?

A. Only data from the table will be deleted, not the table structure.
B. The structure of the table will not be deleted if there is data in it.
C. The structure of the table and all the data from the table will be deleted, but can be rolled back and
restored.
D. The structure of the table and all the data in the table will be deleted, and cannot be rolled back and
restored.


10.Which of the following statements will a user use to display a database in MySQL?

A.SHOW DATABASE;
B.SELECT * FROM DATABASES;
C.VIEW DATABASES;
D.DISPLAY DATABASES;

11.Which of the following SQL functions may require the use of a GROUP BY clause in a SELECT statement? Each correct answer represents a complete solution. Choose all that apply.
A.TO_CHAR
B.LOWER
C.SUM
D.AVG
E.TO_NUMBER

12.What is the default precision for fractional seconds in a TIMESTAMP datatype column?

A.6 digits
B.2 digits
C.8 digits
D.9 digits

13.Identify whether the given statement is true or false.

"The NUMBER datatype is used to store both fixed-point and floating-point numbers."

A. False
B. True