COMPUTER SCIENCE AND ENGINEERING
SQL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
They are used to provide details of an backup plans
|
|
|
Master records the information for SQL Server temporarily
|
|
|
Master records the initialization information for SQL Server
|
|
|
None of the mentioned
|
Detailed explanation-1: -Explanation: Master database includes information about the file locations of the user databases, as well as logon accounts, server configuration settings, and a number of other items such as linked servers and startup stored procedures.
Detailed explanation-2: -The master database records all the system-level information for a SQL Server system. This includes instance-wide metadata such as logon accounts, endpoints, linked servers, and system configuration settings.
Detailed explanation-3: -Which of the following statement is true? Explanation: The SQL TRUNCATE command is used to delete all the rows from the table and free the space containing the table.
Detailed explanation-4: -7. Which one of the following statements can be used to select the database? Explanation: $mysqli->select db(’databasename’); can be used to select the database.