-
An application needs to store a 5 MB JPEG image in a DB2 table. Which data type should be specified for the column that will be used for storing the image?（）
A . GRAPHIC
B . BINARY
C . IMAGE
D . BLOB
-
Which two roles or privileges must you have to export tables owned by another user？（）
A . CREATE USER
B . CREATE SESSION
C . CREATE ANY TABLE
D . IMP_FULL_DATABASE
E . EXP_FULL_DATABASE
-
The house is（）owned by her father.
A . part
B . partly
C . parts
D . a part
-
Everyone（）the right to his own opinion.
A . imitates
B . requests
C . deserves
D . outline
-
You need to design the storage of the application texts for UI elements to fulfill the requirements. Which table and column design should you use?（）
A . Languages (LanguageID, Name)Elements (ElementID, Description)ElementLanguages (ElementID, LanguageID, Text)
B . Languages (LanguageID, Name)Elements (ElementID, LanguageID, Description, Text)
C . Languages (LanguageID, Name)ElementTexts (LanguageID, Text)ElementDescriptions (ElementID, Description)
D . Languages (LanguageID, Name)Elements (ElementID, Description, Text)
-
An application accesses a small lookup table frequently. You notice that the required data blocks are getting aged out of the default buffer cache. How would you guarantee that the blocks for the table never age out?（）
A . Configure the KEEP buffer pool and alter the table with the corresponding storage clause.
B . Increase the database buffer cache size.
C . Configure the RECYCLE buffer pool and alter the table with the corresponding storage clause.
D . Configure Automata Shared Memory Management.
E . Configure Automatic Memory Management
-
You need to base a data block on the EMP table, but you do not want to give the users of the application access privileges on the table. Which type of data source would you use to create the data block?（）
A . table
B . transactional trigger
C . stored procedure
D . FROM clause query
-
（）of the rooms has its own computer.
A . Every
B . Each
C . Whole
D . All
-
Examine the structures of the EMPLOYEES and TAX tables.
https://assets.asklib.com/images/image2/2018080116321734981.jpg
You need to find the percentage tax applicable for each employee. Which SQL statement would you use?（）
A . SELECT employee_id, salary, tax_percent FROM employees e, tax t WHERE e.salary BETWEEN t.min_salary AND t.max_salary;
B . SELECT employee_id, salary, tax_percent FROM employees e, tax t WHERE e.salary > t.min_salary, tax_percent
C . SELECT employee_id, salary, tax_percent FROM employees e, tax t WHERE MIN(e.salary) = t.min_salary AND MAX(e.salary) = t.max_salary
D . You cannot find the information because there is no common column between the two tables.
-
Click the Exhibit button to examine the structures of the EMPLOYEES and TAX tables.
You need to find the percentage tax applicable for each employee. Which SQL statement would you use?（）
https://assets.asklib.com/images/image2/2018080114273930960.jpg
A . SELECT employee_id, salary, tax_percent FROM employees e JOIN tax t ON e.salary BETWEEN t.min_salary AND t.max_salary;
B . SELECT employee_id, salary, tax_percent FROM employees e JOIN tax t WHERE e.salary > t.min_salary AND < t.max_salary;
C . SELECT employee_id, salary, tax_percent FROM employees e JOIN tax t ON (MIN(e.salary) = t.min_salary AND MAX(e.salary) = t.max_salary);
D . You cannot find the information because there is no common column between the two tables.
-
You are designing a Windows Azure application that will use Windows Azure Table storage. You need to recommend an approach for minimizing storage costs. What should you recommend？ （）
A . Use Entity Group Transactions.
B . Use multiple partitions to store data.
C . Use a transaction scope to groupall storage operations.
D . Use Microsoft Distributed Transaction Coordinator （MSDTC）.
-
You own a table called EMPLOYEES with this table structure: EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2(25) LAST_NAME VARCHAR2(25) HIRE_DATE DATE What happens when you execute this DELETE statement? DELETE employees; （）
A . You get an error because of a primary key violation.
B . The data and structure of the EMPLOYEES table are deleted.
C . The data in the EMPLOYEES table is deleted but not the structure.
D . You get an error because the statement is not syntactically correct.
-
“He rose from the table; and advancing to the master, basin and spoon in hand, said: somewhat alarmed at his own temerity: ‘Please, sir, I want some more.’” This is taken from ______
-
“You have won rooms of your own in the house hitherto exclusively owned by men.” Here a room is compared to_____ , while the house is compared to the whole society.
-
Ive decided to tke the plungend strt up my own business. The underlined word mensofIve decided to tke the plungend strt up my own business. The underlined word mensoffer B．risk C．opportunity D．ide
A．offer
B．risk
C．opportunity
D．idea
-
Who own the shop which the mob smashed ？
The shop the mob smashed is owned by a_______________________________.
-
What is the median number of CDs owned？
-
The boss allowed us to carry out the invention on our own.（)
A．A.simple sentence
B．B.compound sentence
C．C.complex sentence
D．D.compound-complex sentence
-
Click the Exhibit button to examine the structures of the EMPLOYEES and TAX tables.You need to find the percentage tax applicable for each employee. Which SQL statement would you use？（）
<img src='https://img2.soutiyun.com/shangxueba/ask/17133001-17136000/17135988/ea49d0916fc0345195a85a9b2816cb50.jpg' />
A.SELECT employee_id, salary, tax_percent FROM employees e JOIN tax t ON e.salary BETWEEN t.min_salary AND t.max_salary;
B.SELECT employee_id, salary, tax_percent FROM employees e JOIN tax t WHERE e.salary ＞ t.min_salary AND ＜ t.max_salary;
C.SELECT employee_id, salary, tax_percent FROM employees e JOIN tax t ON (MIN(e.salary) = t.min_salary AND MAX(e.salary) = t.max_salary);
D.You cannot find the information because there is nocommon column between the two tables.
-
Your network consists of one Active Directory forest that contains two domains namedDomain1.contoso.com and Domain2.contoso.com. The functional level of the forest is Windows Server 2003.The domains contain the global security groups shown in the following table.Each domain has three servers. Each server has a group named Sales-Applications-Local. TheSales-Applications-Local groups are used to grant permissions to resources on the servers.You need to implement a solution to meet the following requirements:Allow Sales department employees from any domain to access the Sales department resources in any domain.Minimize administrative effort when membership of the Sales department changes, additional domains are added,or additional servers are added.What should you do？ （）
<img src='https://img2.soutiyun.com/shangxueba/ask/17130001-17133000/17130429/bf8057609f4797423559244897ea263f.jpg' />
A. ·On each of the servers, add Domain1-Sales-Global and Domain2-Sales-Global to Sales-Applications-Local. ·In Domain1, create a universal security group named Sales-Department-Universal. ·Add Domain1-Sales-Global and Domain2-Sales-Global to Sales-Department-Universal.
B. ·On each of the servers, add Sales-Department-Universal group to Sales-Applications-Local. ·In each domain, create a domain local security group named Sales-Applications-Domain-Local. ·In each domain, add Domain1-Sales-Global and Domain2-Sales-Global to Sales-Applications-Domain-Local.
C. ·On each of the servers, assign permissions to Sales-Applications-Domain-Local from the local domain. ·Create two universal security groups named Domain1\Sales-Department-Universal andDomain2\Sales-Department-Universal. ·Add Domain1\Domain1-Sales-Global to Domain1\Sales-Department-Universal. ·Add Domain2\Domain2-Sales-Global to Domain2\Sales-Department-Universal.
D. ·On each of the servers, add Domain1\Sales-Department-Universal and Domain2\Sales-Department-Universal to Sales-Applications-Local.
-
Who owned the bus line during the time of the Montgomery Bus Boycott？
A．Montgomery Bus Lines
B．Rosa Parks
C．National City Lines
D．Montgomery City Lines
-
Tips are generally not required at cafeterias where you serve yourself and you are expecteTips are generally not required at cafeterias where you serve yourself and you are expected to clear your own table of dishes and utensils, and discard your trash in the garbage cans.
-
TCP/IP （）layer protocols provide services to the application（）running on a computer. The application layer does not define the application itself, but rather it defines（）that applications need--lik
A．iteration
B． object
C． interface
D． activity
-
individual study is the stage when students are expected to work on their own at their own speed.（)
是
否
