MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 424 Mcqs, each offering curated multiple-choice questions to sharpen your Structured Query Language (SQL) knowledge and support exam preparation. Choose a topic below to get started.
| 401. |
Which menu is used to restore windows to their original locations ? |
| A. | Edit |
| B. | File |
| C. | Tools |
| D. | Windows |
| Answer» E. | |
| 402. |
Which of the following shortcut is used to clear all bookmarks ? |
| A. | Ctrl+K+L |
| B. | Ctrl+K+O |
| C. | Ctrl+K+B |
| D. | Ctrl+K+P |
| Answer» B. Ctrl+K+O | |
| 403. |
Ctrl+K+K shortcut refers to _________ |
| A. | Refresh IntelliSense |
| B. | Add or remove a bookmark |
| C. | Enable all bookmarks |
| D. | Move to the next bookmark |
| Answer» C. Enable all bookmarks | |
| 404. |
SMO in SQL Server stands for ________ |
| A. | Server Management Object |
| B. | Service Management Object |
| C. | SQL Management Object |
| D. | SQL Server Management Object |
| Answer» E. | |
| 405. |
Which of the following feature is not provided by SSS 2008 ? |
| A. | Automatic formatting |
| B. | IntelliSense |
| C. | Code Outlining |
| D. | SQLCMD |
| Answer» B. IntelliSense | |
| 406. |
Which of the following pane option is not provided by Query Designer ? |
| A. | Diagram pane |
| B. | Grid pane |
| C. | Results pane |
| D. | Query pane |
| Answer» E. | |
| 407. |
Which of the following tool is used for designing schema of the database in SSMS ? |
| A. | Query Designer |
| B. | Database Diagrams |
| C. | Table designer |
| D. | Query Editor |
| Answer» D. Query Editor | |
| 408. |
________ is tool in SSMS used to manage multiple servers. |
| A. | Registered Servers |
| B. | Query Editor |
| C. | Template Explorer |
| D. | Context Explorer |
| Answer» B. Query Editor | |
| 409. |
Template Explorer is used to manage _________ |
| A. | T-SQL scripts |
| B. | Registered Servers |
| C. | Properties |
| D. | Query design |
| Answer» B. Registered Servers | |
| 410. |
Which was the first version of SQL Server to introduce in-memory capability ? |
| A. | SQL Server 2012 |
| B. | SQL Server 2014 |
| C. | SQL Server 2005 |
| D. | SQL Server 2008 |
| Answer» C. SQL Server 2005 | |
| 411. |
________ is free database software running free SQL Server technology. |
| A. | SQL Server Express |
| B. | SQL Server Workgroup |
| C. | SQL Server Enterprise |
| D. | SQL Server Web |
| Answer» B. SQL Server Workgroup | |
| 412. |
__________is the first true GUI-based database server. |
| A. | SQL Server 7.0 |
| B. | SQL Server 6.5 |
| C. | SQL Server 2005 |
| D. | SQL Server 2008 |
| Answer» B. SQL Server 6.5 | |
| 413. |
Codename for SQL Server 2012 is ______ |
| A. | Kilimanjaro |
| B. | Katmai |
| C. | Denali |
| D. | Hekaton |
| Answer» D. Hekaton | |
| 414. |
When was the first version of Microsoft SQL Server released ? |
| A. | 1983 |
| B. | 1988 |
| C. | 1990 |
| D. | 1991 |
| Answer» C. 1990 | |
| 415. |
WHICH_OF_THE_FOLLOWING_STATEMENT_IS_TRUE_??$ |
| A. | DELETE does not free the space containing the table and TRUNCATE free the space containing the table |
| B. | Both DELETE and TRUNCATE free the space containing the table |
| C. | Both DELETE and TRUNCATE does not free the space containing the table |
| D. | DELETE free the space containing the table and TRUNCATE does not free the space containing the table |
| Answer» B. Both DELETE and TRUNCATE free the space containing the table | |
| 416. |
What_is_the_purpose_of_the_SQL_AS_clause_?$ |
| A. | The AS SQL clause is used change the name of a column in the result set or to assign a name to a derived column |
| B. | The AS clause is used with the JOIN clause only |
| C. | The AS clause defines a search condition |
| D. | All of the mentioned |
| Answer» B. The AS clause is used with the JOIN clause only | |
| 417. |
If you don’t specify ASC or DESC after a SQL ORDER BY clause, the following is used by defaul?# |
| A. | ASC |
| B. | DESC |
| C. | There is no default value |
| D. | None of the mentioned |
| Answer» B. DESC | |
| 418. |
________________ is not a category of SQL command. |
| A. | TCL |
| B. | SCL |
| C. | DCL |
| D. | DDL |
| Answer» C. DCL | |
| 419. |
Which of the following are TCL commands ? |
| A. | UPDATE and TRUNCATE |
| B. | SELECT and INSERT |
| C. | GRANT and REVOKE |
| D. | ROLLBACK and SAVEPOINT |
| Answer» E. | |
| 420. |
Which of the following is not a DDL command ? |
| A. | UPDATE |
| B. | TRUNCATE |
| C. | ALTER |
| D. | None of the Mentioned |
| Answer» B. TRUNCATE | |
| 421. |
___________removes all rows from a table without logging the individual row deletions. |
| A. | DELETE |
| B. | REMOVE |
| C. | DROP |
| D. | TRUNCATE |
| Answer» E. | |
| 422. |
Which of the following SQL clauses is used to DELETE tuples from a database table ? |
| A. | DELETE |
| B. | REMOVE |
| C. | DROP |
| D. | CLEAR |
| Answer» B. REMOVE | |
| 423. |
Which SQL keyword is used to retrieve a maximum value ? |
| A. | MOST |
| B. | TOP |
| C. | MAX |
| D. | UPPER |
| Answer» D. UPPER | |
| 424. |
Which SQL function is used to count the number of rows in a SQL query ? |
| A. | COUNT() |
| B. | NUMBER() |
| C. | SUM() |
| D. | COUNT(*) |
| Answer» E. | |