×
Detail Form
We will send your result on your email id and phone no. please fill detail
1.
Which of the following syntaxes will a user use to remove a database in MySQL?
2.
Which of the following statements are true about group functions?
Each correct answer represents a complete solution. Choose all that apply.
3.
Which of the following comprises a unit of work performed within a database management system against a database, and treated in a coherent and reliable way independent of other transactions?
4.
You work as a Database Administrator for Pass4sure.com. The company uses MySQL as its database. You have created a table named Employees in the database. Now, you want to display information about indexes in
the Employees table. Which of the following commands will you use to accomplish the task?
the Employees table. Which of the following commands will you use to accomplish the task?
5.
You work as a Database Administrator for Pass4sure.com. The management instructs you to check the transaction in DBMS to guarantee that either all of the tasks of a transaction are performed or none of them are. Which of the following properties will you use to accomplish the task?
6.
You work as a Database Administrator for Pass4sure.com. 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.
7.
Which of the following update statements will change the salary and job title of employee Scott to that of
Adams? Each correct answer represents a complete solution. Choose all that apply.
8.
You work as a Database Administrator for Pass4sure.com. The company uses MySQL as its database. You have created a table named Employees and want to retrieve the days of the week on which more than 7
members were hired, as well as the exact number of employees hired on those days.
Which of the following queries will you execute to accomplish the task?
members were hired, as well as the exact number of employees hired on those days.
Which of the following queries will you execute to accomplish the task?
9.
Which of the following operators is used to check if the field values are included in a specified comma-delimited list?
10.
Which of the following methods is used to search a string based on a regular expression?