MS SQL Server - 38 - System Stored Procedures and Functions MCQ

38 – System Stored Procedures and Functions MCQ

Best of luck!

1 / 25

1. What are System Stored Procedures in SQL Server?

Procedures that are defined by users

Procedures that cannot be executed

Procedures that are used to manage the SQL Server system

Procedures that return scalar values

2 / 25

2. Which system stored procedure in SQL Server is used to create a new database?

sp_create_database

sp_add_db

sp_make_db

sp_create_db

3 / 25

3. What is the purpose of the sp_who system stored procedure in SQL Server?

To add a new user

To create a new database

To retrieve information about current connections

To create a table

4 / 25

4. Which system stored procedure in SQL Server is used to display the structure of a table or view?

sp_describe_table

sp_table_info

sp_show_structure

sp_help

5 / 25

5. What is the primary purpose of the sp_rename system stored procedure in SQL Server?

To rename a stored procedure

To rename a column in a table

To drop a table

To change a user's password

6 / 25

6. Which system stored procedure in SQL Server is used to retrieve information about database files?

sp_get_file_info

sp_file_info

sp_helpfile

sp_list_files

7 / 25

7. What is the purpose of the @@ERROR system function in SQL Server?

To retrieve information about tables

To retrieve the current user's username

To retrieve the last error code

To calculate mathematical expressions

8 / 25

8. Which system function in SQL Server is used to return the current user’s login ID?

@@USERNAME

@@USER

@@LOGIN

@@LOGON

9 / 25

9. What is the primary purpose of the OBJECT_ID() system function in SQL Server?

To calculate mathematical expressions

To check if an object exists in the database

To retrieve information about database files

To retrieve the current user's login ID

10 / 25

10. Which system function in SQL Server is used to retrieve the current date and time?

CURRENT_TIMESTAMP()

NOW()

@@DATE

GETDATE()

11 / 25

11. What is the primary purpose of the OBJECT_NAME() system function in SQL Server?

To retrieve the name of an object by its object_id

To calculate mathematical expressions

To retrieve the current date and time

To retrieve information about tables

12 / 25

12. Which system function in SQL Server is used to return the name of the current user?

CURRENT_USER()

@@USER

@@USERNAME

USER_NAME()

13 / 25

13. What is the primary purpose of the HOST_NAME() system function in SQL Server?

To calculate mathematical expressions

To return the name of the current host or computer

To retrieve the current date and time

To retrieve information about database files

14 / 25

14. Which system function in SQL Server is used to retrieve the length of a string?

LENGTH()

LEN()

STRING_LENGTH()

CHAR_LENGTH()

15 / 25

15. What is the primary purpose of the DATABASEPROPERTYEX() system function in SQL Server?

To return information about database properties

To retrieve the length of a string

To calculate mathematical expressions

To retrieve the current date and time

16 / 25

16. Which system function in SQL Server is used to return the current user’s default schema?

SCHEMA_NAME()

@@SCHEMA

DEFAULT_SCHEMA()

USER_SCHEMA()

17 / 25

17. What is the primary purpose of the SCHEMA_ID() system function in SQL Server?

To retrieve information about tables

To calculate mathematical expressions

To retrieve the current user's default schema

To return the schema ID for a given schema name

18 / 25

18. Which system function in SQL Server is used to retrieve the name of a specified schema by its schema ID?

NAME_OF_SCHEMA()

GET_SCHEMA_NAME()

@@SCHEMA_NAME

SCHEMA_NAME()

19 / 25

19. What is the primary purpose of the SCHEMA_NAME() system function in SQL Server?

To retrieve the name of a specified schema by its schema ID

To retrieve information about database files

To return the current user's default schema

To calculate mathematical expressions

20 / 25

20. Which system function in SQL Server is used to determine if a specified database exists?

DATABASE_EXISTS()

@@DB_EXISTS

DB_ID()

EXISTS_DATABASE()

21 / 25

21. What is the primary purpose of the DATABASEPROPERTY() system function in SQL Server?

To return the name of the current host or computer

To retrieve the length of a string

To calculate mathematical expressions

To retrieve information about database properties

22 / 25

22. Which system function in SQL Server is used to return the collation of a specified column?

@@COLLATION

GET_COLUMN_COLLATION()

COLUMN_COLLATION()

COLLATION_NAME()

23 / 25

23. What is the primary purpose of the TYPEPROPERTY() system function in SQL Server?

To return information about data type properties

To retrieve the collation of a specified column

To calculate mathematical expressions

To retrieve the current date and time

24 / 25

24. Which system function in SQL Server is used to return the precision of a specified numeric data type?

@@PRECISION

GET_PRECISION()

PRECISION()

NUMERIC_PRECISION()

25 / 25

25. What is the primary purpose of the FORMATPROPERTY() system function in SQL Server?

To return information about format properties

To calculate mathematical expressions

To retrieve the precision of a specified numeric data type

To retrieve the current date and time

Your score is

MS SQL Server – 38 – System Stored Procedures and Functions MCQ