多項(xiàng)選擇題

TestKing.com has a SQL Server 2005 computer. You have been assigned the task of retrieving information about a user who is currently logged in. You need to create a function that returns scalar information about the activity time for a particular user.
What are two possible ways to achieve this goal？（）

A.Create a function that returns a list of values that represent the login times for the given user.
B.Create a function that returns a list of values that represent the people who have logged more hours than the current user has logged.
C.Create a function that returns a numeric value that represents the number of hours that a user has logged for the current day.
D.Create a function that returns a numeric value that represents the number of hours that a user has logged for the current month.

你可能感興趣的試題

單項(xiàng)選擇題

You are responsible for managing the database schema for an order entry application in a SQL Server 2005 database. After a design review， a member of the development staff asks you to add a new column named CommissionRate to the Product table. Because the actual commission rates for all products are not known at this time， each product has a default commission rate of 12 percent. The rate can be modified as necessary. You add the new column. You need to configure the table to assign the default value as efficiently as possible.
What should you do？（）

A.Create an INSERT trigger to assign the default value to each item in the table.
B.Create a CHECK constraint to validate the data and to assign the default value to each item in the table.
C.Create an UPDATE trigger to update the default value for each new item in the table.
D.Create a DEFAULT constraint to assign the default value specifying the WITH VALUES argument.

單項(xiàng)選擇題

銷售部和財(cái)務(wù)部在兩棟不同的樓里。兩個(gè)部門由一個(gè)2兆位的網(wǎng)絡(luò)連接。并且都使用SQL Server 2005。銷售部在一個(gè)名為DB1的數(shù)據(jù)庫(kù)里記錄所有的銷售事務(wù)。DB1包含380張表，大小為10GB。財(cái)務(wù)部為做報(bào)表可以只讀方式訪問DB1里的4張表。財(cái)務(wù)部會(huì)全天進(jìn)行查詢并需要盡可能最新的數(shù)據(jù)。財(cái)務(wù)部的用戶告訴你報(bào)表執(zhí)行非常緩慢。為優(yōu)化網(wǎng)絡(luò)容量，你的部門決定為財(cái)務(wù)部提供此四張表的副本。現(xiàn)在，你需要提供這些表的副本。因此，你想用一種占最小網(wǎng)絡(luò)帶寬的復(fù)制法達(dá)成此目標(biāo)，該怎樣做？（）

A.將DB1鏡像到財(cái)務(wù)部，以高有效性模式配置鏡像
B.建立DB1的每日事務(wù)日志傳輸?shù)截?cái)務(wù)部
C.建立每日快照復(fù)制到財(cái)務(wù)部，定義一個(gè)只包含這四張表的發(fā)布
D.建立事務(wù)復(fù)制到財(cái)務(wù)部，定義一個(gè)只包含此四張表的發(fā)布

日韩欧美亚洲 _ 欧美亚洲一区 _ 日本亚洲欧美 _ 亚洲精品欧美 国产白袜脚足J棉袜在线观看_亚洲熟妇av一区二区三区_久久天天躁狠狠躁夜_精品众筹模特私拍在线

你可能感興趣的試題

日韩欧美亚洲 _ 欧美亚洲一区 _ 日本亚洲欧美 _ 亚洲精品欧美国产白袜脚足J棉袜在线观看_亚洲熟妇av一区二区三区_久久天天躁狠狠躁夜_精品众筹模特私拍在线