SQL SERVER QUIZZES TEST/PDF FOR FRESHERE | VERY BASIC - SET 1
Here we come with Sql server quiz for fresher only, who are very new to sql server, can try there knowledge. Here are top 15 questions with answers, first try to answers them then you can see the answers at the top.
Answers:
15) DESC, 14) Diagram, 13) Query Designer, 12) Management Studio, 11) Dialect,
10) One-to-many, 9) Foreign key,8) DDL,7) T-SQL, 6) Type, 5) Cell, 4) Primary key, 3) Tables, 2) Network, 1) Sql query,
1). To retrieve or update the data in a database, the client sends a/an ______ to the database
2). The three main hardware components of a client/server system are the clients, the server, and the ____________
3). A relational database consist of one or more ______
4). A ______ uniquely identifies each row in a table
5). The intersection of a row and a column is commonly called a/an ______
6). When a column in a table is defined, it is given a data ______ that determines what kind of data it can store
7). The SQL dialect that Microsoft SQL Server uses is called ___
8). SQL statements that define the tables in a database are referred to as _______ statements
9). To relate one table to another, a/an ________ in one table is used to point to the primary key in another table
10). The most common type of relationship between two tables is a/an ________ relationship
11). Although the American National Standards Institute (ANSI) published the specifications for a standard SQL language, each DBMS vendor has its own ______ of SQL
12). The ________ is a graphical user interface for working with the objects in a SQL Server database
13). Within the Management Studio, you can build a SQL statement without having to write your own code by using the _______
14). A database _______ is a schematic drawing that shows you the relationships between the tables you're working with
15). To sort the records that are retrieved by a SELECT statement in descending sequence by InvoiceTotal, you code ___________ after ORDER BY InvoiceTotal.
Answers:
15) DESC, 14) Diagram, 13) Query Designer, 12) Management Studio, 11) Dialect,
10) One-to-many, 9) Foreign key,8) DDL,7) T-SQL, 6) Type, 5) Cell, 4) Primary key, 3) Tables, 2) Network, 1) Sql query,
SQL SERVER QUIZ FOR FRESHER SQL DEVELOPERS
1). To retrieve or update the data in a database, the client sends a/an ______ to the database
2). The three main hardware components of a client/server system are the clients, the server, and the ____________
3). A relational database consist of one or more ______
4). A ______ uniquely identifies each row in a table
5). The intersection of a row and a column is commonly called a/an ______
6). When a column in a table is defined, it is given a data ______ that determines what kind of data it can store
7). The SQL dialect that Microsoft SQL Server uses is called ___
8). SQL statements that define the tables in a database are referred to as _______ statements
9). To relate one table to another, a/an ________ in one table is used to point to the primary key in another table
10). The most common type of relationship between two tables is a/an ________ relationship
11). Although the American National Standards Institute (ANSI) published the specifications for a standard SQL language, each DBMS vendor has its own ______ of SQL
12). The ________ is a graphical user interface for working with the objects in a SQL Server database
13). Within the Management Studio, you can build a SQL statement without having to write your own code by using the _______
14). A database _______ is a schematic drawing that shows you the relationships between the tables you're working with
15). To sort the records that are retrieved by a SELECT statement in descending sequence by InvoiceTotal, you code ___________ after ORDER BY InvoiceTotal.
Pdf will be available soon..
Comments