All Forums Training
ashwinrp 1 post Joined 09/14
01 Sep 2014
Need Help Fro Traning Purpose

 

1) You can add a row using SQL in a database with which of the following?
Insert
2) Which of the following do you need to consider when you make a table in SQL?
All of the above
3) Which one of the following Sorts rows in SQL?
Order By
4) The SQL Statement that queries or read data form a table is __________
Select
5) The SQL Command to create a table is
Create Table
6) Which operator tests the table column for the absence of the data?
Null
7) The SQL Keyword BETWEEN is used?
For ranges
8) The Command to remove rows from the table ‘CUSTOMER’ is?
Delete table Customer
9) The Command to eliminate rows from a table ‘CUSTOMER’ is?
Delete table Customer
10) What is a Database?
A Database is a collection of tables, with related data.
11) What is a Foreign Key? (Select all that apply)
A Foreign Key is a linking pin between two or more tables.
A Foreign Key is an encrypted key to the database.
A Foreign Key is unique key provided by the Software Manufacturer.
A Foreign Key is one unique key on every database.
12) What is Select Statement?
Defines what is to be returned.
Selecting any particular database object.
Highlighting the database.
It’s used while creating a database.
13) Which of the following are the comparison operators?
=,<,<=,>,>=,<>
14) A table consists of?       
None of above.
15) What is UNION?
Product of two or more tables.
Product of two or more columns in a table.
Product of two or more records (rows) in a table.
None of the above.
Section 2 (10 Questions)
The next S set of questions (1-5) is based on below table: Table Name: EMP_Master
Emp_Id           Emp_Name       Emp_Project       Emp_Manager       Designation
1112252      John Martin           Wal-Mart        Stacy Mangle       Store Manager
1112253       David Hoff          Whirlpool                        Victor Maze         Finance Analyst
1112254     Stanley Lawson      Papa Jones         Gloria McFaul      Logistics’ Analyst
 1112255    Nancy Bridge         Whirlpool           Tara Wood           Sr. Financial Analyst
 1112256   Tom Herald             Papa Jones         Michael Bell         Client Manager
 1112257     Nicholas Jr.          Lexmark               Bill Faber             Field Services Manager
 1112258    Bryan Nickson    Wal-Mart           Ben Bernanke    Billing Head
1.How do we retrieve the Employee Names from the Emp_Master Table?
Select * From Emp_Master:
Select Emp_Name IN Emp_Master:
Select Emp_Name from Emp_Master
Select All Emp_Name from Emp_Master
2.Get all the Employee data from the Whirlpool Project?
Select * IN Emp_Master WHERE Emp_Project = Whirlpool
Select All from Emp_Master WHERE Emp_Project = Whhirlpool
Select * from Emp_Master WHERE Emp_project = Whirlpool
Select * from Emp_Master WHERE Emp_Project <> Whirlpool
3.Retrieve All Manager Names from the Emp_Master Tables                    
Select Emp_Manager From Emp_Master WHERE Designation Like %Manager%
Select Emp_Manager WHERE Designation = “Manager”
Select Emp_Manager WHERE Designation IS Manager
Select Emp_Manager WHERE Designation = ?Manager’:
4.How many records are there in the Emp_master table with Wal-Mart Project?
Select SUM(Emp_Project) from Emp_Master WHERE Emp_Project = Wal-Mart
Select Count (Emp_Project) from Emp_Master WHERE Emp_Project LIKE-Wal-Mart
Select CountIF (Emp_Project) =Wal-Mart from Emp_Master
Select Count (Emp_Project) From Emp_Master WHERE Emp_Project  ONLY ‘Wal-Mart’.
5. Retrieve the Project Names from Emp_Master Table With no Duplicate Values.
Select ONLY Emp_Project from Emp_Master
Select DISTINCT Emp_Project from Emp_Master
Select UNIQUE Emp_Project from Emp_Master
Select DISTINCTIVE Emp_Project from Emp_Master.
6. What is the command to create  the print file of the report?
PRINT
SPOOL
SEND
PRINT FILE
7. Which one of the below are correct?
TURNCATE is a DDL Command and cannot be rolled back DELETE is a DML Command and can be rolled back.
DELETE is a DDL Command and can be rolled back. TURNCATE is a DML Command and cannot be rolled back.
DELETE is a DML Command and cannot be rolled back. TURNCATE is a DDL Command and can be rolled back.
None of the Above.
8. Which Command is used to execute the content of a specific file?
RUN
BEGIN
START
EXECUTE
9. Wildcard % is used for single character Substitution and _ is for multi character Substitution.
True
False
10. Which of the below statement are true for the Primary Key & Unique Key? (Select all that apply)
Primary Key creates the clustered index. Non-Clustered index is created by the Unique Key.
Primary Key allows NULLs. Unique Key does not NULLs.     
Primary Key does not allow NULLs. Unique Key allows NULLs.
Primary Key Creates the Non-Clustered index. Clustered index is created by the Unique Key.
Section 3 (5 Questions)
1 Fill in the blanks: How do you select all the records from a table named “persons” where the value of the column “First-Name” is “Peter”?
 
Ans:   Select _____*_____ From Persons WHERE First-Name _____=____ “Peter”.
         
2. Fill in the blanks: How do you all the recodes from a table named “Persons” where the value of the column “First-Name” starts with an “a”?
 
Ans:  Select * From Persons WHERE First-Name ___LIKE a%_
 
3. Write a Simple  SQL query based on the following given criteria: Delete the records where the “First-Name” is “Peter” in the “Persons” table?
 
 Ans: DELETE FROM Persons WHERE FirstName = 'Peter'
 
4.  Write a simple SQL query based on the following given criteria:  Change “Hansen” into “Nilsen” in the “Last-Name” Column in the Persons table?
 
    UPDATE Persons SET LastName='Nilsen' WHERE LastName='Hansen'
 
5. Write a simple SQL query based on the following given criteria: Remove the Column “Last-Name” in Persons table?
 
     _____________________________________________
 
I need the Following answers for the Test Please can anyone help me in this...........

lcarter40 1 post Joined 11/09
02 Sep 2014

I don't believe the purpose of this forum is to provide test question answers.
You can take the SQL WBT classes to research these questions, test this SQL on a system such a Teradata Express, or read the reference manuals.

Larry Carter

Raja_KT 1246 posts Joined 07/09
05 Sep 2014

Please dont mind my suggestions. Reading the materials and practicing like in Express  as mentioned above will help. By practicing and having real time implementation, it gives good confidence and we can fare well. Also, by learning more practically, it motivates to do the work justifiably and we give justice to work. Finally, it gives what is called job satisfaction.

Raja K Thaw
My wiki: http://en.wikipedia.org/wiki/User:Kt_raj1
Street Children suffer not by their fault. We can help them if we want.

You must sign in to leave a comment.