Microsoft-TS Microsoft SQL Server 2005 - Implementation and Maintenance Set 3

Question - 15 Maximum mark : - 28

Home
All Exams
Microsoft-TS Microsoft SQL Server 2005 - Implementation and Maintenance Online Practice Exams
Microsoft-TS Microsoft SQL Server 2005 - Implementation and Maintenance Set 3

Given below is a list of functions and their purpose in random order. Function Purpose 1)NVL a) Used for evaluating NOT NULL and NULL values 2)NULLIF b) Used to return the first non- null values in a list of expressions 3)COALESCE c) Used to compare two expressions. If both are same, it returns NULL; otherwise, it returns only the first expression. 4)NVL2 d) Used to convert NULL values to actual values Identify the correct combination of functions and their usage.

1-a, 2-c, 3-b, 4-d ✘ 1-d, 2-c, 3-b, 4-a ✘ 1-b, 2-c, 3-d, 4-a ✘ 1-d, 2-b, 3-c, 4-a ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

Evaluate the following SQL statement: ALTER TABLE hr.emp SET UNUSED (mgr_id); Which statement is true regarding the effect of the above SQL statement?

Any synonym existing on the EMP table would have to be re-created. ✘ Any constraints defined on the MGR_ID column would be removed by the above command. ✘ Any views created on the EMP table that include the MGR_ID column would have to be dropped and re-created. ✘ Any index created on the MGR_ID column would continue to exist until the DROP UNUSED COLUMNScommand is executed. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

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? SELECT * FROM ord;

CREATE SYNONYM ord FOR orders; This command is issued by OE. ✘ CREATE PUBLIC SYNONYM ord FOR orders; This command is issued by OE. ✘ CREATE SYNONYM ord FOR oe.orders; This command is issued by the database administrator. ✘ CREATE PUBLIC SYNONYM ord FOR oe.orders; This command is issued by the database administrator. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

Evaluate the following SQL statement: ALTER TABLE hr.emp SET UNUSED (mgr_id); Which statement is true regarding the effect of the above SQL statement?

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

The following are the steps for a correlated subquery, listed in random order: 1) The WHERE clause of the outer query is evaluated. 2) The candidate row is fetched from the table specified in the outer query. 3) The procedure is repeated for the subsequent rows of the table, till all the rows are processed. 4) Rows are returned by the inner query, after being evaluated with the value from the candidate row in the outer query. Identify the option that contains the steps in the correct sequence in which the Oracle server evaluates a correlated subquery.

4,2,1,3 ✘ 4,1,2,3 ✘ 2,4,1,3 ✘ 2,1,4,3 ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

Which statement is true regarding Flashback Version Query?

It returns versions of rows only within a transaction. ✘ It can be used in subqueries contained only in a SELECT statement. ✘ It will return an error if the undo retention time is less than the lower bound time or SCN specified. ✘ It retrieves all versions including the deleted as well as subsequently reinserted versions of the rows. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

Which view would you use to display the column names and DEFAULT values for a table?

DBA_TABLES ✘ DBA_COLUMNS ✘ USER_COLUMNS ✘ USER TAB COLUMNS ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

The user SCOTT who is the owner of ORDERS and ORDER_ITEMS tables issues the following GRANT command: GRANT ALL ON orders, order_items TO PUBLIC; What correction needs to be done to the above statement?

PUBLIC should be replaced with specific usernames. ✘ ALL should be replaced with a list of specific privileges. ✘ WITH GRANT OPTION should be added to the statement. ✘ Separate GRANT statements are required for ORDERS and ORDER_ITEMS tables. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

Which statements are true? (Choose all that apply.)

Views with the same name but different prefixes, such as DBA, ALL and USER, use the same base tablesfrom the data dictionary The data dictionary views can consist of joins of dictionary base tables and user-defined tables. The usernames of all the users including the database administrators are stored in the data dictionary. The USER_CONS_COLUMNS view should be queried to find the names of the columns to which aconstraint applies. Both USER_OBJECTS and CAT views provide the same information about all the objects that are ownedby the user.

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

10.

Which statement is true regarding the SESSION_PRIVS dictionary view?

It contains the current object privileges available in the user session. ✘ It contains the current system privileges available in the user session. ✘ It contains the object privileges granted to other users by the current user session. ✘ It contains the system privileges granted to other users by the current user session. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

Prev Next

Congratulations

you have successfully completed the test

Back to Question View Result

Detail Form

We will send your result on your email id and phone no. please fill detail

Name

Email ID Note: Report will be send to the above Email ID

Phone No

Microsoft-TS Microsoft SQL Server 2005 - Implementation and Maintenance Set 3

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Congratulations

COMPANY

Products

OTHERS

Partner