| |
Que No. 1 ) What is the purpose of the "JOIN" clause in SQL Server?
A.) To filter rows in a table
B.) To order rows in a table
C.) combine rows from two or more tables based on a related column
D.) To calculate the average value of a column
|
Que No. 2 ) Which SQL Server feature allows you to group and summarize data in a query result set?
A.) GROUP BY clause
B.) ORDER BY clause
C.) HAVING clause
D.) WHERE clause
|
Que No. 3 ) What is the purpose of the SQL Server function "COUNT()"?
A.) To calculate the average value of a column
B.) To count the number of rows in a result set
C.) To round a numeric value to the nearest integer
D.) To extract a substring from a string
|
Que No. 4 ) Which SQL Server command is used to modify existing data in a table?
A.) DELETE
B.) INSERT
C.) UPDATE
D.) ALTER
|
Que No. 5 ) What is the purpose of the SQL Server "INNER JOIN" clause?
A.) To return all rows from both tables, including unmatched rows
B.) To return only rows that have matching values in both tables
C.) To return all rows from the left table and matching rows from the right table
D.) To return all rows from the right table and matching rows from the left table
|
Que No. 6 ) Which SQL Server data type is used to store large binary data, such as images or documents?
A.) INT
B.) VARCHAR
C.) BLOB
D.) DATE
|
Que No. 7 ) What is the purpose of the SQL Server "CASE" statement?
A.) To create a new table
B.) To count the number of rows in a table
C.) To conditionally return different values based on a specified condition
D.) To order rows in a result set
|
Que No. 8 ) Which SQL Server function is used to find the maximum value in a column?
A.) AVG()
B.) SUM()
C.) MAX()
D.) MIN()
|
Que No. 9 ) What is the purpose of the SQL Server "UNION" operator?
A.) To combine rows from two or more tables into a single result set
B.) To perform a cross join between two tables
C.) To filter rows in a table
D.) To order rows in a result set
|
Que No. 10 ) What is the purpose of the SQL Server "TRUNCATE TABLE" statement?
A.) To delete all rows from a table
B.) To remove a column from a table
C.) To change the data type of a column
D.) To remove a table from the database
|